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(); } } }