public string AddSysDics(SYS_DICSMODEL entity)
{
UserBll.Instance.CheckUserOnlingState();
//var rpm = GetRpm(context);
//var dc = new SysDics
//{
// FClassCode = rpm.Request("code"),
// FClassName = rpm.Request("title"),
// //Sortnum = PublicMethod.GetInt(rpm.Request("sortnum")),
// FRemark = rpm.Request("remark")
//};
string result = SYS_DICSBLL.Instance.Add(entity.FCLASSCODE, entity.FCLASSNAME, entity.FSYSDEFAULT, SysVisitor.Instance.UserId, entity.FREMARK);
if (result.IsGuid())
{
return(new JsonMessage {
Success = true, Data = result, Message = "保存数据字典完成！"
}.ToString());
}
else
{
return(new JsonMessage {
Success = false, Data = result, Message = result
}.ToString());
}
}
public string EditSysDics(SYS_DICSMODEL entity)
{
UserBll.Instance.CheckUserOnlingState();
entity.FUPDATERID = SysVisitor.Instance.UserId;
string result = SYS_DICSBLL.Instance.Update(entity);
if (result.IsNullOrEmpty())
{
return(new JsonMessage {
Success = true, Data = result, Message = "修改数据字典完成！"
}.ToString());
}
else
{
return(new JsonMessage {
Success = false, Data = result, Message = result
}.ToString());
}
//var msg = "修改成功。";
//if (!string.IsNullOrEmpty(result))
// msg = result;
//return new JsonMessage { Success = string.IsNullOrEmpty(result), Data = result, Message = msg }.ToString();
}
public IEnumerable <SYS_SUBDICSMODEL> GetByCode(string code)
{
SYS_DICSMODEL parent = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = code }).FirstOrDefault();
if (parent != null)
{
return(SYS_SUBDICSDAL.Instance.GetWhere(new { FCLASSID = parent.FID }).OrderBy(m => m.FNAME));
}
return(null);
}
public IEnumerable <SYS_SUBDICSMODEL> GetByCode(Constant.SysDics code)
{
SYS_DICSMODEL parent = SYS_DICSBLL.Instance.GetByCode(code);
if (parent != null)
{
return(SYS_SUBDICSDAL.Instance.GetWhere(new { FCLASSID = parent.FID }));
}
return(null);
}
public List <SYS_SUBDICSMODEL> GetDics_Area(string categorycode, string keyword, bool all = false)
{
try
{
List <SYS_SUBDICSMODEL> datas = new List <SYS_SUBDICSMODEL>();
SYS_DICSMODEL parent = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = categorycode }).FirstOrDefault();
if (parent != null)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT * from SYS_SUBDICS where fclassid='" + parent.FID + "'");
sql.AppendLine(" and fid in(select fclassarea2 from v_icpr_icpo_icseout_thd where (leftsl>0 or leftsl is null) and autoid is not null and fdesbillno is not null)");
LogHelper.WriteLog(sql.ToStr());
var list = SYS_SUBDICSDAL.Instance.Query(sql.ToString()).OrderBy(m => m.FNAME).ToList();
LogHelper.WriteLog(sql.ToStr());
if (!string.IsNullOrEmpty(keyword))
{
foreach (var item in list)
{
if (string.IsNullOrEmpty(keyword) || item.FNAME.Contains(keyword))
{
datas.Add(item);
}
}
list = datas;
}
if (all)
{
list.Insert(0, new SYS_SUBDICSMODEL()
{
FNAME = "全部", FID = ""
});
}
return(list);
}
return(null);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
///// <summary>
///// 新增
///// </summary>
///// <param name="entity"></param>
///// <returns></returns>
//public string Add(SYS_DICSMODEL entity)
//{
// if (Sys_DicsDal.Instance.CountWhere(new { FCLASSCODE = entity.FCLASSCODE }) > 0)
// {
// return "编码重复，请检查！";
// }
// return Sys_DicsDal.Instance.Insert(entity).IsGuid() ? "保存失败！" : null;
//}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public string Add(string classCode, string name, int sysDefault, string creatorID, string remark)
{
if (SYS_DICSDAL.Instance.CountWhere(new { FCLASSCODE = classCode }) > 0)
{
return("编码重复，请检查！");
}
SYS_DICSMODEL entity = new SYS_DICSMODEL()
{
FCLASSCODE = classCode,
FCLASSNAME = name,
FSYSDEFAULT = sysDefault,
FCREATORID = creatorID,
FREMARK = remark,
FCREATETIME = DateTime.Now,
};
return(SYS_DICSDAL.Instance.Insert(entity));
}
/// <summary>
/// 获取指定数据字典的列表数据
/// </summary>
/// <param name="categorycode"></param>
/// <returns></returns>
/// <returns></returns>
public List <SYS_SUBDICSMODEL> GetDics(string categorycode, string keyword, bool all = false)
{
try
{
List <SYS_SUBDICSMODEL> datas = new List <SYS_SUBDICSMODEL>();
SYS_DICSMODEL parent = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = categorycode }).FirstOrDefault();
if (parent != null)
{
var list = SYS_SUBDICSDAL.Instance.GetWhere(new { FCLASSID = parent.FID }).OrderBy(m => m.FNAME).ToList();
if (!string.IsNullOrEmpty(keyword))
{
foreach (var item in list)
{
if (string.IsNullOrEmpty(keyword) || item.FNAME.Contains(keyword))
{
datas.Add(item);
}
}
list = datas;
}
if (all)
{
list.Insert(0, new SYS_SUBDICSMODEL()
{
FNAME = "全部", FID = ""
});
}
return(list);
}
return(null);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public string Update(SYS_DICSMODEL entity)
{
SYS_DICSMODEL model = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = entity.FCLASSCODE }).FirstOrDefault();
if (model != null && model.FID != entity.FID)
{
return("编码重复，请检查！");
}
return(SYS_DICSDAL.Instance.UpdateWhatWhere(new
{
FCLASSNAME = entity.FCLASSNAME,
FCLASSCODE = entity.FCLASSCODE,
FUPDATETIME = DateTime.Now,
FUPDATERID = entity.FUPDATERID,
FREMARK = entity.FREMARK
}, new
{
FID = entity.FID
}) == 0 ? "保存失败！" : null);
}
/// <summary>
/// 获取指定Code字典的ID
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public string GetIDByCode(string code)
{
SYS_DICSMODEL model = SYS_DICSDAL.Instance.GetWhere(new { FClassCode = code }).FirstOrDefault();
return(model == null ? null : model.FID);
}
