/// <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)); }