public static bool IsAssetTypeReference(int TypeID)
{
try
{
return(AssetTypeSettingDBHelper.IsAssetTypeReference(TypeID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除固定资产类别
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <param name="ID">主键</param>
/// <returns>true 成功，false失败</returns>
public static bool DeleteAssetType(string ID)
{
bool isSucc = false;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (string.IsNullOrEmpty(ID) && string.IsNullOrEmpty(CompanyCD))
{
return(false);
}
try
{
isSucc = AssetTypeSettingDBHelper.DeleteAssetType(CompanyCD, ID);
//定义变量
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);
//操作日志
LogInfoModel logModel = InitLogInfo(no);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据类别ID获取类别信息
/// </summary>
/// <param name="TypeID">类别ID</param>
/// <returns>DataTable</returns>
public static string GetAssetTypeNameByTypeID(string ID)
{
if (string.IsNullOrEmpty(ID))
{
return(null);
}
try
{
return(AssetTypeSettingDBHelper.GetAssetTypeNameByTypeID(ID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取固定资产类别信息
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetAssetTypeInfo()
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
DataTable dt = AssetTypeSettingDBHelper.GetAssetTypeInfo(CompanyCD);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow rows in dt.Rows)
{
if (rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_ON)
{
rows["UsedStatus"] = ConstUtil.USED_STATUS_ON_NAME;
}
else if (rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_OFF)
{
rows["UsedStatus"] = ConstUtil.USED_STATUS_OFF_NAME;
}
if (rows["CountMethod"].ToString() == ConstUtil.ASSETCOUNT_METHOD_NXPJF_CODE)
{
rows["CountMethod"] = ConstUtil.ASSETCOUNT_METHOD_NXPJF_NAME;
}
else if (rows["CountMethod"].ToString() == ConstUtil.ASSETCOUNT_METHOD_GZLF_CODE)
{
rows["CountMethod"] = ConstUtil.ASSETCOUNT_METHOD_GZLF_NAME;
}
else if (rows["CountMethod"].ToString() == ConstUtil.ASSETCOUNT_METHOD_NXZHF_CODE)
{
rows["CountMethod"] = ConstUtil.ASSETCOUNT_METHOD_NXZHF_NAME;
}
else if (rows["CountMethod"].ToString() == ConstUtil.ASSETCOUNT_METHOD_SBYETJS_CODE)
{
rows["CountMethod"] = ConstUtil.ASSETCOUNT_METHOD_SBYETJS_NAME;
}
}
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取类别名称
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <returns>DataTable</returns>
public static DataTable GetAssetType()
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (string.IsNullOrEmpty(CompanyCD))
{
return(null);
}
try
{
return(AssetTypeSettingDBHelper.GetAssetType(CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改固定资产类别
/// </summary>
/// <param name="Model">实体</param>
/// <returns>true 成功，false失败</returns>
public static bool UpdateAssetType(AssetTypeSettingModel Model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (Model == null)
{
return(false);
}
if (Model.CompanyCD == null)
{
Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(Model.ID.ToString());
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = AssetTypeSettingDBHelper.UpdateAssetType(Model);
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);
throw ex;
}
}
