public static bool Delete(ISession session, string orderNumber) { INVCheckHead head = INVCheckHead.Retrieve(session, orderNumber); if (head != null) { return(head.Delete(session)); } return(false); }
protected void MagicItemCommand(object sender, MagicItemEventArgs e) { if (e.CommandName == "Save") { using (ISession session = new Session()) { INVCheckHead head = null; if (this.IsNew) { head = new INVCheckHead(); head.OrderNumber = ERPUtil.NextOrderNumber(INVCheckHead.ORDER_TYPE_ADJ); head.Note = this.txtNote.Text.Trim(); head.LocationCode = this.drpLocation.SelectedValue; head.Status = INVCheckStatus.New; head.OrderTypeCode = INVCheckHead.ORDER_TYPE_ADJ; head.CreateTime = DateTime.Now; head.CreateUser = SecuritySession.CurrentUser.UserId; head.Create(session); log.DebugFormat("Create - 库存调整单: {0}", head.OrderNumber); System.Text.StringBuilder url = new System.Text.StringBuilder(); url.Append("StockAdjustmentNewLine.aspx?ordNum=").Append(head.OrderNumber); url.Append("&return="); //保存后跳转到添加明细页面 //下面的返回url设置用途: //1. 从添加明细页面点击返回按钮,将跳转到明细维护界面 //2. 明细维护界面再点击返回按钮,跳转到调整单主档维护页面,并且保留下从调整单主档维护页面进入新增页面时的查询条件 url.Append(WebUtil.escape("StockAdjustmentLine.aspx?ordNum=" + head.OrderNumber + "&return=" + WebUtil.escape(WebUtil.Param("return")))); if (log.IsDebugEnabled) { log.DebugFormat("Redirect - to添加调整明细: url={0}", url.ToString()); log.DebugFormat("返回调整明细页地址: url={0}", "StockAdjustmentLine.aspx?ordNum=" + head.OrderNumber + "&return=" + WebUtil.escape(WebUtil.Param("return"))); } this.Response.Redirect(url.ToString()); } head = INVCheckHead.Retrieve(session, this.OrderNumber); if (head.Status != INVCheckStatus.New) { log.WarnFormat("Warn - 保存库存调整单: 库存调整单{0}状态为{1},无法保存", head.OrderNumber, head.Status.ToString()); WebUtil.ShowMsg(this, "只有状态为新建的库存调整单可以修改保存!"); return; } head.Note = this.txtNote.Text.Trim(); head.LocationCode = this.drpLocation.SelectedValue; head.Update(session, "Note", "LocationCode"); log.DebugFormat("Update - 库存调整单: {0}", head.OrderNumber); WebUtil.ShowMsg(this, "保存成功"); } } }
protected void MagicItemCommand(object sender, MagicItemEventArgs e) { if (e.CommandName == "Save") { try { using (ISession session = new Session()) { try { session.BeginTransaction(); INVCheckHead objHead = null; if (this.IsNew) { objHead = new INVCheckHead(this.drpLocation.SelectedValue, Cast.Enum<INVCheckType>(this.drpCheckType.SelectedValue), this.txtMemo.Text.Trim(), SecuritySession.CurrentUser.UserId); objHead.Create(session); } else { objHead = INVCheckHead.Retrieve(session, this.OrderNumber); objHead.Note = this.txtMemo.Text.Trim(); objHead.CheckType = Cast.Enum<INVCheckType>(this.drpCheckType.SelectedValue); objHead.Update(session, "CheckType", "Note"); } session.Commit(); this.Response.Redirect("InventoryCheckWH.aspx?ordNum=" + objHead.OrderNumber + "&return=" + Microsoft.JScript.GlobalObject.escape(WebUtil.Param("return"))); } catch (Exception ex) { session.Rollback(); throw ex; } } } catch (Exception ex) { logger.Info("保存库存盘点单", ex); WebUtil.ShowMsg(this, "发生未处理的异常,请刷新页面重新操作,或者联系系统管理员"); } } }
public static void ConfirmInvCheckOrder(ISession _session, string InvCheckNumber) { string strSQL = @" SELECT SUM(A.StockQty) AS StockQty,A.LocationCode AS LocationCode,A.AreaCode AS AreaCode,A.SectionCode AS SectionCode, B.SKUID AS SKUID,B.StandardPrice AS Price,B.BasicUnit AS Unit FROM StockDetail A LEFT JOIN ItemSpec B ON A.SKUID=B.SKUID WHERE A.AreaCode In (SELECT AreaCode FROM INVCheckWh WHERE OrderNumber=?) GROUP BY A.LocationCode,A.AreaCode,A.SectionCode, B.SKUID,B.StandardPrice,B.BasicUnit"; DataSet ds = _session.CreateObjectQuery(strSQL) .Attach(typeof(StockDetail)) .Attach(typeof(Magic.Basis.ItemSpec)) .Attach(typeof(Magic.Basis.ItemMaster)) .Attach(typeof(INVCheckWh)) .SetValue(0, InvCheckNumber, EntityManager.GetEntityMapping(typeof(INVCheckWh)).GetPropertyMapping("OrderNumber").DbTypeInfo) .DataSet(); INVCheckHead objHead = new INVCheckHead(); objHead.OrderNumber = InvCheckNumber; objHead.Status = INVCheckStatus.Confirm; objHead.Update(_session, "Status"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { INVCheckLine objItem = new INVCheckLine(); objItem.AreaCode = Cast.String(ds.Tables[0].Rows[i]["AreaCode"]); objItem.BeforeQty = Cast.Decimal(ds.Tables[0].Rows[i]["StockQty"], 0M); objItem.CurrentQty = objItem.BeforeQty; objItem.LineNumber = objHead.NextLineNumber(); objItem.LocationCode = Cast.String(ds.Tables[0].Rows[i]["LocationCode"]); objItem.OrderNumber = InvCheckNumber; objItem.SectionCode = Cast.String(ds.Tables[0].Rows[i]["SectionCode"]); objItem.SKUID = Cast.Int(ds.Tables[0].Rows[i]["SKUID"], 0); objItem.Create(_session); } }
public static void ConfirmInvCheckOrder(ISession _session,string InvCheckNumber) { string strSQL = @" SELECT SUM(A.StockQty) AS StockQty,A.LocationCode AS LocationCode,A.AreaCode AS AreaCode,A.SectionCode AS SectionCode, B.SKUID AS SKUID,B.StandardPrice AS Price,B.BasicUnit AS Unit FROM StockDetail A LEFT JOIN ItemSpec B ON A.SKUID=B.SKUID WHERE A.AreaCode In (SELECT AreaCode FROM INVCheckWh WHERE OrderNumber=?) GROUP BY A.LocationCode,A.AreaCode,A.SectionCode, B.SKUID,B.StandardPrice,B.BasicUnit"; DataSet ds = _session.CreateObjectQuery(strSQL) .Attach(typeof(StockDetail)) .Attach(typeof(Magic.Basis.ItemSpec)) .Attach(typeof(Magic.Basis.ItemMaster)) .Attach(typeof(INVCheckWh)) .SetValue(0, InvCheckNumber, EntityManager.GetEntityMapping(typeof(INVCheckWh)).GetPropertyMapping("OrderNumber").DbTypeInfo) .DataSet(); INVCheckHead objHead = new INVCheckHead(); objHead.OrderNumber = InvCheckNumber; objHead.Status = INVCheckStatus.Confirm; objHead.Update(_session, "Status"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { INVCheckLine objItem = new INVCheckLine(); objItem.AreaCode = Cast.String(ds.Tables[0].Rows[i]["AreaCode"]); objItem.BeforeQty = Cast.Decimal(ds.Tables[0].Rows[i]["StockQty"], 0M); objItem.CurrentQty = objItem.BeforeQty; objItem.LineNumber = objHead.NextLineNumber(); objItem.LocationCode = Cast.String(ds.Tables[0].Rows[i]["LocationCode"]); objItem.OrderNumber = InvCheckNumber; objItem.SectionCode = Cast.String(ds.Tables[0].Rows[i]["SectionCode"]); objItem.SKUID = Cast.Int(ds.Tables[0].Rows[i]["SKUID"], 0); objItem.Create(_session); } }
private void SaveCheckOrder() { try { DataSet ds = Session["InvAdjustmentItem"] as DataSet; Dictionary<int, int> lstCurrentQuantity = new Dictionary<int, int>(); for (int i = 0; i < this.rptInvCheck.Items.Count; i++) { TextBox objBox = this.rptInvCheck.Items[i].FindControl("txtCurrentQuantity") as TextBox; System.Web.UI.HtmlControls.HtmlInputHidden objSKU = this.rptInvCheck.Items[i].FindControl("hidSKUID") as System.Web.UI.HtmlControls.HtmlInputHidden; try { lstCurrentQuantity.Add(Cast.Int(objSKU.Value), Cast.Int(objBox.Text)); } catch (Exception ex) { WebUtil.ShowMsg(this, "调整数量非法,请重新输入!"); return; } } using (_session = new Session()) { _session.BeginTransaction(); try { INVCheckHead objHead = INVCheckHead.Retrieve(_session, this.txtInvCheckNumber.Text); bool blnInsert = false; if (objHead == null) { blnInsert = true; objHead = new INVCheckHead(); objHead.CreateTime = DateTime.Now; objHead.CreateUser = Magic.Security.SecuritySession.CurrentUser.UserId; objHead.Note = this.txtMemo.Text; objHead.OrderNumber = Magic.ERP.ERPUtil.NextOrderNumber(Magic.ERP.Orders.INVCheckHead.ORDER_TYPE_ADJ); objHead.OrderTypeCode = INVCheckHead.ORDER_TYPE_ADJ; objHead.Status = Magic.ERP.INVCheckStatus.New; objHead.Create(_session); } else { if ((objHead.Status == Magic.ERP.INVCheckStatus.Release) || (objHead.Status == Magic.ERP.INVCheckStatus.Close)) { WebUtil.ShowMsg(this, "发布以后的盘点单不可以进行修改"); return; } objHead.Note = this.txtMemo.Text; blnInsert = false; _session.CreateEntityQuery<INVCheckLine>().Where(Exp.Eq("OrderNumber", objHead.OrderNumber)).Delete(); } objHead.CurrentLineNumber = ""; List<INVCheckLine> List = new List<INVCheckLine>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { INVCheckLine objLine = new INVCheckLine(); objLine.SKUID = Cast.Int(ds.Tables[0].Rows[i]["SKUID"]); objLine.AreaCode = Cast.String(ds.Tables[0].Rows[i]["AreaCode"]); objLine.BeforeQty = Cast.Decimal(ds.Tables[0].Rows[i]["BeforeQty"]); objLine.CurrentQty = lstCurrentQuantity[objLine.SKUID]; objLine.LineNumber = objHead.NextLineNumber(); objLine.LocationCode = Cast.String(ds.Tables[0].Rows[i]["LocationCode"]); objLine.OrderNumber = objHead.OrderNumber; objLine.SectionCode = Cast.String(ds.Tables[0].Rows[i]["SectionCode"]); objLine.Create(_session); } objHead.Update(_session, "CurrentLineNumber"); this.txtInvCheckNumber.Text = objHead.OrderNumber; _session.Commit(); } catch (Exception ex) { _session.Rollback(); throw ex; } } WebUtil.ShowMsg(this, "库存盘点单保存成功", "操作成功"); } catch (Exception ex) { logger.Info("保存库存盘点单", ex); WebUtil.ShowMsg(this, "发生未处理的异常,请刷新页面重新操作,或者联系系统管理员"); } }
private void QueryAndBindData(ISession session, INVCheckHead head) { this.repeatControl.DataSource = session.CreateObjectQuery(@" select l.LineNumber as LineNumber,sku.BarCode as BarCode,i.ItemCode as ItemCode,i.ItemName as ItemName ,sku.ColorCode as ColorCode,color.ColorText as ColorText,sku.SizeCode as SizeCode ,l.AreaCode as AreaCode,l.SectionCode as SectionCode,l.BeforeQty as StockQty,l.CurrentQty as AdjQty from INVCheckLine l inner join ItemSpec sku on l.SKUID=sku.SKUID inner join ItemMaster i on i.ItemID=sku.ItemID left join ItemColor color on color.ColorCode=sku.ColorCode where l.OrderNumber=?ordNum order by l.LineNumber") .Attach(typeof(INVCheckLine)) .Attach(typeof(ItemSpec)).Attach(typeof(ItemMaster)).Attach(typeof(ItemColor)) .SetValue("?ordNum", this.OrderNumber, "l.OrderNumber") .DataSet(); this.repeatControl.DataBind(); }
private void SetView(ISession session, INVCheckHead head) { if (!this.IsNew) WebUtil.DisableControl(this.drpLocation); if (head != null) { if (!string.IsNullOrEmpty(head.LocationCode) && head.LocationCode.Trim().Length > 0) { WHLocation location = WHLocation.Retrieve(session, head.LocationCode); this.drpLocation.Items.Clear(); this.drpLocation.Items.Add(new ListItem(location.Name, location.LocationCode)); } this.drpCheckType.SelectedValue = head.CheckType.ToString(); this.txtMemo.Text = head.Note; OrderStatusDef statusDef = OrderStatusDef.Retrieve(session, INVCheckHead.ORDER_TYPE_CHK, (int)head.Status); if (statusDef != null) this.lblStatus.Text = statusDef.StatusText; Magic.Sys.User user = null; if (head.CreateUser > 0) { user = Magic.Sys.User.Retrieve(session, head.CreateUser); if (user != null) this.lblUser.Text = user.FullName; } this.lblCreateTime.Text = RenderUtil.FormatDatetime(head.CreateTime); this.lblApproveResult.Text = ERPUtil.EnumText<ApproveStatus>(head.ApproveResult); if (head.ApproveUser > 0) { user = Magic.Sys.User.Retrieve(session, head.ApproveUser); if (user != null) this.lblApproveUser.Text = user.FullName; } this.lblApproveTime.Text = RenderUtil.FormatDatetime(head.ApproveTime); this.txtApproveNote.Text = head.ApproveNote; if (head.Status != INVCheckStatus.New) { WebUtil.DisableControl(this.txtMemo); WebUtil.DisableControl(this.drpCheckType); this.cmdSave.Visible = false; } } }
protected void MagicItemCommand(object sender, MagicItemEventArgs e) { if (e.CommandName == "Save") { SaveCheckOrder(); } if (e.CommandName == "Close") { try { if (this.txtInvCheckNumber.Text.Trim().Length == 0) { WebUtil.ShowMsg(this, "只有签核通过的库存调整单才可以关闭!"); return; } using (_session = new Session()) { Magic.ERP.Orders.INVCheckHead objhead = Magic.ERP.Orders.INVCheckHead.Retrieve(_session, this.txtInvCheckNumber.Text.Trim()); if ((objhead.Status == Magic.ERP.INVCheckStatus.Release) && (objhead.ApproveResult == Magic.ERP.ApproveStatus.Approve)) { Magic.ERP.ERPUtil.CommitWHTrans(_session, objhead); } else { WebUtil.ShowMsg(this, "只有签核通过的库存调整单才可以关闭!"); return; } } } catch (Exception ex) { WebUtil.ShowMsg(this, "关闭库存调整单失败,请与管理员联系!"); } } if (e.CommandName == "Insert") { try { if (this.hidSkuId.Value.Trim().Length == 0) { WebUtil.ShowMsg(this, "请先选择物料!"); return; } string strSKUID = this.hidSkuId.Value; string strLocation = this.ddlLocation.SelectedValue; string strArea = this.ddlArea.SelectedValue; string strSection = this.ddlSection.SelectedValue; int intNewQuantity = 0; try { intNewQuantity = int.Parse(this.txtNewQuantity.Text); if (intNewQuantity < 0) { WebUtil.ShowMsg(this, "物料库存数量必须为整数,请重新输入!"); return; } } catch (Exception ex) { WebUtil.ShowMsg(this, "物料库存数量必须为整数,请重新输入!"); return; } using (_session = new Session()) { } Magic.ERP.Orders.INVCheckLine objLine = new INVCheckLine(); objLine.AreaCode = strArea; objLine.BeforeQty = int.Parse(this.txtOldQuantity.Value); objLine.CurrentQty = intNewQuantity; objLine.LineNumber = ""; objLine.LocationCode = strLocation; objLine.OrderNumber = this.txtInvCheckNumber.Text; objLine.SectionCode = strSection; objLine.SKUID = int.Parse(strSKUID); SaveItem(objLine, this.txtItemName.Value, this.txtItemSize.Value, this.txtItemColor.Value, this.ddlLocation.SelectedItem.Text, this.ddlArea.SelectedItem.Text, this.ddlSection.SelectedItem.Text); if (this.tblAddItem.Style["display"] == null) { this.tblAddItem.Style.Add("display", "none"); } else { this.tblAddItem.Style["display"] = "none"; } this.txtItemName.Value = ""; this.txtItemColor.Value = ""; this.txtItemSize.Value = ""; this.ddlLocation.SelectedIndex = 0; this.txtOldQuantity.Value = "0"; this.txtNewQuantity.Text = ""; this.ddlArea.Items.Clear(); this.ddlSection.Items.Clear(); } catch (Exception ex) { logger.Error(ex); WebUtil.ShowError(this, ex); } } if (e.CommandName == "Return") { string strURL = "StockAdjustmentManage.aspx"; if ((WebUtil.Param("return") != null) && (WebUtil.Param("return").Length > 0)) { strURL = WebUtil.Param("return").Trim(); } Response.Redirect(strURL); } }
private void SetView(INVCheckHead head) { this.cmdReturn1["Return"].NavigateUrl = WebUtil.Param("return"); this.cmdReturn2["Return"].NavigateUrl = WebUtil.Param("return"); WebUtil.EnableControl(this.drpViewType); if (!IsPostBack) { this.drpViewType.ClearSelection(); this.drpViewType.SelectedValue = "1"; } if (head == null) return; #region ������ť switch (head.Status) { case INVCheckStatus.Confirm: this.cmdEdit1.Visible = true; this.cmdEdit2.Visible = true; this.cmdClose1.Visible = false; this.cmdClose2.Visible = false; if (head.CheckType == INVCheckType.Implicit) WebUtil.DisableControl(this.drpViewType); break; case INVCheckStatus.Release: this.cmdEdit1.Visible = false; this.cmdEdit2.Visible = false; if (head.ApproveResult == ApproveStatus.Approve) { this.cmdClose1.Visible = true; this.cmdClose2.Visible = true; } else { this.cmdClose1.Visible = false; this.cmdClose2.Visible = false; } if (!IsPostBack) { this.drpViewType.ClearSelection(); this.drpViewType.SelectedValue = "2"; } break; case INVCheckStatus.Close: this.cmdEdit1.Visible = false; this.cmdEdit2.Visible = false; this.cmdClose1.Visible = false; this.cmdClose2.Visible = false; if (!IsPostBack) { this.drpViewType.ClearSelection(); this.drpViewType.SelectedValue = "2"; } break; } #endregion }
private void RestoreLastQuery(ISession session, INVCheckHead head) { QueryHelper helper = new QueryHelper(this); if (helper.HasQueryParameter()) { this.drpViewType.SelectedValue = helper.Pop("vt"); this.drpArea.SelectedValue = helper.Pop("area"); this.txtSection.Text= helper.Pop("sec"); this.txtSKU.Text = helper.Pop("sku"); this.txtItemCode.Text = helper.Pop("itmc"); this.txtName.Text = helper.Pop("itmn"); this.txtColor.Text = helper.Pop("color"); this.txtSize.Text = helper.Pop("size"); } int pageSize = Cast.Int(helper.Pop("ps"), this.magicPagerMain.PageSize); int pageIndex = Cast.Int(helper.Pop("pi"), 1); this.QueryAndBindData(session, head, pageSize, pageIndex, true); }
private void QueryAndBindData(ISession session, INVCheckHead head, int pageSize, int pageIndex, bool fetchCount) { Magic.Framework.ORM.Query.ObjectQuery query = session.CreateObjectQuery(string.Format(@" select l.LineNumber as LineNumber ,s.BarCode as BarCode,m.ItemCode as ItemCode,m.ItemName as ItemName ,s.ColorCode as ColorCode,color.ColorText as ColorText,s.SizeCode as SizeCode ,l.AreaCode as AreaCode,l.SectionCode as SectionCode,l.BeforeQty as BeforeQty,l.CurrentQty as CurrentQty from INVCheckLine l inner join ItemSpec s on l.SKUID=s.SKUID inner join ItemMaster m on m.ItemID=s.ItemID left join ItemColor color on color.ColorCode=s.ColorCode where l.OrderNumber=?ordNum {0} order by l.LineNumber", this.drpViewType.SelectedValue == "2" ? "and l.BeforeQty<>l.CurrentQty" : "")) .Attach(typeof(INVCheckLine)).Attach(typeof(ItemSpec)).Attach(typeof(ItemMaster)).Attach(typeof(ItemColor)) .SetValue("?ordNum", this.OrderNumber, "l.OrderNumber") .SetPage(pageIndex, pageSize); if (this.drpArea.SelectedValue.Trim().Length > 0) query.And(Exp.Eq("l.AreaCode", this.drpArea.SelectedValue.Trim())); if (this.txtSKU.Text.Trim().Length > 0) query.And(Exp.Like("s.BarCode", "%" + this.txtSKU.Text.Trim() + "%")); if (this.txtItemCode.Text.Trim().Length > 0) query.And(Exp.Like("m.ItemCode", "%" + this.txtItemCode.Text.Trim() + "%")); if (this.txtName.Text.Trim().Length > 0) query.And(Exp.Like("m.ItemName", "%" + this.txtName.Text.Trim() + "%")); if (this.txtColor.Text.Trim().Length > 0) query.And(Exp.Like("s.ColorCode", "%" + this.txtColor.Text.Trim().ToUpper() + "%")); if (this.txtSize.Text.Trim().Length > 0) query.And(Exp.Like("s.SizeCode", "%" + this.txtSize.Text.Trim().ToUpper() + "%")); this.repeatControl.DataSource = query.DataSet(); this._head = INVCheckHead.Retrieve(session, this.OrderNumber); this.repeatControl.DataBind(); this._head = null; if (fetchCount) this.magicPagerMain.RecordCount = this.magicPagerSub.RecordCount = query.Count(); WebUtil.SetMagicPager(magicPagerMain, pageSize, pageIndex); WebUtil.SetMagicPager(magicPagerSub, pageSize, pageIndex); this.txtReturnToThisUrl.Value = this.GetReturnUrl(); }
private void SetView(INVCheckHead head) { switch (head.Status) { case INVCheckStatus.New: this.cmdEdit1.Visible = true; this.cmdEdit2.Visible = true; this.cmdClose1.Visible = false; this.cmdClose2.Visible = false; break; case INVCheckStatus.Release: this.cmdEdit1.Visible = false; this.cmdEdit2.Visible = false; this.cmdClose1.Visible = true; this.cmdClose2.Visible = true; break; case INVCheckStatus.Close: this.cmdEdit1.Visible = false; this.cmdEdit2.Visible = false; this.cmdClose1.Visible = false; this.cmdClose2.Visible = false; break; } }
private void showInfo(ISession session, INVCheckHead head) { User user; if (head != null) { this.txtOrderNumber.Text = head.OrderNumber; this.txtNote.Text = head.Note; if (!string.IsNullOrEmpty(head.LocationCode)) this.drpLocation.SelectedValue = head.LocationCode; OrderStatusDef statusDef = OrderStatusDef.Retrieve(session, head.OrderTypeCode, (int)head.Status); if (statusDef != null) this.lblStatus.Text = statusDef.StatusText; if (head.CreateUser > 0) { user = Magic.Sys.User.Retrieve(session, head.CreateUser); if (user != null) this.lblUser.Text = user.FullName; } this.lblCreateTime.Text = RenderUtil.FormatDatetime(head.CreateTime); this.lblApproveResult.Text = ERPUtil.EnumText<ApproveStatus>(head.ApproveResult); switch (head.ApproveResult) { case ApproveStatus.Reject: this.lblApproveResult.ForeColor = System.Drawing.Color.Red; break; case ApproveStatus.Approve: this.lblApproveResult.ForeColor = System.Drawing.Color.Blue; break; } if (head.ApproveResult == ApproveStatus.Approve || head.ApproveResult == ApproveStatus.Reject) { if (head.ApproveUser > 0) { user = Magic.Sys.User.Retrieve(session, head.ApproveUser); if (user != null) this.lblApproveUser.Text = user.FullName; } this.lblApproveTime.Text = RenderUtil.FormatDatetime(head.ApproveTime); } this.txtApproveNote.Text = head.ApproveNote; } }
private void setView(INVCheckHead head) { if (this.IsNew) this.cmdDetail.Visible = false; else { this.cmdDetail.Visible = true; this.cmdDetail["Detail"].NavigateUrl = "StockAdjustmentLine.aspx?ordNum=" + this.OrderNumber + "&return=" + Microsoft.JScript.GlobalObject.escape(this.ReturnUrl); if (head != null && head.Status != INVCheckStatus.New) this.cmdEdit.Visible = false; } this.cmdReturn["Return"].NavigateUrl = this.ReturnUrl; if (head != null && head.Status != INVCheckStatus.New) { WebUtil.DisableControl(this.drpLocation); WebUtil.DisableControl(this.txtNote); } }
private void SetView(INVCheckHead head) { if (head == null || head.Status != INVCheckStatus.New) { this.sectionAdd.Visible = false; this.sectionAlert.Visible = false; this.cmdConfirm.Visible = false; if (head != null) { this.cmdViewDetail.Visible = true; this.cmdViewDetail["Detail"].NavigateUrl = "InventoryCheckDetail.aspx?ordNum=" + head.OrderNumber + "&return=" + Microsoft.JScript.GlobalObject.escape(WebUtil.Param("return")); } else this.cmdViewDetail.Visible = false; } else this.cmdViewDetail.Visible = false; this.cmdReturn["Return"].NavigateUrl = WebUtil.Param("return"); }
private void QueryAndBindData(ISession session, INVCheckHead head) { this.repeaterControl.DataSource = session.CreateObjectQuery(@" select 1 from WHArea where AreaCode in (select AreaCode from INVCheckWh where OrderNumber=?ordNum) order by AreaCode") .Attach(typeof(WHArea)).Attach(typeof(INVCheckWh)) .SetValue("?ordNum", this.OrderNumber, EntityManager.GetPropMapping(typeof(INVCheckWh), "OrderNumber").DbTypeInfo) .List<WHArea>(); this._head = head; this.repeaterControl.DataBind(); this._head = null; }
private void BindArea(ISession session, INVCheckHead head) { IList<WHArea> areas = session.CreateObjectQuery(@" select 1 from WHArea where AreaCode not in( select distinct a.AreaCode from INVCheckWh a inner join INVCheckHead b on a.OrderNumber=b.OrderNumber where b.Status=?s1 ) and Status=?status and IsReservedArea=?isReserved and IsTransArea=?transArea and LocationCode=?loc and IsLocked=?islock order by AreaCode") .Attach(typeof(WHArea)).Attach(typeof(INVCheckWh)).Attach(typeof(INVCheckHead)) .SetValue("?s1", INVCheckStatus.New, EntityManager.GetPropMapping(typeof(INVCheckHead), "Status").DbTypeInfo) .SetValue("?status", WHStatus.Enable, "Status") .SetValue("?isReserved", false, "IsReservedArea") .SetValue("?transArea", true, "IsTransArea") .SetValue("?loc", head.LocationCode, "LocationCode") .SetValue("?islock", false, "IsLocked") .List<WHArea>(); this.drpArea.Items.Clear(); foreach (WHArea area in areas) this.drpArea.Items.Add(new ListItem(area.AreaCode, area.AreaCode)); }