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