/// <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;
}
}
}
