public void Delete(FactoryArgs args, t_BigID ModifyBillHeaderID) { using (DataTable dtHeader = _DALModifyBillHeader.GetModifyBillHeader(args, ModifyBillHeaderID)) { DataRow drHeader = dtHeader.Rows[0]; bool bolIsApprove = LBConverter.ToBoolean(drHeader["IsApprove"]); bool bolIsCancel = LBConverter.ToBoolean(drHeader["IsCancel"]); if (bolIsApprove) { throw new Exception("该调价单已审核,无法删除!"); } if (bolIsCancel) { throw new Exception("该调价单已作废,无法删除!"); } } DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { using (DataTable dtDetail = _DALModifyBillDetail.GetModifyBillDetailByHeaderID(argsInTrans, ModifyBillHeaderID)) { foreach (DataRow dr in dtDetail.Rows) { } } _DALModifyBillHeader.Delete(argsInTrans, ModifyBillHeaderID); }; DBHelper.ExecInTrans(args, exec); }
public void Customer_UpdateFromService(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode, t_BigID CustomerTypeID) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { this.Customer_Update(argsInTrans, CustomerID, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID); _DALDbCustomer.UpdateAmount(argsInTrans, CustomerID, TotalReceivedAmount, SalesReceivedAmount); IsForbid.IsNullToZero(); if (IsForbid.Value == 1) { _DALDbCustomer.Forbid(args, CustomerID); } else { _DALDbCustomer.UnForbid(args, CustomerID); } }; DBHelper.ExecInTrans(args, exec); }
public void ChargeType_Delete(FactoryArgs args, t_BigID ChargeTypeID) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { _DALDbChargeType.ChargeType_Delete(argsInTrans, ChargeTypeID); }; DBHelper.ExecInTrans(args, exec); }
public void Bank_Delete(FactoryArgs args, t_BigID ReceiveBankID) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { _DALDbBank.Bank_Delete(argsInTrans, ReceiveBankID); }; DBHelper.ExecInTrans(args, exec); }
public void Car_Delete(FactoryArgs args, t_BigID CarID) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { //_DALDbCar.DeleteCustomerCarByCarID(argsInTrans, CarID); _DALDbCar.Customer_Delete(argsInTrans, CarID); }; DBHelper.ExecInTrans(args, exec); }
public void Car_Insert(FactoryArgs args, out t_BigID CarID, out t_String CarCode, t_String CarNum, t_BigID SupplierID, t_BigID CardID, t_String Description, t_Decimal DefaultCarWeight) { CarCode = new t_String(); CarID = new t_BigID(); DefaultCarWeight.IsNullToZero(); CardID.NullIfZero(); SupplierID.NullIfZero(); using (DataTable dtCar = _DALDbCar.GetCarByName(args, CarID, CarNum)) { if (dtCar.Rows.Count > 0) { throw new Exception("该车牌号码已存在!"); } } t_BigID CarID_temp = new t_BigID(); t_String CarCode_temp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { t_String MaxCode; _DALDbCar.GetMaxCarCode(argsInTrans, out MaxCode); int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("C", "")); CodeIndex++; if (CodeIndex < 10) { CarCode_temp.SetValueWithObject("C000" + CodeIndex.ToString()); } else if (CodeIndex < 100) { CarCode_temp.SetValueWithObject("C00" + CodeIndex.ToString()); } else if (CodeIndex < 1000) { CarCode_temp.SetValueWithObject("C0" + CodeIndex.ToString()); } else { CarCode_temp.SetValueWithObject("C" + CodeIndex.ToString()); } if (CardID.Value > 0)//取消卡片的车辆关联 { CancelRefCard(argsInTrans, CardID); } _DALDbCar.Car_Insert(argsInTrans, out CarID_temp, CarCode_temp, CarNum, Description, DefaultCarWeight, SupplierID, CardID); }; DBHelper.ExecInTrans(args, exec); CarID.Value = CarID_temp.Value; CarCode.Value = CarCode_temp.Value; }
public void Customer_Delete(FactoryArgs args, t_BigID CustomerID) { using (DataTable dtCar = _DALDbCustomer.GetCarByCustomer(args, CustomerID)) { if (dtCar.Rows.Count > 0) { throw new Exception("该客户已关联车辆,无法删除!"); } } DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { _DALDbCar.DeleteCustomerCarByCustomerID(argsInTrans, CustomerID); _DALDbCustomer.Customer_Delete(args, CustomerID); }; DBHelper.ExecInTrans(args, exec); }
public void InsertUpdateUserCnofig(FactoryArgs args, t_ID WeightDeviceType, t_String MachineName, t_ID DeviceBoTeLv, t_ID DeviceShuJuWei, t_ID DeviceTingZhiWei, t_ID DeviceZhenChangDu, t_ID DeviceZhenQiShiBiaoShi, t_ID DeviceZhenChuLiFangShi, t_ID DeviceChongFuWeiZhi, t_ID DeviceChongFuChangDu, t_ID DeviceXiaoShuWei, t_ID DeviceFuHaoKaiShi, t_String SerialName) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { t_BigID WeightDeviceUserTypeID = new t_BigID(); using (DataTable dtUserType = _DbWeightDeviceUserType.GetUserType(argsInTrans, MachineName)) { if (dtUserType.Rows.Count > 0) { DataRow drUserType = dtUserType.Rows[0]; WeightDeviceUserTypeID.SetValueWithObject(drUserType["WeightDeviceUserTypeID"]); _DbWeightDeviceUserType.UpdateUserType(argsInTrans, WeightDeviceUserTypeID, WeightDeviceType, MachineName, SerialName); } else { _DbWeightDeviceUserType.InsertUserType(argsInTrans, out WeightDeviceUserTypeID, WeightDeviceType, MachineName, SerialName); } } if (WeightDeviceType.Value == 0) { using (DataTable dtUserConfig = _DbWeightDeviceUserType.GetUserConfig(argsInTrans, WeightDeviceUserTypeID)) { if (dtUserConfig.Rows.Count == 0) { _DbWeightDeviceUserType.InsertUserCnofig(argsInTrans, WeightDeviceUserTypeID, DeviceBoTeLv, DeviceShuJuWei, DeviceTingZhiWei, DeviceZhenChangDu, DeviceZhenQiShiBiaoShi, DeviceZhenChuLiFangShi, DeviceChongFuWeiZhi, DeviceChongFuChangDu, DeviceXiaoShuWei, DeviceFuHaoKaiShi); } else { _DbWeightDeviceUserType.UpdateUserCnofig(argsInTrans, WeightDeviceUserTypeID, DeviceBoTeLv, DeviceShuJuWei, DeviceTingZhiWei, DeviceZhenChangDu, DeviceZhenQiShiBiaoShi, DeviceZhenChuLiFangShi, DeviceChongFuWeiZhi, DeviceChongFuChangDu, DeviceXiaoShuWei, DeviceFuHaoKaiShi); } } } }; DBHelper.ExecInTrans(args, exec); }
public void UnApprove(FactoryArgs args, t_BigID ReceiveBillHeaderID) { t_Decimal ReceiveAmount = new t_Decimal(0); t_BigID CustomerID = new t_BigID(); t_Decimal SalesReceiveAmountAdd = new t_Decimal(0); t_Decimal SalesReceiveAmountReduce = new t_Decimal(0); using (DataTable dtHeader = _DALRPReceiveBillHeader.GetRPReceiveBillHeader(args, ReceiveBillHeaderID)) { if (dtHeader.Rows.Count > 0) { DataRow drHeader = dtHeader.Rows[0]; bool bolIsApprove = LBConverter.ToBoolean(drHeader["IsApprove"]); bool bolIsCancel = LBConverter.ToBoolean(drHeader["IsCancel"]); ReceiveAmount.SetValueWithObject(drHeader["ReceiveAmount"]); SalesReceiveAmountAdd.SetValueWithObject(drHeader["SalesReceiveAmountAdd"]); SalesReceiveAmountReduce.SetValueWithObject(drHeader["SalesReceiveAmountReduce"]); CustomerID.SetValueWithObject(drHeader["CustomerID"]); if (!bolIsApprove) { throw new Exception("该充值单未审核,无法执行取消审核!"); } if (bolIsCancel) { throw new Exception("该充值单已作废,无法执行取消审核!"); } } else { throw new Exception("该充值单已删除,无法执行取消审核!"); } } DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { _DALRPReceiveBillHeader.UnApprove(argsInTrans, ReceiveBillHeaderID); //扣减客户收款金额 ReceiveAmount.SetValueWithObject(-ReceiveAmount.Value); SalesReceiveAmountAdd.SetValueWithObject(-SalesReceiveAmountAdd.Value); SalesReceiveAmountReduce.SetValueWithObject(-SalesReceiveAmountReduce.Value); _DALRPReceiveBillHeader.UpdateCustomerReceiveAmount(argsInTrans, CustomerID, ReceiveAmount, SalesReceiveAmountAdd, SalesReceiveAmountReduce); }; DBHelper.ExecInTrans(args, exec); }
public void SaveUserPermission(FactoryArgs args, t_BigID UserID, t_Table DTUserPermission, t_Table DTUserPermissionData) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { _DALUserPermission.DeleteUserPermission(argsInTrans, UserID); _DALUserPermission.DeleteUserPermissionData(argsInTrans, UserID); foreach (DataRow dr in DTUserPermissionData.Value.Rows) { long lPermissionID = Convert.ToInt64(dr["PermissionID"]); DTUserPermission.Value.DefaultView.RowFilter = "HasPermission=1 and PermissionID=" + lPermissionID; if (DTUserPermission.Value.DefaultView.Count == 0) { bool bolHasPermission = dr["HasPermission"] == DBNull.Value ? false : Convert.ToBoolean(dr["HasPermission"]); t_BigID PermissionDataID = new t_BigID(dr["PermissionDataID"]); if (bolHasPermission) { _DALUserPermission.InsertUserPermissionData(argsInTrans, UserID, PermissionDataID); } } } foreach (DataRow dr in DTUserPermission.Value.Rows) { long lPermissionID = Convert.ToInt64(dr["PermissionID"]); bool bolHasPermission = dr["HasPermission"] == DBNull.Value ? false : Convert.ToBoolean(dr["HasPermission"]); t_BigID PermissionID = new t_BigID(dr["PermissionID"]); if (bolHasPermission) { _DALUserPermission.InsertUserPermission(argsInTrans, UserID, PermissionID); } } }; DBHelper.ExecInTrans(args, exec); }
public void Customer_InsertFromService(FactoryArgs args, out t_BigID CustomerID, out t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode, t_BigID CustomerTypeID) { CustomerID = new t_BigID(); CustomerCode = new t_String(); t_BigID CustomerIDTemp = new t_BigID(); t_String CustomerCodeTemp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { this.Customer_Insert(argsInTrans, out CustomerIDTemp, out CustomerCodeTemp, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID); _DALDbCustomer.UpdateAmount(argsInTrans, CustomerIDTemp, TotalReceivedAmount, SalesReceivedAmount); }; DBHelper.ExecInTrans(args, exec); CustomerID.Value = CustomerIDTemp.Value; CustomerCode.Value = CustomerCodeTemp.Value; }
public void Car_Update(FactoryArgs args, t_BigID CarID, t_String CarNum, t_BigID CustomerID, t_String Description, t_Decimal DefaultCarWeight, t_BigID SupplierID, t_BigID CardID) { DefaultCarWeight.IsNullToZero(); using (DataTable dtCar = _DALDbCar.GetCarByName(args, CarID, CarNum)) { if (dtCar.Rows.Count > 0) { throw new Exception("该车牌号码已存在!"); } } DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { if (CardID.Value > 0)//取消卡片的车辆关联 { CancelRefCard(argsInTrans, CardID); } _DALDbCar.Car_Update(argsInTrans, CarID, CarNum, Description, DefaultCarWeight, SupplierID, CardID); }; DBHelper.ExecInTrans(args, exec); }
public void ChargeType_Insert(FactoryArgs args, out t_BigID ChargeTypeID, out t_String ChargeTypeCode, t_String ChargeTypeName) { ChargeTypeCode = new t_String(); ChargeTypeID = new t_BigID(); using (DataTable dtCar = _DALDbChargeType.GetChargeTypeByName(args, ChargeTypeID, ChargeTypeName)) { if (dtCar.Rows.Count > 0) { throw new Exception("该收款方式已存在!"); } } t_BigID ChargeTypeID_temp = new t_BigID(); t_String ChargeTypeCode_temp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { t_String MaxCode; _DALDbChargeType.GetMaxCarCode(argsInTrans, out MaxCode); int CodeIndex = MaxCode.Value == null?0: LBConverter.ToInt32(MaxCode.Value.Replace("F", "")); CodeIndex++; if (CodeIndex < 10) { ChargeTypeCode_temp.SetValueWithObject("F0" + CodeIndex.ToString()); } else { ChargeTypeCode_temp.SetValueWithObject("F" + CodeIndex.ToString()); } _DALDbChargeType.ChargeType_Insert(argsInTrans, out ChargeTypeID_temp, ChargeTypeCode_temp, ChargeTypeName); }; DBHelper.ExecInTrans(args, exec); ChargeTypeID.Value = ChargeTypeID_temp.Value; ChargeTypeCode.Value = ChargeTypeCode_temp.Value; }
public void Bank_Insert(FactoryArgs args, out t_BigID ReceiveBankID, out t_String BankCode, t_String BankName) { BankCode = new t_String(); ReceiveBankID = new t_BigID(); using (DataTable dtCar = _DALDbBank.GetBankByName(args, ReceiveBankID, BankName)) { if (dtCar.Rows.Count > 0) { throw new Exception("该收款银行名称已存在!"); } } t_BigID BankID_temp = new t_BigID(); t_String BankCode_temp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { t_String MaxCode; _DALDbBank.GetMaxCarCode(argsInTrans, out MaxCode); int CodeIndex = MaxCode.Value == null?0: LBConverter.ToInt32(MaxCode.Value.Replace("C", "")); CodeIndex++; if (CodeIndex < 10) { BankCode_temp.SetValueWithObject("Y0" + CodeIndex.ToString()); } else { BankCode_temp.SetValueWithObject("Y" + CodeIndex.ToString()); } _DALDbBank.Bank_Insert(argsInTrans, out BankID_temp, BankCode_temp, BankName); }; DBHelper.ExecInTrans(args, exec); ReceiveBankID.Value = BankID_temp.Value; BankCode.Value = BankCode_temp.Value; }
public void Supplier_Insert(FactoryArgs args, out t_BigID SupplierID, out t_String SupplierCode, t_String SupplierName, t_ID IsForbidden) { SupplierCode = new t_String(); SupplierID = new t_BigID(); IsForbidden.IsNullToZero(); using (DataTable dtSupplier = _DALDbSupplier.GetSupplierByName(args, SupplierID, SupplierName)) { if (dtSupplier.Rows.Count > 0) { throw new Exception("该供应商名称已存在!"); } } t_BigID SupplierID_temp = new t_BigID(); t_String SupplierCode_temp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { t_String MaxCode; _DALDbSupplier.GetMaxCarCode(argsInTrans, out MaxCode); int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("G", "")); CodeIndex++; if (CodeIndex < 10) { SupplierCode_temp.SetValueWithObject("G0" + CodeIndex.ToString()); } else { SupplierCode_temp.SetValueWithObject("G" + CodeIndex.ToString()); } _DALDbSupplier.Supplier_Insert(argsInTrans, out SupplierID_temp, SupplierName, SupplierCode_temp, IsForbidden); }; DBHelper.ExecInTrans(args, exec); SupplierID.Value = SupplierID_temp.Value; SupplierCode.Value = SupplierCode_temp.Value; }
public void Update(FactoryArgs args, t_BigID SaleCarReturnBillID, t_Decimal CarTare, t_Decimal SuttleWeight, t_ID ReturnType, t_String Description, t_ID ReturnReason, out t_String NewSaleCarInBillCode, out t_String NewSaleCarOutBillCode, out t_BigID NewSaleCarInBillID, out t_BigID NewSaleCarOutBillID) { NewSaleCarInBillCode = new t_String(); NewSaleCarOutBillCode = new t_String(); t_String NewSaleCarInBillCode_temp = new t_String(); t_String NewSaleCarOutBillCode_temp = new t_String(); NewSaleCarInBillID = new t_BigID(); NewSaleCarOutBillID = new t_BigID(); t_BigID NewSaleCarInBillID_temp = new t_BigID(); t_BigID NewSaleCarOutBillID_temp = new t_BigID(); t_String SaleCarReturnBilCode = new t_String(); t_BigID SaleCarInBillID = new t_BigID(); using (DataTable dtReturnBill = _DALSaleCarReturnBill.GetReturnBill(args, SaleCarReturnBillID)) { if (dtReturnBill.Rows.Count > 0) { DataRow drReturn = dtReturnBill.Rows[0]; SaleCarReturnBilCode.SetValueWithObject(drReturn["SaleCarReturnBilCode"]); SaleCarInBillID.Value = LBConverter.ToInt64(drReturn["SaleCarInBillID"]); int iReturnStatus = LBConverter.ToInt32(drReturn["ReturnStatus"]); if (iReturnStatus == 1) { throw new Exception("该退货记录已完成,无法重复退货!"); } } } DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { using (DataTable dtInBill = _DALSaleCarInOutBill.GetSaleCarInBill(argsInTrans, SaleCarInBillID)) { if (dtInBill.Rows.Count > 0)//校验是否已审核或者已作废 { DataRow drBill = dtInBill.Rows[0]; int iBillStatus = LBConverter.ToInt32(drBill["BillStatus"]); bool bolIsCancel = LBConverter.ToBoolean(drBill["IsCancel"]); t_String ReturnReasonConstText; _IBLLDbSystemConst.GetConstValue(argsInTrans, new t_String("ReturnReason"), new t_String(ReturnReason.Value.ToString()), out ReturnReasonConstText); string strCancelDesc = (ReturnType.Value == 0 ? "完全退货作废" : "部分退货作废") + ",退货单号【" + SaleCarReturnBilCode.Value + "】,退货原因:" + ReturnReasonConstText.Value; //先取消审核磅单 if (iBillStatus == 2) { _IBLLSaleCarInOutBill.UnApprove(argsInTrans, SaleCarInBillID); //取消审核 _IBLLSaleCarInOutBill.Cancel(argsInTrans, SaleCarInBillID, new t_String(strCancelDesc)); ////作废订单 } else if (iBillStatus == 0) { //作废订单 _IBLLSaleCarInOutBill.Cancel(argsInTrans, SaleCarInBillID, new t_String(strCancelDesc)); } if (ReturnType.Value == 0)//完全退货 { //无需处理 } else if (ReturnType.Value == 1)//部分退货 { _IBLLSaleCarInOutBill.CopySaleBill(argsInTrans, SaleCarInBillID, CarTare, out NewSaleCarInBillID_temp, out NewSaleCarOutBillID_temp, out NewSaleCarInBillCode_temp, out NewSaleCarOutBillCode_temp); //_IBLLSaleCarInOutBill.Approve(argsInTrans, NewSaleCarInBillID); } if (bolIsCancel) { throw new Exception("该磅单已作废,无法退货!"); } if (iBillStatus != 2) { throw new Exception("该磅单未审核或者未完成,无法退货!"); } _DALSaleCarReturnBill.Update(argsInTrans, SaleCarReturnBillID, CarTare, SuttleWeight, ReturnType, Description, ReturnReason, NewSaleCarInBillID_temp); } } }; DBHelper.ExecInTrans(args, exec); //_DALSaleCarReturnBill.Insert(args, out SaleCarReturnBillID, SaleCarInBillID, TotalWeight); NewSaleCarInBillCode.Value = NewSaleCarInBillCode_temp.Value; NewSaleCarOutBillCode.Value = NewSaleCarOutBillCode_temp.Value; NewSaleCarInBillID.Value = NewSaleCarInBillID_temp.Value; NewSaleCarOutBillID.Value = NewSaleCarOutBillID_temp.Value; }