public static bool Delete(ISession session, string orderNumber)
{
WHTransferHead head = WHTransferHead.Retrieve(session, orderNumber);
if (head == null)
{
return(false);
}
return(head.Delete(session));
}
protected void MagicItemCommand(object sender, MagicItemEventArgs e)
{
if (e.CommandName == "Save")
{
using (ISession session = new Session())
{
WHTransferHead head = null;
if (this.IsNew)
{
head = new WHTransferHead();
head.OrderNumber = ERPUtil.NextOrderNumber(WHTransferHead.ORDER_TYPE_NORMAL);
head.Note = this.txtNote.Text.Trim();
head.FromLocation = this.drpFromLocation.SelectedValue;
head.ToLocation = this.drpToLocation.SelectedValue;
head.Status = WHTransferStatus.New;
head.OrderTypeCode = WHTransferHead.ORDER_TYPE_NORMAL;
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("TransferNewLine.aspx?ordNum=").Append(head.OrderNumber);
url.Append("&return=");
//保存后跳转到添加明细页面
//下面的返回url设置用途：
//1. 从添加明细页面点击返回按钮，将跳转到明细维护界面
//2. 明细维护界面再点击返回按钮，跳转到移库单主档维护页面，并且保留下从移库单主档维护页面进入新增页面时的查询条件
url.Append(WebUtil.escape("TransferLine.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}", "TransferLine.aspx?ordNum=" + head.OrderNumber + "&return=" + WebUtil.escape(WebUtil.Param("return")));
}
this.Response.Redirect(url.ToString());
}
head = WHTransferHead.Retrieve(session, this.OrderNumber);
if (head.Status != WHTransferStatus.New)
{
log.WarnFormat("Warn - 保存移库单: 移库单{0}状态为{1}，无法保存", head.OrderNumber, head.Status.ToString());
WebUtil.ShowMsg(this, "只有状态为新建的移库单可以修改保存!");
return;
}
head.Note = this.txtNote.Text.Trim();
head.FromLocation = this.drpFromLocation.SelectedValue;
head.ToLocation = this.drpToLocation.SelectedValue;
head.Update(session, "Note", "FromLocation", "ToLocation");
log.DebugFormat("Update - 移库单: {0}", head.OrderNumber);
WebUtil.ShowMsg(this, "保存成功");
}
}
}
private void SetView(WHTransferHead head)
{
switch (head.Status)
{
case WHTransferStatus.New:
this.cmdEdit1.Visible = true;
this.cmdEdit2.Visible = true;
this.cmdClose1.Visible = false;
this.cmdClose2.Visible = false;
break;
case WHTransferStatus.Release:
this.cmdEdit1.Visible = false;
this.cmdEdit2.Visible = false;
this.cmdClose1.Visible = false;
this.cmdClose2.Visible = false;
break;
case WHTransferStatus.Open:
this.cmdEdit1.Visible = false;
this.cmdEdit2.Visible = false;
this.cmdClose1.Visible = true;
this.cmdClose2.Visible = true;
break;
case WHTransferStatus.Close:
this.cmdEdit1.Visible = false;
this.cmdEdit2.Visible = false;
this.cmdClose1.Visible = false;
this.cmdClose2.Visible = false;
break;
}
}
private void QueryAndBindData(ISession session, WHTransferHead 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.FromArea as FromArea,l.FromSection as FromSection,l.ToArea as ToArea,l.ToSection as ToSection
,l.MoveQty as MoveQty
from WHTransferLine 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(WHTransferLine))
.Attach(typeof(ItemSpec)).Attach(typeof(ItemMaster)).Attach(typeof(ItemColor))
.SetValue("?ordNum", this.OrderNumber, "l.OrderNumber")
.DataSet();
this.repeatControl.DataBind();
}
private void showInfo(ISession session, WHTransferHead head)
{
User user;
if (head != null)
{
this.txtOrderNumber.Text = head.OrderNumber;
this.txtNote.Text = head.Note;
if (!string.IsNullOrEmpty(head.FromLocation))
this.drpFromLocation.SelectedValue = head.FromLocation;
if (!string.IsNullOrEmpty(head.ToLocation))
this.drpToLocation.SelectedValue = head.ToLocation;
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(WHTransferHead head)
{
if (this.IsNew)
this.cmdDetail.Visible = false;
else
{
this.cmdDetail.Visible = true;
this.cmdDetail["Detail"].NavigateUrl = "TransferLine.aspx?ordNum=" + this.OrderNumber + "&return=" + Microsoft.JScript.GlobalObject.escape(this.ReturnUrl);
if (head != null && head.Status != WHTransferStatus.New)
this.cmdEdit.Visible = false;
}
this.cmdReturn["Return"].NavigateUrl = this.ReturnUrl;
if (head != null && head.Status != WHTransferStatus.New)
{
WebUtil.DisableControl(this.drpFromLocation);
WebUtil.DisableControl(this.drpToLocation);
WebUtil.DisableControl(this.txtNote);
}
}
private void QueryAndBindData(ISession session, int pageIndex, int pageSize, bool fetchRecordCount)
{
int count = 0;
this._head = WHTransferHead.Retrieve(session, this.OrderNumber);
this.repeatControl.DataSource = WHTransferHead.Query(session, fetchRecordCount, out count, this._head.FromLocation
, this.txtSku.Text, this.txtItemCode.Text, this.txtItemName.Text, this.txtColor.Text, this.txtSize.Text, this.drpArea.SelectedValue, this.txtSection.Text
, pageIndex, pageSize);
this._session = session;
this.repeatControl.DataBind();
this._session = null;
if (fetchRecordCount)
this.magicPagerMain.RecordCount = this.magicPagerSub.RecordCount = count;
WebUtil.SetMagicPager(magicPagerMain, pageSize, pageIndex);
WebUtil.SetMagicPager(magicPagerSub, pageSize, pageIndex);
}
