/// <summary>
///
/// </summary>
/// <param name="Resource"></param>
/// <returns></returns>
public int AddSaveResource(Model.T_Base_Resource Resource)
{
SqlConfig config = new SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "insert into T_Base_Resource values('"
+ Resource.Num + "'," + Resource.LectureId + ",'" + Resource.Content + "','" +
Resource.FilePosition1 + "','" + Resource.FilePosition2 + "','" +
Resource.FilePosition3 + "','" + DateTime.Now + "',0,0)";
int result = cmd.ExecuteNonQuery();
config.Close();
return(result);
}
public JsonResult AddSaveResource(string AddNum, int AddLectureId, string AddContent)
{
Model.T_Base_Resource resource = new Model.T_Base_Resource();
resource.Num = AddNum;
resource.LectureId = AddLectureId;
resource.Content = AddContent;
//文件保存
string fileName1 = "";
string fileName2 = "";
string fileName3 = "";
string path = Server.MapPath("\\upLoad\\");
var file1 = Request.Files["AddFilePosition1"];
if (file1.ContentLength != 0)
{
string[] strfileName1 = file1.FileName.Split('.');
string type1 = "." + strfileName1[strfileName1.Length - 1];
for (int i = 0; i < strfileName1.Length - 1; i++)
{
if (i != strfileName1.Length - 2)
{
fileName1 += strfileName1[i] + ".";
}
else
{
fileName1 += strfileName1[i];
}
}
fileName1 += DateTime.Now.ToString("yyyyMMddHHmmssffff") + type1;
file1.SaveAs(path + fileName1);
}
resource.FilePosition1 = fileName1;
resource.FilePosition2 = fileName2;
resource.FilePosition3 = fileName3;
int result = new BLL.T_Base_Resource().AddSaveResource(resource);
if (result == 1)
{
return(Json("评论成功"));
}
else
{
return(Json("评论失败"));
}
}
public List <Model.T_Base_Resource> GetAllResource(int LectureId)
{
List <Model.T_Base_Resource> list = new List <Model.T_Base_Resource>();
SqlConfig config = new SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select * from T_Base_Resource where LectureId = " + LectureId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Resource resource = new Model.T_Base_Resource();
resource.Id = Convert.ToInt32(reader["Id"]);
resource.Num = Convert.ToString(reader["Num"]);
resource.LectureId = Convert.ToInt32(reader["LectureId"]);
resource.Content = Convert.ToString(reader["Content"]);
if (reader["FilePosition1"].Equals(DBNull.Value))
{
resource.FilePosition1 = Convert.ToString(DBNull.Value);
}
else
{
resource.FilePosition1 = Convert.ToString(reader["FilePosition1"]);
}
if (reader["ResourceDate"].Equals(DBNull.Value))
{
resource.ResourceDate = Convert.ToDateTime(null);
}
else
{
resource.ResourceDate = Convert.ToDateTime(reader["ResourceDate"]);
}
resource.ReviewFlag = Convert.ToInt16(reader["ReviewFlag"]);
list.Add(resource);
}
reader.Close();
config.Close();
return(list);
}
/// <summary>
/// 审核评论
/// </summary>
/// <returns></returns>
public List <Model.T_Base_Resource> GetResourceMsg()
{
List <Model.T_Base_Resource> list = new List <Model.T_Base_Resource>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select Id,LectureId,Content from T_Base_Resource where ReViewFlag = 1 and MsgFlag = 0";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Resource resource = new Model.T_Base_Resource();
resource.Id = Convert.ToInt32(reader["Id"]);
resource.LectureId = Convert.ToInt32(reader["LectureId"]);
resource.Content = Convert.ToString(reader["Content"]);
list.Add(resource);
}
reader.Close();
config.Close();
return(list);
}
public int AddSaveResource(Model.T_Base_Resource Resource)
{
return(new DAL.T_Base_Resource().AddSaveResource(Resource));
}
