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)
     {
     }
 }
Exemple #2
0
        public bool Update(Model_PrpeLesson model)
        {
            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[] cmdParms = 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) };
            cmdParms[0].Value  = model.Grade;
            cmdParms[1].Value  = model.Subject;
            cmdParms[2].Value  = model.Stage;
            cmdParms[3].Value  = model.StartTime;
            cmdParms[4].Value  = model.EndTime;
            cmdParms[5].Value  = model.Require;
            cmdParms[6].Value  = model.NameRule;
            cmdParms[7].Value  = model.Remark;
            cmdParms[8].Value  = model.CreateUser;
            cmdParms[9].Value  = model.CreateTime;
            cmdParms[10].Value = model.ResourceFolder_Id;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
Exemple #3
0
        public Model_PrpeLesson DataRowToModel(DataRow row)
        {
            Model_PrpeLesson lesson = new Model_PrpeLesson();

            if (row != null)
            {
                if (row["ResourceFolder_Id"] != null)
                {
                    lesson.ResourceFolder_Id = row["ResourceFolder_Id"].ToString();
                }
                if (row["Grade"] != null)
                {
                    lesson.Grade = row["Grade"].ToString();
                }
                if (row["Subject"] != null)
                {
                    lesson.Subject = row["Subject"].ToString();
                }
                if (row["Stage"] != null)
                {
                    lesson.Stage = row["Stage"].ToString();
                }
                if ((row["StartTime"] != null) && (row["StartTime"].ToString() != ""))
                {
                    lesson.StartTime = new DateTime?(DateTime.Parse(row["StartTime"].ToString()));
                }
                if ((row["EndTime"] != null) && (row["EndTime"].ToString() != ""))
                {
                    lesson.EndTime = new DateTime?(DateTime.Parse(row["EndTime"].ToString()));
                }
                if (row["Require"] != null)
                {
                    lesson.Require = row["Require"].ToString();
                }
                if (row["NameRule"] != null)
                {
                    lesson.NameRule = row["NameRule"].ToString();
                }
                if (row["Remark"] != null)
                {
                    lesson.Remark = row["Remark"].ToString();
                }
                if (row["CreateUser"] != null)
                {
                    lesson.CreateUser = row["CreateUser"].ToString();
                }
                if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
                {
                    lesson.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
                }
            }
            return(lesson);
        }
Exemple #4
0
        public List <Model_PrpeLesson> DataTableToList(DataTable dt)
        {
            List <Model_PrpeLesson> list = new List <Model_PrpeLesson>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    Model_PrpeLesson item = this.dal.DataRowToModel(dt.Rows[i]);
                    if (item != null)
                    {
                        list.Add(item);
                    }
                }
            }
            return(list);
        }
Exemple #5
0
        public bool Add(Model_PrpeLesson model)
        {
            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[] cmdParms = 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) };
            cmdParms[0].Value  = model.ResourceFolder_Id;
            cmdParms[1].Value  = model.Grade;
            cmdParms[2].Value  = model.Subject;
            cmdParms[3].Value  = model.Stage;
            cmdParms[4].Value  = model.StartTime;
            cmdParms[5].Value  = model.EndTime;
            cmdParms[6].Value  = model.Require;
            cmdParms[7].Value  = model.NameRule;
            cmdParms[8].Value  = model.Remark;
            cmdParms[9].Value  = model.CreateUser;
            cmdParms[10].Value = model.CreateTime;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
 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)
     {
     }
 }
Exemple #7
0
        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);
        }
Exemple #8
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);
        }
Exemple #9
0
 public bool Add(Model_PrpeLesson model, Model_PrpeLesson_Person prpeLesson_Person, Model_ResourceFolder rfmodel)
 {
     return(this.dal.Add(model, prpeLesson_Person, rfmodel));
 }
Exemple #10
0
 public bool Add(Model_PrpeLesson model)
 {
     return(this.dal.Add(model));
 }
Exemple #11
0
 public bool Update(Model_PrpeLesson model, Model_ResourceFolder rfmodel)
 {
     return(this.dal.Update(model, rfmodel));
 }
Exemple #12
0
 public bool Update(Model_PrpeLesson model)
 {
     return(this.dal.Update(model));
 }