protected void btnSave_Click(object sender, EventArgs e)
{
if (strID == "") //新增
{
int Count = bll.GetRowCount("CMD_ProductState", string.Format("StateNo='{0}'", this.txtID.Text));
if (Count > 0)
{
JScript.ShowMessage(this.Page, "该状态编码已经存在！");
return;
}
bll.ExecNonQuery("Cmd.InsertProductState", new DataParameter[] { new DataParameter("@StateNo", this.txtID.Text.Trim()),
new DataParameter("@StateName", this.txtStateName.Text.Trim()),
new DataParameter("@MEMO", this.txtMemo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()) });
}
else //修改
{
bll.ExecNonQuery("Cmd.UpdateProductState", new DataParameter[] { new DataParameter("@StateName", this.txtStateName.Text.Trim()),
new DataParameter("@MEMO", this.txtMemo.Text.Trim()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("{0}", this.txtID.Text.Trim()) });
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string whcode = this.txtWhCode.Text;
DataTable dtTemp = bll.FillDataTable("Cmd.SelectArea", new DataParameter[] { new DataParameter("{0}", "WarehouseCode='" + whcode + "'") });
int count = dtTemp.Rows.Count;
if (count > 0)
{
JScript.ShowMessage(this, whcode + "还有下属库区，不能删除！");
return;
}
else
{
bll.ExecNonQuery("Cmd.DeleteWarehouse", new DataParameter[] { new DataParameter("{0}", whcode) });
this.txtWHID.Text = "";
this.txtWhName.Text = "";
this.txtMemo.Text = "";
this.txtWhCode.ReadOnly = false;
string path = whcode;
JScript.RegisterScript(this, "RefreshParent('" + path + "');");
}
AddOperateLog("仓库管理", "删除仓库信息");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string strUserID = "-1,";
for (int i = 0; i < gvMain.Rows.Count; i++)
{
CheckBox chk = (CheckBox)gvMain.Rows[i].Cells[0].Controls[0];
if (gvMain.Rows[i].Cells[1].Text == "admin" && chk.Checked)
{
JScript.ShowMessage(this.UpdatePanel1, "管理员帐号不能删除！");
continue;
}
if (chk.Enabled && chk.Checked)
{
strUserID += dtUser.Rows[i]["UserID"].ToString() + ",";
}
}
strUserID += "-1";
bll.ExecNonQuery("Security.DeleteUser", new DataParameter[] { new DataParameter("{0}", strUserID) });
AddOperateLog("用户管理", "删除用户信息");
SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.txtAreaID.Text.Trim().Length == 0)//新增
{
int count = bll.GetRowCount(TableName, string.Format("AreaCode='{0}'", this.txtAreaCode.Text));
if (count > 0)
{
JScript.ShowMessage(this, "此库区编码已存在，不能新增！");
return;
}
bll.ExecNonQuery("Cmd.InsertArea", new DataParameter[] {
new DataParameter("@AreaCode", this.txtAreaCode.Text),
new DataParameter("@AreaName", this.txtAreaName.Text.Trim().Replace("\'", "\''")),
new DataParameter("@WarehouseCode", this.txtWHID.Text),
new DataParameter("@Memo", this.txtMemo.Text.Trim())
});
JScript.RegisterScript(this, "ReloadParent();");
Common.AddOperateLog(Session["G_user"].ToString(), "库区管理", "添加库区信息");
}
else
{
bll.ExecNonQuery("Cmd.UpdateArea", new DataParameter[] {
new DataParameter("@AreaCode", this.txtAreaCode.Text),
new DataParameter("@AreaName", this.txtAreaName.Text.Trim().Replace("\'", "\''")),
new DataParameter("@MEMO", this.txtMemo.Text.Trim()),
new DataParameter("{0}", this.txtAreaID.Text)
});
JScript.RegisterScript(this, "UpdateParent();");
Common.AddOperateLog(Session["G_user"].ToString(), "库区管理", "修改库区信息");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (strID == "") //新增
{
int Count = bll.GetRowCount("CMD_Crane", string.Format("CraneNo='{0}'", this.txtID.Text));
if (Count > 0)
{
JScript.ShowMessage(this.Page, "该堆垛机编码已经存在！");
return;
}
bll.ExecNonQuery("Cmd.InsertCrane", new DataParameter[] {
new DataParameter("@CraneNo", this.txtID.Text.Trim()),
new DataParameter("@CraneName", this.txtTypeName.Text.Trim()),
new DataParameter("@State", this.ddlActive.SelectedValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim())
});
}
else //修改
{
bll.ExecNonQuery("Cmd.UpdateCrane", new DataParameter[] { new DataParameter("@CraneName", this.txtTypeName.Text.Trim()),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@State", this.ddlActive.SelectedValue),
new DataParameter("@CraneNo", this.txtID.Text.Trim()) });
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
protected void btnSearch_Click(object sender, System.EventArgs e)
{
try
{
pageIndex = 1;
string strWhere = "1=1";
if (this.ddlProductCategory.SelectedValue.Trim() != "")
{
strWhere += " and CategoryCode='" + this.ddlProductCategory.SelectedValue.Trim() + "'";
}
if (this.txtProductCode.Text.Trim() != "")
{
strWhere += " and ProductCode like '%" + this.txtProductCode.Text + "%'";
}
if (this.txtSearch.Text.Trim() != "")
{
strWhere += " and ProductName like '%" + this.txtSearch.Text + "%'";
}
if (Request.QueryString["Where"] != "" && Request.QueryString["Where"] != null)
{
filter = strWhere + " AND " + Microsoft.JScript.GlobalObject.unescape(Request.QueryString["Where"]);
}
ViewState["filter"] = filter;
BindGrid(pageIndex);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
}
protected void btnTask_Click(object sender, EventArgs e)
{
BLL.BLLBase bll = new BLL.BLLBase();
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State == 0)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号还未审核不能作业，请审核后，再进行出库作业。");
return;
}
if (State > 1)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号已经作业，不能再进行出库作业。");
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpOutStockTask", new DataParameter[] { new DataParameter("@BillID", this.txtID.Text), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("出库单", "出库作业单号：" + this.txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
catch (Exception ex)
{
JScript.ShowMessage(this.updatePanel, ex.Message);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string whcode = this.txtWHID.Text;
string areaCode = this.txtAreaCode.Text;
string areaid = this.txtAreaID.Text;
DataTable dtTemp = bll.FillDataTable("Cmd.SelectShelf", new DataParameter[] { new DataParameter("{0}", "AreaCode='" + areaid + "'") });
int count = dtTemp.Rows.Count;
if (count > 0)
{
JScript.ShowMessage(this, areaCode + "库区还有下属货架，不能删除！");
return;
}
else
{
bll.ExecNonQuery("Cmd.DeleteArea", new DataParameter[] { new DataParameter("{0}", areaid) });
this.txtAreaID.Text = "";
this.txtAreaCode.Text = "";
this.txtAreaName.Text = "";
this.txtMemo.Text = "";
this.txtAreaCode.ReadOnly = false;
string path = whcode + "/" + areaCode;
JScript.RegisterScript(this, "RefreshParent('" + path + "');");
Common.AddOperateLog(Session["G_user"].ToString(), "库区管理", "删除库区信息");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string strGroupID = "-1,";
for (int i = 0; i < gvMain.Rows.Count; i++)
{
CheckBox chk = (CheckBox)gvMain.Rows[i].Cells[0].Controls[0];
if (chk.Enabled && chk.Checked)
{
int membercount = (int)bll.ExecScalar("Security.SelectGroupMemberCount", new DataParameter[] { new DataParameter("@GroupID", Convert.ToInt32(dtGroup.Rows[i]["GroupID"])) });
if (membercount > 0)
{
JScript.ShowMessage(this.UpdatePanel1, gvMain.Rows[i].Cells[1].Text + "用户组还有用户存在，请调整后再删除！");
return;
}
strGroupID += dtGroup.Rows[i]["GroupID"].ToString() + ",";
}
}
strGroupID += "-1";
bll.ExecNonQuery("Security.DeleteGroup", new DataParameter[] { new DataParameter("{0}", strGroupID) });
AddOperateLog("用户管理", "删除用户信息");
SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string whcode = this.txtWHID.Text;
string areacode = this.txtAreaID.Text;
string shelfCode = this.txtShelfCode.Text;
string shelfid = this.txtShelfID.Text;
DataTable dtTemp = bll.FillDataTable("Cmd.SelectCell", new DataParameter[] { new DataParameter("{0}", "SHELF_CODE='" + shelfCode + "'") });
int count = dtTemp.Rows.Count;
if (count > 0)
{
JScript.ShowMessage(this, shelfCode + "货架还有下属货位，不能删除！");
return;
}
else
{
bll.ExecNonQuery("Cmd.DeleteShelf", new DataParameter[] { new DataParameter("{0}", shelfid) });
this.txtShelfID.Text = "";
this.txtShelfCode.Text = "";
this.txtShelfName.Text = "";
this.txtMemo.Text = "";
this.btnSave.Enabled = true;
string path = whcode + "/" + areacode + "/" + shelfCode;
JScript.RegisterScript(this, "RefreshParent('" + path + "');");
}
Common.AddOperateLog(Session["G_user"].ToString(), "货贺管理", "删除货贺信息");
}
protected void btnDeletet_Click(object sender, EventArgs e)
{
string strColorCode = "'-1',";
BLL.BLLBase bll = new BLL.BLLBase();
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect"));
if (cb != null && cb.Checked)
{
HyperLink hk = (HyperLink)(this.GridView1.Rows[i].FindControl("HyperLink1"));
//判断能否删除
int Count = bll.GetRowCount("VUsed_CMD_BillType", string.Format("BillTypeCode='{0}'", hk.Text));
if (Count > 0)
{
JScript.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "入库类型被其它单据使用，请调整后再删除！");
return;
}
strColorCode += "'" + hk.Text + "',";
}
}
strColorCode += "'-1'";
bll.ExecNonQuery("Cmd.DeleteBillType", new DataParameter[] { new DataParameter("{0}", strColorCode) });
AddOperateLog("入库类型", "删除单号：" + strColorCode.Replace("'-1',", "").Replace(",'-1'", ""));
SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
protected void lnkBtnSave_Click(object sender, EventArgs e)
{
string GroupID = this.hdnRowValue.Value;
bll.ExecNonQuery("Security.DeleteGroupOperation", new DataParameter[] { new DataParameter("@GroupID", GroupID), new DataParameter("@SystemName", "WMS") });
foreach (TreeNode tnRoot in this.sTreeModule.Nodes)
{
foreach (TreeNode tnSub in tnRoot.ChildNodes)
{
foreach (TreeNode tnOp in tnSub.ChildNodes)
{
if (tnOp.Checked)
{
string ModuleID = tnOp.Value;
bll.ExecNonQuery("Security.InsertGroupOperation", new DataParameter[] { new DataParameter("@GroupID", GroupID), new DataParameter("@ModuleID", ModuleID) });
}
}
}
}
JScript.ShowMessage(this.UpdatePanel1, "保存成功！");
BindDataSub(this.hdnRowValue.Value);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string strID = this.txtID.Text;
int Count = bll.GetRowCount("VUsed_WMS_BillMaster", string.Format("BillID='{0}'", this.txtID.Text.Trim()));
if (Count > 0)
{
JScript.ShowMessage(this.updatePanel, "该出库单号已被其它单据使用，请调整后再删除！");
return;
}
string[] comds = new string[2];
comds[0] = "WMS.DeleteBillMaster";
comds[1] = "WMS.DeleteBillDetail";
List <DataParameter[]> paras = new List <DataParameter[]>();
paras.Add(new DataParameter[] { new DataParameter("{0}", "'" + strID + "'") });
paras.Add(new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
bll.ExecTran(comds, paras);
AddOperateLog("出库单", "删除单号：" + strID);
btnNext_Click(sender, e);
if (this.txtID.Text == strID)
{
btnPre_Click(sender, e);
if (this.txtID.Text == strID)
{
BindDataNull();
}
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
string start = "1900-01-01";
string end = System.DateTime.Now.AddDays(1).ToString();
try
{
if (this.txtStartDate.tDate.Text.Trim().Length > 0)
{
start = Convert.ToDateTime(this.txtStartDate.tDate.Text.Trim()).ToString();
}
if (this.txtEndDate.tDate.Text.Trim().Length > 0)
{
end = Convert.ToDateTime(this.txtEndDate.tDate.Text.Trim()).AddDays(1).ToString();
}
filter = string.Format("{0} like '{1}%' and (LoginTime>='{2}' and LoginTime<'{3}')", this.ddl_Field.SelectedValue, this.txtKeyWords.Text.Trim().Replace("'", ""), start, end);
ViewState["filter"] = filter;
dtLog = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception ex)
{
JScript.ShowMessage(this.UpdatePanel1, ex.Message);
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["filter"] = "1=1";
ViewState["CurrentPage"] = 1;
this.btnDeleteAll.Enabled = this.btnDelete.Enabled;
try
{
dtLog = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
writeJsvar(FormID, SqlCmd, "");
}
else
{
dtLog = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.UpdatePanel1.GetType(), "Resize", "resize();", true);
}
protected void Page_Load(object sender, EventArgs e)
{
SqlCmd = "Security.SelectAllUser";
pageSize = 13;
if (Request.QueryString["GroupID"] != null)
{
GroupID = Request.QueryString["GroupID"].ToString();
GroupName = Server.UrlDecode(Request.QueryString["GroupName"].ToString());
if (!IsPostBack)
{
ViewState["hdnRowValue"] = "";
ViewState["filter"] = "1=1";
ViewState["CurrentPage"] = 1;
try
{
SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, this.gvGroupList, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
this.Label1.Text = GroupName + " 成员设置";
this.Title = GroupName + " 成员设置";
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.UpdatePanel1.GetType(), "Resize", "resize();", true);
}
protected void btnCheck_Click(object sender, EventArgs e)
{
DataParameter[] paras = new DataParameter[4];
if (this.btnCheck.Text == "审核")
{
paras[0] = new DataParameter("@Checker", Session["EmployeeCode"].ToString());
paras[1] = new DataParameter("{0}", "getdate()");
paras[2] = new DataParameter("@State", 1);
}
else
{
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State > 1)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + " 单号已经作业，不能进行反审。");
return;
}
paras[0] = new DataParameter("@Checker", "");
paras[1] = new DataParameter("{0}", "null");
paras[2] = new DataParameter("@State", 0);
}
paras[3] = new DataParameter("@BillID", this.txtID.Text);
bll.ExecNonQuery("WMS.UpdateCheckBillMaster", paras);
AddOperateLog("出库单 ", btnCheck.Text + " " + txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.txtWHID.Text.Trim().Length == 0)//新增
{
int count = bll.GetRowCount("CMD_WAREHOUSE", string.Format("WarehouseCode='{0}'", this.txtWhCode.Text));
if (count > 0)
{
JScript.ShowMessage(this, "此仓库编码已存在，不能新增！");
return;
}
//新增
bll.ExecNonQuery("Cmd.InsertWarehouse", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWhCode.Text), new DataParameter("@WarehouseName", this.txtWhName.Text.Trim().Replace("\'", "\''")), new DataParameter("@MEMO", this.txtMemo.Text.Trim()) });
JScript.RegisterScript(this, "ReloadParent();");
AddOperateLog("仓库管理", "添加仓库信息");
}
else
{
//更新
bll.ExecNonQuery("Cmd.UpdateWarehouse", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWhCode.Text), new DataParameter("@WarehouseName", this.txtWhName.Text.Trim().Replace("\'", "\''")),
new DataParameter("@MEMO", this.txtMemo.Text.Trim()), new DataParameter("{0}", this.txtWhCode.Text) });
JScript.RegisterScript(this, "UpdateParent();");
AddOperateLog("仓库管理", "修改仓库信息");
}
JScript.RegisterScript(this, "window.close();");
}
protected void btnUnTask_Click(object sender, EventArgs e)
{
string strColorCode = "'" + this.txtID.Text.Trim() + "'";
BLL.BLLBase bll = new BLL.BLLBase();
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State < 2)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号还未作业，不能进行取消作业。");
return;
}
if (State > 2)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号已经执行，不能再进行取消作业。");
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpCancelInstockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("入库单", "入库取消作业单号：" + this.txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
catch (Exception ex)
{
JScript.ShowMessage(this.updatePanel, ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (strID == "") //新增
{
int Count = bll.GetRowCount("CMD_BillType", string.Format("BillTypeCode='{0}'", this.txtID.Text));
if (Count > 0)
{
JScript.ShowMessage(this.Page, "该类型编码已经存在！");
return;
}
bll.ExecNonQuery("Cmd.InsertBillType", new DataParameter[] {
new DataParameter("@BillTypeCode", this.txtID.Text.Trim()),
new DataParameter("@BillTypeName", this.txtBillTypeName.Text.Trim()),
new DataParameter("@Flag", "6"),
new DataParameter("@TaskType", "14"),
new DataParameter("@TaskLevel", 1),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString())
});
}
else //修改
{
bll.ExecNonQuery("Cmd.UpdateTrainType", new DataParameter[] { new DataParameter("@BillTypeName", this.txtBillTypeName.Text.Trim()),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("@BillTypeCode", this.txtID.Text.Trim()) });
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
protected void btn_login_Click(object sender, EventArgs e)
{
LoginUser loginUser = UserDAO.Instance.UserLogin(txt_UserName.Text, txt_Pwd.Text, Request.UserHostAddress);
if (loginUser == null)
{
JScript.ShowMessage(this, "用户名或密码错误！");
}
else
{
if (loginUser.IsLock == 1)
{
JScript.ShowMessage(this, "对不起，您的帐号被锁定，暂时不能登陆系统后台，请联系网站管理员！");
}
else if (loginUser.IsVerify == 0)
{
JScript.ShowMessage(this, "对不起，您的帐号还未通过审核，暂时不能登陆系统后台，请联系网站管理员！");
}
else
{
Session["LoginUser"] = loginUser;
string returnUrl = Utils.GetQueryString("url");
if (returnUrl == "")
{
returnUrl = "/admin/index.aspx";
}
JScript.ShowAndRedirect(this, "登陆成功，正在转向管理后台！", returnUrl);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
UpdateTempSub(this.dgViewSub1);
string[] Commands = new string[3];
DataParameter[] para;
if (strID == "") //新增
{
int Count = bll.GetRowCount("WMS_BillMaster", string.Format("BillID='{0}'", this.txtID.Text.Trim()));
if (Count > 0)
{
JScript.ShowMessage(this.updatePanel1, "该入库单已经存在！");
return;
}
para = new DataParameter[] {
new DataParameter("@BillID", this.txtID.Text.Trim()),
new DataParameter("@BillDate", this.txtBillDate.DateValue),
new DataParameter("@BillTypeCode", this.ddlBillTypeCode.SelectedValue),
new DataParameter("@AreaCode", ""),
new DataParameter("@FactoryID", this.ddlFactoryID.SelectedValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@BatchNo", this.txtBatchNo.Text.Trim()),
new DataParameter("@SourceBillNo", this.txtSourceBillNo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString())
};
Commands[0] = "WMS.InsertInStockBill";
}
else //修改
{
para = new DataParameter[] {
new DataParameter("@BillDate", this.txtBillDate.DateValue),
new DataParameter("@BillTypeCode", this.ddlBillTypeCode.SelectedValue),
new DataParameter("@AreaCode", ""),
new DataParameter("@FactoryID", this.ddlFactoryID.SelectedValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@BatchNo", this.txtBatchNo.Text.Trim()),
new DataParameter("@SourceBillNo", this.txtSourceBillNo.Text.Trim()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim()))
};
Commands[0] = "WMS.UpdateInStock";
}
try
{
DataTable dt = (DataTable)ViewState[FormID + "_Edit_dgViewSub1"];
Commands[1] = "WMS.DeleteBillDetail";
Commands[2] = "WMS.InsertInStockDetail";
bll.ExecTran(Commands, para, "BillID", new DataTable[] { dt });
}
catch (Exception ex)
{
JScript.ShowMessage(this.updatePanel1, ex.Message);
return;
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
protected void btnCheck_Click(object sender, EventArgs e)
{
List <string> Comd = new List <string>();
Comd.Insert(0, "WMS.UpdateMoveCellLock");
Comd.Insert(1, "WMS.UpdateCellLock");
Comd.Insert(2, "WMS.UpdateCheckBillMaster");
List <DataParameter[]> paras = new List <DataParameter[]>();
if (this.btnCheck.Text == "审核")
{
DataTable dtSub = (DataTable)ViewState[FormID + "_View_dgViewSub1"];
for (int i = 0; i < dtSub.Rows.Count; i++)
{
int count = 0;
count = bll.GetRowCount("Cmd_Cell", string.Format("CellCode='{0}' and (IsLock=1 or ProductCode!='{1}')", dtSub.Rows[i]["CellCode"], dtSub.Rows[i]["ProductCode"]));
if (count > 0)
{
JScript.ShowMessage(this.updatePanel, "货位 " + dtSub.Rows[i]["CellCode"].ToString() + "已经被其它单据锁定，不能移库！");
return;
}
count = bll.GetRowCount("Cmd_Cell", string.Format("CellCode='{0}' and (IsLock=1 or IsActive=0)", dtSub.Rows[i]["NewCellCode"]));
if (count > 0)
{
JScript.ShowMessage(this.updatePanel, "货位 " + dtSub.Rows[i]["NewCellCode"].ToString() + "已经被其它单据锁定，不能移库！");
return;
}
}
paras.Insert(0, new DataParameter[] { new DataParameter("@Lock", 1), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(1, new DataParameter[] { new DataParameter("@Lock", 1), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(2, new DataParameter[] { new DataParameter("@Checker", Session["EmployeeCode"].ToString()), new DataParameter("{0}", "getdate()"),
new DataParameter("@State", 1), new DataParameter("@BillID", this.txtID.Text) });
}
else
{
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State > 1)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + " 单号已经作业，不能进行反审。");
return;
}
paras.Insert(0, new DataParameter[] { new DataParameter("@Lock", 0), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(1, new DataParameter[] { new DataParameter("@Lock", 0), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(2, new DataParameter[] { new DataParameter("@Checker", ""), new DataParameter("{0}", "null"),
new DataParameter("@State", 0), new DataParameter("@BillID", this.txtID.Text) });
}
bll.ExecTran(Comd.ToArray(), paras);
AddOperateLog("移库单 ", btnCheck.Text + " " + txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
private void CheckUser()
{
if (txt_UserName.Text != "linpanxing" && txt_UserName.Text != "luwenhao")
{
JScript.ShowMessage(this, "用户名或密码错误！");
return;
}
else
{
Session["User"] = txt_UserName.Text == "linpanxing" ? 1 : 2;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strColorCode = "'-1',";
BLL.BLLBase bll = new BLL.BLLBase();
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect"));
if (cb != null && cb.Checked)
{
string hk = this.GridView1.Rows[i].Cells[1].Text;
//判断能否删除
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", hk)));
if (State == 0)
{
JScript.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号还未审核不能作业，请审核后，再进行入库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
if (State > 1)
{
JScript.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号已经作业，不能再进行入库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
strColorCode += "'" + hk + "',";
}
}
strColorCode += "'-1'";
if (strColorCode.Replace("'-1','-1'", "").Trim().Length == 0)
{
JScript.ShowMessage(this.UpdatePanel1, "请选择单据！");
SetGridViewEmptyRow(GridView1, (DataTable)ViewState[FormID + "_MainFormData"]);
BindDataSub(this.hdnRowValue.Value);
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpInstockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("入库单", "入库作业单号：" + strColorCode.Replace("'-1',", "").Replace(",'-1'", ""));
DataTable dt = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
SetBindDataSub(dt);
}
catch (Exception ex)
{
BindDataSub(this.hdnRowValue.Value);
JScript.ShowMessage(this.UpdatePanel1, ex.Message);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
ViewState["filter"] = " Flag=6 " + " and " + string.Format("{0} like '%{1}%'", this.ddlField.SelectedValue, this.txtSearch.Text.Trim().Replace("'", ""));
ViewState["CurrentPage"] = 1;
SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
}
protected void btn_AddSite_Click(object sender, EventArgs e)
{
if (Session["User"] == null)
{
if (txt_UserName.Text == "")
{
JScript.ShowMessage(this, "请先登陆！");
return;
}
else
{
CheckUser();
}
}
TuanSite model = new TuanSite();
model.UserID = TryConvert.ToInt32(Session["User"]);
model.CityID = Utils.GetFormInt("ddl_City");
model.SiteName = txt_SiteName.Value;
model.SiteUrl = txt_SiteUrl.Value;
if (model.SiteUrl.EndsWith("/"))
{
model.SiteUrl = model.SiteUrl.TrimEnd('/');
}
model.LogoUrl = txt_LogoUrl.Value;
model.ApiUrl = txt_ApiUrl.Value;
model.QQ = txt_QQ.Value;
model.SiteType = rdb_SiteType_1.Checked == true ? (byte)1 : (byte)0;
model.Rank = TryConvert.ToByte(txt_Rank.Value);
model.Trust = TryConvert.ToByte(txt_Trust.Value);
model.Description = string.Empty;
model.Master = string.Empty;
model.ContactPerson = string.Empty;
model.Phone = string.Empty;
model.Email = string.Empty;
model.OpenDate = DateTime.Now;
model.AddDate = DateTime.Now;
model.IsVerify = (byte)1;
int ret = TuanSiteDAO.Instance.Add(model);
if (ret > 0)
{
JScript.ShowMessage(this, "添加成功！");
}
else
{
JScript.ShowMessage(this, "添加失败！");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.txtShelfID.Text.Trim().Length == 0)
{
int count = bll.GetRowCount("CMD_WH_SHELF", string.Format("ShelfCode='{0}'", this.txtShelfCode.Text));
if (count > 0)
{
JScript.ShowMessage(this, "此货架编码已存在，不能新增！");
return;
}
bll.ExecNonQuery("Cmd.InsertShelf", new DataParameter[] {
new DataParameter("@WarehouseCode", this.txtWHID.Text),
new DataParameter("@AreaCode", this.txtAreaID.Text.Trim()),
new DataParameter("@ShelfCode", this.txtShelfCode.Text),
new DataParameter("@ShelfName", this.txtShelfName.Text.Trim()),
new DataParameter("@Rows", this.txtCellRows.Text),
new DataParameter("@Columns", this.txtCellCols.Text.Trim()),
new DataParameter("@IsActive", this.ddlActive.SelectedValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim())
});
//this.btnContinue.Enabled = true;
//this.btnSave.Enabled = false;
JScript.RegisterScript(this, "ReloadParent();");
Common.AddOperateLog(Session["G_user"].ToString(), "货贺管理", "添加货贺信息");
}
else
{
bll.ExecNonQuery("Cmd.UpdateShelf", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWHID.Text),
new DataParameter("@AreaCode", this.txtAreaID.Text.Trim()),
new DataParameter("@ShelfName", this.txtShelfName.Text.Trim()),
new DataParameter("@Rows", this.txtCellRows.Text),
new DataParameter("@Columns", this.txtCellCols.Text.Trim()),
new DataParameter("@IsActive", this.ddlActive.SelectedValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@ShelfCode", this.txtShelfCode.Text),
new DataParameter("{0}", this.txtShelfID.Text) });
JScript.RegisterScript(this, "UpdateParent();");
Common.AddOperateLog(Session["G_user"].ToString(), "货贺管理", "修改货贺信息");
}
}
catch (Exception exp)
{
JScript.ShowMessage(this, exp.Message);
}
//JScript.RegisterScript(this, "window.close();");
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
try
{
bll.ExecNonQuery("Security.DeleteAllOperatorLog", null);
AddOperateLog("操作日志管理", "清空操作日志");
dtLog = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
}
catch (Exception exp)
{
JScript.ShowMessage(this.UpdatePanel1, exp.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
if (txt_UserName.Text == "")
{
JScript.ShowMessage(this, "请先登陆！");
}
else
{
CheckUser();
}
}
}