/// <summary>
/// 校验编号的唯一性
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="columnName">列名</param>
/// <param name="codeValue">输入的编码值</param>
/// <returns>bool 是否已经存在 true 不存在 false 存在</returns>
public static bool CheckCodeUniq(string tableName, string CodeName, string Flag)
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//校验存在性
return(CodeReasonFeeDBHelper.CheckCodeUniq(tableName, companyCD, CodeName, Flag));
}
/// <summary>
/// 修改文档种类信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateThreeCodeInfo(CodeReasonFeeModel model, string TableName)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model == null)
{
return(false);
}
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CodeName, TableName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = CodeReasonFeeDBHelper.UpdateThreeCodeInfo(model, TableName);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex, TableName);
return(false);
}
}
/// <summary>
/// 删除文档分类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool DeleteThreeCodeType(string id, string TableName)
{
if (string.IsNullOrEmpty(id))
{
return(false);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//string CompanyCD = "AAAAAA";
bool isSucc = CodeReasonFeeDBHelper.DeleteThreeCodeType(id, TableName);
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
string[] noList = id.Split(',');
//遍历所有编号，登陆操作日志
for (int i = 0; i < noList.Length; i++)
{
//获取编号
string no = noList[i];
//替换两边的 '
no = no.Replace("'", string.Empty);
string name = "";
//操作日志
switch (TableName)
{
case "officedba.CodeReasonType":
name = "原因ID：";
break;
case "officedba.CodeFeeType":
name = "费用ID：";
break;
case "officedba.CodeUnitType":
name = "计量单位ID：";
break;
}
LogInfoModel logModel = InitLogInfo(name + no, TableName);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
public static DataTable GetCodeUnitType()
{
try
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = userInfo.CompanyCD;
return(CodeReasonFeeDBHelper.GetCodeUnitType(CompanyCD));
}
catch
{
return(null);
throw;
}
}
/// <summary>
/// 根据id获取文档种类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CodeReasonFeeModel GetThreeCodeById(int id, string TableName)
{
if (id == 0)
{
return(null);
}
try
{
return(CodeReasonFeeDBHelper.GetThreeCodeById(id, TableName));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取文档分类
/// </summary>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetThreeCodeType(string CompanyCD, string SubNo, string TableName, string UsedStatus, string Name, string Flag)
{
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
return(CodeReasonFeeDBHelper.GetThreeCodeType(CompanyCD, SubNo, TableName, UsedStatus, Name, Flag));
}
catch
{
return(null);
throw;
}
}
/// <summary>
/// 判断费用表是否已经使用这个费用分类了
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static bool ChargeFee(string ID)
{
return(CodeReasonFeeDBHelper.ChargeFee(ID));
}
