public ReturnCountyCheck Get(NoVerifyAddCountryCheck requset)
{
return(CountryPerson.AddCheck(requset));
}
public ReturnCountyCheck AddCheck(NoVerifyAddCountryCheck requset)
{
using (var db = DbFactory.Open())
{
if (string.IsNullOrEmpty(adcd))
{
throw new Exception("请重新登录");
}
var auditCounty = new AuditCounty();
var returnCountryCheck = new ReturnCountyCheck();
auditCounty.Year = requset.year;
auditCounty.CountyADCD = adcd;
auditCounty.CountyAddTime = DateTime.Now;
var oldAuditCountry = db.Single <AuditCounty>(x => x.CountyADCD == adcd);
int auditnum = 1;
if (null != oldAuditCountry)
{
auditnum = oldAuditCountry.AuditNums.Value + 1;
}
//查询数据有没有更改
var bulid = db.From <CountryPerson>().Where(x => x.adcd == adcd).And(x => x.AuditNums == auditnum);
var list = db.Select <CountryPerson>(bulid);
//2种状态一种是第一次提交另外就是第二次提交
if (oldAuditCountry != null)
{
//审核不通过的2种状态一种更改过数据一种没更改数据
if (oldAuditCountry.Status == -1)
{
if (list.Count == 0)
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = oldAuditCountry.Status;
returnCountryCheck.CheckSuggest = db.Select <AuditCountyDetails>("select Remarks,max(AuditTime) from dbo.AuditCountyDetails where CountyID='" + oldAuditCountry.ID + "' group by Remarks ")[0].Remarks;
return(returnCountryCheck);
}
}
//审核种
else if (oldAuditCountry.Status == 1)
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = oldAuditCountry.Status;
returnCountryCheck.CheckSuggest = "";
return(returnCountryCheck);
}
auditCounty.AuditNums = oldAuditCountry.AuditNums + 1;
auditCounty.Status = 1;
auditCounty.operateLog = null;
auditCounty.ID = db.Select <AuditCounty>("select * from dbo.AuditCounty where CountyADCD='" + adcd + "' and Year='" + DateTime.Now.Year + "'")[0].ID;
}
else
{
var bulidFirst = db.From <CountryPerson>().Where(x => x.adcd == adcd);
var listFirst = db.Select <CountryPerson>(bulidFirst);
//第一次没有记录就提交
if (listFirst.Count == 0)
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "提交后未更改数据";
return(returnCountryCheck);
}
//第一次提交
auditCounty.AuditNums = 1;
auditCounty.Status = 1;
auditCounty.operateLog = null;
if (db.Insert <AuditCounty>(auditCounty) == 1)
{
returnCountryCheck.IsSuccess = true;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "";
#region 日志
StringBuilder sb = new StringBuilder();
sb.Append("在栏目{组织责任/县级防汛防台责任人}下,{" + RealName + "}第{" + auditCounty.AuditNums + "}次提交了责任人审核申请");
logHelper.WriteLog(sb.ToString(), OperationTypeEnums.新增);
#endregion
}
else
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "";
}
return(returnCountryCheck);
}
//审核失败未更改数据
if (list.Count == 0)
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "提交后未更改数据";
return(returnCountryCheck);
}
//更新数据库
if (db.Update <AuditCounty>(auditCounty) == 1)
{
returnCountryCheck.IsSuccess = true;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "";
#region 日志
StringBuilder sb = new StringBuilder();
sb.Append("在栏目{组织责任/县级防汛防台责任人}下,{" + RealName + "}第{" + auditCounty.AuditNums + "}次提交了责任人审核申请");
logHelper.WriteLog(sb.ToString(), OperationTypeEnums.更新);
#endregion
}
else
{
returnCountryCheck.IsSuccess = false;
returnCountryCheck.CheckStatus = 3;
returnCountryCheck.CheckSuggest = "";
}
return(returnCountryCheck);
}
}