/// <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();
}
}
public bool Delete(SqlTransaction sqltran, string KLFAQIDs, out string msg)
{
KLFAQIDs = removeLastComma(KLFAQIDs);
string[] FAQIDArr = KLFAQIDs.Split(',');
try
{
msg = "";
foreach (string FAQID in FAQIDArr)
{
long faqID = long.Parse(FAQID);
Entities.KLFAQ FAQ = new Entities.KLFAQ();
FAQ = this.GetKLFAQ(faqID);
if (FAQ != null)
{
msg += "删除FAQ成功，ID：" + FAQID + ",问题：" + FAQ.Ask + "答案：" + FAQ.Question;
Delete(sqltran, faqID);
}
}
//写入日志
BLL.Util.InsertUserLog(msg);
return(true);
}
catch
{
msg = "FAQ删除失败！";
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.KLFAQ model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLFAQID", SqlDbType.BigInt, 8),
new SqlParameter("@KLID", SqlDbType.BigInt, 8),
new SqlParameter("@Ask", SqlDbType.NVarChar, 2000),
new SqlParameter("@Question", 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),
new SqlParameter("@KCID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.KLID;
parameters[2].Value = model.Ask;
parameters[3].Value = model.Question;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
parameters[8].Value = model.KCID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_KLFAQ_INSERT, parameters);
return(1);//(int)parameters[0].Value
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KLFAQ model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLFAQID", SqlDbType.BigInt, 8),
new SqlParameter("@KLID", SqlDbType.BigInt, 8),
new SqlParameter("@Ask", SqlDbType.NVarChar, 2000),
new SqlParameter("@Question", 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.KLID;
parameters[2].Value = model.Ask;
parameters[3].Value = model.Question;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KLFAQ_INSERT, parameters);
return(Convert.ToInt32(parameters[0].Value));
}
private Entities.KLFAQ LoadSingleKLFAQ(DataRow row)
{
Entities.KLFAQ model = new Entities.KLFAQ();
if (row["KLFAQID"].ToString() != "")
{
model.KLFAQID = long.Parse(row["KLFAQID"].ToString());
}
if (row["KLID"].ToString() != "")
{
model.KLID = long.Parse(row["KLID"].ToString());
}
model.Ask = row["Ask"].ToString();
model.Question = row["Question"].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);
}
public bool UpdateFAQs(SqlTransaction sqltran, List <Entities.KLFAQ> FAQList, long KLID)
{
string msg = "";
try
{
foreach (Entities.KLFAQ FAQ in FAQList)
{
FAQ.ModifyTime = DateTime.Now;
FAQ.ModifyUserID = Util.GetLoginUserID();
FAQ.KLID = KLID;
if (FAQ.KLFAQID == 0)
{//新增
FAQ.CreateTime = DateTime.Now;
FAQ.CreateUserID = Util.GetLoginUserID();
Insert(FAQ);
msg += "添加FAQ，问题：" + FAQ.Ask + ",答案：" + FAQ.Question + "；";
}
else
{//修改
Entities.KLFAQ FAQOri = new Entities.KLFAQ();
FAQOri = GetKLFAQ(FAQ.KLFAQID);
if (FAQ.Ask != FAQOri.Ask || FAQ.Question != FAQOri.Question)
{
msg += " 修改FAQ";
if (FAQ.Ask != FAQOri.Ask)
{
msg += ",问题由“" + FAQOri.Ask + "”改为“" + FAQ.Ask + "”";
}
else
{
msg += ",答案由“" + FAQOri.Question + "”改为“" + FAQ.Question + "”";
}
msg += ";";
Update(FAQ);
}
}
}
//写入日志
BLL.Util.InsertUserLog(msg);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KLFAQ model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLFAQID", SqlDbType.BigInt, 8),
new SqlParameter("@Ask", SqlDbType.NVarChar, 2000),
new SqlParameter("@Question", SqlDbType.NVarChar, 2000),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.KLFAQID;
parameters[1].Value = model.Ask;
parameters[2].Value = model.Question;
parameters[3].Value = model.ModifyTime;
parameters[4].Value = model.ModifyUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_KLFAQ_UPDATE, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KLFAQ model)
{
return(Dal.KLFAQ.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.KLFAQ model)
{
return(Dal.KLFAQ.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.KLFAQ model)
{
return(Dal.KLFAQ.Instance.Insert(sqltran, model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KLFAQ model)
{
return(Dal.KLFAQ.Instance.Insert(model));
}
