public void AddWare_Bill_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Ware_Bill_Extend("); strSql.Append("ID,SCode,SumQty,SumMoney,LensCodeR,LensCodeL,SPHR,SPHL,CYLR,CYLL,X_ADDR,X_ADDL,QtyR,QtyL,PriceR,PriceL,ProCostR,ProCostL)"); strSql.Append(" values ("); strSql.Append("@ID,@SCode,@SumQty,@SumMoney,@LensCodeR,@LensCodeL,@SPHR,@SPHL,@CYLR,@CYLL,@X_ADDR,@X_ADDL,@QtyR,@QtyL,@PriceR,@PriceL,@ProCostR,@ProCostL)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@SCode", SqlDbType.VarChar, 200), new SqlParameter("@SumQty", SqlDbType.Int, 4), new SqlParameter("@SumMoney", SqlDbType.Decimal, 9), new SqlParameter("@LensCodeR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeL", SqlDbType.VarChar, 50), new SqlParameter("@SPHR", SqlDbType.Int, 4), new SqlParameter("@SPHL", SqlDbType.Int, 4), new SqlParameter("@CYLR", SqlDbType.Int, 4), new SqlParameter("@CYLL", SqlDbType.Int, 4), new SqlParameter("@X_ADDR", SqlDbType.Int, 4), new SqlParameter("@X_ADDL", SqlDbType.Int, 4), new SqlParameter("@QtyR", SqlDbType.Int, 4), new SqlParameter("@QtyL", SqlDbType.Int, 4), new SqlParameter("@PriceR", SqlDbType.Decimal, 9), new SqlParameter("@PriceL", SqlDbType.Decimal, 9), new SqlParameter("@ProCostR", SqlDbType.Decimal, 9), new SqlParameter("@ProCostL", SqlDbType.Decimal, 9) }; parameters[0].Value = model.ID; parameters[1].Value = model.SCode; parameters[2].Value = model.SumQty; parameters[3].Value = model.SumMoney; parameters[4].Value = model.LensCodeR; parameters[5].Value = model.LensCodeL; parameters[6].Value = model.SPHR; parameters[7].Value = model.SPHL; parameters[8].Value = model.CYLR; parameters[9].Value = model.CYLL; parameters[10].Value = model.X_ADDR; parameters[11].Value = model.X_ADDL; parameters[12].Value = model.QtyR; parameters[13].Value = model.QtyL; parameters[14].Value = model.PriceR; parameters[15].Value = model.PriceL; parameters[16].Value = model.ProCostR; parameters[17].Value = model.ProCostL; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void UpdateWare_Bill_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Ware_Bill_Extend set "); strSql.Append("SCode=@SCode,"); strSql.Append("SumQty=@SumQty,"); strSql.Append("SumMoney=@SumMoney,"); strSql.Append("LensCodeR=@LensCodeR,"); strSql.Append("LensCodeL=@LensCodeL,"); strSql.Append("SPHR=@SPHR,"); strSql.Append("SPHL=@SPHL,"); strSql.Append("CYLR=@CYLR,"); strSql.Append("CYLL=@CYLL,"); strSql.Append("X_ADDR=@X_ADDR,"); strSql.Append("X_ADDL=@X_ADDL,"); strSql.Append("QtyR=@QtyR,"); strSql.Append("QtyL=@QtyL,"); strSql.Append("PriceR=@PriceR,"); strSql.Append("PriceL=@PriceL,"); strSql.Append("ProCostR=@ProCostR,"); strSql.Append("ProCostL=@ProCostL"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@SCode", SqlDbType.VarChar, 200), new SqlParameter("@SumQty", SqlDbType.Int, 4), new SqlParameter("@SumMoney", SqlDbType.Decimal, 9), new SqlParameter("@LensCodeR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeL", SqlDbType.VarChar, 50), new SqlParameter("@SPHR", SqlDbType.Int, 4), new SqlParameter("@SPHL", SqlDbType.Int, 4), new SqlParameter("@CYLR", SqlDbType.Int, 4), new SqlParameter("@CYLL", SqlDbType.Int, 4), new SqlParameter("@X_ADDR", SqlDbType.Int, 4), new SqlParameter("@X_ADDL", SqlDbType.Int, 4), new SqlParameter("@QtyR", SqlDbType.Int, 4), new SqlParameter("@QtyL", SqlDbType.Int, 4), new SqlParameter("@PriceR", SqlDbType.Decimal, 9), new SqlParameter("@PriceL", SqlDbType.Decimal, 9), new SqlParameter("@ProCostR", SqlDbType.Decimal, 9), new SqlParameter("@ProCostL", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.SCode; parameters[1].Value = model.SumQty; parameters[2].Value = model.SumMoney; parameters[3].Value = model.LensCodeR; parameters[4].Value = model.LensCodeL; parameters[5].Value = model.SPHR; parameters[6].Value = model.SPHL; parameters[7].Value = model.CYLR; parameters[8].Value = model.CYLL; parameters[9].Value = model.X_ADDR; parameters[10].Value = model.X_ADDL; parameters[11].Value = model.QtyR; parameters[12].Value = model.QtyL; parameters[13].Value = model.PriceR; parameters[14].Value = model.PriceL; parameters[15].Value = model.ProCostR; parameters[16].Value = model.ProCostL; parameters[17].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }