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