public void ProcessRequest(HttpContext context)
{
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
context.Response.ContentType = "text/plain";
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
string orderStr = context.Request.Form["order"];
string orderStockInvoiceStr = context.Request.Form["orderStockInvoice"];
string orderDetailStr = context.Request.Form["orderDetail"];
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
NFMT.Document.Model.DocumentOrder order = serializer.Deserialize<NFMT.Document.Model.DocumentOrder>(orderStr);
List<NFMT.Document.Model.OrderReplaceStock> stockInvoices = serializer.Deserialize<List<NFMT.Document.Model.OrderReplaceStock>>(orderStockInvoiceStr);
NFMT.Document.Model.DocumentOrderDetail detail = serializer.Deserialize<NFMT.Document.Model.DocumentOrderDetail>(orderDetailStr);
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
result = bll.UpdateReplaceOrder(user, order, stockInvoices, detail);
if (result.ResultStatus == 0)
result.Message = "制单指令修改成功";
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(result);
context.Response.Write(jsonStr);
}
public void ProcessRequest(HttpContext context)
{
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
context.Response.ContentType = "text/plain";
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
string orderStr = context.Request.Form["order"];
string orderStockInvoiceStr = context.Request.Form["orderStockInvoice"];
string orderDetailStr = context.Request.Form["orderDetail"];
string isSubmitAuditStr = context.Request.Form["IsSubmitAudit"];
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
NFMT.Document.Model.DocumentOrder order = serializer.Deserialize<NFMT.Document.Model.DocumentOrder>(orderStr);
List<NFMT.Document.Model.OrderStockInvoice> stockInvoices = serializer.Deserialize<List<NFMT.Document.Model.OrderStockInvoice>>(orderStockInvoiceStr);
NFMT.Document.Model.DocumentOrderDetail detail = serializer.Deserialize<NFMT.Document.Model.DocumentOrderDetail>(orderDetailStr);
bool isSubmitAudit = false;
if (string.IsNullOrEmpty(isSubmitAuditStr) || !bool.TryParse(isSubmitAuditStr, out isSubmitAudit))
isSubmitAudit = false;
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
result = bll.Create(user, order, stockInvoices, detail, isSubmitAudit);
if (result.ResultStatus == 0)
result.Message = "制单指令新增成功";
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(result);
context.Response.Write(jsonStr);
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
if (!IsPostBack)
{
string redirectUrl = "DocumentList.aspx";
this.navigation1.Routes.Add("制单列表", redirectUrl);
this.navigation1.Routes.Add("可制单指令列表", "OrderReadyList.aspx");
this.navigation1.Routes.Add("制单新增", string.Empty);
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.ResultModel result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
//指令库存
NFMT.Common.SelectModel select = orderBLL.GetOrderSelectedSelect(1, 100, "dos.DetailId desc", order.OrderId,true);
result = orderBLL.Load(user, select);
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
}
}
public void ProcessRequest(HttpContext context)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
context.Response.ContentType = "text/plain";
int id = 0;
int operateId = 0;
if (!int.TryParse(context.Request.Form["id"], out id) || id <= 0)
{
result.Message = "序号错误";
context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
context.Response.End();
}
if (!int.TryParse(context.Request.Form["oi"], out operateId) || operateId <= 0)
{
result.Message = "操作错误";
context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
context.Response.End();
}
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.OperateEnum operateEnum = (NFMT.Common.OperateEnum)operateId;
switch (operateEnum)
{
case NFMT.Common.OperateEnum.作废:
result = bll.Invalid(user, id);
break;
case NFMT.Common.OperateEnum.撤返:
result = bll.GoBack(user, id);
break;
case NFMT.Common.OperateEnum.确认完成:
result = bll.Confirm(user, id);
break;
case NFMT.Common.OperateEnum.确认完成撤销:
result = bll.ConfirmCancel(user, id);
break;
}
if (result.ResultStatus == 0)
result.Message = string.Format("{0}成功", operateEnum.ToString());
context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
if (!IsPostBack)
{
string redirectUrl = "OrderList.aspx";
this.navigation1.Routes.Add("制单指令列表", redirectUrl);
this.navigation1.Routes.Add("制单指令明细", string.Empty);
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取制单指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
#region 合约信息
//合约信息
NFMT.Contract.BLL.ContractSubBLL subBll = new NFMT.Contract.BLL.ContractSubBLL();
result = subBll.Get(user, order.SubId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (sub == null || sub.ContractId == 0)
Response.Redirect(redirectUrl);
this.curSub = sub;
NFMT.Contract.BLL.ContractBLL bll = new NFMT.Contract.BLL.ContractBLL();
result = bll.Get(user, sub.ContractId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Contract.Model.Contract con = result.ReturnValue as NFMT.Contract.Model.Contract;
if (con == null || con.ContractId == 0)
Response.Redirect(redirectUrl);
this.curContract = con;
NFMT.Data.Model.MeasureUnit muContract = NFMT.Data.BasicDataProvider.MeasureUnits.Single(temp => temp.MUId == con.UnitId);
NFMT.Data.Model.Currency cur = NFMT.Data.BasicDataProvider.Currencies.SingleOrDefault(temp => temp.CurrencyId == sub.SettleCurrency);
this.curCurrency = cur;
NFMT.Data.Model.MeasureUnit muSub = NFMT.Data.BasicDataProvider.MeasureUnits.Single(temp => temp.MUId == sub.UnitId);
this.contractExpander1.CurContract = this.curContract;
this.contractExpander1.CurContractSub = this.curSub;
this.contractExpander1.RedirectUrl = redirectUrl;
#endregion
NFMT.Common.SelectModel select = orderBLL.GetOrderSelectedSelect(1, 100, "dos.DetailId desc", order.OrderId);
result = orderBLL.Load(user, select);
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string json = serializer.Serialize(order);
this.hidModel.Value = json;
//attach
this.attach1.BusinessIdValue = this.curOrder.OrderId;
}
}
public void ProcessRequest(HttpContext context)
{
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["pagenum"]))
int.TryParse(context.Request.QueryString["pagenum"], out pageIndex);
pageIndex++;
if (!string.IsNullOrEmpty(context.Request.QueryString["pagesize"]))
int.TryParse(context.Request.QueryString["pagesize"], out pageSize);
if (!string.IsNullOrEmpty(context.Request.QueryString["sortdatafield"]) && !string.IsNullOrEmpty(context.Request.QueryString["sortorder"]))
{
string sortDataField = context.Request.QueryString["sortdatafield"].Trim();
string sortOrder = context.Request.QueryString["sortorder"].Trim();
switch (sortDataField)
{
case "RefNo":
sortDataField = string.Format("sn.{0}", sortDataField);
break;
case "StockWeight":
sortDataField = "sto.GrossAmount";
break;
case "StatusName":
sortDataField = "sd.StatusName";
break;
case "CorpName":
sortDataField = "cor.CorpName";
break;
case "AssetName":
sortDataField = "ass.AssetName";
break;
case "BrandName":
sortDataField = "bra.BrandName";
break;
case "LastAmount":
sortDataField = "ISNULL(sto.CurNetAmount,0) - ISNULL(soad.ApplyAmount,0)";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
int contractId = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["cid"]))
{
context.Response.Write("合约信息错误");
context.Response.End();
}
if (!int.TryParse(context.Request.QueryString["cid"], out contractId) || contractId <= 0)
{
context.Response.Write("合约信息错误");
context.Response.End();
}
string sids = context.Request.QueryString["sids"];
string dids = context.Request.QueryString["dids"];
int orderId = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["orderId"]) || !int.TryParse(context.Request.QueryString["orderId"], out orderId))
orderId = 0;
string refNo = context.Request.Params["refNo"];
int ownCorpId = 0;
if (string.IsNullOrEmpty(context.Request.Params["ownCorpId"]) || !int.TryParse(context.Request.Params["ownCorpId"], out ownCorpId))
ownCorpId = 0;
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.SelectModel select = bll.GetOrderSalesStockSelect(pageIndex, pageSize, orderStr, sids, contractId, orderId, dids, refNo, ownCorpId);
NFMT.Common.ResultModel result = bll.Load(user, select);
context.Response.ContentType = "text/plain";
if (result.ResultStatus != 0)
{
context.Response.Write(result.Message);
context.Response.End();
}
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("count", totalRows);
dic.Add("data", dt);
string postData = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter());
context.Response.Write(postData);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
string redirectUrl = "OrderList.aspx";
this.navigation1.Routes.Add("制单指令列表", redirectUrl);
this.navigation1.Routes.Add("制单指令修改", string.Empty);
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取制单指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
NFMT.Contract.BLL.ContractSubBLL subBll = new NFMT.Contract.BLL.ContractSubBLL();
result = subBll.Get(user, order.SubId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (sub == null || sub.ContractId == 0)
Response.Redirect(redirectUrl);
this.curSub = sub;
NFMT.Contract.BLL.ContractBLL bll = new NFMT.Contract.BLL.ContractBLL();
result = bll.Get(user, sub.ContractId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Contract.Model.Contract con = result.ReturnValue as NFMT.Contract.Model.Contract;
if (con == null || con.ContractId == 0)
Response.Redirect(redirectUrl);
this.curContract = con;
NFMT.Data.Model.Asset ass = NFMT.Data.BasicDataProvider.Assets.First(temp => temp.AssetId == con.AssetId);
this.curAsset = ass;
NFMT.Data.Model.MeasureUnit muContract = NFMT.Data.BasicDataProvider.MeasureUnits.Single(temp => temp.MUId == con.UnitId);
this.curUnit = muContract;
NFMT.Data.Model.Currency cur = NFMT.Data.BasicDataProvider.Currencies.SingleOrDefault(temp => temp.CurrencyId == sub.SettleCurrency);
this.curCurrency = cur;
NFMT.Data.Model.MeasureUnit muSub = NFMT.Data.BasicDataProvider.MeasureUnits.Single(temp => temp.MUId == sub.UnitId);
this.contractExpander1.CurContract = this.curContract;
this.contractExpander1.CurContractSub = this.curSub;
this.contractExpander1.RedirectUrl = redirectUrl;
NFMT.Common.SelectModel select = orderBLL.GetNoStockOrderSelect(1, 100, "dos.DetailId desc", order.OrderId);
result = orderBLL.Load(user, select);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt != null)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
if (ass != null)
dr["AssetName"] = ass.AssetName;
if (muSub != null)
dr["MUName"] = muSub.MUName;
}
}
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
//attach
this.attach1.BusinessIdValue = this.curOrder.OrderId;
}
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
if (!IsPostBack)
{
string redirectUrl = "DocumentList.aspx";
this.navigation1.Routes.Add("制单列表", redirectUrl);
this.navigation1.Routes.Add("制单明细", string.Empty);
int docId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out docId) || docId <= 0)
Response.Redirect(redirectUrl);
//获取制单
NFMT.Document.BLL.DocumentBLL docBLL = new NFMT.Document.BLL.DocumentBLL();
NFMT.Common.ResultModel result = docBLL.Get(user, docId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.Document documnet = result.ReturnValue as NFMT.Document.Model.Document;
if (documnet == null || documnet.DocumentId <= 0)
Response.Redirect(redirectUrl);
this.curDocument = documnet;
//获取指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
result = orderBLL.Get(user, documnet.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
//指令库存
//NFMT.Common.SelectModel select = orderBLL.GetOrderSelectedSelect(1, 100, "dos.DetailId desc", order.OrderId, true);
//result = orderBLL.Load(user, select);
//int totalRows = result.AffectCount;
//System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
//this.OrderJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
NFMT.Common.SelectModel select = docBLL.GetDocumnetStocksSelect(1, 100, "ds.DetailId desc", documnet.DocumentId);
result = orderBLL.Load(user, select);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.DocumentJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string json = serializer.Serialize(documnet);
this.hidModel.Value = json;
//attach
this.attach1.BusinessIdValue = this.curOrder.OrderId;
}
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
if (!IsPostBack)
{
string redirectUrl = "OrderReplaceList.aspx";
this.navigation1.Routes.Add("替临制单列表", redirectUrl);
this.navigation1.Routes.Add("替临制单指令修改", string.Empty);
this.ReplaceOrderType = (int)NFMT.Document.OrderTypeEnum.替临制单指令;
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取替临指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.ResultModel result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curReplaceOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
//获取临票指令
result = orderBLL.Get(user, order.CommercialId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder comOrder = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (comOrder == null || comOrder.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curCommercialOrder = comOrder;
//替临指令库存
NFMT.Common.SelectModel select = orderBLL.GetReplaceStocksSelect(1, 100, "dos.DetailId desc", order.CommercialId, false);
result = orderBLL.Load(user, select);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.JsonReplaceStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
//临票指令库存
select = orderBLL.GetReplaceStocksSelect(1, 100, "dos.DetailId desc", order.CommercialId, true);
result = orderBLL.Load(user, select);
dt = result.ReturnValue as System.Data.DataTable;
this.JsonCommercialStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
//attach
this.attach1.BusinessIdValue = this.curReplaceOrder.OrderId;
}
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
if (!IsPostBack)
{
string redirectUrl = "OrderReplaceList.aspx";
this.navigation1.Routes.Add("替临制单列表", redirectUrl);
this.navigation1.Routes.Add("已承兑临票制单指令列表", "OrderCommercialList.aspx");
this.navigation1.Routes.Add("替临制单指令新增", string.Empty);
this.ReplaceOrderType = (int)NFMT.Document.OrderTypeEnum.替临制单指令;
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取临票指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.ResultModel result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
//指令库存
NFMT.Common.SelectModel select = orderBLL.GetComOrderStocksSelect(1, 100, "dos.DetailId desc", order.OrderId, true);
result = orderBLL.Load(user, select);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt != null)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["InvoiceNo"] != null && dr["InvoiceNo"] != DBNull.Value)
{
string invoiceNo = dr["InvoiceNo"].ToString();
invoiceNo = string.Format("{0}{1}",invoiceNo.Substring(0, invoiceNo.Length - 1),"P");
}
}
}
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
}
}
public void ProcessRequest(HttpContext context)
{
int status = -1, outerCorp = -1;
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty;
bool isReady = false;
string contractNo = context.Request["cn"];
DateTime beginDate = NFMT.Common.DefaultValue.DefaultTime;
DateTime endDate = NFMT.Common.DefaultValue.DefaultTime;
if (!string.IsNullOrEmpty(context.Request["db"]))
{
if (!DateTime.TryParse(context.Request["db"], out beginDate))
beginDate = NFMT.Common.DefaultValue.DefaultTime;
}
if (!string.IsNullOrEmpty(context.Request["de"]))
{
if (!DateTime.TryParse(context.Request["de"], out endDate))
endDate = NFMT.Common.DefaultValue.DefaultTime;
else
endDate.AddDays(1);
}
if (!string.IsNullOrEmpty(context.Request["s"]))
int.TryParse(context.Request["s"], out status);
if (!string.IsNullOrEmpty(context.Request["ci"]))
int.TryParse(context.Request["ci"], out outerCorp);//状态查询条件
if (!string.IsNullOrEmpty(context.Request.QueryString["pagenum"]))
int.TryParse(context.Request.QueryString["pagenum"], out pageIndex);
pageIndex++;
if (!string.IsNullOrEmpty(context.Request.QueryString["pagesize"]))
int.TryParse(context.Request.QueryString["pagesize"], out pageSize);
if (string.IsNullOrEmpty(context.Request.QueryString["re"]) || !bool.TryParse(context.Request.QueryString["re"], out isReady))
isReady = false;
if (!string.IsNullOrEmpty(context.Request.QueryString["sortdatafield"]) && !string.IsNullOrEmpty(context.Request.QueryString["sortorder"]))
{
string sortDataField = context.Request.QueryString["sortdatafield"].Trim();
string sortOrder = context.Request.QueryString["sortorder"].Trim();
switch (sortDataField)
{
case "OrderNo":
sortDataField = "do.OrderNo";
break;
case "OrderTypeName":
sortDataField = "do.OrderType";
break;
case "ApplyCorpName":
sortDataField = "appCorp.CorpName";
break;
case "BuyCorpName":
sortDataField = "buyCorp.CorpName";
break;
case "SubNo":
sortDataField = "cs.SubNo";
break;
case "AssetName":
sortDataField = "ass.AssetName";
break;
case "NetAmount":
sortDataField = "do.NetAmount";
break;
case "MUName":
sortDataField = "mu.MUName";
break;
case "EmpName":
sortDataField = "emp.Name";
break;
case "StatusName":
sortDataField = "do.OrderStatus";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.SelectModel select = bll.GetSelectModel(pageIndex, pageSize, orderStr, beginDate, endDate, contractNo, outerCorp, status,isReady);
NFMT.Common.ResultModel result = bll.Load(user, select);
context.Response.ContentType = "text/plain";
if (result.ResultStatus != 0)
{
context.Response.Write(result.Message);
context.Response.End();
}
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("count", result.AffectCount);
dic.Add("data", dt);
string postData = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter());
context.Response.Write(postData);
}
protected void Page_Load(object sender, EventArgs e)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
if (!IsPostBack)
{
string redirectUrl = "DocumentList.aspx";
this.navigation1.Routes.Add("制单列表", redirectUrl);
this.navigation1.Routes.Add("可制单指令列表", "OrderReadyList.aspx");
this.navigation1.Routes.Add("制单新增", string.Empty);
int orderId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out orderId) || orderId <= 0)
Response.Redirect(redirectUrl);
//获取指令
NFMT.Document.BLL.DocumentOrderBLL orderBLL = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.ResultModel result = orderBLL.Get(user, orderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrder order = result.ReturnValue as NFMT.Document.Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
Response.Redirect(redirectUrl);
this.curOrder = order;
NFMT.Document.BLL.DocumentOrderDetailBLL detailBLL = new NFMT.Document.BLL.DocumentOrderDetailBLL();
result = detailBLL.GetByOrderId(user, order.OrderId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Document.Model.DocumentOrderDetail orderDetail = result.ReturnValue as NFMT.Document.Model.DocumentOrderDetail;
if (orderDetail == null || orderDetail.DetailId <= 0)
Response.Redirect(redirectUrl);
this.curOrderDetail = orderDetail;
//品种，单位
NFMT.Data.Model.Asset ass = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == order.AssetId);
NFMT.Data.Model.MeasureUnit mu = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == order.UnitId);
//指令库存
NFMT.Common.SelectModel select = orderBLL.GetOrderSelectedSelect(1, 100, "dos.DetailId desc", order.OrderId, true);
result = orderBLL.Load(user, select);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt != null)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
if(ass!= null)
dr["AssetName"] = ass.AssetName;
if(mu != null)
dr["MUName"] = mu.MUName;
}
}
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
}
}
public void ProcessRequest(HttpContext context)
{
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
string subNo = context.Request.QueryString["sn"];
DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime;
DateTime toDate = NFMT.Common.DefaultValue.DefaultTime;
int outCorpId = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["oci"]))
{
if (!int.TryParse(context.Request.QueryString["oci"], out outCorpId))
outCorpId = 0;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["fd"]))
{
if (!DateTime.TryParse(context.Request.QueryString["fd"], out fromDate))
fromDate = NFMT.Common.DefaultValue.DefaultTime;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["td"]))
{
if (!DateTime.TryParse(context.Request.QueryString["td"], out toDate))
toDate = NFMT.Common.DefaultValue.DefaultTime;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["pagenum"]))
int.TryParse(context.Request.QueryString["pagenum"], out pageIndex);
pageIndex++;
if (!string.IsNullOrEmpty(context.Request.QueryString["pagesize"]))
int.TryParse(context.Request.QueryString["pagesize"], out pageSize);
if (!string.IsNullOrEmpty(context.Request.QueryString["sortdatafield"]) && !string.IsNullOrEmpty(context.Request.QueryString["sortorder"]))
{
string sortDataField = context.Request.QueryString["sortdatafield"].Trim();
string sortOrder = context.Request.QueryString["sortorder"].Trim();
switch (sortDataField)
{
case "ContractDate":
sortDataField = string.Format("cs.{0}", sortDataField);
break;
case "ContractNo":
sortDataField = string.Format("con.{0}", sortDataField);
break;
case "SubNo":
sortDataField = "cs.SubNo";
break;
case "InCorpName":
sortDataField = "inccd.CorpName";
break;
case "OutCorpName":
sortDataField = "outccd.CorpName";
break;
case "AssetName":
sortDataField = "a.AssetName";
break;
case "AllotBala":
sortDataField = "cs.ContractDate";
break;
case "AllotWeigth":
sortDataField = "soad.SumWeight";
break;
case "LaveWeight":
sortDataField = "(cs.SignAmount -isnull(soad.SumWeight,0))";
break;
case "StatusName":
sortDataField = "sd.StatusName";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Document.BLL.DocumentOrderBLL bll = new NFMT.Document.BLL.DocumentOrderBLL();
NFMT.Common.IAuthority auth = new NFMT.Authority.ContractAuth();
auth.AuthColumnNames.Add("con.ContractId");
NFMT.Common.SelectModel select = bll.GetContractListSelect(pageIndex, pageSize, orderStr, subNo, outCorpId, fromDate, toDate);
NFMT.Common.ResultModel result = bll.Load(user, select, auth);
context.Response.ContentType = "text/plain";
if (result.ResultStatus != 0)
{
context.Response.Write(result.Message);
context.Response.End();
}
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("count", totalRows);
dic.Add("data", dt);
string postData = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter());
context.Response.Write(postData);
}
