/// <summary>
/// 根据发票号查询单据信息
/// </summary>
/// <param name="invoiceInputSysNos"></param>
/// <returns></returns>
public List <EIMSInvoiceInputExtendInfo> QueryEIMSInvoiceInputExtendByInvoiceInputSysNo(params int[] invoiceInputSysNos)
{
if (invoiceInputSysNos == null ||
invoiceInputSysNos.Length == 0)
{
return(new List <EIMSInvoiceInputExtendInfo>());
}
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("EIMS_Query_ExtendListByInvoiceInputSysNo");
string InvoiceInputSysNo = string.Empty;
for (int i = 0; i < invoiceInputSysNos.Length; i++)
{
if (i > 0)
{
InvoiceInputSysNo += ",";
}
InvoiceInputSysNo += string.Format("{0}", invoiceInputSysNos[i]);
}
command.CommandText = command.CommandText.Replace("#InvoiceInputSysNo#", InvoiceInputSysNo);
List <EIMSInvoiceInputExtendInfo> list = new List <EIMSInvoiceInputExtendInfo>();
using (IDataReader reader = command.ExecuteDataReader())
{
EIMSInvoiceInputExtendInfo model = null;
while (reader.Read())
{
model = new EIMSInvoiceInputExtendInfo();
model.SysNo = Convert.ToInt32(reader["SysNo"]);
model.InvoiceNumber = reader["InvoiceNumber"].ToString();
model.InvoiceInputSysNo = Convert.ToInt32(reader["InvoiceInputSysNo"]);
list.Add(model);
}
}
return(list);
}
public void UpdateInvoiceInputExtend(EIMSInvoiceInputExtendInfo entity)
{
DataCommand command = DataCommandManager.GetDataCommand("EIMS_Update_InvoiceInputExtend");
command.SetParameterValue("@SysNo", entity.SysNo);
command.SetParameterValue("@InvoiceInputSysNo", entity.InvoiceInputSysNo);
command.SetParameterValue("@InvoiceNumber", entity.InvoiceNumber);
command.SetParameterValue("@Status", entity.Status);
command.ExecuteNonQuery();
}
