/// <summary>
/// 插入设备信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertCodeEquipmentInfo(CodeEquipmentTypeModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
int succ = 0;
LogInfoModel logModel = InitLogInfo(model.CodeName);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.Menu_Equipment;
//设置操作日志类型 修改
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_Equipment;
//操作对象
succ = CategorySetDBHelper.InsertCodeEquipmentInfo(model);
if (succ < 1)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return(0);
}
}
/// <summary>
/// 修改设备种类信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateCodeEquipmentInfo(CodeEquipmentTypeModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
int succ = 0;
LogInfoModel logModel = InitLogInfo(model.CodeName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
logModel.ModuleID = ConstUtil.Menu_Equipment;
//设置操作日志类型 修改
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_Equipment;
succ = CategorySetDBHelper.UpdateCodeEquipmentInfo(model);
if (succ < 1)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception)
{
return(0);
throw;
}
}
public static DataTable SearchDeptInfo(string companyCD, string deptID, string TableName)
{
if (string.IsNullOrEmpty(TableName))
{
return(null);
}
DataTable dt = null;
try
{
if (TableName == "officedba.CodeCompanyType")
{
dt = CategorySetDBHelper.SearchCodeCompanyInfo(companyCD, deptID);
}
else if (TableName == "officedba.CodeProductType")
{
dt = CategorySetDBHelper.SearchDeptInfo(companyCD, deptID);
}
return(dt);
}
catch
{
return(null);
throw;
}
}
public static string GetProductTypeInfo(int ID, string TypeFlag)
{
try
{
return(CategorySetDBHelper.GetProductTypeInfo(ID, TypeFlag));
}
catch
{
return(null);
throw;
}
}
/// <summary>
/// 修改文档种类信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateCodeBigTypeInfo(CodeEquipmentTypeModel model, string TableName)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
int succ = 0;
LogInfoModel logModel = InitLogInfo(model.CodeName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
if (TableName == "officedba.CodeCompanyType")
{
logModel.ModuleID = ConstUtil.Menu_CompanyType;
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_CompanyType;
}
else if (TableName == "officedba.CodeProductType")
{
logModel.ModuleID = ConstUtil.Menu_ProductType;
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_ProductType;
}
succ = CategorySetDBHelper.UpdateCodeBigTypeInfo(model, TableName);
if (succ < 1)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception)
{
return(0);
throw;
}
//if (model == null)
// return 0;
//try
//{
// return CategorySetDBHelper.UpdateCodeBigTypeInfo(model,TableName);
//}
//catch (Exception ex)
//{
// throw;
//}
}
/// <summary>
/// 根据id获取设备种类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CodeEquipmentTypeModel GetCodeEuipment(int id)
{
if (id == 0)
{
return(null);
}
try
{
return(CategorySetDBHelper.GetCodeEuipment(id));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据id获取文档种类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static CodeEquipmentTypeModel GetCodeBigTypebyId(int id, string TableName)
{
if (id == 0)
{
return(null);
}
try
{
return(CategorySetDBHelper.GetCodeBigTypeById(id, TableName));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetCodeEquipmentType(string CompanyCD, string flag)
{
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
return(CategorySetDBHelper.GetCodeEquipmentType(CompanyCD, flag));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取文档分类
/// </summary>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetCodeBigFlagType(string CompanyCD, string TableName)
{
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
return(CategorySetDBHelper.GetCodeBigType(CompanyCD, TableName));
}
catch
{
return(null);
throw;
}
}
public static int DeleteCodeEquipmentInfo(int id)
{
if (id == 0)
{
return(0);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = userInfo.CompanyCD;
//string CompanyCD = "AAAAAA";
int isSucc = CategorySetDBHelper.DeleteCodeEquipmentInfo(id);
//定义变量
string remark;
//成功时
if (isSucc > 0)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
//操作日志
LogInfoModel logModel = InitLogInfo(Convert.ToString(id));
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
logModel.ModuleID = ConstUtil.Menu_Equipment;
logModel.ObjectID = "设备分类ID：" + id;
//设置操作日志类型 修改
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_Equipment;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
public static DataTable GetProductType()
{
try
{
string CompanyCD = "";
try
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
CompanyCD = userInfo.CompanyCD;
}
catch
{
CompanyCD = "AAAAAA";
}
return(CategorySetDBHelper.GetProductType(CompanyCD));
}
catch
{
return(null);
throw;
}
}
/// <summary>
/// 删除文档分类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DeleteCodeBigType(int id, string TableName)
{
if (id == 0)
{
return(0);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = userInfo.CompanyCD;
//string CompanyCD = "AAAAAA";
int isSucc = CategorySetDBHelper.DeleteCodeBigType(id, TableName);
//定义变量
string remark;
//成功时
if (isSucc > 0)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
//操作日志
LogInfoModel logModel = InitLogInfo(Convert.ToString(id));
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
if (TableName == "officedba.CodeCompanyType")
{
logModel.ModuleID = ConstUtil.Menu_CompanyType;
logModel.ObjectID = "往来单位ID：" + id;
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_CompanyType;
}
else if (TableName == "officedba.CodeProductType")
{
logModel.ModuleID = ConstUtil.Menu_ProductType;
logModel.ObjectID = "物品分类ID：" + id;
logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_ProductType;
}
//设置操作日志类型 修改
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
//if (id == 0)
// return 0;
//try
//{
// return CategorySetDBHelper.DeleteCodeBigType(id,TableName);
//}
//catch (Exception ex)
//{
// throw;
//}
}
/// <summary>
/// 获取文档类型的方法
/// </summary>
/// <param name="CompanyCD">公司代码</param>
/// <returns>返回所有类型及类型ID</returns>
public static DataTable GetDocType(string CompanyCD)
{
return(CategorySetDBHelper.GetDocType(CompanyCD));
}
