/// <summary>
/// 根据输入的PO单据号获取应付款中的PO单列表
/// </summary>
/// <param name="condition"></param>
/// <param name="entity"></param>
/// <returns></returns>
public virtual List <POItemCheckEntity> GetPOCheckList(List <int> condition, APInvoiceItemInputEntity entity)
{
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("POInputCheck");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, null, "POM.VendorSysNo"))
{
sqlBuilder.ConditionConstructor.AddInCondition(
QueryConditionRelationType.AND,
"pay.OrderSysNo",
DbType.Int32,
condition);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"pay.OrderType",
DbType.Int32,
"@OrderType",
QueryConditionOperatorType.Equal,
entity.OrderType);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"pay.CompanyCode",
DbType.AnsiStringFixedLength,
"@CompanyCode",
QueryConditionOperatorType.Equal,
entity.CompanyCode);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
return(dataCommand.ExecuteEntityList <POItemCheckEntity>());
}
}
public APInvoiceInfoResp InputInvoiceItem(APInvoiceItemInputEntity inputEntity)
{
string errorMsg = string.Empty;
List <APInvoiceInvoiceItemInfo> result = appService.InputInvoiceItem(inputEntity, ref errorMsg);
return(new APInvoiceInfoResp()
{
invoiceItemList = result,
ErrorMsg = errorMsg
});
}
/// <summary>
/// 录入InvoiceItem
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void HyperlinkButton_InputInvoiceItem_Click(object sender, RoutedEventArgs e)
{
if (!ValidateInvInput())
{
if (this.vm.ItemInvoiceAmt == null)
{
this.Text_ItemInvoiceAmt.Focus();
}
return;
}
if (!vm.VendorSysNo.HasValue)
{
this.Text_InvoiceItemsStatistic.Foreground = RedBrush;
this.Text_InvoiceItemsStatistic.Text = ResInvoiceInputMaintain.Msg_Tips + ResInvoiceInputMaintain.Msg_ValidateVendor;
//Window.Alert(ResInvoiceInputMaintain.Msg_ValidateVendor);
return;
}
APInvoiceItemInputEntity request = new APInvoiceItemInputEntity();
request.ItemsNoList = vm.InvoiceItemNoList;
request.InvoiceDate = vm.InvoiceDate;
request.InvoiceAmt = vm.ItemInvoiceAmt;
request.VendorSysNo = vm.VendorSysNo;
request.VendorName = vm.VendorName;
request.CompanyCode = CPApplication.Current.CompanyCode;
request.InvoiceItemList = vm.ConvertVM <InvoiceInputMaintainVM, APInvoiceInfo>().InvoiceItemList;
facade.InputInvoiceItem(request, (obj, args) =>
{
APInvoiceInfo info = new APInvoiceInfo();
info.InvoiceItemList = args.Result.invoiceItemList;
InvoiceInputMaintainVM resultVM = info.Convert <APInvoiceInfo, InvoiceInputMaintainVM>();
vm.InvoiceItemList = resultVM.InvoiceItemList;
if (!string.IsNullOrEmpty(args.Result.ErrorMsg))
{
//Window.Alert(args.Result.ErrorMsg);
this.Text_InvoiceItemsStatistic.Foreground = RedBrush;
this.Text_InvoiceItemsStatistic.Text = args.Result.ErrorMsg;
}
else
{
this.Text_InvoiceItemsStatistic.Text = string.Empty;
}
if (vm.POItemList.Count > 0 && vm.InvoiceItemList.Count > 0)
{
btnDiffCalc.IsEnabled = true;
}
this.Text_InvoiceNo.Focus();
});
}
/// <summary>
/// 录入PoItem
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void HyperlinkButton_InputPoItem_Click(object sender, RoutedEventArgs e)
{
if (!ValidatePOInput())
{
return;
}
APInvoiceItemInputEntity request = new APInvoiceItemInputEntity();
request.ItemsNoList = vm.POItemNoList;
request.OrderType = vm.OrderType;
request.VendorSysNo = vm.VendorSysNo;
request.VendorName = vm.VendorName;
request.CompanyCode = CPApplication.Current.CompanyCode;
request.POItemList = vm.ConvertVM <InvoiceInputMaintainVM, APInvoiceInfo>().POItemList;
facade.InputPoItem(request, (obj, args) =>
{
APInvoiceInfo info = new APInvoiceInfo();
info.POItemList = args.Result.poItemList;
info.VendorName = args.Result.VendorName;
info.VendorSysNo = args.Result.VendorSysNo;
InvoiceInputMaintainVM resultVM = info.Convert <APInvoiceInfo, InvoiceInputMaintainVM>();
vm.POItemList = resultVM.POItemList;
vm.VendorSysNo = resultVM.VendorSysNo;
vm.VendorName = resultVM.VendorName;
if (!string.IsNullOrEmpty(args.Result.ErrorMsg))
{
this.Text_POItemsStatistic.Foreground = RedBrush;
this.Text_POItemsStatistic.Text = args.Result.ErrorMsg;
//Window.Alert(args.Result.ErrorMsg);
}
else
{
this.Text_POItemsStatistic.Text = string.Empty;
}
if (vm.POItemList.Count > 0)
{
VendorPicker.IsEnabled = false;
}
else
{
VendorPicker.IsEnabled = true;
}
if (vm.POItemList.Count > 0 && vm.InvoiceItemList.Count > 0)
{
btnDiffCalc.IsEnabled = true;
}
});
}
/// <summary>
/// 加载供应商未录入的Poitems
/// </summary>
/// <param name="request"></param>
/// <param name="callback"></param>
public void LoadNotInputPOItems(APInvoiceItemInputEntity request, EventHandler <RestClientEventArgs <List <APInvoicePOItemInfo> > > callback)
{
string relativeUrl = string.Format("/InvoiceService/InvoiceInput/LoadNotInputPOItems", request);
restClient.Query <List <APInvoicePOItemInfo> >(relativeUrl, request, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
/// <summary>
/// 录入InvoiceItems
/// </summary>
/// <param name="request"></param>
/// <param name="callback"></param>
public void InputInvoiceItem(APInvoiceItemInputEntity request, EventHandler <RestClientEventArgs <APInvoiceInfoResp> > callback)
{
string relativeUrl = "/InvoiceService/InvoiceInput/InputInvoiceItem";
restClient.Create <APInvoiceInfoResp>(relativeUrl, request, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
public APInvoiceInfoResp InputPoItem(APInvoiceItemInputEntity inputEntity)
{
string errorMsg = string.Empty;
string vendorName = string.Empty;
int vendorSysNo;
List <APInvoicePOItemInfo> result = appService.InputPoItem(inputEntity, ref vendorName, ref errorMsg, out vendorSysNo);
return(new APInvoiceInfoResp()
{
poItemList = result,
VendorName = vendorName,
VendorSysNo = vendorSysNo,
ErrorMsg = errorMsg
});
}
/// <summary>
/// 加载供应商未录入的PO单据
/// </summary>
/// <param name="request">查询条件</param>
/// <returns></returns>
public virtual List <APInvoicePOItemInfo> LoadNotInputPOItems(APInvoiceItemInputEntity request)
{
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("LoadNotInputPOItems");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, null, "A.OrderSysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND
, "A.PoBaselineDate"
, DbType.DateTime
, "@PODateFrom"
, QueryConditionOperatorType.MoreThanOrEqual
, request.PODateFrom);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
}
dataCommand.AddInputParameter("@VendorSysNo", DbType.Int32, request.VendorSysNo);
dataCommand.AddInputParameter("@CompanyCode", DbType.AnsiStringFixedLength, request.CompanyCode);
return(dataCommand.ExecuteEntityList <APInvoicePOItemInfo>());
}
/// <summary>
/// 根据条件加载供应商未录入的POItems
/// 1.必须选择供应商。
/// 2.可选条件--加载日期起始。
/// 3.加载时会保留原有页面中的数据--只会更新POItems表，且保留原表中的数据。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void HyperlinkButton_LoadPOItems_Click(object sender, RoutedEventArgs e)
{
if (!vm.VendorSysNo.HasValue)
{
Window.Alert(ResInvoiceInputMaintain.Msg_ValidateVendor);
return;
}
APInvoiceItemInputEntity request = new APInvoiceItemInputEntity();
request.CompanyCode = CPApplication.Current.CompanyCode;
request.VendorSysNo = vm.VendorSysNo;
request.POItemList = vm.ConvertVM <InvoiceInputMaintainVM, APInvoiceInfo>().POItemList;
request.PODateFrom = vm.PODateFrom;
facade.LoadNotInputPOItems(request, (obj, args) =>
{
APInvoiceInfo info = new APInvoiceInfo();
info.POItemList = args.Result;
InvoiceInputMaintainVM resultVM = info.Convert <APInvoiceInfo, InvoiceInputMaintainVM>();
vm.POItemList = resultVM.POItemList;
if (vm.POItemList.Count > 0)
{
VendorPicker.IsEnabled = false;
this.Text_POItemsStatistic.Foreground = BlackBrush;
this.Text_POItemsStatistic.Text = ResInvoiceInputMaintain.Msg_LoadSuccess;
}
else
{
VendorPicker.IsEnabled = true;
Window.Alert(ResInvoiceInputMaintain.Msg_EmptyPoItems);
}
if (vm.POItemList.Count > 0 && vm.InvoiceItemList.Count > 0)
{
btnDiffCalc.IsEnabled = true;
}
});
}
public List <APInvoicePOItemInfo> LoadNotInputPOItems(APInvoiceItemInputEntity request)
{
return(appService.LoadNotInputPOItems(request));
}
/// <summary>
/// 获取无效的发票号码
/// </summary>
/// <param name="invoiceList"></param>
/// <param name="entity"></param>
/// <returns></returns>
public virtual List <string> GetInvalidInvoiceNo(List <string> invoiceList, APInvoiceItemInputEntity entity)
{
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetInvalidInvoiceNo");
List <string> result = new List <string>();
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, null, "API.InvoiceNo"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND
, "APM.VendorSysNo"
, DbType.Int32
, "@VendorSysNo"
, QueryConditionOperatorType.Equal
, entity.VendorSysNo);
sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND
, "API.[Status]"
, DbType.String
, "@ItemStatus"
, QueryConditionOperatorType.Equal
, APInvoiceItemStatus.Active);
sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.OR);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND
, "API.[Status]"
, DbType.String
, "@ItemNStatus"
, QueryConditionOperatorType.Equal
, APInvoiceItemStatus.Deactive);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND
, "APM.[Status]"
, DbType.Int32
, "@MasterStatus"
, QueryConditionOperatorType.MoreThanOrEqual
, APInvoiceMasterStatus.Origin);
sqlBuilder.ConditionConstructor.EndGroupCondition();
sqlBuilder.ConditionConstructor.EndGroupCondition();
sqlBuilder.ConditionConstructor.AddInCondition(QueryConditionRelationType.AND
, "API.InvoiceNo"
, DbType.String
, invoiceList);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"API.CompanyCode",
DbType.AnsiStringFixedLength,
"@CompanyCode",
QueryConditionOperatorType.Equal,
entity.CompanyCode);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var dataSet = dataCommand.ExecuteDataSet();
if (dataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
result.Add(dr["InvoiceNo"].ToString());
}
}
}
return(result);
}
/// <summary>
/// 录入PoItem
/// </summary>
/// <param name="checkInfo"></param>
/// <param name="vendorName"></param>
/// <param name="errorMsg"></param>
/// <param name="vendorSysNo"></param>
/// <returns></returns>
public virtual List <APInvoicePOItemInfo> InputPoItem(APInvoiceItemInputEntity inputEntity, ref string vendorName, ref string errorMsg, out int vendorSysNo)
{
return(processor.InputPoItem(inputEntity, ref vendorName, ref errorMsg, out vendorSysNo));
}
/// <summary>
/// 录入InvoiceItem
/// </summary>
/// <param name="inputEntity"></param>
/// <param name="errorMsg"></param>
/// <returns></returns>
public virtual List <APInvoiceInvoiceItemInfo> InputInvoiceItem(APInvoiceItemInputEntity inputEntity, ref string errorMsg)
{
return(processor.InputInvoiceItem(inputEntity, ref errorMsg));
}
/// <summary>
/// 加载供应商未录入的POItems
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public virtual List <APInvoicePOItemInfo> LoadNotInputPOItems(APInvoiceItemInputEntity request)
{
return(processor.LoadNotInputPOItems(request));
}
