/// <summary>
/// ��ȡһ����¼[�ѹ�ʱ]
/// </summary>
/// <param name="A_ID">��¼���</param>
/// <returns>һ����¼</returns>
public XYECOM.Model.AuditingInfo GetItem(int A_ID)
{
XYECOM.Model.AuditingInfo aut = null;
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@strWhere"," Where A_ID=" + A_ID.ToString()),
new SqlParameter("@strTableName","pl_Auditing"),
new SqlParameter("@strOrder","")
};
using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_SelectByWhere", param))
{
if (rdr.Read())
{
aut = new XYECOM.Model.AuditingInfo();
aut.A_Advice = rdr["A_Advice"].ToString();
aut.A_ID = Int64.Parse(rdr["A_ID"].ToString());
aut.A_Reason = rdr["A_Reason"].ToString();
aut.DescTabID = Int64.Parse(rdr["DescTabID"].ToString());
aut.DescTabName = rdr["DescTabName"].ToString();
}
}
return aut;
}
/// <summary>
/// �ܾ�ͨ�����
/// </summary>
/// <param name="descTabName">���ݱ�ʶ</param>
/// <param name="infoId">��ϢId</param>
/// <param name="reason">ԭ��</param>
/// <param name="advice">����</param>
protected int NotPassAudit(string descTabName, long infoId, string reason, string advice)
{
XYECOM.Business.Auditing audBLL = new XYECOM.Business.Auditing();
XYECOM.Model.AuditingInfo audInfo = new XYECOM.Model.AuditingInfo();
//�����״̬
int i = audBLL.UpdatesAuditing(infoId, descTabName, XYECOM.Model.AuditingState.NoPass);
audInfo = audBLL.GetItem(infoId + "", descTabName);
if (audInfo == null)
{
audInfo = new XYECOM.Model.AuditingInfo();
audInfo.DescTabName = descTabName;
audInfo.DescTabID = infoId;
}
audInfo.A_Advice = reason;
audInfo.A_Reason = advice;
audBLL.Update(audInfo);
return i;
}