public bool SetYGInfo(string USERID, string Name, string OPHONE, string StateATT) { try { using (kaoqingEntities db = new kaoqingEntities()) { var uid = Convert.ToInt32(USERID); var entity = db.USERINFO.Where(p => p.USERID == uid).FirstOrDefault(); if (entity != null) { entity.Name = Name; entity.OPHONE = OPHONE; entity.StateATT = Convert.ToInt32(StateATT); db.USERINFO.Attach(entity); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(entity); stateEntity.SetModifiedProperty("Name"); stateEntity.SetModifiedProperty("OPHONE"); stateEntity.SetModifiedProperty("StateATT"); db.SaveChanges(); return(true); } return(false); } } catch { return(false); } }
private string GetName(int uid) { using (kaoqingEntities db = new kaoqingEntities()) { return(db.USERINFO.Where(p => p.USERID == uid).FirstOrDefault().Name); } }
public Models.ATTModels.UserInfoList GetYGInfo(int PageSize, int CurPage, bool isall, string Key) { try { Models.ATTModels.UserInfoList list = new ATTModels.UserInfoList(); using (kaoqingEntities db = new kaoqingEntities()) { list.listtime = db.wokeday.Select(p => p.day).ToList(); if (isall) { if (Key == null) { list.all = db.USERINFO.ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList(); } else { list.all = db.USERINFO.Where(p => p.Name.Contains(Key)).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList(); } } else { if (Key == null) { list.all = db.USERINFO.Where(p => p.StateATT == 1).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList(); } else { list.all = db.USERINFO.Where(p => p.StateATT == 1 && p.Name.Contains(Key)).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList(); } } list.ErrorCode = 0; if (isall) { if (Key == null) { list.tbCount = db.USERINFO.Count(); } else { list.tbCount = db.USERINFO.Where(p => p.Name.Contains(Key)).Count(); } } else { if (Key == null) { list.tbCount = db.USERINFO.Where(p => p.StateATT == 1).Count(); } else { list.tbCount = db.USERINFO.Where(p => p.StateATT == 1 && p.Name.Contains(Key)).Count(); } } return(list); } } catch { return(null); } }
public Models.ATTModels.UserInfoList GetUserInfo() { List <Models.ATTModels.UserInfo> list = new List <Models.ATTModels.UserInfo>(); List <Models.ATTModels.UserInfo> listALL = new List <Models.ATTModels.UserInfo>(); Models.ATTModels.UserInfoList infoList = new ATTModels.UserInfoList(); try { using (kaoqingEntities db = new kaoqingEntities()) { var T_list = db.USERINFO.Where(p => p.StateATT == 1).ToList(); foreach (var a in T_list) { Models.ATTModels.UserInfo userInfo = new ATTModels.UserInfo(); userInfo.NAME = a.Name; userInfo.StateATT = 1; userInfo.USERID = a.USERID; userInfo.OPHONE = a.OPHONE; list.Add(userInfo); } T_list = db.USERINFO.ToList(); foreach (var a in T_list) { Models.ATTModels.UserInfo userInfo = new ATTModels.UserInfo(); userInfo.NAME = a.Name; userInfo.StateATT = 0; userInfo.USERID = a.USERID; userInfo.OPHONE = a.OPHONE; listALL.Add(userInfo); } infoList.list = list; infoList.listAll = listALL; infoList.ErrorCode = 0; return(infoList); } }catch (Exception ex) { infoList.list = null; infoList.listAll = null; infoList.ErrorCode = -1; return(infoList); } }
public int Up_UserInfo(object value) { try { using (kaoqingEntities db = new kaoqingEntities()) { string str = ""; string sql = ""; JArray arrayvalue = (JArray)value; foreach (var a in arrayvalue) { int uid = Convert.ToInt32(((Newtonsoft.Json.Linq.JValue)a).Value); USERINFO entity = db.USERINFO.Where(p => p.USERID == uid).FirstOrDefault(); entity.StateATT = 1; db.USERINFO.Attach(entity); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(entity); stateEntity.SetModifiedProperty("StateATT"); db.SaveChanges(); str += uid.ToString(); str += ","; } if (str == "") { sql = "update USERINFO set StateATT = 0"; } else { str = str.Substring(0, str.Length - 1); sql = "update USERINFO set StateATT = 0 where USERID not in(" + str + ")"; } db.Database.ExecuteSqlCommand(sql); return(0); } } catch (Exception ex) { return(-1); } }
public Models.ATTModels.ValidateATTInfoS ValidateATT(object workday, object satday, object time) { JArray arraytime = (JArray)time; string stime = arraytime[0].ToString(); string etime = arraytime[1].ToString(); List <Models.ATTModels.ATTModelInfo> list = new List <Models.ATTModels.ATTModelInfo>(); list = QueryATTInfo(null, Convert.ToDateTime(stime), Convert.ToDateTime(etime).AddDays(1), 999999, 1).list; List <Models.ATTModels.ValidateATT> listVA = new List <ATTModels.ValidateATT>(); Models.ATTModels.ValidateATTInfoS aTTInfoS = new ATTModels.ValidateATTInfoS(); List <string> arrayworkday = ChangeDay((JArray)workday); List <string> arraysatday = ChangeDay((JArray)satday); try { using (kaoqingEntities db = new kaoqingEntities()) { var userlist = db.USERINFO.Where(p => p.StateATT == 1).ToList(); foreach (var a in userlist) { var vt = CheckValidateATT(a.USERID, list, arrayworkday, arraysatday); foreach (var vtt in vt) { listVA.Add(vtt); } } aTTInfoS.ErrorCode = 0; aTTInfoS.list = listVA; return(aTTInfoS); } }catch (Exception ex) { aTTInfoS.ErrorCode = -1; aTTInfoS.list = listVA; return(aTTInfoS); } }
public Models.ATTModels.ATTNameInfoS GetNameList() { List <Models.ATTModels.ATTNameInfo> list = new List <Models.ATTModels.ATTNameInfo>(); try { using (kaoqingEntities db = new kaoqingEntities()) { // DataSet ds = new DataSet(); // string sql = "SELECT userid,name from userinfo"; // ds = AccessHelper.dataSet(sql); var ds = db.USERINFO.ToList(); // foreach (DataRow dr in ds.Tables[0].Rows) foreach (var a in ds) { Models.ATTModels.ATTNameInfo aTTNameInfo = new Models.ATTModels.ATTNameInfo(); //aTTNameInfo.NAME = dr["name"].ToString(); //aTTNameInfo.USERID = dr["userid"].ToString(); aTTNameInfo.NAME = a.Name.ToString(); aTTNameInfo.USERID = a.USERID.ToString(); list.Add(aTTNameInfo); } Models.ATTModels.ATTNameInfoS aTTNameInfoS = new Models.ATTModels.ATTNameInfoS(); aTTNameInfoS.list = list; aTTNameInfoS.ErrorCode = ""; return(aTTNameInfoS); } } catch (Exception ex) { Models.ATTModels.ATTNameInfoS aTTNameInfoS = new Models.ATTModels.ATTNameInfoS(); aTTNameInfoS.list = list; aTTNameInfoS.ErrorCode = ex.Message; return(aTTNameInfoS); } }
public Models.ATTModels.SetXList SetX(DateTime sTime, DateTime eTime, int UID) { List <Models.ATTModels.SetXUpInfo> setXUpInfos = new List <ATTModels.SetXUpInfo>(); Models.ATTModels.SetXList setXList = new ATTModels.SetXList(); int upday = 0; try { using (kaoqingEntities db = new kaoqingEntities()) { //step 1 var TimeList = GetAllDays(sTime, eTime); Random random = new Random(); foreach (var day in TimeList) { DateTime dt; dt = day.AddHours(23); dt = dt.AddMinutes(59); dt = dt.AddSeconds(59); DateTime SPM; DateTime EPM; SPM = day.AddHours(18); EPM = day.AddHours(18); EPM = EPM.AddMinutes(40); DateTime XBTime; DateTime SBTime; if (db.CHECKINOUT.Where(p => p.CHECKTIME > day && p.CHECKTIME < dt).Count() > 20) { //setp 2 int XBhour; int SBhour; if (db.CHECKINOUT.Where(p => p.CHECKTIME > SPM && p.CHECKTIME < EPM).Count() > 10) { XBhour = 18; } else { XBhour = 16; } int XBMinute = random.Next(30, 40); int XBsecond = random.Next(0, 59); XBTime = day.AddHours(XBhour); XBTime = XBTime.AddMinutes(XBMinute); XBTime = XBTime.AddSeconds(XBsecond); SBhour = 8; int SBMinute = random.Next(45, 59); int SBsecond = random.Next(0, 59); SBTime = day.AddHours(SBhour); SBTime = SBTime.AddMinutes(SBMinute); SBTime = SBTime.AddSeconds(SBsecond); //setp 3 DateTime CDtime = day.AddHours(9); CDtime = CDtime.AddMinutes(3); DateTime ZTtime = day.AddHours(16); string sql; bool updayflag = false; Models.ATTModels.SetXUpInfo setXUpInfo = new ATTModels.SetXUpInfo(); var temp = db.CHECKINOUT.Where(p => p.CHECKTIME > day && p.CHECKTIME < dt && p.USERID == UID).ToList(); if (temp.Count == 0) { //setp 3.1 //sql = "DELETE CHECKINOUT WHERE CONVERT(varchar(100), CHECKTIME, 111)= '" + day.ToString("yyyy/MM/dd") + "' and USERID=" + UID.ToString(); //db.Database.ExecuteSqlCommand(sql); List <string> sqllist = new List <string>(); sql = "INSERT INTO CHECKINOUT(USERID,CHECKTIME,VERIFYCODE,SENSORID,WorkCode,sn,UserExtFmt)VALUES(" + UID.ToString() + ",'" + SBTime.ToString() + "',1,101,0,3215154504760,1)"; db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); sql = "INSERT INTO CHECKINOUT(USERID,CHECKTIME,VERIFYCODE,SENSORID,WorkCode,sn,UserExtFmt)VALUES(" + UID.ToString() + ",'" + XBTime.ToString() + "',1,101,0,3215154504760,1)"; db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); updayflag = true; setXUpInfo.day = day.ToString(); setXUpInfo.sql = sqllist; } else { //setp 3.2 List <string> sqllist = new List <string>(); if (temp.Where(p => p.CHECKTIME < CDtime && p.USERID == UID).Count() == 0) { sql = "DELETE CHECKINOUT WHERE CHECKTIME > '" + day.ToString("yyyy/MM/dd 00:00:00") + "'and CHECKTIME<'" + day.ToString("yyyy/MM/dd 12:00:00") + "' and USERID=" + UID.ToString(); db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); sql = "INSERT INTO CHECKINOUT(USERID,CHECKTIME,VERIFYCODE,SENSORID,WorkCode,sn,UserExtFmt)VALUES(" + UID.ToString() + ",'" + SBTime.ToString() + "',1,101,0,3215154504760,1)"; db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); updayflag = true; setXUpInfo.day = day.ToString(); } //setp 3.3 if (temp.Where(p => p.CHECKTIME > ZTtime && p.USERID == UID).Count() == 0) { sql = "DELETE CHECKINOUT WHERE CHECKTIME > '" + day.ToString("yyyy/MM/dd 16:00:00") + "'and CHECKTIME<'" + day.ToString("yyyy/MM/dd 23:59:59") + "' and USERID=" + UID.ToString(); db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); sql = "INSERT INTO CHECKINOUT(USERID,CHECKTIME,VERIFYCODE,SENSORID,WorkCode,sn,UserExtFmt)VALUES(" + UID.ToString() + ",'" + XBTime.ToString() + "',1,101,0,3215154504760,1)"; db.Database.ExecuteSqlCommand(sql); sqllist.Add(sql); updayflag = true; setXUpInfo.day = day.ToString(); } setXUpInfo.sql = sqllist; } if (updayflag) { upday++; setXUpInfos.Add(setXUpInfo); } } } setXList.Code = 0; setXList.Result = "Success"; setXList.UpDays = upday; setXList.UpInfo = setXUpInfos; return(setXList); } } catch (Exception ex) { setXList.Code = -1; setXList.Result = ex.Message; setXList.UpDays = upday; setXList.UpInfo = setXUpInfos; return(setXList); } }
public Models.ATTModels.ATTModelInfoS QueryATTInfo(string Key, DateTime sTime, DateTime eTime, int PageSize, int CurPage) { List <Models.ATTModels.ATTModelInfo> list = new List <Models.ATTModels.ATTModelInfo>(); int tbCount = 0; try { using (kaoqingEntities db = new kaoqingEntities()) { string _sTime = ""; string _eTime = ""; // _sTime = sTime.Month + "/" + sTime.Day + "/" + sTime.Year; // _eTime = eTime.Month + "/" + (eTime.Day+1).ToString() + "/" + eTime.Year; _sTime = sTime.Year + "-" + sTime.Month + "-" + sTime.Day; _eTime = eTime.Year + "-" + eTime.Month + "-" + eTime.Day.ToString(); _eTime = Convert.ToDateTime(_eTime).AddDays(1).ToString("yyyy/MM/dd"); // DataSet ds = new DataSet(); //string sql = "SELECT CHECKINOUT.USERID, CHECKINOUT.CHECKTIME,USERINFO.Name FROM CHECKINOUT, USERINFO WHERE "; string sql = "SELECT distinct CHECKINOUT.CHECKTIME,CHECKINOUT.USERID,USERINFO.Name FROM CHECKINOUT, USERINFO WHERE "; if (Key != null) { if (IsNumeric(Key)) { sql += " (CHECKINOUT.USERID = "; sql += Key; sql += " or "; } else { sql += "("; } sql += " USERINFO.Name = '"; sql += Key; sql += "') and "; } //sql += " CHECKINOUT.USERID = USERINFO.USERID and CHECKINOUT.CHECKTIME between #"; //sql += _sTime; //sql += "# and #"; //sql += _eTime; //sql += "# ORDER BY CHECKINOUT.CHECKTIME;"; sql += " CHECKINOUT.USERID = USERINFO.USERID and CHECKINOUT.CHECKTIME between '"; sql += _sTime; sql += "' and '"; sql += _eTime; sql += "' ORDER BY CHECKINOUT.CHECKTIME DESC;"; // ds = AccessHelper.dataSet(sql); var ds = db.Database.SqlQuery <Models.ATTModels._ATTNameInfo>(sql); // tbCount = ds.Tables[0].Rows.Count; tbCount = ds.Count(); // foreach (DataRow dr in GetPagedTable(ds.Tables[0], CurPage, PageSize).Rows) foreach (var dr in ds.Skip((CurPage - 1) * PageSize).Take(PageSize)) { Models.ATTModels.ATTModelInfo aTTModelInfo = new Models.ATTModels.ATTModelInfo(); //aTTModelInfo.USERID = dr["USERID"].ToString(); //aTTModelInfo.NAME = dr["NAME"].ToString(); //aTTModelInfo.CHECKTIME = Convert.ToDateTime(dr["CHECKTIME"]); aTTModelInfo.USERID = dr.USERID.ToString(); aTTModelInfo.NAME = dr.NAME.ToString(); aTTModelInfo.CHECKTIME = dr.CHECKTIME; list.Add(aTTModelInfo); } Models.ATTModels.ATTModelInfoS aTTModelInfoS = new Models.ATTModels.ATTModelInfoS(); aTTModelInfoS.ErrorCode = ""; aTTModelInfoS.list = list; aTTModelInfoS.tbCount = tbCount; return(aTTModelInfoS); } } catch (Exception ex) { Models.ATTModels.ATTModelInfoS aTTModelInfoS = new Models.ATTModels.ATTModelInfoS(); aTTModelInfoS.ErrorCode = ex.Message; aTTModelInfoS.list = list; aTTModelInfoS.tbCount = 0; return(aTTModelInfoS); } }