//查询 protected void Select(object sender, EventArgs e) { string frame_name = Frame_name1.Value.Trim(); string enabled = Enabled1.Value.Trim(); if (enabled.Equals("ALL")) { enabled = ""; } string region_name = DropDownList2.SelectedValue; if (region_name == "ALL") { region_name = ""; } string create_by = Create_by1.Value; string update_by = Update_by1.Value; FrameDC frameDc = new FrameDC(); try { DataSet ds = frameDc.searchRegionByFourParameters(create_by, frame_name, update_by, enabled, region_name); Line_Repeater.DataSource = ds; Line_Repeater.DataBind(); } catch (Exception ex) { PageUtil.showToast(this, "无相关数据!"); return; } }
//更新料架信息 protected void Update(object sender, EventArgs e) { if (Session["LoginName"] == null) { PageUtil.showToast(this, "请登录用户!"); ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>setTimeout(function(){window.location.href='Login.aspx'},1000)</script>"); return; } List <ModelFrame> list = new List <ModelFrame>(); FrameDC frameDc = new FrameDC(); string frame_key = Frame_key2.Value; string frame_name = Frame_name2.Value; if (string.IsNullOrWhiteSpace(frame_name)) { PageUtil.showToast(this, "料架名不允许为空!"); return; } if (frame_name.Length > 100) { PageUtil.showToast(this, "料架名输入长度超出范围!"); return; } string enabled = Enabled2.Value.Trim(); string region_name = Region_key2.SelectedValue; string update_by = Session["LoginName"].ToString(); string description = Description2.Value; if (description.Length > 50) { PageUtil.showToast(this, "描述输入长度超出范围!"); return; } DataSet ds = frameDc.searchRegionByFourParameters("", frame_name, "", "", ""); if (ds != null && ds.Tables[0].Rows.Count > 0 && !ds.Tables[0].Rows[0]["frame_key"].ToString().Equals(frame_key)) { PageUtil.showToast(this, "更新失败,料架已存在!"); return; } if (frameDc.updateSubinventory(frame_key, frame_name, update_by, enabled, description, region_name)) { Select(sender, e); PageUtil.showToast(this, "成功更新料架信息!"); } else { PageUtil.showToast(this, "更新料架信息失败!"); } }
//添加料架 protected void Insert(object sender, EventArgs e) { List <ModelFrame> list = new List <ModelFrame>(); FrameDC frameDc = new FrameDC(); if (Session["LoginName"] == null) { PageUtil.showToast(this, "请登录用户!"); ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>setTimeout(function(){window.location.href='Login.aspx'},1000)</script>"); return; } string create_by = Session["LoginName"].ToString(); string frame_name = Frame_name.Value; if (string.IsNullOrWhiteSpace(frame_name)) { PageUtil.showToast(this, "料架名不允许为空!"); return; } if (frame_name.Length > 100) { PageUtil.showToast(this, "料架名输入长度超出范围!"); return; } DataSet ds = frameDc.searchRegionByFourParameters("", frame_name, "", "", ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { PageUtil.showToast(this, "该料架名已存在!"); return; } string enabled = Enabled.Value; string region_key = Region_key.SelectedValue; if (region_key == "--------select--------") { PageUtil.showToast(this, "请选择区域!"); return; } string description = Description.Value; if (description.Length > 50) { PageUtil.showToast(this, "描述输入长度超出范围!"); Description.Value = ""; return; } if (frameDc.insertFrame(frame_name, enabled, description, create_by, region_key)) { Select(sender, e); PageUtil.showToast(this, "成功插入料架信息!"); Frame_name.Value = null; Enabled.Value = null; Region_key.SelectedIndex = 0; Description.Value = null; } else { PageUtil.showToast(this, "添加料架信息失败!"); } }