public void AddWare_Bill_Count_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Count_Extend model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Ware_Bill_Count_Extend(");
strSql.Append("ID,SumQty1,SumQty2,SumQty)");
strSql.Append(" values (");
strSql.Append("@ID,@SumQty1,@SumQty2,@SumQty)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@SumQty1", SqlDbType.Int, 4),
new SqlParameter("@SumQty2", SqlDbType.Int, 4),
new SqlParameter("@SumQty", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.SumQty1;
parameters[2].Value = model.SumQty2;
parameters[3].Value = model.SumQty;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public void UpdateWare_Bill_Count_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Count_Extend model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Ware_Bill_Count_Extend set ");
strSql.Append("SumQty1=@SumQty1,");
strSql.Append("SumQty2=@SumQty2,");
strSql.Append("SumQty=@SumQty");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@SumQty1", SqlDbType.Int, 4),
new SqlParameter("@SumQty2", SqlDbType.Int, 4),
new SqlParameter("@SumQty", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.SumQty1;
parameters[1].Value = model.SumQty2;
parameters[2].Value = model.SumQty;
parameters[3].Value = model.ID;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
