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