コード例 #1
0
 public string Dao_InsertPayment(BoPayment pPayment)
 {
     this.LListParam = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdOrder", pPayment.LOrder.LIdOrder.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@ValuePayment", pPayment.LValuePayment.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pPayment.LStatus.LIdStatus);
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pPayment.LObject.LIdObject.ToString());
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertPayment", "spr_CreatePayment"));
 }
コード例 #2
0
 public string Dao_UpdateInvoice(BoInvoice pInvoice)
 {
     this.LListParam = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoice", pInvoice.LCustomer.LIdCustomer.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdInvoice", pInvoice.LCdInvoice);
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdCustomer", pInvoice.LCustomer.LIdCustomer.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pInvoice.LStatus.LIdStatus);
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranUpdateInvoice", "spr_UpdateInvoice"));
 }
コード例 #3
0
 public string Dao_UpdateCustomer(BoCustomer pCustomer)
 {
     this.LListParams = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NameCustomer", pCustomer.LNameCustomer);
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@LastNameCustomer", pCustomer.LLastNameCustomer);
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdTypeIdentification", pCustomer.LTypeIdentification.LIdTypeIdentification.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NoIdentification", pCustomer.LNoIdentification);
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@IdStatus", pCustomer.LStatus.LIdStatus);
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranUpdateCustomer", "spr_UpdateCustomer"));
 }
コード例 #4
0
 public string Dao_InsertProduct(BoProduct pProduct)
 {
     this.LListParam = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@NameProduct", pProduct.LNameProduct);
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@CdProduct", pProduct.LCdProduct);
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdUnit", pProduct.LUnit.LIdUnit.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@Price", pProduct.LValue.ToString(CultureInfo.CurrentCulture));
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdSupplier", pProduct.LSupplier.LIdSupplier.ToString());
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Decimal, "@PriceSupplier", pProduct.LValueSupplier.ToString(CultureInfo.CurrentCulture));
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pProduct.LStatus.LIdStatus);
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pProduct.LObject.LIdObject.ToString());
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertProduct", "spr_CreateProduct"));
 }
コード例 #5
0
 public string Dao_DeleteCustomer(BoCustomer pCustomer)
 {
     this.LListParams = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString());
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranDeleteCustomer", "spr_DeleteCustomer"));
 }
コード例 #6
0
 public string Dao_DeletePayment(BoPayment pPayment)
 {
     this.LListParam = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdPayment", pPayment.LIdPayment.ToString());
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeletePayment", "spr_DeletePayment"));
 }
コード例 #7
0
 public string Dao_DeleteInvoice(BoInvoice pInvoice)
 {
     this.LListParam = new List <SqlParameter>();
     DaoUtilsLib.dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdInvoice", pInvoice.LIdInvoice.ToString());
     return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranDeleteInvoice", "spr_DeleteInvoice"));
 }