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 static string OperateResourceAuth(string ReId, string stage)
{
try
{
if (!string.IsNullOrEmpty(ReId))
{
Model_PrpeLesson model = new BLL_PrpeLesson().GetModel(ReId.Filter());
if (model != null)
{
model.Stage = stage.Filter();
if (new BLL_PrpeLesson().Update(model))
{
return("1");
}
else
{
return("");
}
}
else
{
return("");
}
}
else
{
return("");
}
}
catch (Exception ex)
{
return("");
}
}
public static string GetList(string ResourceFolder_Id)
{
try
{
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
DataTable dt = new DataTable();
BLL_PrpeLesson bll = new BLL_PrpeLesson();
string sql = @"select u.UserId,u.UserName,u.TrueName,c.D_Name as Subject from [dbo].[PrpeLesson_Person] p
left join f_user u on u.UserId=p.ChargePerson
left join Common_Dict c on c.Common_Dict_ID=u.Subject
where ResourceFolder_Id='" + ResourceFolder_Id.Filter() + "' group by u.UserId,u.UserName,u.TrueName,c.D_Name ";
string SqlClass = @" select distinct ClassId,ClassName,userId from [dbo].[VW_UserOnClassGradeSchool] where IType='class'";
DataTable dtclass = Rc.Common.DBUtility.DbHelperSQL.Query(SqlClass).Tables[0];
dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0];
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
string ClassName = string.Empty;
DataRow[] dr = dtclass.Select("UserId='" + dt.Rows[i]["UserId"].ToString() + "'");
if (dr.Length > 0)
{
foreach (DataRow item in dr)
{
ClassName += item["ClassName"].ToString() + ",";
}
}
listReturn.Add(new
{
UserId = dt.Rows[i]["UserId"].ToString(),
ClassName = !string.IsNullOrEmpty(ClassName.TrimEnd(',')) ? ClassName.TrimEnd(',') : "-",
Subject = dt.Rows[i]["Subject"].ToString(),
UserName = dt.Rows[i]["UserName"].ToString(),
TrueName = dt.Rows[i]["TrueName"].ToString(),
ResourceFolder_Id = ResourceFolder_Id,
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
public static string GetList(string KeyName, string SubjectID, string GradeID, string ResourceFolder_Id)
{
try
{
KeyName = KeyName.Filter();
SubjectID = SubjectID.Filter();
GradeID = GradeID.Filter();
ResourceFolder_Id = ResourceFolder_Id.Filter();
HttpContext.Current.Session["StatsClassSubject"] = SubjectID;
string strWhere = " ";
if (!string.IsNullOrEmpty(KeyName))
{
strWhere += " and (UserName like '%" + KeyName + "%' or TrueName like '%" + KeyName + "%')";
}
if (!string.IsNullOrEmpty(SubjectID))
{
strWhere += " and Common_Dict_ID = '" + SubjectID + "'";
}
if (!string.IsNullOrEmpty(GradeID))
{
strWhere += " and GradeId = '" + GradeID + "'";
}
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
DataTable dt = new DataTable();
BLL_PrpeLesson bll = new BLL_PrpeLesson();
string sql = string.Format(@"select distinct vw.UserId,vw.UserName,vw.TrueName,vw.GradeName,cd.D_Name,cd.Common_Dict_ID from [dbo].[VW_UserOnClassGradeSchool] vw
left join F_User u on u.UserId=vw.UserId
left join [dbo].[Common_Dict] cd on cd.Common_Dict_Id=u.Subject
where vw.schoolId in (select distinct schoolId from [VW_UserOnClassGradeSchool] where userId='{1}') and vw.UserId<>'{1}'" + strWhere, ResourceFolder_Id, loginUser.UserId);
dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0];
string sqlP = @"select * from PrpeLesson_Person where ResourceFolder_Id='" + ResourceFolder_Id + "'";
DataTable dtP = Rc.Common.DBUtility.DbHelperSQL.Query(sqlP).Tables[0];
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow[] dr = dtP.Select("ChargePerson='" + dt.Rows[i]["UserId"].ToString() + "'");
listReturn.Add(new
{
UserId = dt.Rows[i]["UserId"].ToString(),
GradeName = dt.Rows[i]["GradeName"].ToString(),
Subject = dt.Rows[i]["D_Name"].ToString(),
UserName = dt.Rows[i]["UserName"].ToString(),
TrueName = dt.Rows[i]["TrueName"].ToString(),
PrpeLesson_Person_Id = dr.Length,
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
public static string GetList(string KeyName, string SubjectID, string GradeID, int PageIndex, int PageSize)
{
try
{
KeyName = KeyName.Filter();
SubjectID = SubjectID.Filter();
GradeID = GradeID.Filter();
string PpstWhere = string.Empty;
HttpContext.Current.Session["StatsClassSubject"] = SubjectID;
string strWhere = " where 1=1 ";
if (!string.IsNullOrEmpty(KeyName))
{
strWhere += " and ResourceFolder_Name like '%" + KeyName + "%'";
}
strWhere += " and pl.Subject = '" + SubjectID + "'";
strWhere += " and pl.Grade = '" + GradeID + "'";
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
if (loginUser.UserPost == UserPost.普通老师)
{
PpstWhere = "inner join PrpeLesson_Person pp on pp.ResourceFolder_Id=pl.ResourceFolder_Id and pp.ChargePerson='" + loginUser.UserId + @"'";
}
DataTable dt = new DataTable();
BLL_PrpeLesson bll = new BLL_PrpeLesson();
string sql = @" select * from (select ROW_NUMBER() over(ORDER BY pl.CreateTime DESC) row, pl.*,u.UserName,u.TrueName,dc.D_Name as SubjectName,ug.UserGroup_Name as GradeName,rf.ResourceFolder_Name
from PrpeLesson pl " + PpstWhere + @"
inner join ResourceFolder rf on rf.[ResourceFolder_Id]=pl.ResourceFolder_Id
left join Common_Dict dc on dc.Common_Dict_Id=pl.Subject
left join UserGroup ug on ug.UserGroup_Id=pl.Grade
left join f_user u on u.UserId=pl.CreateUser " + strWhere + ")t where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + "";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0];
string sqlFiles = @" select * from ResourceToResourceFolder rtrf where File_Suffix<>'' and Resource_Type='" + Resource_TypeConst.集体备课文件 + "'";
DataTable dtFiles = Rc.Common.DBUtility.DbHelperSQL.Query(sqlFiles).Tables[0];
string countsql = @"select count(*) from PrpeLesson pl " + PpstWhere + @"
inner join ResourceFolder rf on rf.[ResourceFolder_Id]=pl.ResourceFolder_Id
left join Common_Dict dc on dc.Common_Dict_Id=pl.Subject
left join UserGroup ug on ug.UserGroup_Id=pl.Grade" + strWhere;
int intRecordCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(countsql));
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
int PersonCount = new BLL_PrpeLesson_Person().GetRecordCount("ResourceFolder_Id='" + dt.Rows[i]["ResourceFolder_Id"] + "'");
DataRow[] dr = dtFiles.Select("Book_Id='" + dt.Rows[i]["ResourceFolder_Id"] + "'");
int FilesCount = dr.Length;
listReturn.Add(new
{
ResourceFolder_Id = dt.Rows[i]["ResourceFolder_Id"].ToString(),
ResourceFolder_Name = dt.Rows[i]["ResourceFolder_Name"].ToString(),
GradeName = dt.Rows[i]["GradeName"].ToString(),
Subject = dt.Rows[i]["SubjectName"].ToString(),
PersonCount = PersonCount,
FilesCount = FilesCount,
StartTime = pfunction.ToShortDate(dt.Rows[i]["StartTime"].ToString()),
EndTime = pfunction.ToShortDate(dt.Rows[i]["EndTime"].ToString()),
CreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["CreateTime"].ToString()),
UserName = !string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["TrueName"].ToString() : dt.Rows[i]["UserName"].ToString(),
flag = dt.Rows[i]["CreateUser"].ToString() == loginUser.UserId ? "true" : "false",
stage = dt.Rows[i]["stage"].ToString()
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = intRecordCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
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)
{
}
}
