/// <summary> /// 增加一条数据 /// </summary> public void Add(Models.T_ControlItemMode model, SqlTransaction tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_ControlItem("); strSql.Append("Code,Note2,Note3,Note4,Note5,CName,ControlCodeFirst,ControlNameFirst,ControlCodeSecond,ControlNameSecond,Months,Remark,Note1,Status"); strSql.Append(") values ("); strSql.Append("@Code,@Note2,@Note3,@Note4,@Note5,@CName,@ControlCodeFirst,@ControlNameFirst,@ControlCodeSecond,@ControlNameSecond,@Months,@Remark,@Note1,@Status"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Note2", SqlDbType.NVarChar, 50), new SqlParameter("@Note3", SqlDbType.NVarChar, 50), new SqlParameter("@Note4", SqlDbType.NVarChar, 50), new SqlParameter("@Note5", SqlDbType.NVarChar, 50), new SqlParameter("@CName", SqlDbType.NVarChar, 50), new SqlParameter("@ControlCodeFirst", SqlDbType.NVarChar, 50), new SqlParameter("@ControlNameFirst", SqlDbType.NVarChar, 50), new SqlParameter("@ControlCodeSecond", SqlDbType.NVarChar, 50), new SqlParameter("@ControlNameSecond", SqlDbType.NVarChar, 50), new SqlParameter("@Months", SqlDbType.VarChar, 5), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@Note1", SqlDbType.NVarChar, 50), new SqlParameter("@Status", SqlDbType.Char, 1) }; parameters[0].Value = SqlNull(model.Code); parameters[1].Value = SqlNull(model.Note2); parameters[2].Value = SqlNull(model.Note3); parameters[3].Value = SqlNull(model.Note4); parameters[4].Value = SqlNull(model.Note5); parameters[5].Value = SqlNull(model.CName); parameters[6].Value = SqlNull(model.ControlCodeFirst); parameters[7].Value = SqlNull(model.ControlNameFirst); parameters[8].Value = SqlNull(model.ControlCodeSecond); parameters[9].Value = SqlNull(model.ControlNameSecond); parameters[10].Value = SqlNull(model.Months); parameters[11].Value = SqlNull(model.Remark); parameters[12].Value = SqlNull(model.Note1); parameters[13].Value = SqlNull(model.Status); DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false); }
/// <summary> /// /// </summary> /// <param name="saleprocemode"></param> /// <returns></returns> public int Updetesalep(Models.T_ControlItemMode saleprocemode) { string sql = "update T_ControlItem set CName=@CName,ControlCodeFirst=@ControlCodeFirst,ControlNameFirst=@ControlNameFirst,ControlCodeSecond=@ControlCodeSecond,ControlNameSecond=@ControlNameSecond,Status=@Status,Months=@Months,Remark=@Remark where Code=@Code"; SqlParameter[] sps = { new SqlParameter("@CName", saleprocemode.CName), new SqlParameter("@ControlCodeFirst", saleprocemode.ControlCodeFirst), new SqlParameter("@ControlNameFirst", saleprocemode.ControlNameFirst), new SqlParameter("@ControlCodeSecond", saleprocemode.ControlCodeSecond), new SqlParameter("@ControlNameSecond", saleprocemode.ControlNameSecond), new SqlParameter("@Status", saleprocemode.Status), new SqlParameter("@Months", saleprocemode.Months), new SqlParameter("@Remark", saleprocemode.Remark), new SqlParameter("@Code", saleprocemode.Code) }; return(DataHelper.ExcuteNonQuery(sql, sps, false)); }
public void Add(Models.T_ControlItemMode model) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { Add(model, tran); tran.Commit(); } catch { tran.Rollback(); throw; } } }