/// <summary>
/// 设置自审信息
/// </summary>
/// <param name="cityId">城市</param>
/// <param name="companyId">企业</param>
/// <param name="allotId">任务ID</param>
/// <param name="datType">任务数据类型</param>
/// <param name="userName">自审人</param>
/// <param name="pass">是否通过</param>
/// <param name="remark">自审说明</param>
/// <param name="message"></param>
/// <param name="_db"></param>
/// <param name="tx"></param>
/// <returns></returns>
public static int SetMyCheckInfo(int cityId, int companyId, long allotId, long datId, int datType, string userName, bool pass, string remark, out string message, DataBase _db = null, ITransaction tx = null)
{
message = "";
DataBase db = new DataBase(_db);
TransactionHelper tr = new TransactionHelper(db.DB, tx);
try
{
bool add = false;
DatCheck obj = GetCheckByAllotId(allotId, db);
//是否存在数据
if (obj == null)
{
add = true;
obj = new DatCheck();
obj.CityId = cityId;
obj.FxtCompanyId = companyId;
obj.AllotId = allotId;
obj.DatType = datType;
obj.DatId = datId;
}
obj.CheckUserName1 = userName;
obj.CheckState1 = SYSCodeManager.STATECODE_7;
if (pass)
{
obj.CheckState1 = SYSCodeManager.STATECODE_6;
}
obj.CheckRemark1 = remark;
obj.CheckDate1 = DateTime.Now;
bool upResult = false;
if (add)
{
upResult = db.DB.Create(obj, tx);
}
else
{
upResult = db.DB.Update(obj, tx);
}
if (!upResult)
{
tr.Rollback();
db.Close();
return(0);
}
tr.Commit();
db.Close();
}
catch (Exception ex)
{
tr.Rollback();
db.Close();
message = "系统异常";
log.Error("SetMyCheckInfo:系统异常", ex);
return(-1);
}
return(1);
}
/// <summary>
/// 根据任务ID获取任务审核信息
/// </summary>
/// <param name="allotId"></param>
/// <param name="_db"></param>
/// <returns></returns>
public static DatCheck GetCheckByAllotId(long allotId, DataBase _db = null)
{
DataBase db = new DataBase(_db);
try
{
string sql = "{0} allotId=:allotId order by Id desc";
sql = string.Format(sql, NHibernateUtility.GetMSSQL_SQL_NOLOCK(NHibernateUtility.TableName_DatCheck, keyword: " top 1 "));
List <NHParameter> parameters = new List <NHParameter>();
parameters.Add(new NHParameter("allotId", allotId, NHibernateUtil.Int64));
DatCheck obj = db.DB.GetCustomSQLQueryEntity <DatCheck>(sql, parameters);
db.Close();
return(obj);
}
catch (Exception ex)
{
db.Close();
throw ex;
}
}
