/// <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();
}
}
//修改KnowledgeLib表
private void updateKnowledgeLib(SqlTransaction sqltran, Entities.KnowledgeLib model)
{
if (model != null)
{
BLL.KnowledgeLib.Instance.Update(sqltran, model);
}
}
protected void Page_Load(object sender, EventArgs e)
{
int kid = 0;
if (!IsPostBack)
{
int userID = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userID, "SYS024BUT3101") && !BLL.Util.CheckRight(userID, "SYS024BUT3102"))
{
Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限"));
Response.End();
}
if (int.TryParse(KID, out kid))
{
Entities.KnowledgeLib info = BLL.KnowledgeLib.Instance.GetKnowledgeLib(kid);
if (info != null)
{
if (BLL.KnowledgeLib.Instance.IsExistQuestion(kid))
{
Control ctl = this.LoadControl("~/KnowledgeLib/UCKnowledgeLib/UCQuestionView.ascx", kid);
this.phQuestion.Controls.Add(ctl);
}
status = info.Status.ToString();
}
}
}
}
private void BindKnowledgeInfo()
{
Entities.KnowledgeLib model = BLL.KnowledgeLib.Instance.GetKnowledgeLib(long.Parse(KID));
if (model != null)
{
this.txtTitle.Value = model.Title;
// this.txtContext.Value = BLL.Util.HtmlDiscode(model.Content);
this.FCKeditor1.Value = BLL.KnowledgeLib.Instance.GetKnowledgeHtml(long.Parse(KID));
this.txtAbstract.Value = model.Abstract;
status = model.Status.ToString();;
#region 知识点级别
Entities.KnowledgeCategory category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (category != null)
{
Level = category.Level.ToString();
if (Level == "3")
{
Level3ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level2ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1ID = category.KCID.ToString();
}
}
}
else if (Level == "2")
{
Level2ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1ID = category.KCID.ToString();
}
}
else if (Level == "1")
{
Level1ID = category.KCID.ToString();
}
KCID = model.KCID.ToString();
}
#endregion
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(Entities.KnowledgeLib model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLID", SqlDbType.BigInt, 8),
new SqlParameter("@KLNum", SqlDbType.VarChar, 20),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@KCID", SqlDbType.Int, 4),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@IsHistory", SqlDbType.Int, 4),
new SqlParameter("@RejectReason", SqlDbType.NVarChar, 200),
new SqlParameter("@UploadFileCount", SqlDbType.Int, 4),
new SqlParameter("@FAQCount", SqlDbType.Int, 4),
new SqlParameter("@QuestionCount", SqlDbType.Int, 4),
new SqlParameter("@Abstract", SqlDbType.NVarChar, 1000),
new SqlParameter("@FileUrl", SqlDbType.NVarChar, 1000)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.KLNum;
parameters[2].Value = model.Title;
parameters[3].Value = model.KCID;
parameters[4].Value = model.Content;
parameters[5].Value = model.Status;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreateUserID;
parameters[8].Value = model.LastModifyTime;
parameters[9].Value = model.LastModifyUserID;
parameters[10].Value = model.IsHistory;
parameters[11].Value = model.RejectReason;
parameters[12].Value = model.UploadFileCount;
parameters[13].Value = model.FAQCount;
parameters[14].Value = model.QuestionCount;
parameters[15].Value = model.Abstract;
parameters[16].Value = model.FileUrl;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KNOWLEDGELIB_INSERT, parameters);
long retval = 0;
if (long.TryParse(parameters[0].Value.ToString(), out retval))
{
}
return(retval);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.KnowledgeLib model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLID", SqlDbType.Int, 8),
new SqlParameter("@KLNum", SqlDbType.VarChar, 20),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@KCID", SqlDbType.Int, 4),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@IsHistory", SqlDbType.Int, 4),
new SqlParameter("@RejectReason", SqlDbType.NVarChar, 200),
new SqlParameter("@UploadFileCount", SqlDbType.Int, 4),
new SqlParameter("@FAQCount", SqlDbType.Int, 4),
new SqlParameter("@QuestionCount", SqlDbType.Int, 4),
new SqlParameter("@Abstract", SqlDbType.NVarChar, 1000),
new SqlParameter("@FileUrl", SqlDbType.NVarChar, 1000)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.KLNum;
parameters[2].Value = model.Title;
parameters[3].Value = model.KCID;
parameters[4].Value = model.Content;
parameters[5].Value = model.Status;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreateUserID;
parameters[8].Value = model.LastModifyTime;
parameters[9].Value = model.LastModifyUserID;
parameters[10].Value = model.IsHistory;
parameters[11].Value = model.RejectReason;
parameters[12].Value = model.UploadFileCount;
parameters[13].Value = model.FAQCount;
parameters[14].Value = model.QuestionCount;
parameters[15].Value = model.Abstract;
parameters[16].Value = model.FileUrl;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_KNOWLEDGELIB_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.KnowledgeLib model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KLID", SqlDbType.BigInt, 8),
new SqlParameter("@KLNum", SqlDbType.VarChar, 20),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@KCID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@IsHistory", SqlDbType.Int, 4),
new SqlParameter("@RejectReason", SqlDbType.NVarChar, 200),
new SqlParameter("@UploadFileCount", SqlDbType.Int, 4),
new SqlParameter("@FAQCount", SqlDbType.Int, 4),
new SqlParameter("@QuestionCount", SqlDbType.Int, 4),
new SqlParameter("@Abstract", SqlDbType.NVarChar, 1000),
new SqlParameter("@FileUrl", SqlDbType.NVarChar, 256)
};
parameters[0].Value = model.KLID;
parameters[1].Value = model.KLNum;
parameters[2].Value = model.Title;
parameters[3].Value = model.KCID;
parameters[4].Value = model.Status;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
parameters[7].Value = model.LastModifyTime;
parameters[8].Value = model.LastModifyUserID;
parameters[9].Value = model.IsHistory;
parameters[10].Value = model.RejectReason;
parameters[11].Value = model.UploadFileCount;
parameters[12].Value = model.FAQCount;
parameters[13].Value = model.QuestionCount;
parameters[14].Value = model.Abstract;
parameters[15].Value = model.FileUrl;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KNOWLEDGELIB_UPDATE, parameters));
}
public void ProcessRequest(HttpContext context)
{
BitAuto.YanFa.SysRightManager.Common.UserInfo.Check();
context.Response.ContentType = "text/plain";
string errMsg = "";
int kid = 0;
#region 录音共享保存
if (Action == "RecordingSharingSave")
{
try
{
Entities.KnowledgeLib model = new Entities.KnowledgeLib();
model.Title = RequestTitle;
if (int.TryParse(RequestKCID, out kid))
{
model.KCID = kid;
}
model.Abstract = RequestKAbstract;
model.FileUrl = RequestFileUrl;
model.Status = 1;//待审核
model.CreateTime = DateTime.Now;
model.CreateUserID = BLL.Util.GetLoginUserID();
model.KLNum = "KL" + BLL.KnowledgeLib.Instance.GetCurrMaxID().ToString().PadLeft(7, '0');
model.LastModifyTime = DateTime.Now;
model.LastModifyUserID = BLL.Util.GetLoginUserID();
model.IsHistory = 0;
model.RejectReason = "";
model.UploadFileCount = 1;
model.FAQCount = 0;
model.QuestionCount = 0;//试题数量
BLL.KnowledgeLib.Instance.Insert(model);
}
catch (Exception ex)
{
errMsg = ex.Message;
}
if (errMsg != "")
{
context.Response.Write("{'result':'Error','errMsg':'" + errMsg + "'}");
}
else
{
context.Response.Write("{'result':'success','errMsg':''}");
}
return;
}
#endregion
KnowledgeLibHelper knowledgelibhelper = new KnowledgeLibHelper();
try
{
int userID = BLL.Util.GetLoginUserID();
knowledgelibhelper.SubmitCheckInfo(userID, out errMsg, Action, out kid, IsManager, RequestSingleInfo);
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
if (errMsg != "")
{
context.Response.Write("{'result':'Error','kid':'" + errMsg + "'}");
}
else
{
context.Response.Write("{'result':'success','kid':'" + kid.ToString() + "'}");
}
}
//审批通过、驳回、停用、删除公用方法：将得到的KLID串进行分解，分别单条操作，同时进行提醒；
//n=1:审批通过；n=2:驳回；n=3:停用；n=4:删除
private void operateKnowledgeLib(int n, SqlTransaction sqltran, out string msg)
{
msg = string.Empty;
if (RequestKLID != "")
{
string[] KLIDs = RequestKLID.Split(',');
for (int i = 0; i < KLIDs.Length; i++)
{
long _klid;
if (long.TryParse(KLIDs[i], out _klid))
{
Entities.KnowledgeLib model = BLL.KnowledgeLib.Instance.GetKnowledgeLib(_klid);
if (model != null)
{
switch (n)
{
case 1:
//审核通过前的状态必须为1：待审核；
if (model.Status == 1)
{
model.Status = 2;
updateKnowledgeLib(sqltran, model);
#region 设置所有用户对当前知识点为未读
BLL.KLReadTag.Instance.UpdateTagByKLID(sqltran, _klid, 0);
#endregion
BLL.Util.InsertUserLog(sqltran, "【审核通过】知识库信息表【审核通过】知识点ID：【" + _klid + "】将操作状态【待审核】修改为：【审核通过】的记录");
}
msg = "{'msg':'审批通过操作成功'}";
break;
case 2:
//驳回前的状态必须为1：待审核；
if (model.Status == 1)
{
model.Status = -1;
model.RejectReason = HttpUtility.UrlDecode(RequestRejectReason); //驳回理由
updateKnowledgeLib(sqltran, model);
BLL.Util.InsertUserLog(sqltran, "【驳回】知识库信息表【驳回】知识点ID：【" + _klid + "】将操作状态【待审核】修改为：【驳回】驳回理由：【" + RequestRejectReason + "】的记录");
}
msg = "{'msg':'驳回操作成功'}";
break;
case 3:
//停用前的状态必须为2：审核通过；
if (model.Status == 2)
{
model.Status = 3;
updateKnowledgeLib(sqltran, model);
BLL.Util.InsertUserLog(sqltran, "【停用】知识库信息表【停用】知识点ID：【" + _klid + "】将操作状态【审核通过】修改为：【停用】的记录");
}
msg = "{'msg':'停用操作成功'}";
break;
case 4:
//删除前的状态只要不为删除都可以进行删除
if (model.Status != 4)
{
model.Status = 4;
updateKnowledgeLib(sqltran, model);
BLL.Util.InsertUserLog(sqltran, "【删除】知识库信息表【删除】知识点ID：【" + _klid + "】将操作状态【" + getStatusNameBylib(int.Parse(model.Status.ToString())) + "】修改为：【删除】的记录");
}
msg = "{'msg':'删除操作成功'}";
break;
}
}
}
}
}
}
private Entities.KnowledgeLib LoadSingleKnowledgeLib(DataRow row)
{
Entities.KnowledgeLib model = new Entities.KnowledgeLib();
if (row["KLID"].ToString() != "")
{
model.KLID = long.Parse(row["KLID"].ToString());
}
model.KLNum = row["KLNum"].ToString();
model.Title = row["Title"].ToString();
if (row["KCID"].ToString() != "")
{
model.KCID = int.Parse(row["KCID"].ToString());
}
// model.Content = row["Content"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
model.Abstract = row["Abstract"].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["LastModifyTime"].ToString() != "")
{
model.LastModifyTime = DateTime.Parse(row["LastModifyTime"].ToString());
}
if (row["LastModifyUserID"].ToString() != "")
{
model.LastModifyUserID = int.Parse(row["LastModifyUserID"].ToString());
}
if (row["IsHistory"].ToString() != "")
{
model.IsHistory = int.Parse(row["IsHistory"].ToString());
}
model.RejectReason = row["RejectReason"].ToString();
if (row["UploadFileCount"].ToString() != "")
{
model.UploadFileCount = int.Parse(row["UploadFileCount"].ToString());
}
if (row["FAQCount"].ToString() != "")
{
model.FAQCount = int.Parse(row["FAQCount"].ToString());
}
if (row["QuestionCount"].ToString() != "")
{
model.QuestionCount = int.Parse(row["QuestionCount"].ToString());
}
if (row["DownLoadCount"].ToString() != "")
{
model.DownLoadCount = int.Parse(row["DownLoadCount"].ToString());
}
if (row["FileUrl"].ToString() != "")
{
model.FileUrl = row["FileUrl"].ToString();
}
if (row["clickcount"].ToString() != "")
{
model.ClickCount = Convert.ToInt32(row["clickcount"]);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KnowledgeLib model)
{
return(Dal.KnowledgeLib.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.KnowledgeLib model)
{
return(Dal.KnowledgeLib.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(Entities.KnowledgeLib model)
{
return(Dal.KnowledgeLib.Instance.Insert(model));
}
private void BindKnowledgeInfo()
{
Entities.KnowledgeLib model = BLL.KnowledgeLib.Instance.GetKnowledgeLib(long.Parse(KID));
if (model != null)
{
FileUrl = model.FileUrl == null ? "" : "/upload/" + (BLL.Util.GetUploadProject(BLL.Util.ProjectTypePath.KnowledgeLib) + model.FileUrl).Replace("\\", "/");
lbCreateTime.Text = model.CreateTime.Value.ToString("yyyy-M-d");
lbClickCount.Text = model.ClickCount < 0 ? "0" : model.ClickCount.ToString();
lbDownCount.Text = model.DownLoadCount < 0 ? "0" : model.DownLoadCount.ToString();
hdAbs.Value = string.IsNullOrEmpty(model.Abstract) ? "" : model.Abstract;
this.txtTitle.InnerText = model.Title;
try
{
this.txtContext.InnerHtml = BLL.KnowledgeLib.Instance.GetKnowledgeHtml(long.Parse(KID));
blIsContentEmpty = string.IsNullOrEmpty(this.txtContext.InnerHtml);
}
catch
{
}
//给摘要赋值
Entities.KnowledgeCategory categortyModel = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (model.UploadFileCount > 0)
{
IsHaveFiles = "1";
}
#region 知识点级别
Entities.KnowledgeCategory category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (category != null)
{
//lbC.Text = category.Name;
Level = category.Level.ToString();
if (Level == "3")
{
Level3Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level2Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1Name = category.Name.ToString();
}
}
}
else if (Level == "2")
{
Level2Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1Name = category.Name.ToString();
}
}
else if (Level == "1")
{
Level1Name = category.Name.ToString();
}
}
lbC.Text = Level1Name + "--" + Level2Name;
/*
* string catageName = "";
*
*
* if (Level3Name != "")
* {
* catageName = Level3Name;
* }
* else if (Level2Name != "")
* {
* catageName = Level2Name;
* }
* else if (Level1Name != "")
* {
* catageName = Level1Name;
* }
*/
//this.txtCategory.InnerHtml = DateTime.Parse(model.CreateTime.ToString()).ToString("yyyy-MM-dd") + " " + catageName;
#endregion
}
}
