/// <summary>
/// 显示所有
/// </summary>
/// <param name="PageCount">PageCount</param>
/// <param name="PageSize">PageSize</param>
/// <param name="Type">类型(试卷?问卷)</param>
/// <param name="CourseID">课程ID</param>
/// <returns></returns>
public List <Model.Papers> GetList(int PageCount, int PageSize, string Type, int CourseID)
{
string strSql = "";
string RedCountsql = "";
int RowTotal = (PageCount - 1) * PageSize;//
RedCountsql = "(select count(ID) from [Papers] Where [CourseID]='" + CourseID + "' and [Type]='" + Type + "' ) as RowTotal";
strSql = "Select Top " + PageSize + " *," + RedCountsql + " FROM [Papers] where [ID] not in (Select Top " + RowTotal + " [ID] from [Papers] Where [CourseID]='" + CourseID + "' and [Type]='" + Type + "' ORDER BY ID DESC) and [CourseID]='" + CourseID + "' and [Type]='" + Type + "' ORDER BY ID DESC";
List <Model.Papers> List = new List <Model.Papers>();
SqlParameter[] parameters =
{
};
using (SqlDataReader DR = ExamSys.ExecuteReader(strSql.ToString(), parameters))
{
while (DR.Read())
{
Model.Papers model = new Model.Papers();
model.RowTotal = int.Parse(DR["RowTotal"].ToString());
model.ID = int.Parse(DR["ID"].ToString());
model.Name = DR["Name"].ToString();
model.CourseID = int.Parse(DR["CourseID"].ToString());
model.Type = DR["Type"].ToString();
model.Lock = int.Parse(DR["Lock"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 详细信息
/// </summary>
/// <param name="ID">ID</param>
/// <returns></returns>
public List <Model.Papers> Details(int ID)
{
string strSql = "";
strSql = "Select * FROM [Papers] Where [ID]='" + ID + "'";
List <Model.Papers> List = new List <Model.Papers>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.Papers model = new Model.Papers();
model.ID = int.Parse(DR["ID"].ToString());
model.Name = DR["Name"].ToString();
model.CourseID = int.Parse(DR["CourseID"].ToString());
model.Type = DR["Type"].ToString();
model.Lock = int.Parse(DR["Lock"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
protected void gv01_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int ID = int.Parse(gv01.DataKeys[e.RowIndex]["ID"].ToString());
BLL.Papers bll = new BLL.Papers();
Model.Papers model = new Model.Papers();
List <Model.Papers> list = new List <Model.Papers>();
list = bll.Details(ID);
model.ID = ID;
model.Name = list[0].Name;
if (list[0].Lock > 0)
{
model.Lock = 0;
}
else
{
model.Lock = 1;
}
if (bll.Updata(model) > 0)
{
Common.Function.Redirect("List.aspx?TitleType=" + Request.QueryString["TitleType"] + "&CourseID=" + lb_CourseID.Text);
}
else
{
Common.Function.AlertRedirect("系统繁忙！", "List.aspx?TitleType=" + Request.QueryString["TitleType"] + "&CourseID=" + lb_CourseID.Text);
}
}
public bool Add(Model.Papers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Papers2(");
strSql.Append("id,name,title,url,authorId)");
strSql.Append(" values (");
strSql.Append("@id,@name,@title,@url,@authorId)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar, 100),
new SqlParameter("@name", SqlDbType.NVarChar, 100),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@url", SqlDbType.NVarChar, 100),
new SqlParameter("@authorId", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Title;
parameters[3].Value = model.Url;
parameters[4].Value = model.AuthorId;
int rows = SqlHelp.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void LoadEntity(Model.Papers model, DataRow row)
{
model.Id = row["id"].ToString();
model.Name = row["name"].ToString();
model.Title = row["Title"].ToString();
model.Url = row["Url"].ToString();
model.AuthorId = row["AuthorId"].ToString();
}
/// <summary>
/// 添加试卷
/// </summary>
private void Papers()
{
BLL.Papers bll = new BLL.Papers();
Model.Papers model = new Model.Papers();
model.Name = Common.Function.StringEncode(tb_Name.Text.Trim());
model.CourseID = int.Parse(lb_CourseID.Text);
model.Type = Request.QueryString["TitleType"];
PapersID = bll.Add(model);
if (PapersID > 0)
{
}
else
{
Common.Function.AlertRedirect("系统繁忙！", "Auto.aspx?TitleType=" + Request.QueryString["TitleType"] + "&CourseID=" + int.Parse(lb_CourseID.Text));
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Updata(Model.Papers model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@ReturnValue", SqlDbType.Int),
new SqlParameter("@Lock", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@ID", SqlDbType.Int),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Lock;
parameters[2].Value = model.Name;
parameters[3].Value = model.ID;
ExamSys.RunProcedure("Papers_Updata", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
protected void imgbt_Save_Click(object sender, ImageClickEventArgs e)
{
BLL.Papers bll = new BLL.Papers();
Model.Papers model = new Model.Papers();
model.Name = Common.Function.StringEncode(tb_Name.Text.Trim());
model.CourseID = int.Parse(lb_CourseID.Text);
model.Type = Request.QueryString["TitleType"];
int PapersID = bll.Add(model);
if (PapersID > 0)
{
AddPapersTitleList(PapersID);
}
else
{
Common.Function.AlertRedirect("系统繁忙！", "Add.aspx?TitleType=" + Request.QueryString["TitleType"] + "&CourseID=" + int.Parse(lb_CourseID.Text));
}
}
public List <Model.Papers> GetAllList()
{
string sql = "select * from Papers2 ";
DataTable dt = SqlHelp.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
List <Model.Papers> list = new List <Model.Papers>();
foreach (DataRow row in dt.Rows)
{
Model.Papers model = new Model.Papers();
LoadEntity(model, row);
list.Add(model);
}
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// 保存试卷
/// </summary>
/// <param name="context"></param>
private void SavePaper(HttpContext context)
{
string Name = context.Request["Name"].ToString(); //类别ID
int CourseID = int.Parse(context.Request["CourseID"].ToString()); //课程ID
string TitleType = context.Request["Type"].ToString(); //类型
string TitleID = context.Request["array"].ToString(); //题目ID字符串
int StatusID = int.Parse(context.Request["Status_id"].ToString());
//string[] arrayTitle = DelLastComma(TitleID).Split(',');
string[] arrayTitle = TitleID.Split(',');
string str_score = context.Request["str_score"].ToString();//分数字符串
//string[] arrayScore= DelLastComma(str_score).Split(',');
string[] arrayScore = str_score.Split(',');
//context.Response.Write("{\"status\": 0, \"msg\": \"系统繁忙！\"}");
//return;
BLL.Papers bll = new BLL.Papers();
Model.Papers model = new Model.Papers();
model.Name = Common.Function.StringEncode(Name);
model.CourseID = CourseID;
model.Type = TitleType;
int PapersID = bll.Add(model);
if (PapersID > 0)
{
AddPapersTitleList(PapersID, arrayTitle, arrayScore, CourseID, StatusID);
}
else
{
context.Response.Write("{\"status\": 0, \"msg\": \"系统繁忙！\"}");
return;
}
context.Response.Write("{\"status\": 1, \"msg\": \"保存成功！\"}");
return;
}
public bool Add(Model.Papers model)
{
return(dal.Add(model));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
CommentMethods commentMethods = new CommentMethods();
string articleName = context.Request.Form["articleName"]; //文章名字
string authorName = context.Request.Form["authorName"]; //文章名字
string content = context.Request.Form["content"]; //base64字节
#region 切割base64
string str = "base64,";
int index = content.IndexOf(str) + str.Length;
int end = content.Length - index;
content = content.Substring(index, end);
#endregion
string path = context.Server.MapPath("../Papers/system/");
Random rd = new Random();
string fileName = DateTime.Now.ToString("yyyyMMddhhmmss") + "-" + rd.Next(100, 999).ToString() + "-" + articleName;
byte[] buff = Convert.FromBase64String(content);
if (commentMethods.ByteToFile(content, path, fileName))
{
Bll.AuthorBll authorBll = new Bll.AuthorBll();
var author = new Model.Author()
{
Id = Guid.NewGuid().ToString(),
Name = authorName,
Adress = "",
Email = ""
};
if (authorBll.Add(author))
{
Bll.PapersBll papersBll = new Bll.PapersBll();
var paper = new Model.Papers()
{
Id = Guid.NewGuid().ToString(),
AuthorId = author.Id,
Name = articleName,
Url = "../Papers/system/" + fileName,
Title = ""
};
if (papersBll.Add(paper))
{
var ketWords = commentMethods.GetKeyWord(commentMethods.GetAll(path + fileName));
Bll.KeyWordsBll keyWordsBll = new Bll.KeyWordsBll();
var keyWord = new Model.KeyWords()
{
Id = Guid.NewGuid().ToString(),
PaperId = paper.Id,
KeyWord1 = ketWords[0],
KeyWord2 = ketWords[1],
KeyWord3 = ketWords[2],
KeyWord4 = ketWords[3],
KeyWord5 = ketWords[4],
KeyWord6 = ketWords[5],
};
if (keyWordsBll.Add(keyWord))
{
context.Response.Write(JsonConvert.SerializeObject(new ReturnMessage()
{
Code = 1, Message = "添加成功"
}));
}
}
}
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public int Updata(Model.Papers model)
{
return(dal.Updata(model));
}
/// <summary>
/// 添加
/// </summary>
public int Add(Model.Papers model)
{
return(dal.Add(model));
}