public void UpdateWare_Bill_PD(int lgIndex, SqlCommand cmd, MWare_Bill_PD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Ware_Bill_PD set ");
strSql.Append("LensCode=@LensCode,");
strSql.Append("F_LR=@F_LR");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@LensCode", SqlDbType.VarChar, 50),
new SqlParameter("@F_LR", SqlDbType.VarChar, 1),
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.LensCode;
parameters[1].Value = model.F_LR;
parameters[2].Value = model.ID;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public void AddWare_Bill_PD(int lgIndex, SqlCommand cmd, MWare_Bill_PD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Ware_Bill_PD(");
strSql.Append("ID,LensCode,F_LR)");
strSql.Append(" values (");
strSql.Append("@ID,@LensCode,@F_LR)");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@LensCode", SqlDbType.VarChar, 50),
new SqlParameter("@F_LR", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.LensCode;
parameters[2].Value = model.F_LR;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}