/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="info"></param> /// <returns>true:已存在;fasel:不存在。</returns> public bool ExistsWHSite(WHSite model) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); List <DataParameter> parameters = new List <DataParameter>(); int count = 0; try { sqlBuilder.Append("SELECT COUNT(0) FROM T_WH_Site"); sqlBuilder.Append(" WHERE ID <> @ID AND WHID = @WHID AND (Code = @Code or Description = @Description)"); parameters.Add(new DataParameter { ParameterName = "ID", DataType = DbType.String, Value = model.ID }); parameters.Add(new DataParameter { ParameterName = "WHID", DataType = DbType.String, Value = model.WHID }); parameters.Add(new DataParameter { ParameterName = "Code", DataType = DbType.String, Value = model.Code }); parameters.Add(new DataParameter { ParameterName = "Description", DataType = DbType.String, Value = model.Description }); using (IDataSession session = AppDataFactory.CreateMainSession()) { count = Convert.ToInt32(session.ExecuteSqlScalar(sqlBuilder.ToString(), parameters.ToArray())); } return(count > 0); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public DataPage GetList(WHSite condition, DataPage page) { string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { sql = this.GetQuerySql(condition, ref parameters); //分页关键字段及排序 page.KeyName = "ID"; if (string.IsNullOrEmpty(page.SortExpression)) { page.SortExpression = "UPDATETIME DESC"; } using (IDataSession session = AppDataFactory.CreateMainSession()) { page = session.GetDataPage <WHSite>(sql, parameters.ToArray(), page); } return(page); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public DataResult <int> Insert(WHSite model) { DataResult <int> result = new DataResult <int>(); try { //基本信息 model.ID = Guid.NewGuid().ToString(); model.CREATEUSER = this.LoginUser.UserID; model.CREATETIME = DateTime.Now; model.UPDATEUSER = model.CREATEUSER; model.UPDATETIME = model.CREATETIME; if (ExistsWHSite(model)) { result.Msg = "编号或名称已存在"; result.Result = -1; return(result); } result.Result = new WHSiteDAL().Insert(model); result.IsSuccess = true; return(result); } catch (Exception ex) { throw ex; } }
private void BindData() { WHSiteBLL bll = null; DataPage dp = new DataPage(); WHSite condition = new WHSite(); string whID = Request.QueryString["whID"]; try { bll = BLLFactory.CreateBLL <WHSiteBLL>(); this.hiWHID.Value = whID; condition.Code = this.Code.Text.Trim(); condition.WHID = whID; condition.Description = this.Description.Text.Trim(); PagerHelper.InitPageControl(this.AspNetPager1, dp, true); dp = bll.GetList(condition, dp); List <WHSite> list = dp.Result as List <WHSite>; this.GvList.DataSource = list; this.GvList.DataBind(); for (int i = 0; i < this.GvList.Rows.Count; i++) { string click = string.Format("return edit('{0}');", this.GvList.DataKeys[i]["ID"].ToString()); (this.GvList.Rows[i].Cells[6].Controls[0] as WebControl).Attributes.Add("onclick", click); } PagerHelper.SetPageControl(AspNetPager1, dp, true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取信息 /// </summary> /// <param name="">条件</param> /// <returns>信息</returns> public WHSite Get(WHSite model) { try { return(new WHSiteDAL().Get(model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取导出的数据 /// </summary> /// <param name="">查询条件</param> /// <returns>数据</returns> public DataTable GetExportData(WHSite model) { try { return(new WHSiteDAL().GetExportData(model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name="">信息</param> /// <returns>删除个数</returns> public int Delete(WHSite model) { try { return(new WHSiteDAL().Delete(model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public DataPage GetList(WHSite condition, DataPage page) { try { return(new WHSiteDAL().GetList(condition, page)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="">信息</param> /// <returns>true:已存在;fasel:不存在。</returns> public bool ExistsWHSite(WHSite model) { try { return(new WHSiteDAL().ExistsWHSite(model)); } catch (Exception ex) { throw ex; } }
protected void btDelete_Click(object sender, EventArgs e) { ArrayList pkArray = null; WHSiteBLL bll = null; List <string> msgList = new List <string>(); try { bll = BLLFactory.CreateBLL <WHSiteBLL>(); pkArray = GvHelper.GetPKValueByChk(this.GvList, 0, "cbxSelect", 0); for (int i = 0; i < this.GvList.Rows.Count; i++) { CheckBox cbxSelect = this.GvList.Rows[i].Cells[0].FindControl("cbxSelect") as CheckBox; if (cbxSelect.Checked == false) { continue; } WHSite site = new WHSite(); site.ID = this.GvList.DataKeys[i]["ID"].ToString(); site.Description = this.GvList.Rows[i].Cells[1].Text; //判断是否已使用 bool r = bll.IsUse(site); if (r == true) { msgList.Add(site.Description); continue; } //删除 bll.Delete(site); } string msg = string.Join(",", msgList.ToArray()); if (msg != "") { ClientScript.RegisterStartupScript(this.GetType(), "myjs", "MSI('提示','" + msg + "仓位已使用,无法删除');", true); } this.BindData(); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取信息 /// </summary> /// <param name="">条件</param> /// <returns>*信息</returns> public WHSite Get(WHSite model) { try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //获取信息 model = session.Get <WHSite>(model); } return(model); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHSite model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除基本信息 count = session.Delete <WHSite>(model); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取查询语句 /// </summary> /// <param name="user">查询条件</param> /// <param name="parameters">参数</param> /// <returns>查询语句</returns> private string GetQuerySql(WHSite condition, ref List <DataParameter> parameters) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); try { //构成查询语句 sqlBuilder.Append(@"SELECT t1.ID,t1.Code,t1.Description,t1.WHID,t2.Description as WarehourseName ,t1.Place,t1.Remark,t1.CREATEUSER,t1.CREATETIME,t1.UPDATEUSER,t1.UPDATETIME,area.Description as AreaName FROM T_WH_Site t1 Inner join T_WH_Warehouse t2 on t1.WHID=t2.ID left outer join T_WH_AREA area on t1.AreaID = area.ID"); if (string.IsNullOrEmpty(condition.WHID) == false) { whereBuilder.Append(" AND t1.WHID = @WHID"); parameters.Add(new DataParameter("WHID", condition.WHID)); } if (string.IsNullOrEmpty(condition.Code) == false) { whereBuilder.Append(" AND t1.Code like @Code"); parameters.Add(new DataParameter("Code", "%" + condition.Code + "%")); } if (string.IsNullOrEmpty(condition.Description) == false) { whereBuilder.Append(" AND t1.Description like @Description"); parameters.Add(new DataParameter("Description", "%" + condition.Description + "%")); } //查询条件 if (whereBuilder.Length > 0) { sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4)); } return(sqlBuilder.ToString()); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断是否被使用 /// </summary> /// <param name="info">仓位</param> /// <returns>true:已使用;false:未使用</returns> public bool IsUse(WHSite info) { int count = 0; string sql = null; sql = "select count(ID) from T_WH_MatAmount where SaveSite = @SaveSite"; using (IDataSession session = AppDataFactory.CreateMainSession()) { count = int.Parse(session.ExecuteSqlScalar(sql, new DataParameter("SaveSite", info.ID)).ToString()); } if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新信息 /// </summary> /// <param name="">信息</param> /// <returns>更新行数</returns> public DataResult <int> Update(WHSite model) { DataResult <int> result = new DataResult <int>(); try { if (ExistsWHSite(model)) { result.Msg = "编号或名称已存在"; result.Result = -1; return(result); } model.UPDATEUSER = this.LoginUser.UserID; result.Result = new WHSiteDAL().Update(model); result.IsSuccess = true; return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取导出的数据 /// </summary> /// <param name="user">查询条件</param> /// <returns>数据</returns> public DataTable GetExportData(WHSite model) { DataTable dt = null; string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { //构成查询语句 sql = this.GetQuerySql(model, ref parameters); using (IDataSession session = AppDataFactory.CreateMainSession()) { dt = session.GetTable(sql, parameters.ToArray()); dt.TableName = "WHSite"; } return(dt); } catch (Exception ex) { throw ex; } }
protected void btSave_Click(object sender, EventArgs e) { WHSite info = new WHSite(); WHSiteBLL bll = null; DataResult <int> result = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <WHSiteBLL>(); info.WHID = this.Warehouse.SelectedValue; if (this.hiID.Value == "") { result = bll.Insert(info); } else { info.CREATEUSER = this.HiCREATEUSER.Value; info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value); info.ID = this.hiID.Value; result = bll.Update(info); } if (string.IsNullOrEmpty(result.Msg) == false) { ClientScript.RegisterStartupScript(this.GetType(), "myjs", "MSI('提示','" + result.Msg + "')", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } } catch (Exception ex) { throw ex; } }
private void BindData() { string id = Request.QueryString["id"]; WHSiteBLL bll = null; WHSite info = new WHSite(); string whID = Request.QueryString["whID"]; try { if (string.IsNullOrEmpty(whID) == false) { this.Warehouse.Enabled = false; } else { this.Warehouse.Enabled = true; } bll = BLLFactory.CreateBLL <WHSiteBLL>(); if (string.IsNullOrEmpty(id) == false) { info.ID = id; info = bll.Get(info); UIBindHelper.BindForm(this.Page, info); this.Warehouse.SelectedValue = info.WHID; this.hiID.Value = info.ID; this.HiCREATEUSER.Value = info.CREATEUSER; this.HiCREATETIME.Value = info.CREATETIME.ToString(); this.Warehouse.Enabled = false; } else { info = new WHSite(); if (string.IsNullOrEmpty(whID) == false) { this.Warehouse.SelectedValue = whID; } } List <DictInfo> dicts = null; //绑定区域 if (string.IsNullOrEmpty(this.Warehouse.SelectedValue) == false) { List <WHArea> whList = BLLFactory.CreateBLL <WHAreaBLL>().GetList(this.Warehouse.SelectedValue); dicts = whList.Select(p => new DictInfo { ID = p.ID, Des = p.Description }).ToList <DictInfo>(); Tools.BindDataToDDL(this.AreaID, dicts, null); if (string.IsNullOrEmpty(info.AreaID) == false) { this.AreaID.SelectedValue = info.AreaID; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断是否被使用 /// </summary> /// <param name="info">仓位</param> /// <returns>true:已使用;false:未使用</returns> public bool IsUse(WHSite info) { return(new WHSiteDAL().IsUse(info)); }