/// <summary>
/// 获得Model
/// </summary>
/// <param name="Top">大于0取前几行数据，否则取全部</param>
/// <param name="whereStr">where条件</param>
/// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param>
/// <returns></returns>
public Model.course_chapter GetModel(int Top, string whereStr, string filedOrder)
{
DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0];
Model.course_chapter model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private bool DoAdd()
{
bool result = false;
Model.course_chapter model = new Model.course_chapter();
model.group_id = (int)EnumCollection.chapter_group.精品微课;
model.course_id = this.course_id;
model.name = txtname.Text.Trim();
model.tag = "";
model.parent_id = Convert.ToInt32(this.ddlChapter.SelectedValue);
model.add_time = DateTime.Now;
model.chapter_level = 1;
if (model.parent_id > 0)
{
Model.course_chapter parent_model = new BLL.course_chapter().GetModel(model.parent_id);
if (parent_model != null)
{
model.chapter_level = parent_model.chapter_level + 1;
}
}
int id = new BLL.course_chapter().Add(model);
if (id > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public Model.course_chapter GetModel(string whereStr)
{
DataTable dt = dal.GetList(whereStr).Tables[0];
Model.course_chapter model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private void ShowInfo(int _id)
{
BLL.course_chapter bll = new BLL.course_chapter();
Model.course_chapter model = bll.GetModel(_id);
this.ddlChapter.SelectedValue = model.parent_id + "";
this.txtname.Text = model.name;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.course_chapter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into ybd_course_chapter(
group_id
,course_id
,name
,tag
,chapter_level
,parent_id
,add_time
) Values (
@group_id
,@course_id
,@name
,@tag
,@chapter_level
,@parent_id
,@add_time
);
SELECT @@IDENTITY;");
SqlParameter[] parameters =
{
new SqlParameter("@group_id", SqlDbType.Int, 4)
, new SqlParameter("@course_id", SqlDbType.Int, 4)
, new SqlParameter("@name", SqlDbType.NVarChar, 50)
, new SqlParameter("@tag", SqlDbType.NVarChar, 50)
, new SqlParameter("@chapter_level", SqlDbType.Int, 4)
, new SqlParameter("@parent_id", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.group_id;
parameters[1].Value = model.course_id;
parameters[2].Value = model.name;
parameters[3].Value = model.tag;
parameters[4].Value = model.chapter_level;
parameters[5].Value = model.parent_id;
parameters[6].Value = model.add_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void BindInfo()
{
BLL.course_chapter bll = new BLL.course_chapter();
Model.course_chapter model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
txtgroup_id.Text = model.group_id + "";
txtcourse_id.Text = model.course_id + "";
txtname.Text = model.name + "";
txttag.Text = model.tag + "";
txtchapter_level.Text = model.chapter_level + "";
txtparent_id.Text = model.parent_id + "";
txtadd_time.Text = model.add_time + "";
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.course_chapter DataRowToModel(DataRow row)
{
Model.course_chapter model = new Model.course_chapter();
if (row != null)
{
if (row["id"] != null) //&& row["id"].ToString() != ""
{
model.id = Convert.ToInt32(row["id"]);
}
if (row["group_id"] != null) //&& row["group_id"].ToString() != ""
{
model.group_id = Convert.ToInt32(row["group_id"]);
}
if (row["course_id"] != null) //&& row["course_id"].ToString() != ""
{
model.course_id = Convert.ToInt32(row["course_id"]);
}
if (row["name"] != null) //&& row["name"].ToString() != ""
{
model.name = Convert.ToString(row["name"]);
}
if (row["tag"] != null) //&& row["tag"].ToString() != ""
{
model.tag = Convert.ToString(row["tag"]);
}
if (row["chapter_level"] != null) //&& row["chapter_level"].ToString() != ""
{
model.chapter_level = Convert.ToInt32(row["chapter_level"]);
}
if (row["parent_id"] != null) //&& row["parent_id"].ToString() != ""
{
model.parent_id = Convert.ToInt32(row["parent_id"]);
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = Convert.ToDateTime(row["add_time"]);
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.course_chapter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"UPDATE ybd_course_chapter SET
group_id = @group_id
,course_id = @course_id
,name = @name
,tag = @tag
,chapter_level = @chapter_level
,parent_id = @parent_id
,add_time = @add_time
WHERE id = @id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
, new SqlParameter("@group_id", SqlDbType.Int, 4)
, new SqlParameter("@course_id", SqlDbType.Int, 4)
, new SqlParameter("@name", SqlDbType.NVarChar, 50)
, new SqlParameter("@tag", SqlDbType.NVarChar, 50)
, new SqlParameter("@chapter_level", SqlDbType.Int, 4)
, new SqlParameter("@parent_id", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.id;
parameters[1].Value = model.group_id;
parameters[2].Value = model.course_id;
parameters[3].Value = model.name;
parameters[4].Value = model.tag;
parameters[5].Value = model.chapter_level;
parameters[6].Value = model.parent_id;
parameters[7].Value = model.add_time;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_course_chapter", EnumCollection.ActionEnum.Modify.ToString()); //检查权限
BLL.course_chapter bll = new BLL.course_chapter();
Model.course_chapter model = bll.GetModel(this.id);
model.group_id = Convert.ToInt32(txtgroup_id.Text);
model.course_id = Convert.ToInt32(txtcourse_id.Text);
model.name = Convert.ToString(txtname.Text);
model.tag = Convert.ToString(txttag.Text);
model.chapter_level = Convert.ToInt32(txtchapter_level.Text);
model.parent_id = Convert.ToInt32(txtparent_id.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改课程章节信息，主键:" + id); //记录日志
JscriptMsg("修改课程章节信息成功！", "Manage.aspx");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.course_chapter model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.course_chapter model)
{
return(dal.Add(model));
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_course_chapter", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region
string strError = string.Empty;
if (txtgroup_id.Text.Trim() == "" || txtgroup_id.Text.Trim().Length > 4)
{
strError += "分组为空或超出长度![br]";
}
if (txtcourse_id.Text.Trim() == "" || txtcourse_id.Text.Trim().Length > 4)
{
strError += "课程ID为空或超出长度![br]";
}
if (txtname.Text.Trim() == "" || txtname.Text.Trim().Length > 50)
{
strError += "名称为空或超出长度![br]";
}
if (txttag.Text.Trim() == "" || txttag.Text.Trim().Length > 50)
{
strError += "标签为空或超出长度![br]";
}
if (txtchapter_level.Text.Trim() == "" || txtchapter_level.Text.Trim().Length > 4)
{
strError += "章节级别为空或超出长度![br]";
}
if (txtparent_id.Text.Trim() == "" || txtparent_id.Text.Trim().Length > 4)
{
strError += "父级ID为空或超出长度![br]";
}
if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8)
{
strError += "添加时间为空或超出长度![br]";
}
if (strError != string.Empty)
{
JscriptMsg(strError, "", "Error");
return;
}
#endregion
Model.course_chapter model = new Model.course_chapter();
BLL.course_chapter bll = new BLL.course_chapter();
model.group_id = Convert.ToInt32(txtgroup_id.Text);
model.course_id = Convert.ToInt32(txtcourse_id.Text);
model.name = Convert.ToString(txtname.Text);
model.tag = Convert.ToString(txttag.Text);
model.chapter_level = Convert.ToInt32(txtchapter_level.Text);
model.parent_id = Convert.ToInt32(txtparent_id.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
int id = bll.Add(model);
if (id > 0)
{
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加课程章节信息，主键:" + id); //记录日志
JscriptMsg("添加课程章节信息成功！", "Manage.aspx", "");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
private void BindData()
{
BLL.course_chapter ccBll = new BLL.course_chapter();
Model.course_chapter chapter = ccBll.GetModel(this.chapter);
if (chapter == null)
{
JscriptMsg("没有此节", "back");
return;
}
this.chapter_name = chapter.name;
Model.course_chapter pModel = ccBll.GetModel(chapter.parent_id);
if (pModel == null)
{
JscriptMsg("没有此章", "back");
return;
}
this.parent_name = pModel.name;
Model.classroom_info ciModel = new BLL.classroom_info().GetModel(pModel.course_id);
if (ciModel == null)
{
JscriptMsg("没有此课堂", "back");
return;
}
this.class_name = ciModel.name;
Model.user_info user = new BLL.user_info().GetModel(" phone = '" + adminInfo.user_name + "' ");
if (user == null)
{
JscriptMsg("没有此教师", "back");
return;
}
if (ciModel.user_id != user.id)
{
JscriptMsg("此课堂不属于你", "back");
return;
}
Model.common_examination exaModel = new BLL.common_examination().GetModel(this.exa_id);
if (exaModel == null)
{
JscriptMsg("没有此作业", "back");
return;
}
this.examination = exaModel.name;
#region 组装查询条件
string whereStr = " 1 = 1 ";
DataTable dtids = new BLL.examination_question().GetList(" exa_id = " + this.exa_id);
string ids = string.Empty;
foreach (DataRow item in dtids.Rows)
{
ids += Convert.ToInt32(item["q_id"]) + ",";
}
ids = Utils.DelLastComma(ids);
if (!string.IsNullOrEmpty(ids))
{
whereStr += " and id in (" + ids + ") ";
}
string _keywords = keywords.Replace("'", "");
if (!string.IsNullOrEmpty(_keywords))
{
if (Utils.IsSafeSqlString(_keywords))
{
whereStr += " and (Title like '%" + _keywords + "%')";
}
else
{
JscriptMsg("搜索关键词中包含危险字符，检索终止！", Utils.CombUrlTxt("currect_question_list.aspx", "keywords={0}", ""));
return;
}
}
if (this.type > 0)
{
this.ddlType.SelectedValue = this.type + "";
whereStr += " and type = " + this.type;
}
#endregion
this.page = RequestHelper.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.common_questions bll = new BLL.common_questions();
this.rptList.DataSource = bll.GetListByPage(whereStr, "ID", this.page, this.pageSize);
this.rptList.DataBind();
this.totalCount = bll.GetRecordCount(whereStr);
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("currect_question_list.aspx", "keywords={0}&page={1}&type={2}", this.keywords, "__id__", this.type + "");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
