public AdjustRequestInfo LoadAdjustRequestInfo(string requestSysNo)
{
int sysNo = int.Parse(requestSysNo);
AdjustRequestInfo result = ObjectFactory <AdjustRequestAppService> .Instance.GetAdjustRequestInfoBySysNo(sysNo);
return(result);
}
public AdjustRequestInfo GetAdjustProductLine(string productSysNo)
{
int sysNo = int.Parse(productSysNo);
AdjustRequestInfo result = ObjectFactory <AdjustRequestAppService> .Instance.GetProductLineInfo(sysNo);
return(result);
}
private AdjustRequestVM ConvertRequestInfoToVM(AdjustRequestInfo info)
{
AdjustRequestVM vm = info.Convert <AdjustRequestInfo, AdjustRequestVM>((i, v) =>
{
v.StockSysNo = i.Stock == null ? null : i.Stock.SysNo;
v.AuditUserSysNo = i.AuditUser == null ? null : i.AuditUser.SysNo;
v.CreateUserSysNo = i.CreateUser == null ? null : i.CreateUser.SysNo;
v.EditUserSysNo = i.EditUser == null ? null : i.EditUser.SysNo;
v.OutStockUserSysNo = i.OutStockUser == null ? null : i.OutStockUser.SysNo;
v.ProductLineSysno = i.ProductLineSysno == null ? null : i.ProductLineSysno;
v.InvoiceInfo = i.InvoiceInfo.Convert <AdjustRequestInvoiceInfo, AdjustRequestInvoiceVM>();
});
if (info.AdjustItemInfoList != null)
{
info.AdjustItemInfoList.ForEach(p =>
{
AdjustRequestItemVM item = vm.AdjustItemInfoList.FirstOrDefault(i => i.SysNo == p.SysNo);
if (p.AdjustProduct != null)
{
item.ProductSysNo = p.AdjustProduct.SysNo;
item.ProductName = p.AdjustProduct.ProductBasicInfo.ProductTitle.Content;
item.ProductID = p.AdjustProduct.ProductID;
}
item.BatchDetailsInfoList = EntityConverter <InventoryBatchDetailsInfo, ProductBatchInfoVM> .Convert(p.BatchDetailsInfoList);
});
}
return(vm);
}
public void CreateRequest(AdjustRequestVM requestVM, Action <List <AdjustRequestVM> > callback)
{
string relativeUrl = "/InventoryService/AdjustRequest/CreateRequest";
requestVM.CompanyCode = CPApplication.Current.CompanyCode;
SetRequestUserInfo(requestVM, InventoryAdjustSourceAction.Create);
AdjustRequestInfo msg = ConvertRequestVMToInfo(requestVM);
restClient.Create <List <AdjustRequestInfo> >(relativeUrl, msg, (obj, args) =>
{
if (!args.FaultsHandle())
{
List <AdjustRequestVM> vmList = new List <AdjustRequestVM>();
if (args.Result != null)
{
args.Result.ForEach(x => {
vmList.Add(ConvertRequestInfoToVM(x));
});
}
if (callback != null)
{
callback(vmList);
}
}
});
}
/// <summary>
/// 更新损益单发票
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual AdjustRequestInfo MaintainAdjustInvoiceInfo(AdjustRequestInfo entityToUpdate)
{
AdjustRequestInfo resultRequest = adjustRequestProcessor.MaintainAdjustInvoiceInfo(entityToUpdate);
LoadRequestDetailInfo(resultRequest);
return(resultRequest);
}
/// <summary>
/// 根据损益单的SysNo获取损益单的全部信息
/// </summary>
/// <param name="sysNo"></param>
/// <returns></returns>
public virtual AdjustRequestInfo GetAdjustRequestInfoBySysNo(int requestSysNo)
{
AdjustRequestInfo requestInfo = adjustRequestProcessor.GetAdjustRequestInfoBySysNo(requestSysNo);
LoadRequestDetailInfo(requestInfo);
return(requestInfo);
}
/// <summary>
/// 损益出库
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual AdjustRequestInfo OutStockRequest(AdjustRequestInfo entityToUpdate)
{
LoadRequestProductInfo(entityToUpdate);
AdjustRequestInfo resultRequest = adjustRequestProcessor.OutStockRequest(entityToUpdate);
LoadRequestDetailInfo(resultRequest);
return(resultRequest);
}
/// <summary>
/// 取消作废损益单
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual AdjustRequestInfo CancelAbandonRequest(AdjustRequestInfo entityToUpdate)
{
LoadRequestProductInfo(entityToUpdate);
AdjustRequestInfo resultRequest = adjustRequestProcessor.CancelAbandonRequest(entityToUpdate);
LoadRequestDetailInfo(resultRequest);
return(resultRequest);
}
public void BuildData(System.Collections.Specialized.NameValueCollection requestPostData, out KeyValueVariables variables, out KeyTableVariables tableVariables)
{
variables = new KeyValueVariables();
tableVariables = new KeyTableVariables();
string sysNo = requestPostData["SysNo"];
if (sysNo != null && sysNo.Trim() != String.Empty)
{
sysNo = System.Web.HttpUtility.UrlDecode(sysNo);
int requestSysNo = int.TryParse(sysNo, out requestSysNo) ? requestSysNo : int.MinValue;
if (requestSysNo > int.MinValue)
{
AdjustRequestInfo requestInfo = ObjectFactory <AdjustRequestAppService> .Instance.GetAdjustRequestInfoBySysNo(requestSysNo);
variables.Add("SelfCompanyName", ResouceManager.GetMessageString(CommonConst.MessagePath_Common, "Res_Company_Name"));
variables.Add("SelfCompanyAddress", ResouceManager.GetMessageString(CommonConst.MessagePath_Common, "Res_Company_Address"));
variables.Add("SelfCompanyPhone", ResouceManager.GetMessageString(CommonConst.MessagePath_Common, "Res_Company_Phone"));
variables.Add("SelfCompanyWebAddress", ResouceManager.GetMessageString(CommonConst.MessagePath_Common, "Res_Company_Url"));
variables.Add("CreateUser", requestInfo.CreateUser.UserDisplayName);
variables.Add("CreateDate", requestInfo.CreateDate.HasValue ? requestInfo.CreateDate.Value.ToString(SOConst.LongTimeFormat) : string.Empty);
variables.Add("AuditUser", requestInfo.AuditUser.UserDisplayName);
variables.Add("AuditDate", requestInfo.AuditDate.HasValue ? requestInfo.AuditDate.Value.ToString(SOConst.LongTimeFormat) : string.Empty);
variables.Add("RequestSysNo", requestInfo.RequestID);
variables.Add("Stock", requestInfo.Stock == null ? "" : requestInfo.Stock.StockName);
variables.Add("Status", requestInfo.RequestStatus.ToDisplayText());
variables.Add("OutStockUser", requestInfo.OutStockUser.UserDisplayName);
variables.Add("OutStockDate", requestInfo.OutStockDate.HasValue ? requestInfo.OutStockDate.Value.ToString(SOConst.LongTimeFormat) : string.Empty);
variables.Add("Note", requestInfo.Note);
DataTable dtProduct = new DataTable();
dtProduct.Columns.AddRange(new System.Data.DataColumn[]
{
new DataColumn("ProductID"),
new DataColumn("ProductName"),
new DataColumn("Price"),
new DataColumn("Quantity"),
new DataColumn("Amount")
});
decimal totalAmount = 0M;
requestInfo.AdjustItemInfoList.ForEach(p =>
{
totalAmount += p.AdjustQuantity * p.AdjustCost;
DataRow drProduct = dtProduct.NewRow();
drProduct["ProductID"] = p.AdjustProduct.ProductID;
drProduct["ProductName"] = p.AdjustProduct.ProductBasicInfo.ProductTitle;
drProduct["Price"] = p.AdjustCost.ToString("N2");
drProduct["Quantity"] = p.AdjustQuantity;
drProduct["Amount"] = (p.AdjustQuantity * p.AdjustCost).ToString("N2");
dtProduct.Rows.Add(drProduct);
});
variables.Add("TotalAmount", totalAmount.ToString("N2"));
tableVariables.Add("ProductList", dtProduct);
}
}
}
private void LoadRequestDetailInfo(AdjustRequestInfo requestInfo)
{
LoadRequestProductInfo(requestInfo);
LoadRequestUserInfo(requestInfo);
//batch info
if (requestInfo.AdjustItemInfoList != null && requestInfo.AdjustItemInfoList.Count > 0 && requestInfo.SysNo.HasValue)
{
LoadRequestProductBatchInfo(requestInfo);
}
}
/// <summary>
/// 创建损益单
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual List <AdjustRequestInfo> CreateRequest(AdjustRequestInfo entityToCreate)
{
LoadRequestDetailInfo(entityToCreate);
List <AdjustRequestInfo> requestList = adjustRequestProcessor.CreateRequest(entityToCreate);
foreach (AdjustRequestInfo request in requestList)
{
LoadRequestDetailInfo(request);
}
return(requestList);
}
public static AdjustRequestInfo GetAdjustRequestInfoBySysNo(int requestSysNo)
{
AdjustRequestInfo adjustRequest = GetAdjustRequestMainInfoBySysNo(requestSysNo);
if (adjustRequest != null)
{
adjustRequest.AdjustItemInfoList = GetAdjustItemListByRequestSysNo(requestSysNo);
adjustRequest.InvoiceInfo = GetInvoiceInfoByRequestSysNo(requestSysNo);
}
return(adjustRequest);
}
/// <summary>
/// 更新损益单
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual AdjustRequestInfo UpdateAdjustRequest(AdjustRequestInfo entity)
{
DataCommand command = DataCommandManager.GetDataCommand("Inventory_UpdateAdjustRequest");
command.SetParameterValue("@RequestSysNo", entity.SysNo.Value);
command.SetParameterValue("@RequestID", entity.RequestID);
command.SetParameterValue("@StockSysNo", entity.Stock.SysNo);
command.SetParameterValue("@RequestStatus", (int?)entity.RequestStatus);
command.SetParameterValue("@AdjustProperty", (int?)entity.AdjustProperty);
command.SetParameterValue("@Note", entity.Note);
command.SetParameterValue("@ProductLineSysno", entity.ProductLineSysno);
return(command.ExecuteEntity <AdjustRequestInfo>());
}
/// <summary>
/// 更新损益单状态
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static AdjustRequestInfo UpdateAdjustRequestStatus(AdjustRequestInfo entity)
{
DataCommand dc = DataCommandManager.GetDataCommand("Inventory_UpdateAdjustRequestStatus");
dc.SetParameterValue("@RequestSysNo", entity.SysNo);
dc.SetParameterValue("@RequestStatus", (int)entity.RequestStatus);
dc.SetParameterValue("@AuditDate", entity.AuditDate);
dc.SetParameterValue("@AuditUserSysNo", 1 /*entity.AuditUser.SysNo*/);
dc.SetParameterValue("@OutStockDate", entity.OutStockDate);
dc.SetParameterValue("@OutStockUserSysNo", 1 /* entity.OutStockUser.SysNo*/);
return(dc.ExecuteEntity <AdjustRequestInfo>());
}
private void LoadRequestProductBatchInfo(AdjustRequestInfo requestInfo)
{
if (requestInfo == null || requestInfo.AdjustItemInfoList == null || requestInfo.AdjustItemInfoList.Count == 0)
{
return;
}
ProductInventoryProcessor proInventory = ObjectFactory <ProductInventoryProcessor> .Instance;
foreach (var item in requestInfo.AdjustItemInfoList)
{
item.BatchDetailsInfoList = proInventory.GetProdcutBatchesInfo("AD", requestInfo.SysNo.Value, item.AdjustProduct.SysNo);
}
}
private void LoadRequestProductInfo(AdjustRequestInfo requestInfo)
{
if (requestInfo == null || requestInfo.AdjustItemInfoList == null || requestInfo.AdjustItemInfoList.Count == 0)
{
return;
}
IIMBizInteract IMService = ObjectFactory <IIMBizInteract> .Instance;
foreach (var item in requestInfo.AdjustItemInfoList)
{
if (item.AdjustProduct != null && item.AdjustProduct.SysNo > 0)
{
item.AdjustProduct = IMService.GetProductInfo(item.AdjustProduct.SysNo);
}
}
}
private void UpdateRequestStatus(string relativeUrl, AdjustRequestVM requestVM, Action <AdjustRequestVM> callback)
{
AdjustRequestInfo msg = ConvertRequestVMToInfo(requestVM);
restClient.Update <AdjustRequestInfo>(relativeUrl, msg, (obj, args) =>
{
if (!args.FaultsHandle())
{
AdjustRequestVM vm = null;
if (args.Result != null)
{
vm = ConvertRequestInfoToVM(args.Result);
}
if (callback != null)
{
callback(vm);
}
}
});
}
/// <summary>
/// 创建损益单
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public virtual AdjustRequestInfo CreateAdjustRequest(AdjustRequestInfo entity)
{
DataCommand command = DataCommandManager.GetDataCommand("Inventory_CreateAdjustRequest");
command.SetParameterValue("@RequestSysNo", entity.SysNo.Value);
command.SetParameterValue("@RequestID", entity.RequestID);
command.SetParameterValue("@StockSysNo", entity.Stock.SysNo);
command.SetParameterValue("@CreateDate", entity.CreateDate);
command.SetParameterValue("@CreateUserSysNo", entity.CreateUser.SysNo);
command.SetParameterValue("@AuditDate", entity.AuditDate);
command.SetParameterValue("@AuditUserSysNo", entity.AuditUser.SysNo);
command.SetParameterValue("@OutStockDate", entity.OutStockDate);
command.SetParameterValue("@OutStockUserSysNo", entity.OutStockUser.SysNo);
command.SetParameterValue("@RequestStatus", (int?)entity.RequestStatus);
command.SetParameterValue("@AdjustProperty", (int?)entity.AdjustProperty);
command.SetParameterValue("@ConsignFlag", (int?)entity.ConsignFlag);
command.SetParameterValue("@Note", entity.Note);
command.SetParameterValue("@CompanyCode", "8601");//[Mark][Alan.X.Luo 硬编码]
command.SetParameterValue("@ProductLineSysno", entity.ProductLineSysno);
return(command.ExecuteEntity <AdjustRequestInfo>());
}
public void MaintainRequestInvoiceInfo(AdjustRequestVM requestVM, Action <AdjustRequestVM> callback)
{
string relativeUrl = "/InventoryService/AdjustRequest/MaintainAdjustInvoiceInfo";
AdjustRequestInfo msg = ConvertRequestVMToInfo(requestVM);
restClient.Update <AdjustRequestInfo>(relativeUrl, msg, (obj, args) =>
{
if (!args.FaultsHandle())
{
AdjustRequestVM vm = null;
if (args.Result != null)
{
vm = ConvertRequestInfoToVM(args.Result);
}
if (callback != null)
{
callback(vm);
}
}
});
}
private void LoadRequestUserInfo(AdjustRequestInfo requestInfo)
{
if (requestInfo.CreateUser != null && requestInfo.CreateUser.SysNo != null)
{
requestInfo.CreateUser = ExternalDomainBroker.GetUserInfo((int)requestInfo.CreateUser.SysNo);
}
if (requestInfo.EditUser != null && requestInfo.EditUser.SysNo != null)
{
requestInfo.EditUser = ExternalDomainBroker.GetUserInfo((int)requestInfo.CreateUser.SysNo);
}
if (requestInfo.AuditUser != null && requestInfo.AuditUser.SysNo != null)
{
requestInfo.AuditUser = ExternalDomainBroker.GetUserInfo((int)requestInfo.CreateUser.SysNo);
}
if (requestInfo.OutStockUser != null && requestInfo.OutStockUser.SysNo != null)
{
requestInfo.OutStockUser = ExternalDomainBroker.GetUserInfo((int)requestInfo.CreateUser.SysNo);
}
}
public void UpdateRequest(AdjustRequestVM requestVM, Action <AdjustRequestVM> callback)
{
string relativeUrl = "/InventoryService/AdjustRequest/UpdateRequest";
SetRequestUserInfo(requestVM, InventoryAdjustSourceAction.Update);
AdjustRequestInfo msg = ConvertRequestVMToInfo(requestVM);
restClient.Update <AdjustRequestInfo>(relativeUrl, msg, (obj, args) =>
{
if (!args.FaultsHandle())
{
AdjustRequestVM vm = null;
if (args.Result != null)
{
vm = ConvertRequestInfoToVM(args.Result);
}
if (callback != null)
{
callback(vm);
}
}
});
}
private AdjustRequestInfo ConvertRequestVMToInfo(AdjustRequestVM vm)
{
AdjustRequestInfo info = vm.ConvertVM <AdjustRequestVM, AdjustRequestInfo>((v, i) =>
{
i.Stock = new StockInfo {
SysNo = v.StockSysNo
};
i.CreateUser = new BizEntity.Common.UserInfo {
SysNo = v.CreateUserSysNo
};
i.EditUser = new BizEntity.Common.UserInfo {
SysNo = v.EditUserSysNo
};
i.AuditUser = new BizEntity.Common.UserInfo {
SysNo = v.AuditUserSysNo
};
i.OutStockUser = new BizEntity.Common.UserInfo {
SysNo = v.OutStockUserSysNo
};
i.ProductLineSysno = v.ProductLineSysno;
i.InvoiceInfo = v.InvoiceInfo.ConvertVM <AdjustRequestInvoiceVM, AdjustRequestInvoiceInfo>();
});
info.AdjustItemInfoList = new List <AdjustRequestItemInfo>();
vm.AdjustItemInfoList.ForEach(item =>
{
AdjustRequestItemInfo itemInfo = item.ConvertVM <AdjustRequestItemVM, AdjustRequestItemInfo>();
itemInfo.AdjustProduct = new BizEntity.IM.ProductInfo {
SysNo = item.ProductSysNo.Value
};
itemInfo.BatchDetailsInfoList = new List <InventoryBatchDetailsInfo>();
itemInfo.BatchDetailsInfoList = EntityConverter <ProductBatchInfoVM, InventoryBatchDetailsInfo> .Convert(item.BatchDetailsInfoList);
info.AdjustItemInfoList.Add(itemInfo);
});
return(info);
}
public List <AdjustRequestInfo> CreateAdjustRequest(AdjustRequestInfo entityToCreate)
{
List <AdjustRequestInfo> result = ObjectFactory <AdjustRequestAppService> .Instance.CreateRequest(entityToCreate);
return(result);
}
/// <summary>
/// 根据商品编号得到其所属产品线
/// </summary>
/// <param name="sysNo"></param>
/// <returns></returns>
public virtual AdjustRequestInfo GetProductLineInfo(int ProductsysNo)
{
AdjustRequestInfo requestInfo = adjustRequestProcessor.GetProductLineInfo(ProductsysNo);
return(requestInfo);
}
public void BuildData(System.Collections.Specialized.NameValueCollection requestPostData, out KeyValueVariables variables, out KeyTableVariables tableVariables)
{
variables = new KeyValueVariables();
tableVariables = new KeyTableVariables();
string sysNo = requestPostData["SysNo"];
if (sysNo != null && sysNo.Trim() != String.Empty)
{
sysNo = System.Web.HttpUtility.UrlDecode(sysNo);
int requestSysNo = int.TryParse(sysNo, out requestSysNo) ? requestSysNo : int.MinValue;
if (requestSysNo > int.MinValue)
{
AdjustRequestInfo requestInfo = ObjectFactory <AdjustRequestAppService> .Instance.GetAdjustRequestInfoBySysNo(requestSysNo);
DataTable dtInvoice = new DataTable();
dtInvoice.Columns.AddRange(new DataColumn[]
{
new DataColumn("OutStockDate"),
new DataColumn("ReceiveName"),
new DataColumn("Contact"),
new DataColumn("Address"),
new DataColumn("Phone"),
new DataColumn("Note"),
new DataColumn("CustomerID"),
new DataColumn("RequestSysNo"),
new DataColumn("UpperAmount"),
new DataColumn("ProductList", typeof(DataTable))
});
tableVariables.Add("InvoiceList", dtInvoice);
DataRow dr = dtInvoice.NewRow();
dr["ReceiveName"] = requestInfo.InvoiceInfo.ReceiveName;
dr["Contact"] = requestInfo.InvoiceInfo.ContactAddress;
dr["Address"] = requestInfo.InvoiceInfo.ContactShippingAddress;
dr["Phone"] = requestInfo.InvoiceInfo.ContactPhoneNumber;
dr["CustomerID"] = requestInfo.InvoiceInfo.CustomerID;
dr["RequestSysNo"] = requestInfo.SysNo;
dr["OutStockDate"] = requestInfo.OutStockDate.HasValue ? requestInfo.OutStockDate.Value.ToString(SOConst.DateFormat) : string.Empty;
dr["Note"] = requestInfo.InvoiceInfo.Note;
DataTable dtProduct = new DataTable();
dtProduct.Columns.AddRange(new System.Data.DataColumn[]
{
new DataColumn("ProductID"),
new DataColumn("ProductName"),
new DataColumn("Price"),
new DataColumn("Quantity"),
new DataColumn("Amount")
});
decimal totalAmount = 0M;
int i = 0;
requestInfo.AdjustItemInfoList.ForEach(p =>
{
i++;
totalAmount += p.AdjustQuantity * p.AdjustCost;
DataRow drProduct = dtProduct.NewRow();
drProduct["ProductID"] = p.AdjustProduct.ProductID;
drProduct["ProductName"] = p.AdjustProduct.ProductBasicInfo.ProductBriefTitle;
drProduct["Price"] = p.AdjustCost.ToString("N2");
drProduct["Quantity"] = p.AdjustQuantity;
drProduct["Amount"] = (p.AdjustQuantity * p.AdjustCost).ToString("N2");
dtProduct.Rows.Add(drProduct);
if (i % 6 == 0 || i == requestInfo.AdjustItemInfoList.Count)
{
dr["ProductList"] = dtProduct;
dr["UpperAmount"] = MoneyUtility.GetChineseMoney(totalAmount);
dtInvoice.Rows.Add(dr);
if (i != requestInfo.AdjustItemInfoList.Count - 1)
{
dtProduct = dtProduct.Clone();
DataRow tdr = dtInvoice.NewRow();
// dtInvoice.Rows.Add(tdr);
tdr["ReceiveName"] = dr["ReceiveName"];
tdr["Contact"] = dr["Contact"];
tdr["Address"] = dr["Address"];
tdr["Phone"] = dr["Phone"];
tdr["CustomerID"] = dr["CustomerID"];
tdr["RequestSysNo"] = dr["RequestSysNo"];
tdr["OutStockDate"] = dr["OutStockDate"];
tdr["Note"] = dr["Note"];
dr = tdr;
dtProduct.Rows.Clear();
}
}
});
}
}
}
public AdjustRequestInfo CancelVerifyAdjustRequest(AdjustRequestInfo entityToUpdate)
{
return(ObjectFactory <AdjustRequestAppService> .Instance.CancelVerifyRequest(entityToUpdate));
}
public AdjustRequestInfo MaintainAdjustInvoiceInfo(AdjustRequestInfo entityToUpdate)
{
return(ObjectFactory <AdjustRequestAppService> .Instance.MaintainAdjustInvoiceInfo(entityToUpdate));
}
public AdjustRequestInfo UpdateAdjustRequest(AdjustRequestInfo entityToUpdate)
{
return(ObjectFactory <AdjustRequestAppService> .Instance.UpdateRequest(entityToUpdate));
}
public override void LoadAdjustContractReferenceInfo()
{
int requestSysNo = int.Parse(this.AdjustContractInfo.ReferenceSysNo);
CurrentRequestInfo = ObjectFactory <IAdjustRequestDA> .Instance.GetAdjustRequestInfoBySysNo(requestSysNo);
}
