/// <summary>
///
/// </summary>
/// <param name="model"></param>
public void Add(SaleProcessMode model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
Add(model, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(SaleProcessMode model, SqlTransaction tran)
{
// Delete(model.Code, tran);
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_SaleProcess(");
strSql.Append("Code,PName,Status,Note1,Note2,Note3,Note4,Note5");
strSql.Append(") values (");
strSql.Append("@Code,@PName,@Status,@Note1,@Note2,@Note3,@Note4,@Note5");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@PName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.Char, 1),
new SqlParameter("@Note1", 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)
};
parameters[0].Value = SqlNull(model.Code);
parameters[1].Value = SqlNull(model.PName);
parameters[2].Value = SqlNull(model.Status);
parameters[3].Value = SqlNull(model.Note1);
parameters[4].Value = SqlNull(model.Note2);
parameters[5].Value = SqlNull(model.Note3);
parameters[6].Value = SqlNull(model.Note4);
parameters[7].Value = SqlNull(model.Note5);
DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false);
}
public IList <SaleProcessMode> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <SaleProcessMode> list = new List <SaleProcessMode>();
foreach (DataRow dr in dt.Rows)
{
SaleProcessMode model = new SaleProcessMode();
model.Code = dr["Code"].ToString();
model.PName = dr["PName"].ToString();
model.Status = dr["Status"].ToString();
model.Note1 = dr["Note1"].ToString();
model.Note2 = dr["Note2"].ToString();
model.Note3 = dr["Note3"].ToString();
model.Note4 = dr["Note4"].ToString();
model.Note5 = dr["Note5"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SaleProcessMode GetModel(string Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" where Code=@Code ");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Code;
SaleProcessMode model = new SaleProcessMode();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.Code = dr["Code"].ToString();
model.PName = dr["PName"].ToString();
model.Status = dr["Status"].ToString();
model.Note1 = dr["Note1"].ToString();
model.Note2 = dr["Note2"].ToString();
model.Note3 = dr["Note3"].ToString();
model.Note4 = dr["Note4"].ToString();
model.Note5 = dr["Note5"].ToString();
return(model);
}
else
{
return(null);
}
}
}
