/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.QS_ApprovalHistory model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Char, 10),
new SqlParameter("@ApprovalType", SqlDbType.Char, 10),
new SqlParameter("@ApprovalResult", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.QS_RTID;
parameters[2].Value = model.QS_RID;
parameters[3].Value = model.Type;
parameters[4].Value = model.ApprovalType;
parameters[5].Value = model.ApprovalResult;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Status;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_QS_APPROVALHISTORY_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.QS_ApprovalHistory model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Char, 10),
new SqlParameter("@ApprovalType", SqlDbType.Char, 10),
new SqlParameter("@ApprovalResult", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.QS_RTID;
parameters[2].Value = model.QS_RID;
parameters[3].Value = model.Type;
parameters[4].Value = model.ApprovalType;
parameters[5].Value = model.ApprovalResult;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Status;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_QS_APPROVALHISTORY_INSERT, parameters);
return((int)parameters[0].Value);
}
/// 评分表复审驳回
/// <summary>
/// 评分表复审驳回
/// </summary>
private void ScoreTableReject(out string msg, int userId)
{
msg = "";
if (!string.IsNullOrEmpty(QS_RTID))
{
int valint = 0;
if (int.TryParse(QS_RTID, out valint))
{
Entities.QS_RulesTable model = BLL.QS_RulesTable.Instance.GetQS_RulesTable(valint);
model.Status = (Int32)Entities.QSRulesTableStatus.Unfinished;
BLL.QS_RulesTable.Instance.Update(model);
Entities.QS_ApprovalHistory historyModel = new Entities.QS_ApprovalHistory();
historyModel.ApprovalType = Convert.ToInt32(Entities.QSApprovalType.TableAduit).ToString();
historyModel.ApprovalResult = 2;
historyModel.QS_RTID = valint;
historyModel.Type = "1";
historyModel.CreateTime = System.DateTime.Now;
historyModel.CreateUserID = userId;
BLL.QS_ApprovalHistory.Instance.Insert(historyModel);
//add by qizq 添加日志2013-5-8
StringBuilder sbStr = new StringBuilder();
sbStr.Append("评分表 " + model.Name + " 审核驳回");
BLL.Util.InsertUserLog(sbStr.ToString());
}
}
else
{
msg = "评分表参数错误";
}
}
/// 历史表维护
/// <summary>
/// 历史表维护
/// </summary>
/// <param name="userID"></param>
/// <param name="QS_RTID"></param>
/// <param name="QS_RID"></param>
/// <param name="qsapprovaltype"></param>
private void InsertApprovalHistory(int userID, int QS_RTID, int QS_RID, QSApprovalType qsapprovaltype)
{
Entities.QS_ApprovalHistory historyModel = new Entities.QS_ApprovalHistory();
historyModel.ApprovalType = Convert.ToInt32(qsapprovaltype).ToString();
historyModel.QS_RTID = QS_RTID;
historyModel.QS_RID = QS_RID;
historyModel.Type = "2";
historyModel.CreateTime = System.DateTime.Now;
historyModel.CreateUserID = userID;
BLL.QS_ApprovalHistory.Instance.Insert(historyModel);
}
private Entities.QS_ApprovalHistory LoadSingleQS_ApprovalHistory(DataRow row)
{
Entities.QS_ApprovalHistory model = new Entities.QS_ApprovalHistory();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["QS_RTID"].ToString() != "")
{
model.QS_RTID = int.Parse(row["QS_RTID"].ToString());
}
if (row["QS_RID"].ToString() != "")
{
model.QS_RID = int.Parse(row["QS_RID"].ToString());
}
model.Type = row["Type"].ToString();
model.ApprovalType = row["ApprovalType"].ToString();
if (row["ApprovalResult"].ToString() != "")
{
model.ApprovalResult = int.Parse(row["ApprovalResult"].ToString());
}
model.Remark = row["Remark"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.QS_ApprovalHistory model)
{
return(Dal.QS_ApprovalHistory.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.QS_ApprovalHistory model)
{
return(Dal.QS_ApprovalHistory.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.QS_ApprovalHistory model)
{
return(Dal.QS_ApprovalHistory.Instance.Insert(model));
}
