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));
}
