public void LoadData() { try { Model_PrpeLesson model = new Model_PrpeLesson(); model = new BLL_PrpeLesson().GetModel(ResourceFolder_Id); Model_ResourceFolder resourceFolder = new Model_ResourceFolder(); resourceFolder = new BLL_ResourceFolder().GetModel(ResourceFolder_Id); if (model != null && resourceFolder != null) { this.txtResourceFolder_Name.Text = resourceFolder.ResourceFolder_Name; this.txtEndTime.Text = pfunction.ToShortDate(model.EndTime.ToString()); this.txtNameRule.Value = model.NameRule; this.txtRemark.Value = model.Remark; this.txtRequire.Text = model.Require; this.txtStartTime.Text = pfunction.ToShortDate(model.StartTime.ToString()); ddlGrade.SelectedValue = model.Grade.TrimEnd(); ddlStage.SelectedValue = model.Stage; ddlSubject.SelectedValue = model.Subject; } } catch (Exception ex) { } }
public bool Add(Model_ResourceFolder model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ResourceFolder("); builder.Append("ResourceFolder_Id,ResourceFolder_ParentId,ResourceFolder_Name,ResourceFolder_Level,Resource_Type,Resource_Class,Resource_Version,ResourceFolder_Remark,ResourceFolder_Order,ResourceFolder_Owner,CreateFUser,CreateTime,ResourceFolder_isLast,LessonPlan_Type,GradeTerm,Subject,Book_ID,ParticularYear)"); builder.Append(" values ("); builder.Append("@ResourceFolder_Id,@ResourceFolder_ParentId,@ResourceFolder_Name,@ResourceFolder_Level,@Resource_Type,@Resource_Class,@Resource_Version,@ResourceFolder_Remark,@ResourceFolder_Order,@ResourceFolder_Owner,@CreateFUser,@CreateTime,@ResourceFolder_isLast,@LessonPlan_Type,@GradeTerm,@Subject,@Book_ID,@ParticularYear)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_ParentId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceFolder_Name", SqlDbType.NVarChar, 250), new SqlParameter("@ResourceFolder_Level", SqlDbType.Int, 4), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Class", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Remark", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@ResourceFolder_Order", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Owner", SqlDbType.Char, 0x24), new SqlParameter("@CreateFUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ResourceFolder_isLast", SqlDbType.Char, 1), new SqlParameter("@LessonPlan_Type", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Book_ID", SqlDbType.Char, 0x24), new SqlParameter("@ParticularYear", SqlDbType.Int, 4) }; cmdParms[0].Value = model.ResourceFolder_Id; cmdParms[1].Value = model.ResourceFolder_ParentId; cmdParms[2].Value = model.ResourceFolder_Name; cmdParms[3].Value = model.ResourceFolder_Level; cmdParms[4].Value = model.Resource_Type; cmdParms[5].Value = model.Resource_Class; cmdParms[6].Value = model.Resource_Version; cmdParms[7].Value = model.ResourceFolder_Remark; cmdParms[8].Value = model.ResourceFolder_Order; cmdParms[9].Value = model.ResourceFolder_Owner; cmdParms[10].Value = model.CreateFUser; cmdParms[11].Value = model.CreateTime; cmdParms[12].Value = model.ResourceFolder_isLast; cmdParms[13].Value = model.LessonPlan_Type; cmdParms[14].Value = model.GradeTerm; cmdParms[15].Value = model.Subject; cmdParms[0x10].Value = model.Book_ID; cmdParms[0x11].Value = model.ParticularYear; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Update(Model_ResourceFolder model) { StringBuilder builder = new StringBuilder(); builder.Append("update ResourceFolder set "); builder.Append("ResourceFolder_ParentId=@ResourceFolder_ParentId,"); builder.Append("ResourceFolder_Name=@ResourceFolder_Name,"); builder.Append("ResourceFolder_Level=@ResourceFolder_Level,"); builder.Append("Resource_Type=@Resource_Type,"); builder.Append("Resource_Class=@Resource_Class,"); builder.Append("Resource_Version=@Resource_Version,"); builder.Append("ResourceFolder_Remark=@ResourceFolder_Remark,"); builder.Append("ResourceFolder_Order=@ResourceFolder_Order,"); builder.Append("ResourceFolder_Owner=@ResourceFolder_Owner,"); builder.Append("CreateFUser=@CreateFUser,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("ResourceFolder_isLast=@ResourceFolder_isLast,"); builder.Append("LessonPlan_Type=@LessonPlan_Type,"); builder.Append("GradeTerm=@GradeTerm,"); builder.Append("Subject=@Subject,"); builder.Append("Book_ID=@Book_ID,"); builder.Append("ParticularYear=@ParticularYear"); builder.Append(" where ResourceFolder_Id=@ResourceFolder_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceFolder_ParentId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceFolder_Name", SqlDbType.NVarChar, 250), new SqlParameter("@ResourceFolder_Level", SqlDbType.Int, 4), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Class", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Remark", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@ResourceFolder_Order", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Owner", SqlDbType.Char, 0x24), new SqlParameter("@CreateFUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ResourceFolder_isLast", SqlDbType.Char, 1), new SqlParameter("@LessonPlan_Type", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Book_ID", SqlDbType.Char, 0x24), new SqlParameter("@ParticularYear", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.ResourceFolder_ParentId; cmdParms[1].Value = model.ResourceFolder_Name; cmdParms[2].Value = model.ResourceFolder_Level; cmdParms[3].Value = model.Resource_Type; cmdParms[4].Value = model.Resource_Class; cmdParms[5].Value = model.Resource_Version; cmdParms[6].Value = model.ResourceFolder_Remark; cmdParms[7].Value = model.ResourceFolder_Order; cmdParms[8].Value = model.ResourceFolder_Owner; cmdParms[9].Value = model.CreateFUser; cmdParms[10].Value = model.CreateTime; cmdParms[11].Value = model.ResourceFolder_isLast; cmdParms[12].Value = model.LessonPlan_Type; cmdParms[13].Value = model.GradeTerm; cmdParms[14].Value = model.Subject; cmdParms[15].Value = model.Book_ID; cmdParms[0x10].Value = model.ParticularYear; cmdParms[0x11].Value = model.ResourceFolder_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_ResourceFolder> DataTableToList(DataTable dt) { List <Model_ResourceFolder> list = new List <Model_ResourceFolder>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_ResourceFolder item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public static string ModifyFolder(string userId, string name, string id, string pid) { try { userId = userId.Filter(); name = name.Filter(); id = id.Filter(); pid = pid.Filter(); BLL_ResourceFolder bll = new BLL_ResourceFolder(); Model_ResourceFolder model = new Model_ResourceFolder(); bool flag = false; if (string.IsNullOrEmpty(id)) { #region 添加 //文件夹名称已存在 if (bll.GetRecordCount("ResourceFolder_ParentId='" + pid + "' and ResourceFolder_Name='" + name + "' ") > 0) { return("2"); } Model_ResourceFolder modelParent = bll.GetModel(pid); model.ResourceFolder_Id = Guid.NewGuid().ToString(); model.ResourceFolder_ParentId = pid; model.ResourceFolder_Name = name.Filter(); model.ResourceFolder_Level = modelParent.ResourceFolder_Level + 1; model.Resource_Type = modelParent.Resource_Type; model.Resource_Class = modelParent.Resource_Class; model.ResourceFolder_Order = 1; model.ResourceFolder_Owner = userId; model.CreateFUser = userId; model.CreateTime = DateTime.Now; model.ResourceFolder_isLast = "0"; if (bll.Add(model)) { flag = true; } #endregion } else { #region 修改 //文件夹名称已存在 if (bll.GetRecordCount("ResourceFolder_Id!='" + id + "' and ResourceFolder_ParentId='" + pid + "' and ResourceFolder_Name='" + name + "' ") > 0) { return("2"); } model = bll.GetModel(id); model.ResourceFolder_Name = name.Filter(); if (bll.Update(model)) { flag = true; } #endregion } if (flag) { return(model.ResourceFolder_Id); } else { return("0"); } } catch (Exception) { return("0"); } }
public bool Update(Model_ResourceFolder model) { return(this.dal.Update(model)); }
public bool Add(Model_ResourceFolder model) { return(this.dal.Add(model)); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(ResourceFolder_Id)) { #region 添加 Model_PrpeLesson prpeLesson = new Model_PrpeLesson(); Model_ResourceFolder resourceFolder = new Model_ResourceFolder(); #region 备课表 prpeLesson.ResourceFolder_Id = hidResourceFolder_Id.Value; prpeLesson.Grade = ddlGrade.SelectedValue; prpeLesson.Subject = ddlSubject.SelectedValue; prpeLesson.Stage = ddlStage.SelectedValue; prpeLesson.StartTime = Convert.ToDateTime(txtStartTime.Text.TrimEnd()); prpeLesson.EndTime = Convert.ToDateTime(txtEndTime.Text.TrimEnd()); prpeLesson.NameRule = txtNameRule.Value.TrimEnd(); prpeLesson.Remark = txtRemark.Value.TrimEnd(); prpeLesson.Require = txtRequire.Text.TrimEnd(); prpeLesson.CreateUser = FloginUser.UserId; prpeLesson.CreateTime = DateTime.Now; #endregion #region 负责人表 Model_PrpeLesson_Person prpeLesson_Person = new Model_PrpeLesson_Person(); prpeLesson_Person.PrpeLesson_Person_Id = Guid.NewGuid().ToString(); prpeLesson_Person.ChargePerson = FloginUser.UserId; prpeLesson_Person.CreateUser = FloginUser.UserId; prpeLesson_Person.CreateTime = DateTime.Now; prpeLesson_Person.ResourceFolder_Id = hidResourceFolder_Id.Value; #endregion #region 文件夹 resourceFolder.ResourceFolder_Id = hidResourceFolder_Id.Value; resourceFolder.ResourceFolder_ParentId = "0"; resourceFolder.ResourceFolder_Level = 0; resourceFolder.ResourceFolder_Name = txtResourceFolder_Name.Text.TrimEnd(); resourceFolder.Book_ID = hidResourceFolder_Id.Value; resourceFolder.CreateFUser = FloginUser.UserId; resourceFolder.CreateTime = DateTime.Now; resourceFolder.Subject = ddlSubject.SelectedValue; resourceFolder.Resource_Type = Resource_TypeConst.集体备课文件; resourceFolder.Resource_Class = Resource_ClassConst.自有资源; #endregion if (bll.Add(prpeLesson, prpeLesson_Person, resourceFolder)) { string i = "window.opener.loadData();"; if (FloginUser.UserPost == UserPost.普通老师) { i = "window.opener.location.reload();"; } ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('添加成功', { icon: 1, time: 2000 }, function () {" + i + "window.opener=null;window.close();})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('添加失败!',{ time: 2000,icon:2});</script>"); return; } #endregion } else { Model_PrpeLesson model = new Model_PrpeLesson(); model = new BLL_PrpeLesson().GetModel(ResourceFolder_Id); Model_ResourceFolder resourceFolder = new Model_ResourceFolder(); resourceFolder = new BLL_ResourceFolder().GetModel(ResourceFolder_Id); #region 文件夹 resourceFolder.ResourceFolder_Level = 0; resourceFolder.ResourceFolder_Name = txtResourceFolder_Name.Text.TrimEnd(); #endregion #region 备课表 model.Grade = ddlGrade.SelectedValue; model.Subject = ddlSubject.SelectedValue; model.Stage = ddlStage.SelectedValue; model.StartTime = Convert.ToDateTime(txtStartTime.Text.TrimEnd()); model.EndTime = Convert.ToDateTime(txtEndTime.Text.TrimEnd()); model.NameRule = txtNameRule.Value.TrimEnd(); model.Remark = txtRemark.Value.TrimEnd(); model.Require = txtRequire.Text.TrimEnd(); #endregion if (bll.Update(model, resourceFolder)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改成功', { icon: 1, time: 2000 }, function () {window.opener.loadData();window.opener=null;window.close();})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>"); return; } } } catch (Exception ex) { } }
public bool Add(Model_PrpeLesson model, Model_PrpeLesson_Person prpeLesson_Person, Model_ResourceFolder rfmodel) { Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>(); StringBuilder builder = new StringBuilder(); builder = new StringBuilder(); builder.Append("insert into PrpeLesson("); builder.Append("ResourceFolder_Id,Grade,Subject,Stage,StartTime,EndTime,Require,NameRule,Remark,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@ResourceFolder_Id,@Grade,@Subject,@Stage,@StartTime,@EndTime,@Require,@NameRule,@Remark,@CreateUser,@CreateTime)"); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Grade", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Stage", SqlDbType.VarChar, 100), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Require", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@NameRule", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Remark", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameterArray[0].Value = model.ResourceFolder_Id; parameterArray[1].Value = model.Grade; parameterArray[2].Value = model.Subject; parameterArray[3].Value = model.Stage; parameterArray[4].Value = model.StartTime; parameterArray[5].Value = model.EndTime; parameterArray[6].Value = model.Require; parameterArray[7].Value = model.NameRule; parameterArray[8].Value = model.Remark; parameterArray[9].Value = model.CreateUser; parameterArray[10].Value = model.CreateTime; dictionary.Add(builder.ToString(), parameterArray); builder = new StringBuilder(); builder.Append("insert into PrpeLesson_Person("); builder.Append("PrpeLesson_Person_Id,ResourceFolder_Id,ChargePerson,CreateTime,CreateUser)"); builder.Append(" values ("); builder.Append("@PrpeLesson_Person_Id,@ResourceFolder_Id,@ChargePerson,@CreateTime,@CreateUser)"); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@PrpeLesson_Person_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@ChargePerson", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24) }; parameterArray2[0].Value = prpeLesson_Person.PrpeLesson_Person_Id; parameterArray2[1].Value = prpeLesson_Person.ResourceFolder_Id; parameterArray2[2].Value = prpeLesson_Person.ChargePerson; parameterArray2[3].Value = prpeLesson_Person.CreateTime; parameterArray2[4].Value = prpeLesson_Person.CreateUser; dictionary.Add(builder.ToString(), parameterArray2); builder = new StringBuilder(); builder.Append("insert into ResourceFolder("); builder.Append("ResourceFolder_Id,ResourceFolder_ParentId,ResourceFolder_Name,ResourceFolder_Level,Resource_Type,Resource_Class,Resource_Version,ResourceFolder_Remark,ResourceFolder_Order,ResourceFolder_Owner,CreateFUser,CreateTime,ResourceFolder_isLast,LessonPlan_Type,GradeTerm,Subject,Book_ID,ParticularYear)"); builder.Append(" values ("); builder.Append("@ResourceFolder_Id,@ResourceFolder_ParentId,@ResourceFolder_Name,@ResourceFolder_Level,@Resource_Type,@Resource_Class,@Resource_Version,@ResourceFolder_Remark,@ResourceFolder_Order,@ResourceFolder_Owner,@CreateFUser,@CreateTime,@ResourceFolder_isLast,@LessonPlan_Type,@GradeTerm,@Subject,@Book_ID,@ParticularYear)"); SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_ParentId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceFolder_Name", SqlDbType.NVarChar, 250), new SqlParameter("@ResourceFolder_Level", SqlDbType.Int, 4), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Class", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Remark", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@ResourceFolder_Order", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Owner", SqlDbType.Char, 0x24), new SqlParameter("@CreateFUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ResourceFolder_isLast", SqlDbType.Char, 1), new SqlParameter("@LessonPlan_Type", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Book_ID", SqlDbType.Char, 0x24), new SqlParameter("@ParticularYear", SqlDbType.Int, 4) }; parameterArray3[0].Value = rfmodel.ResourceFolder_Id; parameterArray3[1].Value = rfmodel.ResourceFolder_ParentId; parameterArray3[2].Value = rfmodel.ResourceFolder_Name; parameterArray3[3].Value = rfmodel.ResourceFolder_Level; parameterArray3[4].Value = rfmodel.Resource_Type; parameterArray3[5].Value = rfmodel.Resource_Class; parameterArray3[6].Value = rfmodel.Resource_Version; parameterArray3[7].Value = rfmodel.ResourceFolder_Remark; parameterArray3[8].Value = rfmodel.ResourceFolder_Order; parameterArray3[9].Value = rfmodel.ResourceFolder_Owner; parameterArray3[10].Value = rfmodel.CreateFUser; parameterArray3[11].Value = rfmodel.CreateTime; parameterArray3[12].Value = rfmodel.ResourceFolder_isLast; parameterArray3[13].Value = rfmodel.LessonPlan_Type; parameterArray3[14].Value = rfmodel.GradeTerm; parameterArray3[15].Value = rfmodel.Subject; parameterArray3[0x10].Value = rfmodel.Book_ID; parameterArray3[0x11].Value = rfmodel.ParticularYear; dictionary.Add(builder.ToString(), parameterArray3); return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0); }
public bool Update(Model_PrpeLesson model, Model_ResourceFolder rfmodel) { Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>(); StringBuilder builder = new StringBuilder(); builder = new StringBuilder(); builder.Append("update PrpeLesson set "); builder.Append("Grade=@Grade,"); builder.Append("Subject=@Subject,"); builder.Append("Stage=@Stage,"); builder.Append("StartTime=@StartTime,"); builder.Append("EndTime=@EndTime,"); builder.Append("Require=@Require,"); builder.Append("NameRule=@NameRule,"); builder.Append("Remark=@Remark,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where ResourceFolder_Id=@ResourceFolder_Id "); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@Grade", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Stage", SqlDbType.VarChar, 100), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Require", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@NameRule", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@Remark", SqlDbType.NVarChar, 0xfa0), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24) }; parameterArray[0].Value = model.Grade; parameterArray[1].Value = model.Subject; parameterArray[2].Value = model.Stage; parameterArray[3].Value = model.StartTime; parameterArray[4].Value = model.EndTime; parameterArray[5].Value = model.Require; parameterArray[6].Value = model.NameRule; parameterArray[7].Value = model.Remark; parameterArray[8].Value = model.CreateUser; parameterArray[9].Value = model.CreateTime; parameterArray[10].Value = model.ResourceFolder_Id; dictionary.Add(builder.ToString(), parameterArray); builder = new StringBuilder(); builder.Append("update ResourceFolder set "); builder.Append("ResourceFolder_ParentId=@ResourceFolder_ParentId,"); builder.Append("ResourceFolder_Name=@ResourceFolder_Name,"); builder.Append("ResourceFolder_Level=@ResourceFolder_Level,"); builder.Append("Resource_Type=@Resource_Type,"); builder.Append("Resource_Class=@Resource_Class,"); builder.Append("Resource_Version=@Resource_Version,"); builder.Append("ResourceFolder_Remark=@ResourceFolder_Remark,"); builder.Append("ResourceFolder_Order=@ResourceFolder_Order,"); builder.Append("ResourceFolder_Owner=@ResourceFolder_Owner,"); builder.Append("CreateFUser=@CreateFUser,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("ResourceFolder_isLast=@ResourceFolder_isLast,"); builder.Append("LessonPlan_Type=@LessonPlan_Type,"); builder.Append("GradeTerm=@GradeTerm,"); builder.Append("Subject=@Subject,"); builder.Append("Book_ID=@Book_ID,"); builder.Append("ParticularYear=@ParticularYear"); builder.Append(" where ResourceFolder_Id=@ResourceFolder_Id "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@ResourceFolder_ParentId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceFolder_Name", SqlDbType.NVarChar, 250), new SqlParameter("@ResourceFolder_Level", SqlDbType.Int, 4), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Class", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Remark", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@ResourceFolder_Order", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Owner", SqlDbType.Char, 0x24), new SqlParameter("@CreateFUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ResourceFolder_isLast", SqlDbType.Char, 1), new SqlParameter("@LessonPlan_Type", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Book_ID", SqlDbType.Char, 0x24), new SqlParameter("@ParticularYear", SqlDbType.Int, 4), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24) }; parameterArray2[0].Value = rfmodel.ResourceFolder_ParentId; parameterArray2[1].Value = rfmodel.ResourceFolder_Name; parameterArray2[2].Value = rfmodel.ResourceFolder_Level; parameterArray2[3].Value = rfmodel.Resource_Type; parameterArray2[4].Value = rfmodel.Resource_Class; parameterArray2[5].Value = rfmodel.Resource_Version; parameterArray2[6].Value = rfmodel.ResourceFolder_Remark; parameterArray2[7].Value = rfmodel.ResourceFolder_Order; parameterArray2[8].Value = rfmodel.ResourceFolder_Owner; parameterArray2[9].Value = rfmodel.CreateFUser; parameterArray2[10].Value = rfmodel.CreateTime; parameterArray2[11].Value = rfmodel.ResourceFolder_isLast; parameterArray2[12].Value = rfmodel.LessonPlan_Type; parameterArray2[13].Value = rfmodel.GradeTerm; parameterArray2[14].Value = rfmodel.Subject; parameterArray2[15].Value = rfmodel.Book_ID; parameterArray2[0x10].Value = rfmodel.ParticularYear; parameterArray2[0x11].Value = rfmodel.ResourceFolder_Id; dictionary.Add(builder.ToString(), parameterArray2); return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0); }
public Model_ResourceFolder DataRowToModel(DataRow row) { Model_ResourceFolder folder = new Model_ResourceFolder(); if (row != null) { if (row["ResourceFolder_Id"] != null) { folder.ResourceFolder_Id = row["ResourceFolder_Id"].ToString(); } if (row["ResourceFolder_ParentId"] != null) { folder.ResourceFolder_ParentId = row["ResourceFolder_ParentId"].ToString(); } if (row["ResourceFolder_Name"] != null) { folder.ResourceFolder_Name = row["ResourceFolder_Name"].ToString(); } if ((row["ResourceFolder_Level"] != null) && (row["ResourceFolder_Level"].ToString() != "")) { folder.ResourceFolder_Level = new int?(int.Parse(row["ResourceFolder_Level"].ToString())); } if (row["Resource_Type"] != null) { folder.Resource_Type = row["Resource_Type"].ToString(); } if (row["Resource_Class"] != null) { folder.Resource_Class = row["Resource_Class"].ToString(); } if (row["Resource_Version"] != null) { folder.Resource_Version = row["Resource_Version"].ToString(); } if (row["ResourceFolder_Remark"] != null) { folder.ResourceFolder_Remark = row["ResourceFolder_Remark"].ToString(); } if ((row["ResourceFolder_Order"] != null) && (row["ResourceFolder_Order"].ToString() != "")) { folder.ResourceFolder_Order = new int?(int.Parse(row["ResourceFolder_Order"].ToString())); } if (row["ResourceFolder_Owner"] != null) { folder.ResourceFolder_Owner = row["ResourceFolder_Owner"].ToString(); } if (row["CreateFUser"] != null) { folder.CreateFUser = row["CreateFUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { folder.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } if (row["ResourceFolder_isLast"] != null) { folder.ResourceFolder_isLast = row["ResourceFolder_isLast"].ToString(); } if (row["LessonPlan_Type"] != null) { folder.LessonPlan_Type = row["LessonPlan_Type"].ToString(); } if (row["GradeTerm"] != null) { folder.GradeTerm = row["GradeTerm"].ToString(); } if (row["Subject"] != null) { folder.Subject = row["Subject"].ToString(); } if (row["Book_ID"] != null) { folder.Book_ID = row["Book_ID"].ToString(); } if ((row["ParticularYear"] != null) && (row["ParticularYear"].ToString() != "")) { folder.ParticularYear = new int?(int.Parse(row["ParticularYear"].ToString())); } } return(folder); }
public bool Add(Model_PrpeLesson model, Model_PrpeLesson_Person prpeLesson_Person, Model_ResourceFolder rfmodel) { return(this.dal.Add(model, prpeLesson_Person, rfmodel)); }
public bool Update(Model_PrpeLesson model, Model_ResourceFolder rfmodel) { return(this.dal.Update(model, rfmodel)); }