private void BindData() { string id = Request.QueryString["id"]; WHMatSpecBLL bll = null; WHMatSpec info = new WHMatSpec(); try { bll = BLLFactory.CreateBLL <WHMatSpecBLL>(); if (string.IsNullOrEmpty(id) == false) { info.ID = id; info = bll.Get(info); UIBindHelper.BindForm(this.Page, info); this.hiID.Value = info.ID; } else { info = new WHMatSpec(); } } catch (Exception ex) { throw ex; } }
protected void btSave_Click(object sender, EventArgs e) { WHMatSpec info = new WHMatSpec(); WHMatSpecBLL bll = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <WHMatSpecBLL>(); info.MatID = this.hiMatID.Value; if (this.hiID.Value == "") { bll.Insert(info); } else { info.ID = this.hiID.Value; bll.Update(info); } ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据货品唯一识别码获取货品信息 /// </summary> /// <param name="matIDCode">唯一识别码</param> /// <returns>货品信息</returns> public WHMat GetMatByIDCode(string matIDCode) { try { WHMat info = new WHMatDAL().GetMatByIDCode(matIDCode); if (info == null) { return(info); } //处理货品规格 List <MatUnit> matUnits = new WHMatSpecBLL().GetMayUnits(info.MatID); MatUnit find = matUnits.Find(p => p.ID == info.MatSpecID); if (find != null) { info.UnitCode = find.ID; info.OperateUnitName = find.Description; info.OperateSpecName = find.Remark; } //计算核算数量 List <WHMatSpec> matSpecList = new WHMatSpecBLL().GetList(new WHMatSpec { MatID = info.MatID }); WHMatSpec findMatSpec = matSpecList.Find(p => p.ID == info.MatSpecID); decimal mainUnitAmount = 1; while (findMatSpec != null && findMatSpec.ChangeUnit != info.UnitCode) { mainUnitAmount = mainUnitAmount * findMatSpec.Amount; findMatSpec = matSpecList.Find(p => p.ID == findMatSpec.ChangeUnit); if (findMatSpec == null) { break; } } if (findMatSpec != null && findMatSpec.ChangeUnit == info.UnitCode) { mainUnitAmount = mainUnitAmount * findMatSpec.Amount; } info.MainUnitAmount = mainUnitAmount; return(info); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取列表 /// </summary> /// <param name="condition">条件</param> /// <returns>仓库列表</returns> public List <WHMatSpec> GetList(WHMatSpec condition) { string sql = null; List <WHMatSpec> list = null; List <DataParameter> parameters = new List <DataParameter>(); sql = "SELECT * FROM T_WH_MatSpec where MatID = @MatID order by UnitName"; parameters.Add(new DataParameter("MatID", condition.MatID)); using (IDataSession session = AppDataFactory.CreateMainSession()) { list = session.GetList <WHMatSpec>(sql, parameters.ToArray()).ToList(); } return(list); }
/// <summary> /// 获取信息 /// </summary> /// <param name="">条件</param> /// <returns>*信息</returns> public WHMatSpec Get(WHMatSpec model) { try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //获取信息 model = session.Get <WHMatSpec>(model); } return(model); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name=""></param> /// <returns>更新行数</returns> public int Update(WHMatSpec model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //更新信息 count = session.Update <WHMatSpec>(model); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHMatSpec model) { StringBuilder sqlBuilder = new StringBuilder(); List <DataParameter> parameters = new List <DataParameter>(); int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { count = session.Delete <WHMatSpec>(model); } return(count); } catch (Exception ex) { throw ex; } }
private void BindData() { WHMatSpecBLL bll = null; DataPage dp = new DataPage(); WHMatSpec condition = new WHMatSpec(); string matID = Request.QueryString["matID"]; try { bll = BLLFactory.CreateBLL <WHMatSpecBLL>(); this.MatID.Value = matID; WHMat mat = BLLFactory.CreateBLL <WHMatBLL>().Get(new WHMat { ID = matID }); this.MatCode.Text = mat.MatCode; this.MatName.Text = mat.MatName; PagerHelper.InitPageControl(this.AspNetPager1, dp, true); condition.MatID = matID; dp = bll.GetList(condition, dp); List <WHMatSpec> list = dp.Result as List <WHMatSpec>; 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="condition">条件</param> /// <returns>仓库列表</returns> public DataPage GetList(WHMatSpec condition, DataPage page) { string sql = null; List <DataParameter> parameters = new List <DataParameter>(); sql = @"SELECT t1.*,t2.Description as ChangeUnitName FROM T_WH_MatSpec t1 left outer join T_WH_MatUnit t2 on t1.ChangeUnit = t2.ID where MatID = @MatID"; parameters.Add(new DataParameter("MatID", condition.MatID)); //分页关键字段及排序 page.KeyName = "ID"; if (string.IsNullOrEmpty(page.SortExpression)) { page.SortExpression = "UnitName"; } using (IDataSession session = AppDataFactory.CreateMainSession()) { page = session.GetDataPage <WHMatSpec>(sql, parameters.ToArray(), page); } return(page); }
/// <summary> /// 获取列表 /// </summary> /// <param name="condition">条件</param> /// <returns>仓库列表</returns> public DataPage GetList(WHMatSpec condition, DataPage page) { page = new WHMatSpecDAL().GetList(condition, page); List <WHMatSpec> list = page.Result as List <WHMatSpec>; //获取货品规格单位 List <WHMatSpec> matSpecList = this.GetList(new WHMatSpec { MatID = condition.MatID }); foreach (WHMatSpec item in list) { WHMatSpec find = matSpecList.Find(p => p.ID == item.ChangeUnit); if (find != null) { item.ChangeUnitName = find.UnitName; } } return(page); }
/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="info"></param> /// <returns>true:已存在;fasel:不存在。</returns> public bool Exists(WHMatSpec 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_MatSpec"); whereBuilder.Append(" AND ID <> @ID "); parameters.Add(new DataParameter { ParameterName = "ID", DataType = DbType.String, Value = model.ID }); if (!string.IsNullOrEmpty(model.Description)) { whereBuilder.Append(" AND UnitName = @UnitName "); parameters.Add(new DataParameter { ParameterName = "UnitName", DataType = DbType.String, Value = model.UnitName }); } if (whereBuilder.Length > 0) { sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4)); } using (IDataSession session = AppDataFactory.CreateMainSession()) { string sql = this.ChangeSqlByDB(sqlBuilder.ToString(), session); count = Convert.ToInt32(session.ExecuteSqlScalar(sql, parameters.ToArray())); } return(count > 0); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public int Insert(WHMatSpec model) { model.ID = Guid.NewGuid().ToString(); return(new WHMatSpecDAL().Insert(model)); }
/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="info"></param> /// <returns>true:已存在;fasel:不存在。</returns> public bool Exists(WHMatSpec model) { return(new WHMatSpecDAL().Exists(model)); }
/// <summary> /// 更新信息 /// </summary> /// <param name=""></param> /// <returns>更新行数</returns> public int Update(WHMatSpec model) { return(new WHMatSpecDAL().Update(model)); }
/// <summary> /// 删除 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHMatSpec model) { return(new WHMatSpecDAL().Delete(model)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="condition">条件</param> /// <returns>仓库列表</returns> public List <WHMatSpec> GetList(WHMatSpec condition) { return(new WHMatSpecDAL().GetList(condition)); }
/// <summary> /// 获取信息 /// </summary> /// <param name="">条件</param> /// <returns>*信息</returns> public WHMatSpec Get(WHMatSpec model) { return(new WHMatSpecDAL().Get(model)); }