/// <summary>
/// 获取所有展示图片
/// </summary>
/// <param name="context"></param>
public void GetFullResourceData(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
List <ResourceData> ResourceDataList = db.ResourceData.Where(t => t.IsDel != true && t.IsCarousel == true).OrderBy(t => t.CreateDate).ToList();
List <ResourcePath> ResourcePathList = db.ResourcePath.ToList();
JArray DataArray = new JArray();
foreach (ResourceData ResourceData in ResourceDataList)
{
JObject jobject = new JObject();
jobject.Add("Name", ResourceData.Name);
jobject.Add("ID", ResourceData.ID);
jobject.Add("ResourcePathID", ResourceData.ResourcePathID);
jobject.Add("CreateDate", ResourceData.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
jobject.Add("Path", ResourceDAO.GetPath(ResourceData, ResourcePathList) + "/" + ResourceData.Name);
DataArray.Add(jobject);
}
returnobj.Add("ResourceData", DataArray);
returnobj.Add("result", "success");
}
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
protected void btn_Delete_Click(object sender, EventArgs e)
{
try
{
string ids = this.hf_CheckIDS.Value.TrimEnd(',');
using (IFMPDBContext db = new IFMPDBContext())
{
try
{
foreach (string id in ids.Split(','))
{
int selid = Convert.ToInt32(id);
db.BaseClassUser.RemoveRange(db.BaseClassUser.Where(t => t.FlowID == selid));
}
db.SaveChanges();
new SysLogDAO().AddLog(LogType.操作日志_删除, "删除基础班次用户设置信息", UserID);
ShowMessage("删除成功");
}
catch
{
ShowMessage("删除失败");
return;
}
}
}
catch (Exception ex)
{
new SysLogDAO().AddLog(LogType.系统日志, ex.Message, UserID);
ShowMessage(ex.Message);
}
this.hf_CheckIDS.Value = "";
DataBindList();
}
protected void btn_Sumbit_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.txt_SysID.Text.ToString()))
{
ShowMessage("请至少选择一名人员！！");
return;
}
using (IFMPDBContext db = new IFMPDBContext())
{
int depid = Convert.ToInt32(ddl_UserType.SelectedValue);
foreach (string userid in this.txt_SysID.Text.ToString().TrimEnd(',').Split(','))
{
int selid = Convert.ToInt32(userid);
DepartmentUser DepartmentUser = db.DepartmentUser.FirstOrDefault(t => t.UserID == selid && t.DepartmentID == depid);
if (DepartmentUser == null)
{
DepartmentUser = new DepartmentUser();
DepartmentUser.DepartmentID = depid;
DepartmentUser.UserID = selid;
db.DepartmentUser.Add(DepartmentUser);
db.SaveChanges();
}
}
ShowMessage();
}
}
catch (Exception error)
{
ShowMessage(error.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (IFMPDBContext db = new IFMPDBContext())
{
List <TableType> TableTypeList = db.TableType.Where(t => t.IsDel != true).ToList();
this.ddl_TableType.DataSource = TableTypeList;
this.ddl_TableType.DataValueField = "ID";
this.ddl_TableType.DataTextField = "Name";
this.ddl_TableType.DataBind();
if (BaseFlowRoleID != 0)
{
BindInfo();
}
int TableType = Convert.ToInt32(this.ddl_TableType.SelectedValue);
List <Flow> FlowList = db.Flow.Where(t => t.TableTypeID == TableType).OrderBy(t => t.ParentID).ThenBy(t => t.ID).ToList();
this.ddl_Flow.DataSource = FlowList;
this.ddl_Flow.DataValueField = "ID";
this.ddl_Flow.DataTextField = "Name";
this.ddl_Flow.DataBind();
}
}
}
protected void lbtn_ZF_Click(object sender, EventArgs e)
{
try
{
string ids = this.hf_CheckIDS.Value.TrimEnd(',');
if (string.IsNullOrEmpty(ids))
{
ShowMessage("请至少选择一条记录");
return;
}
using (IFMPDBContext db = new IFMPDBContext())
{
foreach (string id in ids.Split(','))
{
int selid = Convert.ToInt32(id);
ScoreUser ScoreUser = db.ScoreUser.FirstOrDefault(t => t.ID == selid);
ScoreUser.IsDel = true;
}
db.SaveChanges();
new SysLogDAO().AddLog(LogType.操作日志_删除, "作废积分奖扣信息", UserID);
ShowMessage("作废奖扣记录成功");
}
}
catch (Exception ex)
{
ShowMessage(ex.Message.ToString());
new SysLogDAO().AddLog(LogType.系统日志, ex.Message);
}
this.hf_CheckIDS.Value = "";
DataBindList();
}
public void GetTableColumn(HttpContext context)
{
string url = context.Request.UrlReferrer.ToString();
url = url.Split('&')[0];
int tabletypeid = Convert.ToInt32(url.Substring(url.IndexOf("type") + 5, url.Length - url.IndexOf("type") - 5));
//int tabletypeid = Convert.ToInt32(context.Request["type"]);
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
List <TableColumn> TableColumnList = db.TableColumn.Where(t => t.IsFill == true && t.TableTypeID == tabletypeid).OrderBy(t => t.Order).ToList();
foreach (TableColumn TableColumn in TableColumnList)
{
JObject jobject = new JObject();
jobject.Add("id", TableColumn.ID);
jobject.Add("text", TableColumn.ColumnName);
jarray.Add(jobject);
}
}
}
catch (Exception error)
{
}
context.Response.Clear();
context.Response.Write(jarray);
context.Response.End();
}
public void GetPic(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
DirectoryInfo Dir = new DirectoryInfo(System.AppDomain.CurrentDomain.BaseDirectory + "resource");
DirectoryInfo[] DirSub = Dir.GetDirectories();
foreach (FileInfo f in Dir.GetFiles("*.*", SearchOption.TopDirectoryOnly))
{
JObject jobject = new JObject();
jobject.Add("Name", f.Name);
jarray.Add(jobject);
}
}
returnobj.Add("result", "success");
returnobj.Add("PicList", jarray);
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
public void UpdateUser(JObject data, User user, string accesstoken)
{
string url = string.Format("https://oapi.dingtalk.com/user/update?access_token={0}", accesstoken);
using (IFMPDBContext db = new IFMPDBContext())
{
JObject GetData = new JObject();
GetData.Add("userid", user.ID);
GetData.Add("name", user.RealName);
GetData.Add("userid", user.ID);
JArray departmentarray = new JArray();
List <Department> DepartmentList = db.Department.Where(t => t.IsDel != true && t.IsAdmin && db.DepartmentUser.Where(m => m.UserID == user.ID).Select(m => m.DepartmentID).Contains(t.ID)).ToList();
foreach (Department Department in DepartmentList)
{
departmentarray.Add(Department.ID);
}
GetData.Add("department", departmentarray);
Post Post = db.Post.Where(t => t.IsDel != true && db.PostUser.Where(m => m.UserID == user.ID).Select(m => m.PostID).Contains(t.ID)).FirstOrDefault();
if (Post != null)
{
GetData.Add("position", Post.Name);
}
GetData.Add("mobile", user.Cellphone);
GetData.Add("jobnumber", db.UserDetails.FirstOrDefault(t => t.UserID == user.ID).Identity);
JObject ReturnData = PostData(url, GetData);
}
}
public object GetData(int tableid, TableColumn tablecolumn)
{
object returndata = null;
using (IFMPDBContext db = new IFMPDBContext())
{
List <TableData> SelList = db.TableData.Where(t => t.TableID == tableid &&
db.TableColumnRange.Where(m => m.TableColumnID == tablecolumn.ID).Select(m => m.SourceID).Contains(t.TableColumnID)).ToList();
switch (tablecolumn.ColumnShowType.Value)
{
case ColumnShowType.极值:
returndata = SelList.Select(t => { decimal m = Convert.ToDecimal(t.Data); return(m); }).OrderByDescending(t => t).FirstOrDefault() - SelList.Select(t => { decimal m = Convert.ToDecimal(t.Data); return(m); }).OrderBy(t => t).FirstOrDefault();
break;
case ColumnShowType.平均值:
returndata = System.Decimal.Round(SelList.Select(t => { decimal m = Convert.ToDecimal(t.Data); return(m); }).Sum() / SelList.Count, 4);
break;
case ColumnShowType.最大值:
returndata = SelList.Select(t => { decimal m = Convert.ToDecimal(t.Data); return(m); }).OrderByDescending(t => t).FirstOrDefault();
break;
case ColumnShowType.最小值:
returndata = SelList.Select(t => { decimal m = Convert.ToDecimal(t.Data); return(m); }).OrderBy(t => t).FirstOrDefault();
break;
default:
break;
}
}
return(returndata);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CommonFunction.BindEnum <Sex>(this.ddl_Sex, "-99");
CommonFunction.BindEnum <Polity>(this.ddl_Polity, "-99");
CommonFunction.BindEnum <Nationality>(this.ddl_Nationality, "-99");
CommonFunction.BindEnum <UserType>(this.ddl_UserType, "-99");
using (IFMPDBContext db = new IFMPDBContext())
{
List <Department> DepartmentList = db.Department.Where(t => t.IsDel != true && t.IsAdmin).ToList();
this.ddl_DepID.DataSource = DepartmentList;
this.ddl_DepID.DataValueField = "ID";
this.ddl_DepID.DataTextField = "Name";
this.ddl_DepID.DataBind();
this.ddl_DepID.Items.Insert(0, new ListItem("--请选择--", "-2"));
List <Post> postList = db.Post.Where(t => t.IsDel != true).ToList();
this.ddl_PostID.DataSource = postList;
this.ddl_PostID.DataValueField = "ID";
this.ddl_PostID.DataTextField = "Name";
this.ddl_PostID.DataBind();
this.ddl_PostID.Items.Insert(0, new ListItem("--请选择--", "-2"));
}
if (UID != 0)
{
InfoBind();
}
}
}
public string AddUser(User user, string accesstoken)
{
string url = string.Format("https://oapi.dingtalk.com/user/create?access_token={0}", accesstoken);
using (IFMPDBContext db = new IFMPDBContext())
{
UserDetails UserDetails = db.UserDetails.FirstOrDefault(t => t.UserID == user.ID);
JObject GetData = new JObject();
GetData.Add("userid", user.ID);
GetData.Add("name", user.RealName);
//GetData.Add("userid", user.ID);
JArray departmentarray = new JArray();
//List<Department> DepartmentList = db.Department.Where(t => t.IsDel != true && t.IsAdmin && db.DepartmentUser.Where(m => m.UserID == user.ID).Select(m => m.DepartmentID).Contains(t.ID)).ToList();
//foreach (Department Department in DepartmentList)
//{
// departmentarray.Add(Department.ID);
//}
departmentarray.Add(1);
GetData.Add("department", departmentarray);
Post Post = db.Post.Where(t => t.IsDel != true && db.PostUser.Where(m => m.UserID == user.ID).Select(m => m.PostID).Contains(t.ID)).FirstOrDefault();
if (Post != null)
{
GetData.Add("position", Post.Name);
}
GetData.Add("mobile", user.Cellphone);
GetData.Add("jobnumber", UserDetails.Identity);
DateTime basedate = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1)); // 当地时区
GetData.Add("hiredDate", (long)(UserDetails.HireDate - basedate).TotalSeconds);
//主管设置
JObject ReturnData = PostData(url, GetData);
return(ReturnData["userid"].ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (IFMPDBContext db = new IFMPDBContext())
{
List <TableType> TableTypeList = db.TableType.Where(t => t.IsDel != true).ToList();
this.ddl_TableType.DataSource = TableTypeList;
this.ddl_TableType.DataValueField = "ID";
this.ddl_TableType.DataTextField = "Name";
this.ddl_TableType.DataBind();
this.ddl_TableType.Items.Insert(0, new ListItem("--请选择--", "-2"));
List <Role> RoleList = db.Role.Where(t => t.IsDel != true).OrderBy(t => t.CreateDate).ToList();
this.ddl_Role.DataSource = RoleList;
this.ddl_Role.DataValueField = "ID";
this.ddl_Role.DataTextField = "Name";
this.ddl_Role.DataBind();
this.ddl_Role.Items.Insert(0, new ListItem("--请选择--", "-2"));
this.ddl_Role.SelectedValue = "-2";
}
GetCondition();
DataBindList();
}
}
public void AddResourceData(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
int ResourcePathID = Convert.ToInt32(context.Request["pathid"]);
string Name = context.Request["name"];
ResourceData ResourceData = new ResourceData();
ResourceData.CreateDate = DateTime.Now;
ResourceData.IsDel = false;
ResourceData.Name = Name;
ResourceData.ResourcePathID = ResourcePathID;
db.ResourceData.Add(ResourceData);
db.SaveChanges();
returnobj.Add("result", "success");
}
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
public void GetParentResourcePath(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
int ID = Convert.ToInt32(context.Request["id"]);
ResourcePath ResourcePath = db.ResourcePath.FirstOrDefault(t => t.ID == ID);
returnobj.Add("result", "success");
returnobj.Add("ParentID", ResourcePath.ParentID);
}
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
protected void btn_Compelete_Click(object sender, EventArgs e)
{
try
{
string ids = this.hf_CheckIDS.Value.TrimEnd(',');
using (IFMPDBContext db = new IFMPDBContext())
{
foreach (string id in ids.Split(','))
{
int selid = Convert.ToInt32(id);
ScoreTask ScoreTask = db.ScoreTask.FirstOrDefault(t => t.IsDel != true && t.CreateUserID == UserID && t.AuditState == AuditState.通过);
if (ScoreTask != null)
{
ScoreTask.AuditState = AuditState.确认完成;
}
}
db.SaveChanges();
new SysLogDAO().AddLog(LogType.操作日志_修改, "确认完成成功", UserID);
ShowMessage("确认成功");
DataBindList();
this.hf_CheckIDS.Value = "";
}
}
catch (Exception ex)
{
new SysLogDAO().AddLog(LogType.系统日志, ex.Message, UserID);
ShowMessage(ex.Message);
return;
}
}
public void GetGrade(HttpContext context)
{
try
{
int uid = Convert.ToInt32(context.Request.Params["UserID"]);
//int uid = 1;
int SpotScore = Convert.ToInt32(context.Request.Params["SpotScore"]);
int DormitorySel = Convert.ToInt32(context.Request.Params["DormitorySel"]);
using (IFMPDBContext db = new IFMPDBContext())
{
var user = db.User.FirstOrDefault(x => x.ID == uid);
SpotCheck SpotCheck = new SpotCheck();
SpotCheck.SpotScore = SpotScore;
SpotCheck.DormitoryId = DormitorySel;
SpotCheck.CreateUser = user.RealName;
SpotCheck.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.SpotCheck.Add(SpotCheck);
db.SaveChanges();
var name = "{\"id\":\"" + SpotCheck.SpotId + "\",\"dormitoryid\":\"" + DormitorySel + "\"}";
sb.Append("{\"result\":\"true\",\"data\":[");
sb.Append(name.TrimEnd(','));
sb.Append("]}");
}
}
catch
{
sb.Append("{\"result\":\"false\"}");
}
context.Response.Clear();
context.Response.Write(sb.ToString().TrimEnd(','));
context.Response.End();
}
public void DataBindList()
{
//DateTime begin = Convert.ToDateTime(ViewState["begin"]);
//DateTime end = Convert.ToDateTime(ViewState["end"]);
string Name = ViewState["Name"].ToString();
using (IFMPDBContext db = new IFMPDBContext())
{
List <Flow> FlowList = db.Flow.Where(t => t.Name.Contains(Name) && t.TableTypeID == TableTypeID).ToList();
if (FlowList.Count > 0)
{
tr_null.Visible = false;
}
else
{
tr_null.Visible = true;
}
rp_List.DataSource = FlowList.Skip(Pager.PageSize * (Pager.CurrentPageIndex - 1)).Take(Pager.PageSize).ToList();
Pager.RecordCount = FlowList.Count;
rp_List.DataBind();
}
}
public void SaveReviewDetail(HttpContext context)
{
try
{
int uid = Convert.ToInt32(context.Request.Params["UserID"]);
//int uid = 1;
var Review = context.Request.Params["Review"];
int SpId = Convert.ToInt32(context.Request.Params["SpId"]);
using (IFMPDBContext db = new IFMPDBContext())
{
var model = db.SpotProblem.FirstOrDefault(x => x.SpId == SpId);
model.ReviewMemo = Review;
model.ReviewUser = db.User.FirstOrDefault(x => x.ID == uid).RealName;
model.ReviewDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
model.IsreView = true;
db.SaveChanges();
sb.Append("{\"result\":\"true\"}");
}
}
catch
{
sb.Append("{\"result\":\"false\"}");
}
context.Response.Clear();
context.Response.Write(sb.ToString().TrimEnd(','));
context.Response.End();
}
//获取大屏的报警信息
public void GetAlertMessage(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
DateTime Date = DateTime.Now.AddMinutes(-1);
SysLog log = db.SysLog.FirstOrDefault(t => t.CreateDate > Date && t.LogType == LogType.报警日志);
if (log == null)
{
returnobj.Add("data", null);
}
else
{
returnobj.Add("data", log.Message);
}
returnobj.Add("result", "success");
}
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
private void Out(HttpContext context)
{
StringBuilder sb = new StringBuilder("");
//string name = context.Request.Params["name"].ToString();
int id = Convert.ToInt32(context.Request["UserID"]);
using (IFMPDBContext db = new IFMPDBContext())
{
User user = db.User.FirstOrDefault(t => t.ID == id);
if (user != null)
{
context.Response.Cookies["UserID"].Expires = DateTime.Now.AddDays(-1);
context.Response.Cookies["SysUserName"].Expires = DateTime.Now.AddDays(-1);
context.Response.Cookies["RealName"].Expires = DateTime.Now.AddDays(-1);
sb.Append("{\"result\":\"success\"}");
new SysLogDAO().AddLog(LogType.注销日志, "用户【" + user.RealName + "】于北京时间" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "注销登陆", Convert.ToInt32(user.ID));
}
else
{
sb.Append("{\"result\":\"fail\"}");
}
}
context.Response.Clear();
context.Response.Write(sb.ToString());
context.Response.End();
}
//返回所有的表单类型
public void GetTableType(HttpContext context)
{
JObject returnobj = new JObject();
JArray jarray = new JArray();
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
List <TableType> TableTypeList = db.TableType.Where(t => t.IsDel != true).ToList();
foreach (TableType TableType in TableTypeList)
{
JObject jobject = new JObject();
jobject.Add("ID", TableType.ID);
jobject.Add("Name", TableType.Name);
jarray.Add(jobject);
}
returnobj.Add("result", "success");
returnobj.Add("List", jarray);
}
}
catch
{
returnobj.Add("result", "failed");
}
context.Response.Clear();
context.Response.Write(returnobj);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
public void ClassLoginIn(HttpContext context)
{
string message = "";
int baseclassid = Convert.ToInt32(context.Request["classid"]);
using (IFMPDBContext db = new IFMPDBContext())
{
BaseClass BaseClass = db.BaseClass.FirstOrDefault(t => t.ID == baseclassid && t.IsDel != true);
if (BaseClass != null)
{
HttpContext.Current.Response.Cookies["BaseClassID"].Value = BaseClass.ID.ToString();
HttpContext.Current.Response.Cookies["BaseClassName"].Value = HttpUtility.UrlEncode(BaseClass.Name, Encoding.GetEncoding("UTF-8"));
new SysLogDAO().AddLog(LogType.登录日志, "班次【" + BaseClass.Name + "】于北京时间" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "登录系统");
message = "success";
}
else
{
message = "用户名或密码错误";
}
}
StringBuilder sb = new StringBuilder("");
sb.Append("{\"result\":\"" + message + "\"}");
context.Response.Clear();
context.Response.Write(sb.ToString());
context.Response.End();
}
//验证合法性
public bool ValidateColumnRange(string ids, ColumnShowType ColumnShowType, int tabletypeid)
{
bool result = true;
using (IFMPDBContext db = new IFMPDBContext())
{
List <int> idlist = new List <int>(ids.Split(',').Select(t => { int m = Convert.ToInt32(t); return(m); }));
List <TableColumn> TableColumnList = db.TableColumn.Where(t => idlist.Contains(t.ID)).ToList();
List <Dictionary> DictionaryList = db.Dictionary.ToList();
if (ColumnShowType == ColumnShowType.极值 || ColumnShowType == ColumnShowType.平均值 || ColumnShowType == ColumnShowType.最大值 || ColumnShowType == ColumnShowType.最小值 || ColumnShowType == ColumnShowType.求和)
{
DictionaryList = DictionaryList.Where(t => t.RegexType == RegexType.非负整数 ||
t.RegexType == RegexType.实数 ||
t.RegexType == RegexType.范围的数字 ||
t.RegexType == RegexType.整数 ||
t.RegexType == RegexType.正整数
).ToList();
if (TableColumnList.Count != TableColumnList.Where(t => DictionaryList.Select(m => m.ID).Contains(t.DictionaryID.Value)).Count())
{
result = false;
}
}
}
return(result);
}
public void DataBindList()
{
using (IFMPDBContext db = new IFMPDBContext())
{
string taskname = ViewState["TaskName"].ToString();
int tstate = Convert.ToInt32(ViewState["TState"]);
DateTime begindate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["begin"]));
DateTime enddate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["end"]), false);
List <ScoreTask> ScoreTaskList = db.ScoreTask.Where(t => t.IsDel != true && t.CreateUserID == UserID &&
t.Name.Contains(taskname) &&
t.EndDate >= begindate &&
t.EndDate <= enddate &&
(tstate == -2 || t.AuditState == (AuditState)tstate)
).OrderByDescending(t => t.CreateDate).Skip(Pager.PageSize * (Pager.CurrentPageIndex - 1)).Take(Pager.PageSize).ToList();
if (ScoreTaskList.Count > 0)
{
this.tr_null.Visible = false;
}
else
{
this.tr_null.Visible = true;
}
rp_List.DataSource = ScoreTaskList;
Pager.RecordCount = db.ScoreTask.Count(t => t.IsDel != true && t.CreateUserID == UserID);
rp_List.DataBind();
this.hf_CheckIDS.Value = "";
}
}
public void IsCheckUser(HttpContext context)
{
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
int uid = Convert.ToInt32(context.Request.Params["UserID"]);
//int uid = 6;
List <Scheduling> scheduinglist = db.Scheduling.ToList();
string checknameid = "";
foreach (var scheduing in scheduinglist)
{
checknameid += scheduing.CheckName + ",";
}
var checkname = checknameid.TrimEnd(',').Split(',').Distinct().ToArray();
if (checkname.Any(x => x == uid.ToString()))
{
sb.Append("{\"result\":\"true\"}");
}
else
{
throw new Exception();
}
}
}
catch
{
sb.Append("{\"result\":\"false\"}");
}
context.Response.Clear();
context.Response.Write(sb.ToString().TrimEnd(','));
context.Response.End();
}
protected void btn_Delete_Click(object sender, EventArgs e)
{
try
{
string ids = this.hf_CheckIDS.Value.TrimEnd(',');
using (IFMPDBContext db = new IFMPDBContext())
{
try
{
foreach (string id in ids.Split(','))
{
int selid = Convert.ToInt32(id);
ScoreTask ScoreTask = db.ScoreTask.FirstOrDefault(t => t.ID == selid);
ScoreTask.IsDel = true;
}
db.SaveChanges();
new SysLogDAO().AddLog(LogType.操作日志_删除, "删除任务信息", UserID);
ShowMessage("删除成功");
}
catch
{
ShowMessage("删除失败");
return;
}
}
}
catch (Exception ex)
{
new SysLogDAO().AddLog(LogType.系统日志, ex.Message, UserID);
ShowMessage(ex.Message);
}
this.hf_CheckIDS.Value = "";
DataBindList();
}
private void DataBindList()
{
//DateTime begindate = Convert.ToDateTime(ViewState["begin"]);
//DateTime enddate = Convert.ToDateTime(ViewState["end"]);
DateTime begindate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["begin"]));
DateTime enddate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["end"]), false);
using (IFMPDBContext db = new IFMPDBContext())
{
List <Leave> LeaveList = db.Leave.Where(t => t.IsDel != true && t.CreateDate > begindate && t.CreateDate < enddate && t.UserID == UserID).OrderByDescending(t => t.CreateDate).ToList();
if (LeaveList.Count > 0)
{
this.tr_null.Visible = false;
}
else
{
this.tr_null.Visible = true;
}
this.rp_List.DataSource = LeaveList.Skip((Pager.CurrentPageIndex - 1) * Pager.PageSize).Take(Pager.PageSize).ToList();;
Pager.RecordCount = LeaveList.Count;
this.rp_List.DataBind();
this.hf_CheckIDS.Value = "";
}
}
protected void rp_Count_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DateTime begindate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["begin"]));
DateTime enddate = new BaseUtils().GetSelectDate(Convert.ToDateTime(ViewState["end"]), false);
string Name = ViewState["Name"].ToString();
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater rep = e.Item.FindControl("rp_Count") as Repeater;//找到里层的repeater对象
HiddenField hfid = (HiddenField)e.Item.FindControl("hf_ID");
int userid = Convert.ToInt32(hfid.Value);
List <object> returnList = new List <object>();
using (IFMPDBContext db = new IFMPDBContext())
{
List <Leave> LeaveList = db.Leave.Where(t => t.UserID == userid &&
t.IsDel != true &&
t.LeaveState == LeaveState.通过 &&
t.BeginDate >= begindate && t.EndDate <= enddate).ToList();
List <object> LeaveTypeList = new List <object>();
foreach (LeaveType item in Enum.GetValues(typeof(LeaveType)))
{
double count = LeaveList.Count(t => t.LeaveType == item) > 0 ? LeaveList.Where(t => t.LeaveType == item).Sum(t => t.Day) : 0.0;
returnList.Add(new
{
Count = count
});
}
}
rep.DataSource = returnList;
rep.DataBind();
}
}
private void DataBindList()
{
string realname = ViewState["RealName"].ToString();
int depid = Convert.ToInt32(ViewState["DepID"]);
using (IFMPDBContext db = new IFMPDBContext())
{
List <User> Userlist = db.User.Where(t => t.RealName.Contains(realname) &&
(depid == -1 || db.DepartmentUser.Where(m => m.DepartmentID == depid).Select(m => m.UserID).Contains(t.ID)) &&
t.IsDel != true).OrderByDescending(t => t.CreateDate).Skip((Pager.CurrentPageIndex - 1) * Pager.PageSize).Take(Pager.PageSize).ToList();
if (Userlist.Count > 0)
{
this.tr_null.Visible = false;
}
else
{
this.tr_null.Visible = true;
}
this.rp_List.DataSource = Userlist;
Pager.RecordCount = db.User.Count(t => t.RealName.Contains(realname) &&
(depid == -1 || db.DepartmentUser.Where(m => m.DepartmentID == depid).Select(m => m.UserID).Contains(t.ID)) &&
t.IsDel != true);
this.rp_List.DataBind();
this.hf_CheckIDS.Value = "";
}
}
public void GetUserData(HttpContext context)
{
string code = context.Request.Params["code"].ToString();
string userid = "";
try
{
using (IFMPDBContext db = new IFMPDBContext())
{
//string accesstoken = new DDUtils().GetAccessToken();
string dduserid = new DDUtils().GetUserByCode(code);
User User = db.User.FirstOrDefault(t => t.DDID == dduserid);
if (User != null)
{
userid = User.ID.ToString();
}
}
}
catch (Exception ex)
{
}
context.Response.Clear();
context.Response.Write(sb.Append("{\"result\":\"true\",\"data\":\"" + userid + "\"}"));
context.Response.End();
}
