/// <summary>
/// 获取为已启用的期末项目
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <returns>DataTable</returns>
public static DataTable GetEndItemIsUsed()
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
DataTable dt = EndItemSettingDBHelper.GetEndItemIsUsed(CompanyCD);
//if (dt != null && dt.Rows.Count > 0)
//{
// foreach (DataRow rows in dt.Rows)
// {
// if (rows["ItemName"].ToString().Trim() == "固定资产折旧")
// {
// string PeriodNum = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString();
// if (!EndItemProcessing.CheckPeriodIsexist(PeriodNum, CompanyCD))
// {
// rows["IsAccount"] = "未处理";
// break;
// }
// }
// }
//}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateEndItemByName(string ItemName, string UsedStatus)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(ItemName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = EndItemSettingDBHelper.UpdateEndItemByName(CompanyCD, ItemName, UsedStatus);
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;
}
}
public static bool Isexist(string EndItemName)
{
try
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
return(EndItemSettingDBHelper.Isexist(CompanyCD, EndItemName));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据企业编码查看企业项目设置
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <returns>DataTable</returns>
public static DataTable GetEndItemSettingInfo()
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return(EndItemSettingDBHelper.GetEndItemSettingInfo(CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加期末项目
/// </summary>
/// <param name="CompanyCD">企业编码</param>
/// <param name="ItemName">项目名称</param>
/// <param name="UsedStatus">使用状态</param>
/// <returns>true 成功，false失败</returns>
public static bool InsertEndItemSetting(string ItemName, string UsedStatus)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
int ShowIndex = 0;
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(ItemName);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
if (ItemName.Trim() == "固定资产折旧")
{
ShowIndex = 1;
}
else if (ItemName.Trim() == "期末调汇")
{
ShowIndex = 2;
}
else if (ItemName.Trim() == "损益结转")
{
ShowIndex = 3;
}
succ = EndItemSettingDBHelper.InsertEndItemSetting(CompanyCD, ItemName, UsedStatus, ShowIndex);
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;
}
}
