62,074
社区成员
发帖
与我相关
我的任务
分享
public int AddOrder(string orderNo, int userID, int totalNumber, decimal totalMoney)
{ ///获取连接字符串
string connectionString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
///创建连接
SqlConnection con = new SqlConnection(connectionString);
///设置被执行存储过程的名称
string cmdText = "INSERT INTO sc_order(orderno,userid,totalsl,totalmo,shij)VALUES(@orderNo,@UserID,@totalNumber,@totalMoney,GETDATE());set @id = scope_identity()";
///创建SqlCommand
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.Add("@id", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
///创建参数并赋值
cmd.Parameters.AddWithValue("@orderNo", orderNo);
cmd.Parameters.AddWithValue("@UserID", userID);
cmd.Parameters.AddWithValue("@totalNumber", totalNumber);
cmd.Parameters.AddWithValue("@totalMoney", totalMoney);
try
{ ///打开连接
con.Open();
///操作数据
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{ ///抛出异常
throw new Exception(ex.Message, ex);
}
finally
{ ///关闭连接
con.Close();
}
return (int)cmd.Parameters["@id"].Value;
}
public int AddOrder(string orderNo,int userID,int totalNumber,decimal totalMoney)
{ ///获取连接字符串
string connectionString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
///创建连接
SqlConnection con = new SqlConnection(connectionString);
///设置被执行存储过程的名称
string cmdText = "INSERT INTO sc_order(orderno,userid,totalsl,totalmo,shij)VALUES(@orderNo,@UserID,@totalNumber,@totalMoney,GETDATE()) select @@Identity";
///创建SqlCommand
SqlCommand cmd = new SqlCommand(cmdText,con);
///创建参数并赋值
cmd.Parameters.Add("@orderNo",SqlDbType.VarChar,50);
cmd.Parameters.Add("@UserID",SqlDbType.Int,4);
cmd.Parameters.Add("@totalNumber",SqlDbType.Int,4);
cmd.Parameters.Add("@totalMoney",SqlDbType.Money);
cmd.Parameters[0].Value = orderNo;
cmd.Parameters[1].Value = userID;
cmd.Parameters[2].Value = totalNumber;
cmd.Parameters[3].Value = totalMoney;
object result = null;
try
{ ///打开连接
con.Open();
///操作数据
result = cmd.ExecuteScalar();
}
catch(Exception ex)
{ ///抛出异常
throw new Exception(ex.Message,ex);
}
finally
{ ///关闭连接
con.Close();
}
return result==null?0:Convert.ToInt32(o);
}
declare @table table
(
id int IDENTITY,
v_name varchar(10)
)
insert into @table (v_name) values ('a') select @@identity
insert into @table (v_name) values ('b') select @@identity
return (select @@Identity)