/// <summary>
/// 新建学案，返回学案编号
/// </summary>
/// <param name="dtCourse"></param>
/// <returns></returns>
private static int CreateCourse(DataTable dtCourse, int cobj, int Hid)
{
int newCid = 0;
LearnSite.Model.Courses cs = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
cs = bll.GetTableModel(dtCourse);//获得学案的model
int thisCid = cs.Cid;
string thisCcontent = cs.Ccontent;
cs.Cterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm()); //替换成当前学期
cs.Cdate = DateTime.Now;
cs.Cobj = cobj; //替换成当前年级
cs.Cks = bll.CksMaxValue(cs.Cterm.Value, cs.Cobj.Value, Hid); //替换成当前年级的最新课节
cs.Chid = Hid;
cs.Cfiletype = "txt";
newCid = bll.Add(cs);//获得新增学案的Cid
string oldstr = "Store/" + thisCid.ToString();
string newstr = "Store/" + newCid.ToString();
string newCcontent = thisCcontent.Replace(oldstr, newstr); //替换链接地址
bll.UpdateCcontent(newCid, newCcontent); //更新内容
return(newCid);
}
/// <summary>
/// 学案xml序列化（不用）
/// </summary>
/// <param name="Cid"></param>
/// <returns></returns>
public static bool SerialiazeCourse(int Cid)
{
LearnSite.Model.Courses course = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
course = bll.GetModel(Cid);
string xmlCoursePath = CourseCidPath(Cid);
if (!Directory.Exists(xmlCoursePath)) //如果不存在该目录，则创建
{
Directory.CreateDirectory(xmlCoursePath);
}
string xmlCourseName = xmlCoursePath + @"\" + Cid + ".xml";
if (File.Exists(xmlCourseName))
{
File.Delete(xmlCourseName);
}
XmlSerializer xs = new XmlSerializer(typeof(LearnSite.Model.Courses));
Stream stream = new FileStream(xmlCourseName, FileMode.Create, FileAccess.Write, FileShare.ReadWrite);
xs.Serialize(stream, course);
stream.Close();
if (File.Exists(xmlCourseName))
{
return(true);
}
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LearnSite.Model.Courses model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Courses set ");
strSql.Append("Ctitle=@Ctitle,");
strSql.Append("Cclass=@Cclass,");
strSql.Append("Ccontent=@Ccontent,");
strSql.Append("Cdate=@Cdate,");
strSql.Append("Chit=@Chit,");
strSql.Append("Cobj=@Cobj,");
strSql.Append("Cterm=@Cterm,");
strSql.Append("Cks=@Cks,");
strSql.Append("Cfiletype=@Cfiletype,");
strSql.Append("Cupload=@Cupload,");
strSql.Append("Chid=@Chid,");
strSql.Append("Cpublish=@Cpublish");
strSql.Append(" where Cid=@Cid ");
SqlParameter[] parameters =
{
new SqlParameter("@Cid", SqlDbType.Int, 4),
new SqlParameter("@Ctitle", SqlDbType.NVarChar, 50),
new SqlParameter("@Cclass", SqlDbType.NVarChar, 50),
new SqlParameter("@Ccontent", SqlDbType.NText),
new SqlParameter("@Cdate", SqlDbType.DateTime),
new SqlParameter("@Chit", SqlDbType.Int, 4),
new SqlParameter("@Cobj", SqlDbType.Int, 4),
new SqlParameter("@Cterm", SqlDbType.Int, 4),
new SqlParameter("@Cks", SqlDbType.Int, 4),
new SqlParameter("@Cfiletype", SqlDbType.NVarChar, 50),
new SqlParameter("@Cupload", SqlDbType.Bit, 1),
new SqlParameter("@Chid", SqlDbType.Int, 4),
new SqlParameter("@Cpublish", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Cid;
parameters[1].Value = model.Ctitle;
parameters[2].Value = model.Cclass;
parameters[3].Value = model.Ccontent;
parameters[4].Value = model.Cdate;
parameters[5].Value = model.Chit;
parameters[6].Value = model.Cobj;
parameters[7].Value = model.Cterm;
parameters[8].Value = model.Cks;
parameters[9].Value = model.Cfiletype;
parameters[10].Value = model.Cupload;
parameters[11].Value = model.Chid;
parameters[12].Value = model.Cpublish;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.Courses model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Courses(");
strSql.Append("Ctitle,Cclass,Ccontent,Cdate,Chit,Cobj,Cterm,Cks,Cfiletype,Cupload,Chid,Cpublish)");
strSql.Append(" values (");
strSql.Append("@Ctitle,@Cclass,@Ccontent,@Cdate,@Chit,@Cobj,@Cterm,@Cks,@Cfiletype,@Cupload,@Chid,@Cpublish)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Ctitle", SqlDbType.NVarChar, 50),
new SqlParameter("@Cclass", SqlDbType.NVarChar, 50),
new SqlParameter("@Ccontent", SqlDbType.NText),
new SqlParameter("@Cdate", SqlDbType.DateTime),
new SqlParameter("@Chit", SqlDbType.Int, 4),
new SqlParameter("@Cobj", SqlDbType.Int, 4),
new SqlParameter("@Cterm", SqlDbType.Int, 4),
new SqlParameter("@Cks", SqlDbType.Int, 4),
new SqlParameter("@Cfiletype", SqlDbType.NVarChar, 50),
new SqlParameter("@Cupload", SqlDbType.Bit, 1),
new SqlParameter("@Chid", SqlDbType.Int, 4),
new SqlParameter("@Cpublish", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Ctitle;
parameters[1].Value = model.Cclass;
parameters[2].Value = model.Ccontent;
parameters[3].Value = model.Cdate;
parameters[4].Value = model.Chit;
parameters[5].Value = model.Cobj;
parameters[6].Value = model.Cterm;
parameters[7].Value = model.Cks;
parameters[8].Value = model.Cfiletype;
parameters[9].Value = model.Cupload;
parameters[10].Value = model.Chid;
parameters[11].Value = model.Cpublish;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 将指定Cid从xml内容读到model中
/// </summary>
/// <param name="Cid"></param>
/// <returns></returns>
public static LearnSite.Model.Courses course(int Cid)
{
LearnSite.Model.Courses cs = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
string xmlFile = XmlFilename(Cid);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
if (xmlFile != "")
{
ds.ReadXml(xmlFile);//读取xml文件到ds
dt = ds.Tables["Course"];
cs = bll.GetTableModel(dt);
ds.Dispose();
return cs;
}
else
{
ds.Dispose();
return null;
}
}
/// <summary>
/// 将指定Cid从xml内容读到model中
/// </summary>
/// <param name="Cid"></param>
/// <returns></returns>
public static LearnSite.Model.Courses course(int Cid)
{
LearnSite.Model.Courses cs = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
string xmlFile = XmlFilename(Cid);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
if (xmlFile != "")
{
ds.ReadXml(xmlFile);//读取xml文件到ds
dt = ds.Tables["Course"];
cs = bll.GetTableModel(dt);
ds.Dispose();
return(cs);
}
else
{
ds.Dispose();
return(null);
}
}
/// <summary>
/// 新建课程，返回课程编号
/// </summary>
/// <param name="dtCourse"></param>
/// <returns></returns>
private static int CreateCourse(DataTable dtCourse)
{
LearnSite.Model.Courses cs = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
cs = bll.GetTableModel(dtCourse);//获得课程的model
int thisCid = cs.Cid;
string thisCcontent = cs.Ccontent;
int maxCid = bll.GetMaxId();
string oldstr = "Store/"+thisCid.ToString();
string newstr = "Store/" + maxCid.ToString();
cs.Ccontent = thisCcontent.Replace(oldstr, newstr);//替换链接地址
cs.Cterm =Int32.Parse( LearnSite.Common.XmlHelp.GetTerm());//替换成当前学期
cs.Cdate = DateTime.Now;
if (HttpContext.Current.Session["importgrade"] != null)
{
cs.Cobj = int.Parse(HttpContext.Current.Session["importgrade"].ToString());//替换成当前年级
cs.Cks = bll.CksMaxValue(cs.Cterm.Value, cs.Cobj.Value);//替换成当前年级的最新课时
}
if (HttpContext.Current.Request.Cookies["TeacherCookies"] != null)
{
cs.Chid = Int32.Parse(HttpContext.Current.Request.Cookies["TeacherCookies"].Values["Hid"].ToString());
}
int newCid = bll.Add(cs);//获得新增课程的Cid
return newCid;
}
/// <summary>
/// 课程xml序列化（不用）
/// </summary>
/// <param name="Cid"></param>
/// <returns></returns>
public static bool SerialiazeCourse(int Cid)
{
LearnSite.Model.Courses course = new LearnSite.Model.Courses();
LearnSite.BLL.Courses bll = new LearnSite.BLL.Courses();
course = bll.GetModel(Cid);
string xmlCoursePath = CourseCidPath(Cid);
if (!Directory.Exists(xmlCoursePath)) //如果不存在该目录，则创建
Directory.CreateDirectory(xmlCoursePath);
string xmlCourseName = xmlCoursePath + @"\" + Cid + ".xml";
if (File.Exists(xmlCourseName))
File.Delete(xmlCourseName);
XmlSerializer xs = new XmlSerializer(typeof(LearnSite.Model.Courses));
Stream stream = new FileStream(xmlCourseName, FileMode.Create, FileAccess.Write, FileShare.ReadWrite);
xs.Serialize(stream, course);
stream.Close();
if (File.Exists(xmlCourseName))
{
return true;
}
{
return false;
}
}
/// <summary>
/// �ӱ��е�һ����¼�õ�һ������ʵ��
/// </summary>
public LearnSite.Model.Courses GetTableModel(DataTable dt)
{
LearnSite.Model.Courses model = new LearnSite.Model.Courses();
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Cid"].ToString() != "")
{
model.Cid = int.Parse(dt.Rows[0]["Cid"].ToString());
}
model.Ctitle = dt.Rows[0]["Ctitle"].ToString();
model.Cclass = dt.Rows[0]["Cclass"].ToString();
model.Ccontent = dt.Rows[0]["Ccontent"].ToString();
if (dt.Rows[0]["Cdate"].ToString() != "")
{
model.Cdate = DateTime.Parse(dt.Rows[0]["Cdate"].ToString());
}
if (dt.Rows[0]["Chit"].ToString() != "")
{
model.Chit = int.Parse(dt.Rows[0]["Chit"].ToString());
}
if (dt.Rows[0]["Cobj"].ToString() != "")
{
model.Cobj = int.Parse(dt.Rows[0]["Cobj"].ToString());
}
if (dt.Rows[0]["Cterm"].ToString() != "")
{
model.Cterm = int.Parse(dt.Rows[0]["Cterm"].ToString());
}
if (dt.Rows[0]["Cks"].ToString() != "")
{
model.Cks = int.Parse(dt.Rows[0]["Cks"].ToString());
}
model.Cfiletype = dt.Rows[0]["Cfiletype"].ToString();
if (dt.Rows[0]["Cupload"].ToString() != "")
{
if ((dt.Rows[0]["Cupload"].ToString() == "1") || (dt.Rows[0]["Cupload"].ToString().ToLower() == "true"))
{
model.Cupload = true;
}
else
{
model.Cupload = false;
}
}
if (dt.Rows[0]["Chid"].ToString() != "")
{
model.Chid = int.Parse(dt.Rows[0]["Chid"].ToString());
}
if (dt.Rows[0]["Cpublish"].ToString() != "")
{
if ((dt.Rows[0]["Cpublish"].ToString() == "1") || (dt.Rows[0]["Cpublish"].ToString().ToLower() == "true"))
{
model.Cpublish = true;
}
else
{
model.Cpublish = false;
}
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LearnSite.Model.Courses GetModel(int Cid)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Cid,Ctitle,Cclass,Ccontent,Cdate,Chit,Cobj,Cterm,Cks,Cfiletype,Cupload,Chid,Cpublish from Courses ");
strSql.Append(" where Cid=@Cid ");
SqlParameter[] parameters = {
new SqlParameter("@Cid", SqlDbType.Int,4)};
parameters[0].Value = Cid;
LearnSite.Model.Courses model=new LearnSite.Model.Courses();
DataSet ds =DbHelperSQL.Query(strSql.ToString(), parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["Cid"].ToString()!="")
{
model.Cid=int.Parse(ds.Tables[0].Rows[0]["Cid"].ToString());
}
model.Ctitle=ds.Tables[0].Rows[0]["Ctitle"].ToString();
model.Cclass=ds.Tables[0].Rows[0]["Cclass"].ToString();
model.Ccontent=ds.Tables[0].Rows[0]["Ccontent"].ToString();
if(ds.Tables[0].Rows[0]["Cdate"].ToString()!="")
{
model.Cdate=DateTime.Parse(ds.Tables[0].Rows[0]["Cdate"].ToString());
}
if(ds.Tables[0].Rows[0]["Chit"].ToString()!="")
{
model.Chit=int.Parse(ds.Tables[0].Rows[0]["Chit"].ToString());
}
if(ds.Tables[0].Rows[0]["Cobj"].ToString()!="")
{
model.Cobj=int.Parse(ds.Tables[0].Rows[0]["Cobj"].ToString());
}
if(ds.Tables[0].Rows[0]["Cterm"].ToString()!="")
{
model.Cterm=int.Parse(ds.Tables[0].Rows[0]["Cterm"].ToString());
}
if(ds.Tables[0].Rows[0]["Cks"].ToString()!="")
{
model.Cks=int.Parse(ds.Tables[0].Rows[0]["Cks"].ToString());
}
model.Cfiletype=ds.Tables[0].Rows[0]["Cfiletype"].ToString();
if(ds.Tables[0].Rows[0]["Cupload"].ToString()!="")
{
if((ds.Tables[0].Rows[0]["Cupload"].ToString()=="1")||(ds.Tables[0].Rows[0]["Cupload"].ToString().ToLower()=="true"))
{
model.Cupload=true;
}
else
{
model.Cupload=false;
}
}
if(ds.Tables[0].Rows[0]["Chid"].ToString()!="")
{
model.Chid=int.Parse(ds.Tables[0].Rows[0]["Chid"].ToString());
}
if(ds.Tables[0].Rows[0]["Cpublish"].ToString()!="")
{
if((ds.Tables[0].Rows[0]["Cpublish"].ToString()=="1")||(ds.Tables[0].Rows[0]["Cpublish"].ToString().ToLower()=="true"))
{
model.Cpublish=true;
}
else
{
model.Cpublish=false;
}
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 从表中第一条记录得到一个对象实体
/// </summary>
public LearnSite.Model.Courses GetTableModel(DataTable dt)
{
LearnSite.Model.Courses model = new LearnSite.Model.Courses();
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Cid"].ToString() != "")
{
model.Cid = int.Parse(dt.Rows[0]["Cid"].ToString());
}
model.Ctitle = dt.Rows[0]["Ctitle"].ToString();
model.Cclass = dt.Rows[0]["Cclass"].ToString();
model.Ccontent = dt.Rows[0]["Ccontent"].ToString();
if (dt.Rows[0]["Cdate"].ToString() != "")
{
model.Cdate = DateTime.Parse(dt.Rows[0]["Cdate"].ToString());
}
if (dt.Rows[0]["Chit"].ToString() != "")
{
model.Chit = int.Parse(dt.Rows[0]["Chit"].ToString());
}
if (dt.Rows[0]["Cobj"].ToString() != "")
{
model.Cobj = int.Parse(dt.Rows[0]["Cobj"].ToString());
}
if (dt.Rows[0]["Cterm"].ToString() != "")
{
model.Cterm = int.Parse(dt.Rows[0]["Cterm"].ToString());
}
if (dt.Rows[0]["Cks"].ToString() != "")
{
model.Cks = int.Parse(dt.Rows[0]["Cks"].ToString());
}
if (dt.Rows[0]["Cupload"].ToString() != "")
{
if ((dt.Rows[0]["Cupload"].ToString() == "1") || (dt.Rows[0]["Cupload"].ToString().ToLower() == "true"))
{
model.Cupload = true;
}
else
{
model.Cupload = false;
}
}
if (dt.Rows[0]["Chid"].ToString() != "")
{
model.Chid = int.Parse(dt.Rows[0]["Chid"].ToString());
}
if (dt.Rows[0]["Cpublish"].ToString() != "")
{
if ((dt.Rows[0]["Cpublish"].ToString() == "1") || (dt.Rows[0]["Cpublish"].ToString().ToLower() == "true"))
{
model.Cpublish = true;
}
else
{
model.Cpublish = false;
}
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LearnSite.Model.Courses GetModel(int Cid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Cid,Ctitle,Cclass,Ccontent,Cdate,Chit,Cobj,Cterm,Cks,Cfiletype,Cupload,Chid,Cpublish from Courses ");
strSql.Append(" where Cid=@Cid ");
SqlParameter[] parameters =
{
new SqlParameter("@Cid", SqlDbType.Int, 4)
};
parameters[0].Value = Cid;
LearnSite.Model.Courses model = new LearnSite.Model.Courses();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Cid"].ToString() != "")
{
model.Cid = int.Parse(ds.Tables[0].Rows[0]["Cid"].ToString());
}
model.Ctitle = ds.Tables[0].Rows[0]["Ctitle"].ToString();
model.Cclass = ds.Tables[0].Rows[0]["Cclass"].ToString();
model.Ccontent = ds.Tables[0].Rows[0]["Ccontent"].ToString();
if (ds.Tables[0].Rows[0]["Cdate"].ToString() != "")
{
model.Cdate = DateTime.Parse(ds.Tables[0].Rows[0]["Cdate"].ToString());
}
if (ds.Tables[0].Rows[0]["Chit"].ToString() != "")
{
model.Chit = int.Parse(ds.Tables[0].Rows[0]["Chit"].ToString());
}
if (ds.Tables[0].Rows[0]["Cobj"].ToString() != "")
{
model.Cobj = int.Parse(ds.Tables[0].Rows[0]["Cobj"].ToString());
}
if (ds.Tables[0].Rows[0]["Cterm"].ToString() != "")
{
model.Cterm = int.Parse(ds.Tables[0].Rows[0]["Cterm"].ToString());
}
if (ds.Tables[0].Rows[0]["Cks"].ToString() != "")
{
model.Cks = int.Parse(ds.Tables[0].Rows[0]["Cks"].ToString());
}
model.Cfiletype = ds.Tables[0].Rows[0]["Cfiletype"].ToString();
if (ds.Tables[0].Rows[0]["Cupload"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Cupload"].ToString() == "1") || (ds.Tables[0].Rows[0]["Cupload"].ToString().ToLower() == "true"))
{
model.Cupload = true;
}
else
{
model.Cupload = false;
}
}
if (ds.Tables[0].Rows[0]["Chid"].ToString() != "")
{
model.Chid = int.Parse(ds.Tables[0].Rows[0]["Chid"].ToString());
}
if (ds.Tables[0].Rows[0]["Cpublish"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Cpublish"].ToString() == "1") || (ds.Tables[0].Rows[0]["Cpublish"].ToString().ToLower() == "true"))
{
model.Cpublish = true;
}
else
{
model.Cpublish = false;
}
}
return(model);
}
else
{
return(null);
}
}
