/// <summary> /// 加载发票信息 /// </summary> /// <param name="invoiceSysNo"></param> /// <returns></returns> public InvoiceInfo LoadBySysNo(int invoiceSysNo) { InvoiceMasterInfo masterInfo = null; List <InvoiceTransactionInfo> transactionList = null; //加载Master信息 DataCommand dataCommand = DataCommandManager.GetDataCommand("GetInvoiceMasterBySysNo"); dataCommand.SetParameterValue("@InvoiceNumber", invoiceSysNo); masterInfo = dataCommand.ExecuteEntity <InvoiceMasterInfo>(); //加载Transaction列表 dataCommand = DataCommandManager.GetDataCommand("GetInvoiceTransactionListByMasterSysNo"); dataCommand.SetParameterValue("@MasterInvoiceNumber", masterInfo.SysNo); transactionList = dataCommand.ExecuteEntityList <InvoiceTransactionInfo>(); InvoiceInfo invoice = new InvoiceInfo() { SysNo = masterInfo.SysNo, MasterInfo = masterInfo, InvoiceTransactionInfoList = transactionList, CompanyCode = masterInfo.CompanyCode }; return(invoice); }
private void InnerCreateInvoiceMaster(InvoiceMasterInfo invoiceMaster, out int invoiceSysNo) { DataCommand dataCommand = DataCommandManager.GetDataCommand("InsertInvoiceMaster"); dataCommand.SetParameterValue <InvoiceMasterInfo>(invoiceMaster); invoiceSysNo = Convert.ToInt32(dataCommand.ExecuteScalar()); }
public static void SaveCustomer(InvoiceMasterInfo objInvoiceMasterInfo) { Dictionary <string, object> ParamDict = new Dictionary <string, object>(); ParamDict.Add("@InvoiceDate", objInvoiceMasterInfo.InvoiceDate); ParamDict.Add("@BilledTo", objInvoiceMasterInfo.BilledTo); ParamDict.Add("@ShippedTo", objInvoiceMasterInfo.ShippedTo); ParamDict.Add("@Discount", objInvoiceMasterInfo.Discount); ParamDict.Add("@OtherCharges", objInvoiceMasterInfo.OtherCharges); ParamDict.Add("@TransportMode", objInvoiceMasterInfo.TransportMode); ParamDict.Add("@VehicleNumber", objInvoiceMasterInfo.VehicleNumber); ParamDict.Add("@PoNum", objInvoiceMasterInfo.PoNum); ParamDict.Add("@PoDate", objInvoiceMasterInfo.PoDate); DataAccess.ExecuteNonQuery(@" INSERT INTO InvoiceMaster ( InvoiceDate, BilledTo, ShippedTo, Discount, OtherCharges, TransportMode, VehicleNumber, PoNum, PoDate) VALUES ( @InvoiceDate, @BilledTo, @ShippedTo, @Discount, @OtherCharges, @TransportMode, @VehicleNumber, @PoNum, @PoDate) " , ParamDict, CommandType.Text); var A = DataAccess.GetTableFromQuery("SELECT @@Identity", null, CommandType.Text); }
private InvoiceMasterInfo GetValueFromTextBoxInvoiceMaster() { var objInvoiceMasterInfo = new InvoiceMasterInfo(); var id = ""; var ObjItemInfo = new ItemInfo(); if (GlobalObjInvoiceMasterInfo != null) { id = GlobalObjInvoiceMasterInfo.ID; } objInvoiceMasterInfo.ID = id; objInvoiceMasterInfo.InvoiceDate = idDpInvoiceDate.Text; objInvoiceMasterInfo.BilledTo = idCmbBilledTo.Text; objInvoiceMasterInfo.ShippedTo = idCmbShippedTo.Text; objInvoiceMasterInfo.Discount = idTxtDiscount.Text; objInvoiceMasterInfo.OtherCharges = idTxtOtherCharges.Text; objInvoiceMasterInfo.TransportMode = idCmbTransportMode.Text; objInvoiceMasterInfo.VehicleNumber = idCmbVehicleNum.Text; objInvoiceMasterInfo.PoNum = idTxtPoNo.Text; objInvoiceMasterInfo.PoDate = idDpPoDate.Text; return(objInvoiceMasterInfo); }
public Invoice(InvoiceMasterInfo objInvoiceMasterInfo = null, List <InvoiceItemInfo> ObjInvoiceItemInfo = null) { GlobalObjInvoiceMasterInfo = objInvoiceMasterInfo; GlobalObjInvoiceItemInfo = ObjInvoiceItemInfo; InitializeComponent(); }