/// <summary>
/// 数据字典
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static Sys_BaseDictionaryModel GetNewDicModel(int pId)
{
var model = new Sys_BaseDictionaryModel();
var lastModel = DicList.OrderByDescending(x => x.DCode).FirstOrDefault(x => x.DParentId == pId);
if (lastModel == null || lastModel.Id <= 0)
{
var pModel = GetDicModel(pId, 0);
if (pModel != null && pModel.Id >= 0)
{
model = new Sys_BaseDictionaryModel
{
DIsValid = 1,
DParentId = pId,
DParentName = pModel.DName,
DCode = pModel.DCode * 100 + 1
};
}
}
else
{
model = new Sys_BaseDictionaryModel
{
DIsValid = 1,
DParentId = pId,
DParentName = lastModel.DParentName,
DCode = lastModel.DCode + 1
};
}
return(model);
}
/// <summary>
/// 修改数据字典
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static BaseResponse UpdateDicModel(Sys_BaseDictionaryModel model)
{
var res = new BaseResponse();
var i = Sys_BaseDictionaryAccess.UpdateDicModel(model);
res = new BaseResponse
{
IsSuccess = i > 0 ? 1 : 0,
Msg = i > 0 ? string.Empty : "更新失败",
};
return(res);
}
/// <summary>
/// 新增数据字典
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static int AddDicModel(Sys_BaseDictionaryModel model)
{
var sql = new StringBuilder();
sql.Append(" INSERT INTO `sys_basedictionary` (`DParentId`, `DParentName`, `DName`, `DCode`, `DValue`, `DRemark`, `DIsValid`, `DSort`) VALUES ");
sql.Append("( @DParentId, @DParentName, @DName, @DCode, @DValue, @DRemark, @DIsValid, @DSort)");
var para = new DynamicParameters();
para.Add("@DParentId", model.DParentId);
para.Add("@DParentName", model.DParentName ?? string.Empty);
para.Add("@DName", model.DName ?? string.Empty);
para.Add("@DCode", model.DCode);
para.Add("@DValue", model.DValue ?? string.Empty);
para.Add("@DRemark", model.DRemark ?? string.Empty);
para.Add("@DIsValid", model.DIsValid);
para.Add("@DSort", model.DSort);
var id = MysqlHelper.Insert(sql.ToString(), para);
_DicList = null;
return(id);
}
/// <summary>
/// 新增数据字典
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static BaseResponse AddDicModel(Sys_BaseDictionaryModel model)
{
var res = new BaseResponse();
var id = 0;
if (model.DCode == 0)
{
res.Msg = "无效的Code";
return(res);
}
if (string.IsNullOrEmpty(model.DName))
{
res.Msg = "字典名称不能为空";
return(res);
}
var dic = Sys_BaseDictionaryAccess.GetDicModel(0, model.DCode);
if (dic != null && dic.Id > 0)
{
res.Msg = "已存在相同Code的字典";
return(res);
}
id = Sys_BaseDictionaryAccess.AddDicModel(model);
if (id <= 0)
{
res.Msg = "新增失败";
return(res);
}
else
{
res = new BaseResponse
{
AddId = (int)id,
IsSuccess = 1
};
}
return(res);
}
/// <summary>
/// 修改数据字典
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static int UpdateDicModel(Sys_BaseDictionaryModel model)
{
if (model == null || model.Id <= 0)
{
return(0);
}
var sql = new StringBuilder();
sql.Append(" UPDATE `sys_basedictionary` ");
sql.Append(" SET `DName` = @DName , `DValue`= @DValue , `DRemark`= @DRemark , `DIsValid`= @DIsValid , `DSort`= @DSort ");
sql.Append(" WHERE `Id` =@Id Limit 1; ");
var para = new DynamicParameters();
para.Add("@Id", model.Id);
para.Add("@DName", model.DName ?? string.Empty);
para.Add("@DValue", model.DValue ?? string.Empty);
para.Add("@DRemark", model.DRemark ?? string.Empty);
para.Add("@DIsValid", model.DIsValid);
para.Add("@DSort", model.DSort);
var c = MysqlHelper.Update(sql.ToString(), para);
_DicList = null;
return(c);
}
