PDA

View Full Version : مشکل در insert تو دیتابیس



resatak
یک شنبه 07 آبان 1391, 11:20 صبح
با سلام خدمت دوستان من میخوام این دیتارو وارد دیتابیس کنم وقتی تو ویژوال دیباگ می کنم و run میکنم ارروی و نمی ده موقع اجرا هم اروری نمی ده ولی تو دیتایس وارد نمیشه من استور پروجریس رو هم براتون گذاشتم.
protected void lbtnConfirm_Click(object sender, EventArgs e)
{
if (IsValidate())
{
customerCom customerCm = new customerCom();
//if (((manager_master)this.Master).GetUserKind() == 2)
//{
// customerCm.UserId = ((manager_master)this.Master).GetUserId();
//}
//else
customerCm.UserId = int.Parse(drpMoshaver.SelectedValue);
customerCm.TransactionsTypeId = int.Parse(drpTransactionsType.SelectedValue);
if (drpRegionIndustrialId.SelectedValue != "0")
{
customerCm.RegionIndustrialId = int.Parse(drpRegionIndustrialId.SelectedValue);
}
else
{
customerCm.IndustrialId = int.Parse(drpIndustrialId.SelectedValue);
}
int intParam = 0;
intParam = 0;
int.TryParse(txtSalonArea.Text, out intParam);
customerCm.DataSalonArea = intParam;
intParam = 0;
int.TryParse(txtTotalArea.Text, out intParam);
customerCm.DataTotalArea = intParam;
customerCm.company = txtComponyName.Text;
customerCm.fullname = txtOwner.Text;
customerCm.bazdid1 = txtbazdid1.Text;
customerCm.bazdid1 = txtbazdid2.Text;
customerCm.bazdid1 = txtbazdid3.Text;
customerCm.bazdid1 = txtbazdid4.Text;
customerCm.DataTotalArea = intParam;
//customerCm.Expiredate = DateTime.Parse(expiredate.Text);
if (((manager_master)this.Master).GetUserKind() != 1)
customerCm.DataStatus = (byte)Dal.Enum.DataStatus.Disable;
else
customerCm.DataStatus = (byte)Dal.Enum.DataStatus.Active;
Dictionary<int, string> msg = new Dictionary<int, string>();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNe w))
{
msg = new CustomerDal().Insert_customer(customerCm);
if (msg.ContainsKey(1))
{
ShowMessage("اطلاعات با کد با موفقیت ثبت شد ");
}
scope.Complete();
}
}
}

public class CustomerDal
{
Connection MyCon;
SqlConnection Con;
public CustomerDal()
{
MyCon = new Connection("AmlakConnectionString");
}
public Dictionary<int, string> Insert_customer(customerCom customercm)
{
Dictionary<int, string> msg = new Dictionary<int, string>();
try
{
using (SqlCommand Cm = new SqlCommand())
{
Cm.CommandType = CommandType.StoredProcedure;
Cm.CommandText = "Insert_customer";


Cm.Parameters.Add("Expiredate", SqlDbType.DateTime2).Value = customercm.Expiredate;
Cm.Parameters.Add("DataRegDate", SqlDbType.DateTime).Value = customercm.DataRegDate;
Cm.Parameters.Add("fullname", SqlDbType.NVarChar, 50).Value = customercm.fullname;
Cm.Parameters.Add("comapny", SqlDbType.NVarChar, 50).Value = customercm.company;

Cm.Parameters.Add("DataStatus", SqlDbType.TinyInt).Value = customercm.DataStatus;
Cm.Parameters.Add("tel1", SqlDbType.NVarChar, 50).Value = customercm.tel1;
Cm.Parameters.Add("tel2", SqlDbType.NVarChar, 50).Value = customercm.tel2;
Cm.Parameters.Add("DataTotalArea", SqlDbType.Int).Value = customercm.DataTotalArea;
Cm.Parameters.Add("DatasalonArea", SqlDbType.Int).Value = customercm.DataSalonArea;

Cm.Parameters.Add("bazdid1", SqlDbType.NVarChar, 250).Value = customercm.bazdid1;
Cm.Parameters.Add("bazdid2", SqlDbType.NVarChar, 250).Value = customercm.bazdid2;
Cm.Parameters.Add("bazdid3", SqlDbType.NVarChar, 250).Value = customercm.bazdid3;
Cm.Parameters.Add("bazdid4", SqlDbType.NVarChar, 250).Value = customercm.bazdid4;

Cm.Parameters.Add("RegionIndustrialId", SqlDbType.Int).Value = customercm.RegionIndustrialId;
Cm.Parameters.Add("IndustrialId", SqlDbType.Int).Value = customercm.IndustrialId;

Cm.Parameters.Add("TransactionsTypeId", SqlDbType.Int).Value = customercm.TransactionsTypeId;
Cm.Parameters.Add("UserId", SqlDbType.Int, 4).Value = customercm.UserId;
Cm.Parameters.Add("InputID", SqlDbType.Int).Value = 0;
Cm.Parameters["InputID"].Direction = ParameterDirection.Output;

Con = MyCon.OpenCon();
Cm.Connection = Con;

Cm.ExecuteScalar();
msg.Add(1, Cm.Parameters["InputID"].Value.ToString());
return msg;
}
}
catch (System.Exception ex)
{
msg.Add(-1, ex.Message);
return msg;
throw ex;
}
finally
{
MyCon.CloseCon(Con);
}
}

USE [majidi]
GO
/****** Object: StoredProcedure [dbo].[Insert_customer] Script Date: 10/28/2012 11:45:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Insert_customer]
(@TransactionsTypeId int=NULL
,@RegionIndustrialId int=NULL
,@IndustrialId int=NULL
,@DataSalonArea int=NULL
,@DataTotalArea int=NULL
,@tel1 nvarchar(50) =NULL
,@tel2 nvarchar(50) =NULL
,@fullname nvarchar(50) =NULL
,@comapny nvarchar(50) =NULL
,@bazdid1 nvarchar(250) =NULL
,@bazdid2 nvarchar(250) =NULL
,@bazdid3 nvarchar(250) =NULL
,@bazdid4 nvarchar(250) =NULL
,@Expiredate datetime2 =NULL
,@DataStatus tinyint=NULL,
@UserId int=0,
@InputID Int OUTPUT)
AS
BEGIN
INSERT INTO [dbo].[Customer]
([TransactionsTypeId]
,[RegionIndustrialId]
,[DataSalonArea]
,[DataTotalArea]
,[tel1]
,[tel2]
,[DataRegDate]
,[Expiredate]
,[DataStatus],
IndustrialId,
fullname,
company,
bazdid1,
bazdid2,
bazdid3,
bazdid4,
UserId)
VALUES
(@TransactionsTypeId
,@RegionIndustrialId
,@DataSalonArea
,@DataTotalArea
,@tel1
,@tel2
,GETDATE()
,@Expiredate
,@DataStatus,
@IndustrialId,
@fullname,
@comapny,
@bazdid1,
@bazdid2,
@bazdid3,
@bazdid4,
@UserId)
Set @InputID = scope_identity();
Return @InputID

END

resatak
یک شنبه 07 آبان 1391, 12:48 عصر
دوستان کسی نیست به من کمک کنه؟

resatak
دوشنبه 08 آبان 1391, 10:50 صبح
یعنی واقعا راه حلی نداره؟