private Entities.KLAnswerOption LoadSingleKLAnswerOption(DataRow row)
{
Entities.KLAnswerOption model = new Entities.KLAnswerOption();
if (row["KLAOID"].ToString() != "")
{
model.KLAOID = long.Parse(row["KLAOID"].ToString());
}
if (row["KLQID"].ToString() != "")
{
model.KLQID = long.Parse(row["KLQID"].ToString());
}
model.Answer = row["Answer"].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());
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KLAnswerOption model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLAOID", SqlDbType.BigInt, 8),
new SqlParameter("@KLQID", SqlDbType.BigInt, 8),
new SqlParameter("@Answer", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.KLAOID;
parameters[1].Value = model.KLQID;
parameters[2].Value = model.Answer;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
parameters[5].Value = model.ModifyTime;
parameters[6].Value = model.ModifyUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_KLANSWEROPTION_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KLAnswerOption model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLAOID", SqlDbType.BigInt, 8),
new SqlParameter("@KLQID", SqlDbType.BigInt, 8),
new SqlParameter("@Answer", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.KLQID;
parameters[2].Value = model.Answer;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
parameters[5].Value = model.ModifyTime;
parameters[6].Value = model.ModifyUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KLANSWEROPTION_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 添加时的保存
/// </summary>
/// <param name="knowModel"></param>
/// <param name="faqModel"></param>
/// <param name="questionModel"></param>
/// <param name="answerModel"></param>
/// <param name="optionModel"></param>
/// <param name="errMsg"></param>
public void AddSave(Entities.KnowledgeLib knowModel, Entities.KLFAQ faqModel, Entities.KLQuestion questionModel, Entities.KLQAnswer answerModel, Entities.KLAnswerOption optionModel, out string errMsg)
{
errMsg = "";
SqlConnection connection = new SqlConnection(CONNECTIONSTRINGS);
connection.Open();
SqlTransaction sqlTran = connection.BeginTransaction("SampleTransaction");
try
{
int kid = Dal.KnowledgeLib.Instance.Insert(sqlTran, knowModel);
int faqId = Dal.KLFAQ.Instance.Insert(sqlTran, faqModel);
int questionId = Dal.KLQuestion.Instance.Insert(sqlTran, questionModel);
Dal.KLQAnswer.Instance.Insert(sqlTran, answerModel);
int optionId = Dal.KLAnswerOption.Instance.Insert(sqlTran, optionModel);
}
catch (Exception ex)
{
sqlTran.Rollback();
errMsg = ex.Message.ToString();
}
finally
{
connection.Close();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KLAnswerOption model)
{
return(Dal.KLAnswerOption.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.KLAnswerOption model)
{
return(Dal.KLAnswerOption.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KLAnswerOption model)
{
return(Dal.KLAnswerOption.Instance.Insert(model));
}
