/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(SqlTransaction sqltran, Entities.ExamBSQuestionShip model)
{
SqlParameter[] parameters =
{
new SqlParameter("@BQID", SqlDbType.Int, 8),
new SqlParameter("@KLQID", SqlDbType.Int, 8),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.BQID;
parameters[1].Value = model.KLQID;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_EXAMBSQUESTIONSHIP_INSERT, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.ExamBSQuestionShip model)
{
SqlParameter[] parameters =
{
new SqlParameter("@BQID", SqlDbType.BigInt, 8),
new SqlParameter("@KLQID", SqlDbType.BigInt, 8),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.BQID;
parameters[1].Value = model.KLQID;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CONNECTIONSTRINGS, CommandType.StoredProcedure, P_EXAMBSQUESTIONSHIP_UPDATE, parameters));
}
private Entities.ExamBSQuestionShip LoadSingleExamBSQuestionShip(DataRow row)
{
Entities.ExamBSQuestionShip model = new Entities.ExamBSQuestionShip();
if (row["BQID"].ToString() != "")
{
model.BQID = long.Parse(row["BQID"].ToString());
}
if (row["KLQID"].ToString() != "")
{
model.KLQID = long.Parse(row["KLQID"].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);
}
public void Validate(out Entities.ExamPaper examPaper, out List <Entities.ExamBigQuestion> bigQList, out List <Entities.ExamBSQuestionShip> shipList, out string delBigQIDs, out string msg)
{
examPaper = null;
bigQList = null;
shipList = null;
delBigQIDs = DelBigQIDs;
msg = "";
#region 验证试卷信息
if (ExamPaper != null)
{
examPaper = new Entities.ExamPaper();
#region 验证
int intVal = 0;
if (ExamPaper.EPID != "" && !int.TryParse(ExamPaper.EPID, out intVal))
{
msg += "试卷ID应该为数字！";
}
if (ExamPaper.Name == "")
{
msg += "试卷名称不能为空！";
}
if (ExamPaper.ECID == "")
{
msg += "试卷分类不能为空！";
}
if (!int.TryParse(ExamPaper.ECID, out intVal))
{
msg += "试卷分类应该为数字！";
}
if (ExamPaper.ExamDesc == "")
{
msg += "试卷说明不能为空！";
}
if (ExamPaper.TotalScore == "")
{
msg += "总分不能为空！";
}
if (!int.TryParse(ExamPaper.TotalScore, out intVal))
{
msg += "总分应该为数字！";
}
#endregion
#region 赋值
if (msg == "")
{
if (ExamPaper.EPID != "" && int.TryParse(ExamPaper.EPID, out intVal))
{
examPaper.EPID = intVal;
}
examPaper.Name = ExamPaper.Name;
examPaper.ECID = int.Parse(ExamPaper.ECID);
examPaper.ExamDesc = ExamPaper.ExamDesc;
examPaper.TotalScore = int.Parse(ExamPaper.TotalScore);
examPaper.BGID = int.Parse(ExamPaper.BGID);
}
#endregion
}
#endregion
#region 验证试卷大题信息
if (ExamBigQuestioninfoList != null)
{
bigQList = new List <Entities.ExamBigQuestion>();
#region 验证
int intVal = 0;
foreach (ExamBigQuestionPageinfo item in ExamBigQuestioninfoList)
{
#region 验证大题数据
BigQPageInfo itemBigInfo = item.bigqpageinfo;
if (itemBigInfo != null)
{
if (itemBigInfo.BQID != "" && !int.TryParse(itemBigInfo.BQID, out intVal))
{
msg += "试卷大题ID应该为数字！";
}
}
if (itemBigInfo.EPID != "" && !int.TryParse(itemBigInfo.EPID, out intVal))
{
msg += "试卷大题的试卷ID应该为数字！";
}
if (itemBigInfo.Name == "")
{
msg += "试卷大题的名称不能为空！";
}
if (itemBigInfo.BQDesc == "")
{
msg += "试卷大题的描述不能为空！";
}
if (itemBigInfo.AskCategory == "")
{
msg += "试卷大题的题型不能为空！";
}
if (!int.TryParse(itemBigInfo.AskCategory, out intVal))
{
msg += "试卷大题的题型应该为数字！";
}
if (itemBigInfo.EachQuestionScore == "")
{
msg += "试卷大题的每题分值不能为空！";
}
if (!int.TryParse(itemBigInfo.EachQuestionScore, out intVal))
{
msg += "试卷大题的每题分值应该为数字！";
}
if (itemBigInfo.QuestionCount == "")
{
msg += "试卷大题的试题总量不能为空！";
}
if (!int.TryParse(itemBigInfo.QuestionCount, out intVal))
{
msg += "试卷大题的试题总量应该为数字！";
}
#endregion
#region 验证大小题关系数据
List <QuestinShipPageInfo> shiplist = item.shipList;
if (shiplist != null)
{
foreach (QuestinShipPageInfo shipItem in shiplist)
{
if (shipItem.BQID != "" && !int.TryParse(shipItem.BQID, out intVal))
{
msg += "大小题关系的大题ID应该为数字！";
}
if (shipItem.KLQID == "" && !int.TryParse(shipItem.KLQID, out intVal))
{
msg += "大小题关系的小题ID应该为数字！";
}
}
}
#endregion
}
#endregion
#region 赋值
if (msg == "")
{
bigQList = new List <Entities.ExamBigQuestion>();
shipList = new List <Entities.ExamBSQuestionShip>();
Entities.ExamBigQuestion bigQModel;
Entities.ExamBSQuestionShip shipModel;
int rownum = 0;
foreach (ExamBigQuestionPageinfo item in ExamBigQuestioninfoList)
{
#region 大题赋值
BigQPageInfo itemBigInfo = item.bigqpageinfo;
bigQModel = new Entities.ExamBigQuestion();
if (itemBigInfo.BQID != "")
{
bigQModel.BQID = int.Parse(itemBigInfo.BQID);
}
bigQModel.Name = itemBigInfo.Name;
bigQModel.BQDesc = itemBigInfo.BQDesc;
bigQModel.AskCategory = int.Parse(itemBigInfo.AskCategory);
bigQModel.EachQuestionScore = int.Parse(itemBigInfo.EachQuestionScore);
bigQModel.QuestionCount = int.Parse(itemBigInfo.QuestionCount);
bigQModel.NO = rownum++;
bigQList.Add(bigQModel);
#endregion
#region 大小题关系赋值
List <QuestinShipPageInfo> shiplist = item.shipList;
if (shiplist != null)
{
foreach (QuestinShipPageInfo shipItem in shiplist)
{
shipModel = new Entities.ExamBSQuestionShip();
if (shipItem.BQID != "")
{
shipModel.BQID = int.Parse(shipItem.BQID);
}
else if (itemBigInfo.BQID != "")
{
shipModel.BQID = int.Parse(itemBigInfo.BQID);
}
if (shipItem.KLQID != "")
{
shipModel.KLQID = int.Parse(shipItem.KLQID);
}
shipModel.NO = bigQModel.NO;
shipList.Add(shipModel);
}
}
#endregion
}
}
#endregion
}
#endregion
#region 验证删除的大题IDs
if (!String.IsNullOrEmpty(delBigQIDs))
{
long longval = 0;
string[] idslist = delBigQIDs.Split(',');
foreach (string item in idslist)
{
if (!long.TryParse(item, out longval))
{
msg += "删除的大题ID格式不正确！";
break;
}
}
}
#endregion
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.ExamBSQuestionShip model)
{
return(Dal.ExamBSQuestionShip.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ExamBSQuestionShip model)
{
return(Dal.ExamBSQuestionShip.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(SqlTransaction sqltran, Entities.ExamBSQuestionShip model)
{
Dal.ExamBSQuestionShip.Instance.Insert(sqltran, model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Entities.ExamBSQuestionShip model)
{
Dal.ExamBSQuestionShip.Instance.Insert(model);
}
