/// <summary>
/// 字典管理 详情查询
/// </summary>
public object Get(int id)
{
base_dics info = dicsBLL.GetInfo(id, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 字典管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_dics info)
{
info.dicid = id;
bool success = dicsBLL.Update(info, out errmsg);
WriteSysLog(1, string.Format("更新字典管理 id为 {0},返回{1} {2}", id, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
BaseBLL.FreelyListCache.CacheRemove("Cache_DicsList");
return(new { Rcode = 1, Rmsg = "更新成功" });
}
/// <summary>
/// 字典管理 添加数据
/// </summary>
/// <param name="base_dics">要添加的字典管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_dics info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("dicname", info.dicname));
pars.Add(new DataParameter("dicvalue", info.dicvalue));
pars.Add(new DataParameter("dictype", info.dictype));
pars.Add(new DataParameter("dictypename", info.dictypename));
pars.Add(new DataParameter("isdictype", info.isdictype));
pars.Add(new DataParameter("icon", info.icon));
pars.Add(new DataParameter("tag", info.tag));
pars.Add(new DataParameter("remarks", info.remarks));
pars.Add(new DataParameter("sorts", info.sorts));
string sqlstr = "insert into base_dics (dicname,dicvalue,dictype,dictypename,isdictype,icon,tag,remarks,sorts) values (@dicname,@dicvalue,@dictype,@dictypename,@isdictype,@icon,@tag,@remarks,@sorts) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 字典管理 更新数据
/// </summary>
/// <param name="base_dics">要更新的字典管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_dics info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("dicname", info.dicname));
pars.Add(new DataParameter("dicvalue", info.dicvalue));
pars.Add(new DataParameter("dictype", info.dictype));
pars.Add(new DataParameter("dictypename", info.dictypename));
pars.Add(new DataParameter("isdictype", info.isdictype));
pars.Add(new DataParameter("icon", info.icon));
pars.Add(new DataParameter("tag", info.tag));
pars.Add(new DataParameter("remarks", info.remarks));
pars.Add(new DataParameter("sorts", info.sorts));
string sqlstr = "update base_dics set dicname=@dicname,dicvalue=@dicvalue,dictype=@dictype,dictypename=@dictypename,isdictype=@isdictype,icon=@icon,tag=@tag,remarks=@remarks,sorts=@sorts where dicid=@dicid ";
pars.Add(new DataParameter("dicid", info.dicid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 字典管理 添加数据
/// </summary>
public object Post([FromBody] base_dics info)
{
bool success = false;
if (string.IsNullOrEmpty(info.dicname))
{
info.isdictype = 1;
success = dicsBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加字典类型{0},返回{1} {2}", info.dictypename, success, errmsg));
}
else
{
info.isdictype = 0;
success = dicsBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加字典{0},返回{1} {2}", info.dicname, success, errmsg));
}
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
BaseBLL.FreelyListCache.CacheRemove("Cache_DicsList");
return(new { Rcode = 1, Rmsg = "添加成功" });
}
public object Get(string codes, string type, string flig, string dicsid, string dictype)
{
string andsql = "";
if (!string.IsNullOrEmpty(type))
{
if (type == "dicvalue" || type == "dicname")
{
andsql += " and dictype='" + dictype + "'";
}
base_dics success = dicsBLL.GetInfoVerify(codes, type, andsql, out errmsg);
if (string.Equals("编辑字典", flig))
{
if (success != null)
{
return(new { valid = (string.Equals(success.dicid.ToString(), dicsid)) ? true : false });
}
return(new { valid = true });
}
return(new { valid = (success == null) ? true : false });
}
return(new { valid = false });
}
/// <summary>
/// 字典管理 更新数据
/// </summary>
/// <param name="base_dics">要更新的字典管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_dics info, out string errmsg)
{
return(dicsDAL.Update(info, out errmsg));
}
/// <summary>
/// 字典管理 添加数据
/// </summary>
/// <param name="base_dics">要添加的字典管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_dics info, out string errmsg)
{
return(dicsDAL.Add(info, out errmsg));
}
/// <summary>
/// 字典管理 详情查询
/// </summary>
public static base_dics GetInfo(int dicid, out string errmsg)
{
base_dics info = dicsDAL.GetInfo(dicid, out errmsg);
return(info);
}
