/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateDict(DictInfo info) { if (info == null) return false; if (info.Code == "") return false; return _dao.CreateDict(info); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDict(DictInfo info) { if (info == null) { return(false); } if (info.Code == "") { return(false); } return(_dao.ModifyDict(info)); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateDict(DictInfo info) { if (info == null) { return(false); } if (info.Code == "") { return(false); } return(_dao.CreateDict(info)); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDict(DictInfo info) { StringBuilder sql = new StringBuilder(); sql.Append("Update dictinfo "); sql.Append(" Set Name = '" + info.Name + "',"); sql.Append(" Type = '" + info.TypeCode + "',"); sql.Append(" remark = '" + info.Remark + "',"); sql.Append(" Sort = '" + info.Sort + "',"); sql.Append(" isenable = '" + info.IsEnable + "'"); sql.Append(" Where code = '" + info.Code + "' and Type='" + info.TypeCode + "'"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="Code"></param> /// <returns></returns> public DictInfo GetDictInfo(string Code, string Type) { DictInfo info = null; string sql = _SelectSql + string.Format(" where code='{0}' and Type='{1}'", Code, Type); using (DbDataReader reader = DataBaseManage.ExecuteReader(sql)) { if (reader.Read()) { info = BuilderEntity(reader); } } return(info); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictInfo BuilderEntity(DbDataReader reader) { DictInfo info = new DictInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); info.Sort = (reader.IsDBNull(reader.GetOrdinal("sort"))) ? 0 : decimal.Parse(reader["sort"].ToString()); info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString(); info.TypeCode = (reader.IsDBNull(reader.GetOrdinal("type"))) ? "" : reader["type"].ToString(); info.TypeName = (reader.IsDBNull(reader.GetOrdinal("typename"))) ? "" : reader["typename"].ToString(); return(info); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateDict(DictInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into dictinfo "); sql.Append(" (code, Name, Type, remark, Sort, isenable) "); sql.Append(" Values "); sql.Append(" ( "); sql.Append(" '" + info.Code + "',"); sql.Append(" '" + info.Name + "',"); sql.Append(" '" + info.TypeCode + "',"); sql.Append(" '" + info.Remark + "',"); sql.Append(" '" + info.Sort + "',"); sql.Append(" '" + info.IsEnable + "'"); sql.Append(" )"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateDict(DictInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into dictinfo "); sql.Append(" (code, Name, Type, remark, Sort, isenable) "); sql.Append(" Values "); sql.Append(" ( "); sql.Append(" '" + info.Code + "',"); sql.Append(" '" + info.Name + "',"); sql.Append(" '" + info.TypeCode + "',"); sql.Append(" '" + info.Remark + "',"); sql.Append(" '" + info.Sort + "',"); sql.Append(" '" + info.IsEnable + "'"); sql.Append(" )"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="Condition"></param> /// <returns></returns> public List <DictInfo> GetDictInfoByCondition(DictInfo Condition) { List <DictInfo> list = new List <DictInfo>(); StringBuilder Sql = new StringBuilder(); Sql.Append(_SelectSql); Sql.Append(" where 1=1 "); if (Condition != null) { if (Condition.Code.Trim() != "") { Sql.Append(" and code='" + Condition.Code.Trim() + "'"); } if (Condition.Name.Trim() != "") { Sql.Append(" and Name like '%" + Condition.Name.Trim() + "%'"); } if (Condition.TypeCode != "") { Sql.Append(" and Type = '" + Condition.TypeCode + "'"); } if (Condition.IsEnable != "") { Sql.Append(" and isenable = '" + Condition.IsEnable + "'"); } else { Sql.Append(" and isenable='Y' "); } } Sql.Append(" Order By Type,Sort "); using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql.ToString())) { if (reader != null) { while (reader.Read()) { list.Add(BuilderEntity(reader)); } } } return(list); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { DictInfo info = new DictInfo(); info.Code = this.TXT_CODE.Text.Trim(); info.Name = this.TXT_NAME.Text.Trim(); info.TypeCode = this.DDL_TYPE.SelectedValue; info.Remark = this.TXT_REMARK.Text.Trim(); info.IsEnable = this.CHB_ISENABLE.Checked ? "Y" : "N"; if (this.TXT_SORT.Text.Trim() != "") info.Sort = int.Parse(this.TXT_SORT.Text.Trim()); else info.Sort = 0; if (_Dict.ModifyDict(info)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('新增字典保存成功!');</script>"); Response.Redirect("Default.aspx"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('新增字典保存失败!');</script>"); } }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictInfo BuilderEntity(DbDataReader reader) { DictInfo info = new DictInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); info.Sort = (reader.IsDBNull(reader.GetOrdinal("sort"))) ? 0 : decimal.Parse(reader["sort"].ToString()); info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString(); info.TypeCode = (reader.IsDBNull(reader.GetOrdinal("type"))) ? "" : reader["type"].ToString(); info.TypeName = (reader.IsDBNull(reader.GetOrdinal("typename"))) ? "" : reader["typename"].ToString(); return info; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDict(DictInfo info) { StringBuilder sql = new StringBuilder(); sql.Append("Update dictinfo "); sql.Append(" Set Name = '" + info.Name + "',"); sql.Append(" Type = '" + info.TypeCode + "',"); sql.Append(" remark = '" + info.Remark + "',"); sql.Append(" Sort = '" + info.Sort + "',"); sql.Append(" isenable = '" + info.IsEnable + "'"); sql.Append(" Where code = '" + info.Code + "' and Type='" + info.TypeCode + "'"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
/// <summary> /// /// </summary> /// <param name="Condition"></param> /// <returns></returns> public List<DictInfo> GetDictInfoByCondition(DictInfo Condition) { List<DictInfo> list = new List<DictInfo>(); StringBuilder Sql = new StringBuilder(); Sql.Append(_SelectSql); Sql.Append(" where 1=1 "); if (Condition != null) { if (Condition.Code.Trim() != "") Sql.Append(" and code='" + Condition.Code.Trim() + "'"); if (Condition.Name.Trim() != "") Sql.Append(" and Name like '%" + Condition.Name.Trim() + "%'"); if (Condition.TypeCode != "") Sql.Append(" and Type = '" + Condition.TypeCode + "'"); if (Condition.IsEnable != "") Sql.Append(" and isenable = '" + Condition.IsEnable + "'"); else Sql.Append(" and isenable='Y' "); } Sql.Append(" Order By Type,Sort "); using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql.ToString())) { if (reader != null) { while (reader.Read()) { list.Add(BuilderEntity(reader)); } } } return list; }
/// <summary> /// /// </summary> /// <param name="Condition"></param> /// <returns></returns> public List <DictInfo> GetDictInfoByCondition(DictInfo Condition) { return(_dao.GetDictInfoByCondition(Condition)); }
/// <summary> /// /// </summary> private void BindGridView() { DictInfo info = new DictInfo(); info.Code = this.TXT_CODE.Text.Trim(); info.Name = this.TXT_NAME.Text.Trim(); info.TypeCode = this.DDL_TYPE.SelectedValue; info.IsEnable = this.CHB_ISENABLE.Checked ? "Y" : "N"; this.GridView1.DataSource = _Dict.GetDictInfoByCondition(info); this.GridView1.DataBind(); }
/// <summary> /// /// </summary> /// <param name="Condition"></param> /// <returns></returns> public List<DictInfo> GetDictInfoByCondition(DictInfo Condition) { return _dao.GetDictInfoByCondition(Condition); }
/// <summary> /// /// </summary> private void BindDDL() { Dict _Dict = new Dict(); DictInfo _info = new DictInfo(); _info.TypeCode = "BMLX"; this.DDL_DEPTTYPE.DataSource = _Dict.GetDictInfoByCondition(_info); this.DDL_DEPTTYPE.DataTextField = "Name"; this.DDL_DEPTTYPE.DataValueField = "Code"; this.DDL_DEPTTYPE.DataBind(); this.DDL_DEPTTYPE.Items.Insert(0, new ListItem("---请选择---", "")); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDict(DictInfo info) { if (info == null) return false; if (info.Code == "") return false; return _dao.ModifyDict(info); }