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