private string GetUpdateSql(Auditing model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + model.TableName + " set ");
if (model.Assessor != null)
{
strSql.Append("Assessor='" + model.Assessor + "',");
}
if (model.CheckupMan != null)
{
strSql.Append("CheckupMan='" + model.CheckupMan + "',");
}
if (model.AssessDate != null)
{
strSql.Append("assessDate= " + model.AssessDate + ",");
}
if (model.CheckupDate != null)
{
strSql.Append("checkupDate=" + model.CheckupDate + ",");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
if (model.IdName != null)
{
strSql.Append(" where " + model.IdName + "=" + model.Id + " ");
}
return(strSql.ToString());
}
public bool UpdateConfirm(Auditing auditing)
{
return(sqlHelper.Update(new ArrayList()
{
GetUpdateSql(auditing)
}));
}
/// <summary>
/// 执行审批操作
/// </summary>
/// <param name="auditing">审核表对象</param>
/// <returns>0：审批成功 1：该信息已被审批 2：未查询到该条信息 3：未审核的信息不能被审批</returns>
public int DoConfirm(Auditing auditing)
{
DataTable dt = GetConfirmName(auditing);
if (dt.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dt.Rows[0]["assessor"].ToString()))
{
return(3);//尚未审核的信息不能审批
}
else if (!string.IsNullOrEmpty(dt.Rows[0]["checkupMan"].ToString()))
{
return(1);//已被审批过
}
else
{
try
{
sqlHelper.BeginUserTran();
if (!auditing.Confirm)
{
auditing.Assessor = "";
auditing.CheckupMan = "";
auditing.AssessDate = "null";
auditing.CheckupDate = "null";
}
UpdateConfirm(auditing);
if (AuditingEvent != null)
{
AuditingEvent(auditing, sqlHelper);
}
sqlHelper.CommitUserTran();
return(0);
}
catch
{
sqlHelper.RollBackUserTran();
throw;
}
}
}
else
{
return(2);//未查询到该信息
}
}
/// <summary>
/// 执行审核操作
/// </summary>
/// <param name="auditing">审核表对象</param>
/// <returns>0：审核成功 1：该信息已被审核 2：未查询到该条信息</returns>
public int DoAssessor(Auditing auditing)
{
DataTable dt = GetConfirmName(auditing);
if (dt.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dt.Rows[0]["assessor"].ToString()))
{
UpdateConfirm(auditing);
return(0);//审核成功
}
else
{
return(1);//已被审核过
}
}
else
{
return(2);//未查询到该信息
}
}
public DataTable GetConfirmName(Auditing auditing)
{
return(sqlHelper.QueryForDateSet("select assessor,checkupMan from " + auditing.TableName + " where " + auditing.IdName + "=" + auditing.Id.ToString()).Tables[0]);
}
public AuditingAction(string idName, string tableName)
{
auditing = new Auditing();
auditing.IdName = idName;
auditing.TableName = tableName;
}
