protected override void AfterGetData(Dictionary <string, object> dic, bool isNew, string upperVersionID)
{
if (isNew)
{
string engineeringInfo = GetQueryString("EngineeringInfo");
if (string.IsNullOrEmpty(engineeringInfo))
{
throw new Formula.Exceptions.BusinessValidationException("请选择项目！");
}
string sql = string.Format("select * from S_I_Engineering where ID='{0}' ", engineeringInfo);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("所选项目不存在！");
}
var engineering = FormulaHelper.DataRowToDic(dt.Rows[0]);
dic.SetValue("EngineeringInfo", engineering.GetValue("ID"));
dic.SetValue("EngineeringInfoName", engineering.GetValue("Name"));
dic.SetValue("ProNature", "严重");
dic.SetValue("CheckDate", DateTime.Now.ToString("yyyy-MM-dd"));
dic.SetValue("CheckerName", CurrentUserInfo.UserName);
dic.SetValue("ID", FormulaHelper.CreateGuid());
}
}
public ActionResult List()
{
var engineeringInfo = this.GetEntityByID <S_I_Engineering>(Request["EngineeringInfoID"]);
if (engineeringInfo == null)
{
throw new Formula.Exceptions.BusinessValidationException("工程信息不存在！");
}
var sql = string.Format(@"select Top 1 ID,Name,SerialNumber,PartyA,PartyAName from S_M_ContractInfo where ProjectInfo='{0}' and ContractState='Sign' ", engineeringInfo.ID);
var contractInfo = EPCSQLDB.ExecuteDataTable(sql);
ViewBag.ContractInfo = JsonHelper.ToJson(contractInfo);
var tab = new Tab();
var yearCategory = CategoryFactory.GetYearCategory("BelongYear", 5, 2, false, "年份");
yearCategory.SetDefaultItem(DateTime.Now.Year.ToString());
yearCategory.Multi = false;
tab.Categories.Add(yearCategory);
var monthCategory = CategoryFactory.GetMonthCategory("BelongMonth", false, "月份");
monthCategory.SetDefaultItem(DateTime.Now.Month.ToString());
monthCategory.Multi = false;
tab.Categories.Add(monthCategory);
tab.IsDisplay = true;
ViewBag.Tab = tab;
return(View());
}
//关闭
public JsonResult Close()
{
string id = GetQueryString("ID");
if (string.IsNullOrEmpty(id))
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
string sql = string.Format("select * from S_C_RectifySheet_RectifyProblems where ID='{0}' ", id);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
var problem = FormulaHelper.DataRowToDic(dt.Rows[0]);
if (problem.GetValue("RectifyState") != "Rectify")
{
throw new Formula.Exceptions.BusinessValidationException("只有状态为已整改的单才能关闭，请确认！");
}
sql = string.Format("update S_C_RectifySheet_RectifyProblems set RectifyState='Closed', CloseDate=GETDATE(), CloseUserID='{1}', CloseUserName='******' where ID ='{0}' and RectifyState='Rectify' ",
id, CurrentUserInfo.UserID, CurrentUserInfo.UserName);
this.EPCSQLDB.ExecuteNonQuery(sql);
LoggerHelper.InserLogger("S_C_RectifySheet_RectifyProblems", EnumOperaType.Update, id, problem.GetValue("EngineeringInfo"), problem.GetValue("Name"), "关闭问题");
return(Json(""));
}
public ActionResult Detail()
{
string problemID = GetQueryString("ID");
string sql = string.Format("select * from S_C_RectifySheet_RectifyProblems where ID='{0}' ", problemID);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
var problem = FormulaHelper.DataRowToDic(dt.Rows[0]);
ViewBag.ID = problem.GetValue("ID");
ViewBag.Name = problem.GetValue("Name");
ViewBag.RectifyState = problem.GetValue("RectifyState");
ViewBag.EngineeringInfo = problem.GetValue("EngineeringInfo");
ViewBag.ProType = problem.GetValue("ProType");
ViewBag.JobContent = problem.GetValue("JobContent");
ViewBag.CheckDate = string.IsNullOrEmpty(problem.GetValue("CheckDate")) ? string.Empty : Convert.ToDateTime(problem.GetValue("CheckDate")).ToString("yyyy-MM-dd");
ViewBag.RectifyDate = string.IsNullOrEmpty(problem.GetValue("RectifyDate")) ? string.Empty : Convert.ToDateTime(problem.GetValue("RectifyDate")).ToString("yyyy-MM-dd");
ViewBag.CloseDate = string.IsNullOrEmpty(problem.GetValue("CloseDate")) ? string.Empty : Convert.ToDateTime(problem.GetValue("CloseDate")).ToString("yyyy-MM-dd");
ViewBag.LiablePerson = problem.GetValue("LiablePerson");
ViewBag.CheckerName = problem.GetValue("CheckerName");
ViewBag.BeforeImprovePictrue = problem.GetValue("BeforeImprovePictrue");
ViewBag.AfterImprovePictrue = problem.GetValue("AfterImprovePictrue");
ViewBag.BeforeImprovePictrueList = problem.GetValue("BeforeImprovePictrue").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
ViewBag.AfterImprovePictrueList = problem.GetValue("AfterImprovePictrue").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
return(View());
}
protected override void OnFlowEnd(T_I_ManagerChange entity, S_WF_InsTaskExec taskExec, S_WF_InsDefRouting routing)
{
var updateSql = string.Empty;
if (string.IsNullOrWhiteSpace(entity.LastVersionID))
{
var sql = string.Format(@"select * from T_I_ManagerNominate where ID='{0}' ", entity.ManagerNominateID);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此项目的项目经理信息不存在，请确认！");
}
var firstChange = FormulaHelper.DataRowToDic(dt.Rows[0]);
firstChange.SetValue("NewManager", firstChange.GetValue("Manager"));
firstChange.SetValue("NewManagerName", firstChange.GetValue("ManagerName"));
firstChange.SetValue("ManagerNominateID", firstChange.GetValue("ID"));
firstChange.SetValue("LastVersionID", string.Empty);
firstChange.SetValue("FirstOne", "true");
updateSql += firstChange.CreateInsertSql(EPCSQLDB, "T_I_ManagerChange", FormulaHelper.CreateGuid());
}
var managerNominate = entity.ToDic();
managerNominate.SetValue("FlowPhase", "End");
managerNominate.SetValue("Manager", managerNominate.GetValue("NewManager"));
managerNominate.SetValue("ManagerName", managerNominate.GetValue("NewManagerName"));
updateSql += managerNominate.CreateUpdateSql(EPCSQLDB, "T_I_ManagerNominate", managerNominate.GetValue("ManagerNominateID"));
EPCSQLDB.ExecuteNonQuery(updateSql);
}
//删除
public JsonResult DeleteProblem()
{
string id = GetQueryString("ID");
if (string.IsNullOrEmpty(id))
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
string sql = string.Format("select * from S_C_RectifySheet_RectifyProblems where ID='{0}' ", id);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
var problem = FormulaHelper.DataRowToDic(dt.Rows[0]);
if (problem.GetValue("RectifyState") != "Register")
{
throw new Formula.Exceptions.BusinessValidationException("只有待整改的单才能删除，请确认！");
}
sql = string.Format("delete from S_C_RectifySheet_RectifyProblems where ID ='{0}' and RectifyState='Register' ", id);
this.EPCSQLDB.ExecuteNonQuery(sql);
LoggerHelper.InserLogger("S_C_RectifySheet_RectifyProblems", EnumOperaType.Delete, id, problem.GetValue("EngineeringInfo"), problem.GetValue("Name"));
return(Json(""));
}
protected override void BeforeSave(Dictionary<string, string> dic, S_UI_Form formInfo, bool isNew)
{
if (isNew)
{
dic.SetValue("FlowPhase", "End");
dic.SetValue("EngineeringInfoID", dic.GetValue("EngineeringInfo"));
dic.SetValue("MessageCompany", string.Empty);
dic.SetValue("MessageCompanyName", string.Empty);
dic.SetValue("Status", "Add");
}
else
{
string sql = string.Format("select * from T_C_WorkingContact where ID='{0}' ", dic.GetValue("ID"));
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
throw new Formula.Exceptions.BusinessValidationException("联系单不存在，请确认！");
string actionType = Request["actionType"];
if (!string.IsNullOrEmpty(actionType) && actionType == "Resolve")
{
var status = dt.Rows[0]["Status"].ToString();
if (!string.IsNullOrEmpty(status) && status == "Receive")
{
dic.SetValue("Status", "Resolve");
dic.SetValue("ResolveDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"));
}
else
{
throw new Formula.Exceptions.BusinessValidationException("只有已接收的联系单才能处理，请确认！");
}
}
}
}
public JsonResult SaveList()
{
var engineeringInfo = this.GetEntityByID <S_I_Engineering>(Request["EngineeringInfoID"]);
if (engineeringInfo == null)
{
throw new Formula.Exceptions.BusinessValidationException("工程信息不存在！");
}
var list = JsonHelper.ToList(Request["List"]);
var makeYear = Convert.ToInt32(Request["MakeYear"]);
var makeMonth = Convert.ToInt32(Request["MakeMonth"]);
var planMonths = JsonHelper.ToList(Request["planMonths"]);
var userInfo = FormulaHelper.GetUserInfo();
var sql = string.Format(@"delete from S_F_EngineeringInvestPlan where EngineeringInfo='{0}' and MakeYear={1} and MakeMonth={2} ",
engineeringInfo.ID, makeYear, makeMonth);
foreach (var item in list)
{
item.SetValue("EngineeringInfo", engineeringInfo.ID);
item.SetValue("EngineeringInfoName", engineeringInfo.Name);
item.SetValue("MakeDate", Convert.ToDateTime(string.Format("{0}-{1}-01", makeYear, makeMonth)));
item.SetValue("MakeYear", makeYear);
item.SetValue("MakeMonth", makeMonth);
item.SetValue("ChargerDept", engineeringInfo.ChargerDept);
item.SetValue("ChargerDeptName", engineeringInfo.ChargerDeptName);
item.SetValue("CreateUserID", userInfo.UserID);
item.SetValue("CreateUser", userInfo.UserName);
item.SetValue("CreateDate", DateTime.Now);
item.SetValue("ModifyUserID", userInfo.UserID);
item.SetValue("ModifyUser", userInfo.UserName);
item.SetValue("ModifyDate", DateTime.Now);
var strMonthValue = string.Empty;
var monthValue = 0m;
foreach (var planMonth in planMonths)
{
strMonthValue = item.GetValue(planMonth.GetValue("ColumnName"));
if (string.IsNullOrWhiteSpace(strMonthValue))
{
continue;
}
if (decimal.TryParse(strMonthValue, out monthValue))
{
item.SetValue("PlanDate", Convert.ToDateTime(string.Format("{0}-{1}-01", planMonth.GetValue("Year"), planMonth.GetValue("Month"))));
item.SetValue("PlanYear", planMonth.GetValue("Year"));
item.SetValue("PlanMonth", planMonth.GetValue("Month"));
item.SetValue("Amount", monthValue);
sql += item.CreateInsertSql(EPCSQLDB, "S_F_EngineeringInvestPlan", FormulaHelper.CreateGuid());
}
}
}
EPCSQLDB.ExecuteNonQuery(sql);
return(Json(""));
}
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
string sysName = dic.GetValue("SysName");
if (string.IsNullOrEmpty(sysName))
{
throw new BusinessException("账号不能为空！");
}
string sql = string.Format("select Count(ID) from S_A_ParticipantUser where SysName='{0}' and ID !='{1}' ", sysName, dic.GetValue("ID"));
var sysNameCount = Convert.ToInt32(EPCSQLDB.ExecuteScalar(sql));
if (sysNameCount > 0)
{
throw new BusinessException(string.Format("用户名【{0}】已存在", sysName));
}
sql = string.Format("select * from S_A_ParticipantUser where Participant='{0}' and IsAdmin='1' ", dic.GetValue("Participant"));
var dtParticipant = EPCSQLDB.ExecuteDataTable(sql);
if (isNew)
{
if (dtParticipant.Rows.Count > 0)
{
throw new BusinessException(string.Format("参建方【{0}】已存在管理员账号【{1}】", dic.GetValue("ParticipantName"), sysName));
}
var password = dic.GetValue("Password");
ValidatePwd(password);
password = FormsAuthentication.HashPasswordForStoringInConfigFile(string.Format("{0}{1}", sysName.ToLower(), password), "SHA1");
dic.SetValue("Password", password);
}
else
{
if (dtParticipant.Rows.Count == 1)
{
if (dic.GetValue("ID") != dtParticipant.Rows[0]["ID"].ToString())
{
throw new BusinessException(string.Format("参建方【{0}】只能有一个管理员账号！", dic.GetValue("ParticipantName")));
}
}
else if (dtParticipant.Rows.Count > 1)
{
throw new BusinessException(string.Format("参建方【{0}】只能有一个管理员账号！", dic.GetValue("ParticipantName")));
}
dic.Remove("Password");
}
dic.SetValue("IsAdmin", "true");
}
public JsonResult SaveList()
{
var engineeringInfo = this.GetEntityByID <S_I_Engineering>(Request["EngineeringInfoID"]);
if (engineeringInfo == null)
{
throw new Formula.Exceptions.BusinessValidationException("工程信息不存在！");
}
var list = JsonHelper.ToList(Request["List"]);
var belongYear = Convert.ToInt32(Request["BelongYear"]);
var belongMonth = Convert.ToInt32(Request["BelongMonth"]);
var userInfo = FormulaHelper.GetUserInfo();
var sql = string.Format(@"delete from S_F_EngineeringFundPlan where EngineeringInfo='{0}' and BelongYear={1} and BelongMonth={2} ",
engineeringInfo.ID, belongYear, belongMonth);
var index = 0;
foreach (var item in list)
{
item.SetValue("SortIndex", index);
index++;
item.SetValue("EngineeringInfo", engineeringInfo.ID);
item.SetValue("EngineeringInfoName", engineeringInfo.Name);
item.SetValue("BelongDate", Convert.ToDateTime(string.Format("{0}-{1}-01", belongYear, belongMonth)));
item.SetValue("BelongYear", belongYear);
item.SetValue("BelongMonth", belongMonth);
item.SetValue("ChargerDept", engineeringInfo.ChargerDept);
item.SetValue("ChargerDeptName", engineeringInfo.ChargerDeptName);
if (string.IsNullOrWhiteSpace(item.GetValue("CreateUserID")))
{
item.SetValue("CreateUserID", userInfo.UserID);
item.SetValue("CreateUser", userInfo.UserName);
item.SetValue("CreateDate", DateTime.Now);
}
item.SetValue("ModifyUserID", userInfo.UserID);
item.SetValue("ModifyUser", userInfo.UserName);
item.SetValue("ModifyDate", DateTime.Now);
item.SetValue("MakeYear", DateTime.Now.Year);
item.SetValue("MakeMonth", DateTime.Now.Month);
if (string.IsNullOrWhiteSpace(item.GetValue("ID")))
{
item.SetValue("ID", FormulaHelper.CreateGuid());
}
sql += item.CreateInsertSql(EPCSQLDB, "S_F_EngineeringFundPlan", item.GetValue("ID"));
}
EPCSQLDB.ExecuteNonQuery(sql);
return(Json(""));
}
public JsonResult Reset()
{
var password = Request["pwd"];
if (string.IsNullOrEmpty(password))
{
throw new BusinessException("请输入密码！");
}
ValidatePwd(password);
var listData = JsonHelper.ToList(Request["ListData"]);
if (listData.Count == 0)
{
throw new BusinessException("请选择要操作的行！");
}
var idList = listData.Select(a => a.GetValue("ParticipantUserID"));
string sql = string.Format("select * from S_A_ParticipantUser where ID in ('{0}') and IsAdmin='1' ", string.Join("','", idList));
var dt = EPCSQLDB.ExecuteDataTable(sql);
string updateSql = "";
Dictionary <string, object> operaLog = new Dictionary <string, object>();
var userInfo = FormulaHelper.GetUserInfo();
foreach (DataRow dr in dt.Rows)
{
string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(string.Format("{0}{1}", dr["SysName"].ToString().ToLower(), password), "SHA1");
if (pwd == dr["Password"].ToString())
{
throw new BusinessException(string.Format("账号【{0}】的新密码与旧密码相同，请修改！", dr["SysName"].ToString()));
}
updateSql += string.Format("update S_A_ParticipantUser set Password = '******' where ID = '{1}' and IsAdmin='1' ", pwd, dr["ID"]);
operaLog.SetValue("OperateType", EnumOperaType.Update);
operaLog.SetValue("TableIDs", dr["ID"].ToString());
operaLog.SetValue("Name", dr["UserName"].ToString());
operaLog.SetValue("EngineeringInfoID", string.Empty);
operaLog.SetValue("DBTable", "S_A_ParticipantUser");
operaLog.SetValue("DBTableName", "S_A_ParticipantUser");
operaLog.SetValue("Remark", "重置密码");
operaLog.SetValue("CreateUser", userInfo.UserName);
operaLog.SetValue("CreateUserID", userInfo.UserID);
operaLog.SetValue("CreateDate", DateTime.Now);
updateSql += operaLog.CreateInsertSql(EPCSQLDB, "S_A_ParticipantOperaLog", FormulaHelper.CreateGuid());
}
EPCSQLDB.ExecuteNonQuery(updateSql);
return(Json(""));
}
protected override void AfterSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
var flowPhase = dic.GetValue("FlowPhase");
if (string.IsNullOrWhiteSpace(flowPhase) || flowPhase == "Start")
{
var list = JsonHelper.ToList(dic.GetValue("dataGrid"));
var makeDate = Convert.ToDateTime(dic.GetValue("MakeDate"));
var planMonths = GetPlanMonths(makeDate);
var sql = string.Empty;
if (!isNew)
{
sql = string.Format(@"delete from S_F_InvestPlan_Detail where S_F_InvestPlanID='{0}' ", dic.GetValue("ID"));
}
foreach (var item in list)
{
item.SetValue("S_F_InvestPlanID", dic.GetValue("ID"));
var strMonthValue = string.Empty;
var monthValue = 0m;
foreach (var planMonth in planMonths)
{
strMonthValue = item.GetValue(planMonth.GetValue("ColumnName"));
if (string.IsNullOrWhiteSpace(strMonthValue))
{
continue;
}
if (decimal.TryParse(strMonthValue, out monthValue))
{
item.SetValue("PlanDate", Convert.ToDateTime(string.Format("{0}-{1}-01", planMonth.GetValue("Year"), planMonth.GetValue("Month"))));
item.SetValue("PlanYear", planMonth.GetValue("Year"));
item.SetValue("PlanMonth", planMonth.GetValue("Month"));
item.SetValue("Amount", monthValue);
sql += item.CreateInsertSql(EPCSQLDB, "S_F_InvestPlan_Detail", FormulaHelper.CreateGuid());
}
}
}
EPCSQLDB.ExecuteNonQuery(sql);
}
}
protected override void AfterGetData(Dictionary <string, object> dic, bool isNew, string upperVersionID)
{
if (isNew)
{
string engineeringInfo = GetQueryString("EngineeringInfo");
if (string.IsNullOrEmpty(engineeringInfo))
{
throw new Formula.Exceptions.BusinessValidationException("请选择项目！");
}
string sql = string.Format("select * from S_I_Engineering where ID='{0}' ", engineeringInfo);
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("所选项目不存在！");
}
var engineering = FormulaHelper.DataRowToDic(dt.Rows[0]);
dic.SetValue("EngineeringInfo", engineering.GetValue("ID"));
dic.SetValue("EngineeringInfoName", engineering.GetValue("Name"));
dic.SetValue("Code", engineering.GetValue("SerialNumber"));
SerialNumberParam param = new SerialNumberParam()
{
Code = "TCMWorkingContact",
PrjCode = "",
OrgCode = "",
UserCode = "",
CategoryCode = "",
SubCategoryCode = "",
OrderNumCode = ""
};
var serialNumber = SerialNumberHelper.GetSerialNumberString("{YY}{MM}{DD}-{NNNN}", param, "YearCode,MonthCode", true);
dic.SetValue("SerialNumber", serialNumber);
dic.SetValue("MainCompany", engineering.GetValue("CustomerInfo"));
dic.SetValue("MainCompanyName", engineering.GetValue("CustomerInfoName"));
dic.SetValue("SendCompany", CurrentUserInfo.UserOrgID);
dic.SetValue("SendCompanyName", CurrentUserInfo.UserOrgName);
dic.SetValue("ID", FormulaHelper.CreateGuid());
}
}
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
if (isNew)
{
var sql = string.Format(@"select * from T_I_ManagerChange where ManagerNominateID='{0}' ", dic.GetValue("ManagerNominateID"));
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
dic.SetValue("FirstOne", "true");
}
else
{
var list = FormulaHelper.DataTableToListDic(dt);
if (list.Exists(m => m.GetValue("FlowPhase") != "End"))
{
throw new Formula.Exceptions.BusinessValidationException("此项目经理变更单在审核中，无法变更！");
}
}
}
}
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
if (isNew)
{
dic.SetValue("RectifyState", "Register");//初始状态-- >“待整改”
if (string.IsNullOrEmpty(dic.GetValue("OpenDate")))
{
dic.SetValue("OpenDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
dic.SetValue("CreateCompanyID", string.Empty);
}
else
{
string sql = string.Format("select * from S_C_RectifySheet_RectifyProblems where ID='{0}' ", dic.GetValue("ID"));
var dt = EPCSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
var problem = FormulaHelper.DataRowToDic(dt.Rows[0]);
var currentState = problem.GetValue("RectifyState");
string actionType = GetQueryString("actionType");
switch (actionType)
{
case "Rectify": //整改
if (currentState != "Register")
{
throw new Formula.Exceptions.BusinessValidationException("只有待整改的单才能整改，请确认！");
}
dic.SetValue("RectifyState", "Rectify"); //状态-->“已整改”
if (string.IsNullOrEmpty(dic.GetValue("RectifyDate")))
{
throw new Formula.Exceptions.BusinessValidationException("请选择【整改时间】！");
}
dic.SetValue("RectifyUserID", CurrentUserInfo.UserID);
dic.SetValue("RectifyUserName", CurrentUserInfo.UserName);
break;
case "Close": //关闭
if (currentState != "Rectify")
{
throw new Formula.Exceptions.BusinessValidationException("只有状态为已整改的单才能关闭，请确认！");
}
dic.SetValue("RectifyState", "Closed"); //状态-- >“已关闭”
if (string.IsNullOrEmpty(dic.GetValue("CloseDate")))
{
throw new Formula.Exceptions.BusinessValidationException("请选择【关闭时间】！");
}
dic.SetValue("CloseUserID", CurrentUserInfo.UserID);
dic.SetValue("CloseUserName", CurrentUserInfo.UserName);
break;
case "Reject": //重新整改
if (currentState != "Rectify")
{
throw new Formula.Exceptions.BusinessValidationException("只有状态为已整改的单才能设置重新整改，请确认！");
}
dic.SetValue("RectifyState", "Register"); //状态-- >“待整改”
dic.SetValue("RectifyDate", string.Empty); //整改时间
dic.SetValue("RectifyUserID", string.Empty);
dic.SetValue("RectifyUserName", string.Empty);
break;
default:
if (currentState != "Register")
{
throw new Formula.Exceptions.BusinessValidationException("只有待整改的单才能修改，请确认！");
}
break;
}
}
}
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
if (isNew)
{
dic.Remove("RectifyDate");
dic.Remove("CloseDate");
}
else
{
string sql = string.Format("select * from S_C_RectifySheet_RectifyProblems where ID='{0}' ", dic.GetValue("ID"));
var problem = EPCSQLDB.ExecuteDataTable(sql);
if (problem.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessValidationException("此单不存在，请确认！");
}
var currentState = problem.Rows[0]["RectifyState"] == null ? string.Empty: problem.Rows[0]["RectifyState"].ToString();
if (string.IsNullOrEmpty(currentState))
{
throw new Formula.Exceptions.BusinessValidationException("此单的状态为空，请确认！");
}
string actionType = GetQueryString("actionType");
switch (actionType)
{
case "Rectify": //整改
if (currentState != "Register")
{
throw new Formula.Exceptions.BusinessValidationException("此单已处理，不能重复处理，请确认！");
}
dic.SetValue("RectifyState", "Rectify"); //状态-->“已整改”
if (string.IsNullOrEmpty(dic.GetValue("RectifyDate")))
{
throw new Formula.Exceptions.BusinessValidationException("请选择【整改时间】！");
}
break;
case "Close": //关闭
if (currentState != "Rectify")
{
throw new Formula.Exceptions.BusinessValidationException("此单已关闭，不能重复关闭，请确认！");
}
dic.SetValue("RectifyState", "Closed"); //状态-- >“已关闭”
if (string.IsNullOrEmpty(dic.GetValue("CloseDate")))
{
throw new Formula.Exceptions.BusinessValidationException("请选择【关闭时间】！");
}
break;
case "Reject": //重新整改
if (currentState != "Rectify")
{
throw new Formula.Exceptions.BusinessValidationException("此单已关闭，不能重复关闭，请确认！");
}
dic.SetValue("RectifyState", "Register"); //状态-- >“待整改”
dic.SetValue("RectifyDate", string.Empty); //整改时间
break;
}
}
}
