/// <summary>
/// 返回数据字典类别
/// </summary>
/// <param name="dictName"></param>
/// <returns>category_name和id</returns>
public List <sys_dict> SelectByDictName(sys_dict_type dictName)
{
try {
List <sys_dict> list = new List <sys_dict>();
string sql = "select * from sys_dict where dict_name = '";
switch (dictName)
{
case sys_dict_type.Cost:
sql += sys_dict_type.Cost.ToString() + "' ";
break;
case sys_dict_type.BelongPlace:
sql += sys_dict_type.BelongPlace.ToString() + "'";
break;
case sys_dict_type.Person:
sql += sys_dict_type.Person.ToString() + " ' ";
break;
default:
break;
}
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sys_dict dict1 = new sys_dict();
dict1.id = (int)ds.Tables[0].Rows[i][nameof(sys_dict.id)];
dict1.dict_name = (string)ds.Tables[0].Rows[i][nameof(sys_dict.dict_name)];
dict1.category_name = (string)ds.Tables[0].Rows[i][nameof(sys_dict.category_name)];
dict1.create_time = (DateTime)ds.Tables[0].Rows[i][nameof(sys_dict.create_time)];
dict1.modify_time = (DateTime)ds.Tables[0].Rows[i][nameof(sys_dict.modify_time)];
list.Add(dict1);
}
return(list);
}
catch (Exception e)
{
new LogSysDAL().Add(LogOperations.LogSys("根据数据字典查询" + e.Message));
return(null);
}
}
public static sys_dict_type Change(string type)
{
sys_dict_type res = sys_dict_type.None;
switch (type)
{
case "费用类别":
res = sys_dict_type.Cost;
break;
case "重点人员类别":
res = sys_dict_type.Person;
break;
case "归属地":
res = sys_dict_type.BelongPlace;
break;
default: break;
}
return(res);
}
/// <summary>
/// 英文转中文
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static string EToC(sys_dict_type type)
{
string res = "";
switch (type)
{
case sys_dict_type.Cost:
res = "费用类别";
break;
case sys_dict_type.Person:
res = "重点人员类别";
break;
case sys_dict_type.BelongPlace:
res = "归属地";
break;
default: break;
}
return(res);
}
/// <summary>
/// 根据数据字典名字查分类所有
/// </summary>
/// <param name="dictName"></param>
/// <returns></returns>
public List <sys_dict> SelectByDictName(sys_dict_type dictName)
{
SysSettingDAL set = new SysSettingDAL();
return(set.SelectByDictName(dictName));
}
