/// <summary>
/// 根据发票号查询发票信息
/// </summary>
/// <param name="invoiceInputSysNos"></param>
/// <returns></returns>
public List <EIMSInvoiceInfoEntity> QueryEIMSInvoiceInputByInvoiceInputSysNo(List <string> invoiceInputSysNos)
{
if (invoiceInputSysNos == null ||
invoiceInputSysNos.Count == 0)
{
return(new List <EIMSInvoiceInfoEntity>());
}
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("EIMS_Query_InvoiceListByInvoiceInputSysNo");
string InvoiceInputNo = string.Empty;
for (int i = 0; i < invoiceInputSysNos.Count; i++)
{
if (i > 0)
{
InvoiceInputNo += ",";
}
InvoiceInputNo += string.Format("'{0}'", invoiceInputSysNos[0]);
}
command.CommandText = command.CommandText.Replace("#InvoiceInputNo#", InvoiceInputNo);
List <EIMSInvoiceInfoEntity> list = new List <EIMSInvoiceInfoEntity>();
using (IDataReader reader = command.ExecuteDataReader())
{
EIMSInvoiceInfoEntity model = null;
while (reader.Read())
{
model = new EIMSInvoiceInfoEntity();
model.SysNo = Convert.ToInt32(reader["SysNo"]);
model.InvoiceInputNo = reader["InvoiceInputNo"].ToString();
list.Add(model);
}
}
return(list);
}
public void UpdateInvoiceInput(EIMSInvoiceInfoEntity entity)
{
DataCommand command = DataCommandManager.GetDataCommand("EIMS_Update_InvoiceInput");
command.SetParameterValue("@SysNo", entity.SysNo);
command.SetParameterValue("@InvoiceDate", entity.InvoiceDate);
command.SetParameterValue("@InvoiceEditDateTime", entity.InvoiceEditDateTime);
command.SetParameterValue("@InvoiceEditUser", entity.InvoiceEditUser);
command.SetParameterValue("@InvoiceInputAmount", entity.InvoiceInputAmount);
command.SetParameterValue("@InvoiceInputNo", entity.InvoiceInputNo);
command.SetParameterValue("@Memo", entity.Memo);
command.SetParameterValue("@Status", entity.Status);
command.SetParameterValue("@TaxRate", entity.TaxRate);
command.SetParameterValue("@VendorNumber", entity.VendorNumber);
command.ExecuteNonQuery();
}
