/// <summary>
/// 查询此商品对应需要关闭的虚库申请单数量
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryNeedCloseRequestCount(VirtualRequestQueryFilter queryFilter, EventHandler <RestClientEventArgs <int> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "/InventoryService/VirtualRequest/QueryNeedCloseRequestCount";
restClient.Query <int>(relativeUrl, queryFilter, callback);
}
/// <summary>
/// 查询虚库单关闭日志List
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryVirtualRequestCloseLog(VirtualRequestQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "/InventoryService/VirtualRequest/QueryVirtualRequestCloseLog";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
/// <summary>
/// 导出虚库设置信息
/// </summary>
/// <param name="model"></param>
/// <param name="columns"></param>
public void ExportExcelForVirtualRequest(VirtualRequestQueryFilter queryFilter, ColumnSet[] columns)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "/InventoryService/VirtualRequest/QueryVirtualRequestList";
restClient.ExportFile(relativeUrl, queryFilter, columns);
}
public VirtualRequestAudit()
{
InitializeComponent();
viewVM = new VirtualRequestVM();
queryFilter = new VirtualRequestQueryFilter();
logQueryFilter = new VirtualRequestQueryFilter();
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
//查询:
queryFilter = EntityConverter <VirtualRequestQueryVM, VirtualRequestQueryFilter> .Convert(queryVM);
this.dgVirtualRequestQueryResult.Bind();
}
private void GetLastVerifiedRequest()
{
VirtualRequestQueryFilter filter = new VirtualRequestQueryFilter()
{
ProductSysNo = Convert.ToInt32(this.queryVM.ProductSysNo)
};
queryFacade.QueryVirtualInventoryLastVerifiedRequest(filter, (obj2, args2) =>
{
if (args2.FaultsHandle())
{
return;
}
if (null != args2.Result.Rows)
{
string alertString = string.Empty;
foreach (var item in args2.Result.Rows)
{
alertString += string.Format("此产品在\"{0}\"最后一次虚库申请被拒绝的理由：{1}。", item["StockName"], item["AuditNote"]) + Environment.NewLine;
}
if (!string.IsNullOrEmpty(alertString))
{
this.lblLastRefuseResult.Text = alertString;
}
}
});
}
public QueryResult QueryVirtualInventoryInfoByStock(VirtualRequestQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
result.Data = ObjectFactory <IVirtualRequestQueryDA> .Instance.QueryVirtualInventoryInfoByStock(queryFilter);
result.TotalCount = result.Data.Rows.Count;
return(result);
}
public QueryResult QueryVirtualRequestCloseLog(VirtualRequestQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
int totalCount = 0;
result.Data = ObjectFactory <IVirtualRequestQueryDA> .Instance.QueryVirtualRequestCloseLog(queryFilter, out totalCount);
result.TotalCount = totalCount;
return(result);
}
public QueryResult QueryModifiedVirtualRequest(VirtualRequestQueryFilter queryFilter)
{
int totalCount = 0;
QueryResult result = new QueryResult();
result.Data = ObjectFactory <IVirtualRequestQueryDA> .Instance.QueryModifiedVirtualRequest(queryFilter, out totalCount);
result.TotalCount = totalCount;
return(result);
}
private void btnSearchInventory_Click(object sender, RoutedEventArgs e)
{
//if (string.IsNullOrEmpty(queryVM.ProductSysNo))
if (!queryVM.ProductSysNo.HasValue)
{
Window.Alert("请选择商品!");
return;
}
queryFilter = EntityConverter <VirtualRequestQueryVM, VirtualRequestQueryFilter> .Convert(queryVM);
this.dgVirtualRequestInfo.Bind();
this.dgProductInventoryInfo.Bind();
GetLastVerifiedRequest();
}
public DataTable QueryVirtualInventoryInfoByStock(VirtualRequestQueryFilter queryFilter)
{
DataTable dt = new DataTable();
if (queryFilter.ProductSysNo.HasValue)
{
var dataCommand = DataCommandManager.GetDataCommand("QueryInventoryByStock");
dataCommand.SetParameterValue("@ItemSysNumber", queryFilter.ProductSysNo);
dataCommand.SetParameterValue("@CompanyCode", queryFilter.CompanyCode);
dt = dataCommand.ExecuteDataTable();
}
return(dt);
}
public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
queryVM = new VirtualRequestQueryVM();
inventoryInfoVM = new List <VirtualRequestInventoryInfoVM>();
queryFilter = new VirtualRequestQueryFilter();
queryFacade = new VirtualRequestQueryFacade(this);
this.DataContext = queryVM;
BindComboBoxData();
if (ProductSysNo.HasValue)
{
//queryVM.ProductSysNo = ProductSysNo.ToString();
queryVM.ProductSysNo = ProductSysNo;
btnSearchInventory_Click(null, null);
}
}
public DataTable QueryVirtualInventoryLastVerifiedRequest(VirtualRequestQueryFilter queryFilter)
{
DataTable dt = new DataTable();
if (queryFilter.ProductSysNo.HasValue)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("GetLastVerifiedRequest");
dataCommand.SetParameterValue("@ProductSysNo", queryFilter.ProductSysNo.Value);
dataCommand.SetParameterValue("@CompanyCode", queryFilter.CompanyCode);
EnumColumnList list = new EnumColumnList();
list.Add("Status", typeof(VirtualRequestStatus));
dt = dataCommand.ExecuteDataTable(list);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dr["VirtualTypeString"] = CodeNamePairManager.GetName("Inventory", "VirtualRequestType", dr["VirtualType"].ToString());
}
}
}
return(dt);
}
public DataTable QueryVirtualRequestCloseLog(VirtualRequestQueryFilter queryFilter, out int totalCount)
{
if (queryFilter == null)
{
totalCount = 0;
return(null);
}
DataTable dt = new DataTable();
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PagingInfo.SortBy,
StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize,
MaximumRows = queryFilter.PagingInfo.PageSize
};
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryVirtualInventoryCloseLog");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, " SysNo DESC"))
{
if (queryFilter.SysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "VirtualRequestSysNo",
DbType.AnsiStringFixedLength, "@VirtualRequestSysNo", QueryConditionOperatorType.Equal, queryFilter.SysNo.Value.ToString());
}
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CompanyCode",
DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, queryFilter.CompanyCode);
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
EnumColumnList list = new EnumColumnList();
list.Add("ActionType", typeof(VirtualRequestActionType));
list.Add("VirtualRequestStatus", typeof(VirtualRequestStatus));
dt = dataCommand.ExecuteDataTable(list);
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
}
return(dt);
}
/// <summary>
/// 查询虚库申请单
/// </summary>
/// <returns></returns>
public DataTable QueryVirtualRequest(VirtualRequestQueryFilter queryFilter, out int totalCount)
{
if (queryFilter == null)
{
totalCount = 0;
return(null);
}
DataTable dt = new DataTable();
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PagingInfo.SortBy,
StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize,
MaximumRows = queryFilter.PagingInfo.PageSize
};
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryVirtualRequest");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText,
dataCommand, pagingInfo, "a.SysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode",
DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, queryFilter.CompanyCode);
if (queryFilter.RequestStatus.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status",
DbType.Int32, "@Status", QueryConditionOperatorType.Equal, (int)queryFilter.RequestStatus);
}
if (queryFilter.ProductSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ProductSysNo",
DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo.Value);
}
if (queryFilter.SysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.SysNo",
DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.SysNo.Value);
}
if (queryFilter.StockSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.StockSysNo",
DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, queryFilter.StockSysNo.Value);
}
if (queryFilter.CreateUserSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateUserSysNo",
DbType.Int32, "@CreateUserSysNo", QueryConditionOperatorType.Equal, queryFilter.CreateUserSysNo.Value);
}
if (queryFilter.VirtualRequestType.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.VirtualType",
DbType.Int32, "@VirtualType", QueryConditionOperatorType.Equal, (int)queryFilter.VirtualRequestType);
}
if (queryFilter.StartDate.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateTime",
DbType.DateTime, "@DateFrom", QueryConditionOperatorType.MoreThanOrEqual, queryFilter.StartDate.Value);
}
if (queryFilter.EndDate.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateTime",
DbType.DateTime, "@DateTo", QueryConditionOperatorType.LessThan, queryFilter.EndDate.Value.AddDays(1));
}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
EnumColumnList list = new EnumColumnList();
list.Add("RequestStatus", typeof(VirtualRequestStatus));
dt = dataCommand.ExecuteDataTable(list);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dr["VirtualTypeString"] = CodeNamePairManager.GetName("Inventory", "VirtualRequestType", dr["VirtualType"].ToString());
}
}
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
}
return(dt);
}
public int QueryNeedCloseRequestCount(VirtualRequestQueryFilter queryFilter)
{
return(ObjectFactory <IVirtualRequestDA> .Instance.ExistNeedCloseVirtualQuantity(queryFilter.StockSysNo.Value, queryFilter.ProductSysNo.Value, queryFilter.SysNo.Value, queryFilter.CompanyCode));
}
public VirtualRequestQuery()
{
InitializeComponent();
queryVM = new VirtualRequestQueryVM();
queryFilter = new VirtualRequestQueryFilter();
}
public DataTable QueryModifiedVirtualRequest(VirtualRequestQueryFilter queryCriteria, out int totalCount)
{
DataTable dt = new DataTable();
if (queryCriteria == null)
{
totalCount = 0;
return(null);
}
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
StartRowIndex = 0,
MaximumRows = int.MaxValue
};
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryVirtualRequest");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText,
dataCommand, null, "a.CreateTime DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode",
DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, queryCriteria.CompanyCode);
if (queryCriteria.RequestStatus.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status",
DbType.Int32, "@Status", QueryConditionOperatorType.Equal, (int)queryCriteria.RequestStatus);
}
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ProductSysNo",
DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryCriteria.ProductSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.SysNo",
DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryCriteria.SysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.StockSysNo",
DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, queryCriteria.StockSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateUserSysNo",
DbType.Int32, "@CreateUserSysNo", QueryConditionOperatorType.Equal, queryCriteria.CreateUserSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.VirtualType",
DbType.Int32, "@VirtualType", QueryConditionOperatorType.Equal, queryCriteria.VirtualRequestType);
if (queryCriteria.StartDate.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateTime",
DbType.DateTime, "@DateFrom", QueryConditionOperatorType.MoreThanOrEqual, queryCriteria.StartDate);
}
if (queryCriteria.EndDate.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CreateTime",
DbType.DateTime, "@DateTo", QueryConditionOperatorType.LessThan, queryCriteria.EndDate.Value.AddDays(1));
}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
dataCommand.CommandText = dataCommand.CommandText.Replace("#BY#", "CreateDate DESC");
dt = dataCommand.ExecuteDataTable(new EnumColumnList()
{
{ "RequestStatus", typeof(ECCentral.BizEntity.Inventory.VirtualRequestStatus) }
});
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dr["VirtualTypeString"] = CodeNamePairManager.GetName("Inventory", "VirtualRequestType", dr["VirtualType"].ToString());
}
}
totalCount = dt.Rows.Count;
}
return(dt);
}
