/// 明细表维护
/// <summary>
/// 明细表维护
/// </summary>
/// <param name="userID"></param>
/// <param name="sInfoData"></param>
/// <param name="QS_RID"></param>
/// <param name="HaveDead"></param>
private void InsertUpdateResultDetail(int userID, QS_ResultData sInfoData, int QS_RID, out bool HaveDead)
{
HaveDead = false;
BLL.QS_ResultDetail.Instance.DeleteByQS_RID(QS_RID);
if (sInfoData.QS_ResultDetailList != null && sInfoData.QS_ResultDetailList.Length > 0)
{
for (int i = 0; i < sInfoData.QS_ResultDetailList.Length; i++)
{
Entities.QS_ResultDetail QS_ResultDetailModel = new Entities.QS_ResultDetail();
QS_ResultDetailModel.ScoreType = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreType);
QS_ResultDetailModel.QS_RTID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_RTID);
QS_ResultDetailModel.QS_RID = Convert.ToInt32(QS_RID);
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_CID))
{
QS_ResultDetailModel.QS_CID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_CID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_IID))
{
QS_ResultDetailModel.QS_IID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_IID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_SID))
{
QS_ResultDetailModel.QS_SID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_SID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_MID))
{
QS_ResultDetailModel.QS_MID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_MID);
QS_ResultDetailModel.QS_MID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_MID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].Type))
{
QS_ResultDetailModel.Type = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].Type);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].ScoreDeadID))
{
QS_ResultDetailModel.ScoreDeadID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreDeadID);
QS_ResultDetailModel.ScoreDeadID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreDeadID);
HaveDead = true;
}
QS_ResultDetailModel.Remark = sInfoData.QS_ResultDetailList[i].Remark;
QS_ResultDetailModel.Status = 0;
QS_ResultDetailModel.CreateTime = System.DateTime.Now;
QS_ResultDetailModel.CreateUserID = userID;
BLL.QS_ResultDetail.Instance.Insert(QS_ResultDetailModel);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.QS_ResultDetail model)
{
SqlParameter[] parameters =
{
new SqlParameter("@QS_RDID", SqlDbType.Int, 4),
new SqlParameter("@ScoreType", SqlDbType.Int, 4),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@QS_CID", SqlDbType.Int, 4),
new SqlParameter("@QS_IID", SqlDbType.Int, 4),
new SqlParameter("@QS_SID", SqlDbType.Int, 4),
new SqlParameter("@QS_MID", SqlDbType.Int, 4),
new SqlParameter("@QS_MID_End", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@ScoreDeadID", SqlDbType.Int, 4),
new SqlParameter("@ScoreDeadID_End", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.ScoreType;
parameters[2].Value = model.QS_RTID;
parameters[3].Value = model.QS_RID;
parameters[4].Value = model.QS_CID;
parameters[5].Value = model.QS_IID;
parameters[6].Value = model.QS_SID;
parameters[7].Value = model.QS_MID;
parameters[8].Value = model.QS_MID_End;
parameters[9].Value = model.Type;
parameters[10].Value = model.ScoreDeadID;
parameters[11].Value = model.ScoreDeadID_End;
parameters[12].Value = model.Status;
parameters[13].Value = model.CreateTime;
parameters[14].Value = model.CreateUserID;
parameters[15].Value = model.ModifyTime;
parameters[16].Value = model.ModifyUserID;
parameters[17].Value = model.Remark;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_QS_RESULTDETAIL_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.QS_ResultDetail model)
{
SqlParameter[] parameters =
{
new SqlParameter("@QS_RDID", SqlDbType.Int, 4),
new SqlParameter("@ScoreType", SqlDbType.Int, 4),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@QS_CID", SqlDbType.Int, 4),
new SqlParameter("@QS_IID", SqlDbType.Int, 4),
new SqlParameter("@QS_SID", SqlDbType.Int, 4),
new SqlParameter("@QS_MID", SqlDbType.Int, 4),
new SqlParameter("@QS_MID_End", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@ScoreDeadID", SqlDbType.Int, 4),
new SqlParameter("@ScoreDeadID_End", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.QS_RDID;
parameters[1].Value = model.ScoreType;
parameters[2].Value = model.QS_RTID;
parameters[3].Value = model.QS_RID;
parameters[4].Value = model.QS_CID;
parameters[5].Value = model.QS_IID;
parameters[6].Value = model.QS_SID;
parameters[7].Value = model.QS_MID;
parameters[8].Value = model.QS_MID_End;
parameters[9].Value = model.Type;
parameters[10].Value = model.ScoreDeadID;
parameters[11].Value = model.ScoreDeadID_End;
parameters[12].Value = model.Status;
parameters[13].Value = model.CreateTime;
parameters[14].Value = model.CreateUserID;
parameters[15].Value = model.ModifyTime;
parameters[16].Value = model.ModifyUserID;
parameters[17].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_QS_RESULTDETAIL_UPDATE, parameters));
}
private Entities.QS_ResultDetail LoadSingleQS_ResultDetail(DataRow row)
{
Entities.QS_ResultDetail model = new Entities.QS_ResultDetail();
if (row["QS_RDID"].ToString() != "")
{
model.QS_RDID = int.Parse(row["QS_RDID"].ToString());
}
if (row["ScoreType"].ToString() != "")
{
model.ScoreType = int.Parse(row["ScoreType"].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());
}
if (row["QS_CID"].ToString() != "")
{
model.QS_CID = int.Parse(row["QS_CID"].ToString());
}
if (row["QS_IID"].ToString() != "")
{
model.QS_IID = int.Parse(row["QS_IID"].ToString());
}
if (row["QS_SID"].ToString() != "")
{
model.QS_SID = int.Parse(row["QS_SID"].ToString());
}
if (row["QS_MID"].ToString() != "")
{
model.QS_MID = int.Parse(row["QS_MID"].ToString());
}
if (row["QS_MID_End"].ToString() != "")
{
model.QS_MID_End = int.Parse(row["QS_MID_End"].ToString());
}
if (row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["ScoreDeadID"].ToString() != "")
{
model.ScoreDeadID = int.Parse(row["ScoreDeadID"].ToString());
}
if (row["ScoreDeadID_End"].ToString() != "")
{
model.ScoreDeadID_End = int.Parse(row["ScoreDeadID_End"].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());
}
if (row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
if (row["ModifyUserID"].ToString() != "")
{
model.ModifyUserID = int.Parse(row["ModifyUserID"].ToString());
}
model.Remark = row["Remark"].ToString();
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.QS_ResultDetail model)
{
return(Dal.QS_ResultDetail.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.QS_ResultDetail model)
{
return(Dal.QS_ResultDetail.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.QS_ResultDetail model)
{
return(Dal.QS_ResultDetail.Instance.Insert(model));
}
/// 审核时保存明细数据
/// <summary>
/// 审核时保存明细数据
/// </summary>
/// <param name="userID"></param>
/// <param name="sInfoData"></param>
/// <param name="model"></param>
/// <returns></returns>
private bool AuditResultDetail(int userID, QS_ResultData sInfoData, int QS_RID)
{
bool HaveDead = false;
if (sInfoData.QS_ResultDetailList != null && sInfoData.QS_ResultDetailList.Length > 0)
{
//插入新明细
for (int i = 0; i < sInfoData.QS_ResultDetailList.Length; i++)
{
Entities.QS_ResultDetail QS_ResultDetailModel = new Entities.QS_ResultDetail();
QS_ResultDetailModel.ScoreType = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreType);
QS_ResultDetailModel.QS_RTID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_RTID);
QS_ResultDetailModel.QS_RID = Convert.ToInt32(QS_RID);
if (sInfoData.QS_ResultDetailList[i].QS_MID == "-2" && sInfoData.QS_ResultDetailList[i].QS_MID_End == "-2" && sInfoData.QS_ResultDetailList[i].ScoreDeadID == "" && sInfoData.QS_ResultDetailList[i].ScoreDeadID_End == "")
{
continue;
}
if (sInfoData.QS_ResultDetailList[i].ScoreDeadID == "-2" && sInfoData.QS_ResultDetailList[i].ScoreDeadID_End == "-2" && sInfoData.QS_ResultDetailList[i].QS_MID == "" && sInfoData.QS_ResultDetailList[i].QS_MID_End == "")
{
continue;
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_CID))
{
QS_ResultDetailModel.QS_CID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_CID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_IID))
{
QS_ResultDetailModel.QS_IID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_IID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_SID))
{
QS_ResultDetailModel.QS_SID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_SID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_MID))
{
QS_ResultDetailModel.QS_MID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_MID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_MID_End))
{
QS_ResultDetailModel.QS_MID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_MID_End);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].Type))
{
QS_ResultDetailModel.Type = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].Type);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].ScoreDeadID))
{
QS_ResultDetailModel.ScoreDeadID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreDeadID);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].ScoreDeadID_End))
{
QS_ResultDetailModel.ScoreDeadID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreDeadID_End);
if (sInfoData.QS_ResultDetailList[i].ScoreDeadID_End != "-2")
{
HaveDead = true;
}
}
if (sInfoData.QS_ResultDetailList[i].ScoreType == "3" && !string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].Remark))
{
QS_ResultDetailModel.Remark = sInfoData.QS_ResultDetailList[i].Remark;
}
//更新
if (sInfoData.QS_ResultDetailList[i].QS_RDID != "" && sInfoData.QS_ResultDetailList[i].QS_RDID != "0")
{
Entities.QS_ResultDetail modelstate = BLL.QS_ResultDetail.Instance.GetQS_ResultDetail(Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_RDID));
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_MID_End))
{
modelstate.QS_MID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_MID_End);
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].ScoreDeadID_End))
{
modelstate.ScoreDeadID_End = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].ScoreDeadID_End);
}
if (sInfoData.QS_ResultDetailList[i].ScoreType == "3")
{
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].Remark))
{
modelstate.Remark = sInfoData.QS_ResultDetailList[i].Remark;
}
if (!string.IsNullOrEmpty(sInfoData.QS_ResultDetailList[i].QS_SID))
{
modelstate.QS_SID = Convert.ToInt32(sInfoData.QS_ResultDetailList[i].QS_SID);
}
}
modelstate.ModifyTime = System.DateTime.Now;
modelstate.ModifyUserID = userID;
BLL.QS_ResultDetail.Instance.Update(modelstate);
}
//插入
else
{
QS_ResultDetailModel.Status = 0;
QS_ResultDetailModel.CreateTime = System.DateTime.Now;
QS_ResultDetailModel.CreateUserID = userID;
BLL.QS_ResultDetail.Instance.Insert(QS_ResultDetailModel);
}
}
}
return(HaveDead);
}
