public HttpResponseMessage GetRiZhi2(string userid, string seeid, string logtick) { string res = ""; string sql1 = "select u from WkTUser u where u.KuName='" + userid + "'"; string sql2 = "select u from WkTUser u where u.Id='" + seeid + "'"; string sql3 = "select u.DeptId from Wktuser_M_Dept u where u.WktuserId=" + userid + " and u.State = " + (int)IEntity.stateEnum.Normal; BaseService baseservice = new BaseService(); List<WkTDept> theDepts = new List<WkTDept>(); IList theone = baseservice.loadEntityList(sql3); if (theone != null && theone.Count > 0) { List<RiZhiinfo> stafflist = new List<RiZhiinfo>(); WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(seeid)); string m = user.Kdid.Id.ToString(); int flog = 1; for (int i = 0; i < theone.Count; i++) { string a = ""; a = ((WkTDept)theone[i]).Id.ToString(); if (a == m) { flog = 0; string sqlstr = ""; if (logtick == "0") { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFLOG where WktUserId=" + seeid.ToString() + " and WriteTime > " + logtick.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFLOG where WktUserId=" + seeid.ToString() + " and WriteTime < " + logtick.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } IList one = baseservice.ExecuteSQL(sqlstr); if (one != null && one.Count > 0) { for (int j = 0; j < one.Count; j++) { object[] sf = (object[])one[j]; RiZhiinfo st = new RiZhiinfo(); //// Personinfo p = new Personinfo(); st.PersonId = sf[4].ToString();//分享人的ID WkTUser user1 = new WkTUser(); user1 = (WkTUser)baseservice.loadEntity(user1, Convert.ToInt64(st.PersonId)); st.PersonName = user1.KuLid;//分享人的姓名 //long mm = user1.Kdid.Id; WkTDept dept = new WkTDept(); dept = (WkTDept)baseservice.loadEntity(dept, Convert.ToInt64(m)); st.PersonDept = dept.KdName;//分享人的部门 st.Logtick = sf[3].ToString(); st.PersonMD5code = user1.ImgMD5Code; st.Contenttxt140 = HtmlToReguFormat140(sf[2].ToString());//日志内容去格式前140 ////st.ContenttxtAll = sf[5].ToString();//日志全部内容 st.RizhiTime = new DateTime(Convert.ToInt64(sf[3].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss");//日志时间 st.RizhiId = sf[1].ToString(); //日志id st.Imglist = HtmlToReguForimg(sf[2].ToString());//日志图片 List<Comments> q = new List<Comments>(); List<comm> ps = new List<comm>(); IList c = baseservice.loadEntityList("from StaffLog where State=" + (int)IEntity.stateEnum.Normal + "and Id=" + st.RizhiId); if (c != null && c.Count > 0) { foreach (StaffLog n in c) { IList<Comments> r = n.Comments; foreach (Comments s in r) { string sqql = "select u from WkTUser u where u.KuName='" + s.CommentPersonName.Trim() + "'"; WkTUser ww = (WkTUser)baseservice.loadEntityList(sqql)[0]; comm p = new comm(); p.Id = ww.Id.ToString(); p.Na = s.CommentPersonName;//评论人名字 //IList d = baseservice.loadEntityList("from StaffLog where State=" + 758); //foreach(WkTUser d1 in d) //{ // p.Id = d1.Id; //} p.Co = s.Content;//评论内容 p.Commtime = new DateTime(s.TimeStamp).ToString("yyyy年MM月dd日 HH:mm:ss"); ps.Add(p); } } } st.Comments = ps; stafflist.Add(st); } } } } RiZhiAll l = new RiZhiAll(); l.List = stafflist; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; if(flog==1) { return RiZhiYo(userid, seeid, logtick); } } else { return RiZhiYo(userid, seeid, logtick); } }
public HttpResponseMessage RiZhiYo(string userid,string seeid,string logtick) { string res = ""; BaseService baseservice = new BaseService(); string sqlstr = ""; if (logtick == "0") { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from WktuserShareUserId where SharePresonid = " + userid.ToString() + "and WktUserId=" + seeid.ToString() + " and WktuserShareUserId.STATE = 0 and WriteTime > " + logtick.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from WktuserShareUserId where SharePresonid = " + userid.ToString() + "and WktUserId=" + seeid.ToString() + " and WktuserShareUserId.STATE = 0 and WriteTime < " + logtick.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } IList nbhstaff = baseservice.ExecuteSQL(sqlstr); List<RiZhiinfo> stafflist = new List<RiZhiinfo>(); if (nbhstaff != null && nbhstaff.Count > 0) { for (int i = 0; i < nbhstaff.Count; i++) { object[] sf = (object[])nbhstaff[i]; RiZhiinfo st = new RiZhiinfo(); // Personinfo p = new Personinfo(); st.PersonId = sf[3].ToString();//分享人的ID st.PersonName = sf[6].ToString();//分享人的姓名 WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(st.PersonId)); long m = user.Kdid.Id; WkTDept dept = new WkTDept(); dept = (WkTDept)baseservice.loadEntity(dept, m); st.PersonDept = dept.KdName;//分享人的部门 st.Logtick = sf[4].ToString(); st.PersonMD5code = user.ImgMD5Code; st.Contenttxt140 = HtmlToReguFormat140(sf[5].ToString());//日志内容去格式前140 //st.ContenttxtAll = sf[5].ToString();//日志全部内容 st.RizhiTime = new DateTime(Convert.ToInt64(sf[4].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss");//日志时间 st.RizhiId = sf[7].ToString(); //日志id st.Imglist = HtmlToReguForimg(sf[5].ToString());//日志图片 List<Comments> q = new List<Comments>(); List<comm> ps = new List<comm>(); IList c = baseservice.loadEntityList("from StaffLog where State=" + (int)IEntity.stateEnum.Normal + "and Id=" + st.RizhiId); if (c != null && c.Count > 0) { foreach (StaffLog n in c) { IList<Comments> r = n.Comments; foreach (Comments s in r) { string sqql = "select u from WkTUser u where u.KuName='" + s.CommentPersonName.Trim() + "'"; WkTUser ww = (WkTUser)baseservice.loadEntityList(sqql)[0]; comm p = new comm(); p.Id = ww.Id.ToString(); p.Na = s.CommentPersonName;//评论人名字 //IList d = baseservice.loadEntityList("from StaffLog where State=" + 758); //foreach(WkTUser d1 in d) //{ // p.Id = d1.Id; //} p.Co = s.Content;//评论内容 p.Commtime = new DateTime(s.TimeStamp).ToString("yyyy年MM月dd日 HH:mm:ss"); ps.Add(p); } } } st.Comments = ps; stafflist.Add(st); } RiZhiAll l = new RiZhiAll(); l.List = stafflist; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else { res = "没有内容"; string data = "1";//JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } }
//获得所有随笔 public HttpResponseMessage GetALLSuiBi(string sbtime) { string res = ""; BaseService baseservice = new BaseService(); string sqlstr = ""; if (sbtime == "0") { //sqlstr = "select row=row_number()over(order by getdate()), dbo.SuiBi.Contents, dbo.SuiBi.WkTUserId, dbo.WK_T_DEPT.KD_NAME, dbo.WK_T_USER.KD_ID, dbo.SuiBi.WriteTime, dbo.SuiBi.STATE, dbo.SuiBi.Id, dbo.WK_T_USER.KU_NAME" + // " from dbo.SuiBi INNER JOIN dbo.WK_T_USER ON dbo.SuiBi.WkTUserId = dbo.WK_T_USER.KU_ID INNER JOIN dbo.WK_T_DEPT ON dbo.WK_T_USER.KD_ID = dbo.WK_T_DEPT.KD_ID " + // "where dbo.SuiBi.WkTUserId= "+ userid .ToString ()+" and dbo.SuiBi.STATE= 0 and dbo.SuiBi.WriteTime> "+sbtime .ToString ()+" order by dbo.SuiBi.WriteTime DESC"; //Console.WriteLine (sqlstr); //sqlstr = "with cte as" + // "(" + // "select top 100 percent row=row_number()over(order by SuiBi.WriteTime()desc), dbo.SuiBi.Contents, dbo.SuiBi.WkTUserId, dbo.WK_T_DEPT.KD_NAME, dbo.WK_T_USER.KD_ID, dbo.SuiBi.WriteTime, dbo.SuiBi.STATE, dbo.SuiBi.Id, dbo.WK_T_USER.KU_NAME" + // "from dbo.SuiBi INNER JOIN dbo.WK_T_USER ON dbo.SuiBi.WkTUserId = dbo.WK_T_USER.KU_ID INNER JOIN dbo.WK_T_DEPT ON dbo.WK_T_USER.KD_ID = dbo.WK_T_DEPT.KD_ID " + // "where dbo.SuiBi.WkTUserId=" + userid.ToString() + " and dbo.SuiBi.STATE= 0 and dbo.SuiBi.WriteTime> " + sbtime.ToString() + " order by dbo.SuiBi.WriteTime DESC" + // ") " + // "select * from cte where row between" + "1" + "and" + "10" +"order by dbo.SuiBi.WriteTime desc"; sqlstr = "with cte as" + "(select top 100 percent row=row_number()over(order by(SuiBi.WriteTime)desc), dbo.SuiBi.Contents, dbo.SuiBi.WkTUserId, dbo.WK_T_DEPT.KD_NAME, dbo.WK_T_USER.KD_ID, dbo.SuiBi.WriteTime, dbo.SuiBi.STATE, dbo.SuiBi.Id, dbo.WK_T_USER.KU_NAME " + " from dbo.SuiBi INNER JOIN dbo.WK_T_USER ON dbo.SuiBi.WkTUserId = dbo.WK_T_USER.KU_ID INNER JOIN dbo.WK_T_DEPT ON dbo.WK_T_USER.KD_ID = dbo.WK_T_DEPT.KD_ID " + " where dbo.SuiBi.STATE= 0 and dbo.SuiBi.WriteTime> " + sbtime + ")" + "select * from cte where row >0 and row <11 order by WriteTime desc"; Console.WriteLine(sqlstr); //sqlstr = "with cte as " + // "( " + // " select row=row_number()over(order by getdate()), * from SuiBiV where WkTUserId = " + userid.ToString() + " and STATE = 0 and WriteTime > " + sbtime.ToString() + // ") " + // " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as" + "(select top 100 percent row=row_number()over(order by(SuiBi.WriteTime)desc), dbo.SuiBi.Contents, dbo.SuiBi.WkTUserId, dbo.WK_T_DEPT.KD_NAME, dbo.WK_T_USER.KD_ID, dbo.SuiBi.WriteTime, dbo.SuiBi.STATE, dbo.SuiBi.Id, dbo.WK_T_USER.KU_NAME " + " from dbo.SuiBi INNER JOIN dbo.WK_T_USER ON dbo.SuiBi.WkTUserId = dbo.WK_T_USER.KU_ID INNER JOIN dbo.WK_T_DEPT ON dbo.WK_T_USER.KD_ID = dbo.WK_T_DEPT.KD_ID " + " where dbo.SuiBi.STATE= 0 and dbo.SuiBi.WriteTime<" + sbtime + ")" + "select * from cte where row >0 and row <11 order by WriteTime desc"; //sqlstr = "with cte as " + // "( " + // " select row_number()over(order by getdate()), * from SuiBiView where WkTUserId = " + userid.ToString() + " and STATE = 0 and WriteTime < " + sbtime.ToString() + // ") " + // " select * from cte where row between " + "1" + " and " + "10"; } IList nbhsuibi = baseservice.ExecuteSQL(sqlstr); List<SuiBiinfo> suibilist = new System.Collections.Generic.List<SuiBiinfo>(); if (nbhsuibi != null && nbhsuibi.Count > 0) { for (int i = 0; i < nbhsuibi.Count; i++) { SuiBiinfo st = new SuiBiinfo(); object[] o = (object[])nbhsuibi[i]; st.Suibicontent = o[1].ToString(); st.Personid = o[2].ToString(); st.Persondeptname = o[3].ToString().Trim(); st.Writetime = new DateTime(Convert.ToInt64(o[5].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss"); st.TimeTick = o[5].ToString(); st.Suibiid = o[7].ToString(); st.Personname = o[8].ToString(); suibilist.Add(st); } //for (int i = 0; i < 9; i++) //{ // SuiBiinfo st = new SuiBiinfo(); // st.Suibitime = new DateTime(((Models.SuiBi)nbhsuibi[i]).WriteTime).ToString("yyyy年MM月dd日 HH:mm"); // st.Suibicontentbefor = Htmlsuibibefor(((Models.SuiBi)nbhsuibi[i]).Contents); // st.Suibicontent = ((SuiBi)nbhsuibi[i]).Contents; // st.Suibiid = ((Models.SuiBi)nbhsuibi[i]).Id.ToString(); // //List <com > own=new System.Collections.Generic.List<com>() ; //} worklogService.Controllers.SuiBiController.SuiBiinfo.SuiBiAll all = new worklogService.Controllers.SuiBiController.SuiBiinfo.SuiBiAll(); all.List = suibilist; res = "成功"; string data = JsonTools.ObjectToJson(all); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else if (nbhsuibi != null && nbhsuibi.Count > 0 && nbhsuibi.Count < 10) { for (int i = 0; i < nbhsuibi.Count; i++) { SuiBiinfo st = new SuiBiinfo(); st.Writetime = new DateTime(((Models.SuiBi)nbhsuibi[i]).WriteTime).ToString("yyyy年MM月dd日 HH:mm:ss"); st.TimeTick = ((Models.SuiBi)nbhsuibi[i]).WriteTime.ToString(); // st.Suibicontentbefor = Htmlsuibibefor(((Models.SuiBi)nbhsuibi[i]).Contents); st.Suibiid = ((Models.SuiBi)nbhsuibi[i]).Id.ToString(); suibilist.Add(st); } worklogService.Controllers.SuiBiController.SuiBiinfo.SuiBiAll all = new worklogService.Controllers.SuiBiController.SuiBiinfo.SuiBiAll(); all.List = suibilist; res = "成功"; string data = JsonTools.ObjectToJson(all); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else { res = "没有内容"; string data = "1"; var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } /* string res = ""; BaseService baseservice = new BaseService(); IList suibitext = baseservice.loadEntityList("from SuiBi where wktuserid= " + userid.ToString() + ""); List<SuiBiinfo > ownsuibi=new System.Collections.Generic.List<SuiBiinfo>(); if (ownsuibi != null && ownsuibi.Count > 0) { for (int i = 0; i < ownsuibi.Count; i++) { } }*/ }
//别人分享给自己的日志 public HttpResponseMessage GetRiZhi1(int userid, int staffid) { string res = ""; BaseService baseservice = new BaseService(); IList nbhstaff = baseservice.ExecuteSQL("with cte as " + "( " + " select row=row_number()over(order by getdate()), * from WktuserShareUserId where SharePresonid = " + userid.ToString() + " and WktuserShareUserId.STATE = 0 and Id > " + staffid.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"); List<StaffandPerson> stafflist = new List<StaffandPerson>(); if (nbhstaff != null && nbhstaff.Count > 0) { for (int i = 0; i < nbhstaff.Count; i++) { object[] sf = (object[])nbhstaff[i]; StaffandPerson st = new StaffandPerson(); st.HeaderId = int.Parse(sf[3].ToString());//谁分享的 st.Name = sf[6].ToString();//分享人的姓名 st.Contentext = HtmlToReguFormat(sf[5].ToString()); //st.Contentext = sf[5].ToString();//日志全部内容 st.TimeText = new DateTime(Convert.ToInt64(sf[4].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss"); //st.Tag = sf[7]; //日志id //st.ContentClicked += rizhi_ContentClicked; //st.Parent = rz_flowLayoutPanel; //rz_flowLayoutPanel.Tag = sf[1];//Id号; stafflist.Add(st); } StaffAll l = new StaffAll(); l.List = stafflist; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Mseeage\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } return null; }
public HttpResponseMessage toLoginMessage([FromBody]namepwd nn) { string res; string data = "1"; string name = nn.Name; string orpwd = nn.Pwd; //string name = "mashi"; string orpwd = "186754"; BaseService baseservice = new BaseService(); IList pwd = baseservice.ExecuteSQL("select right(sys.fn_VarBinToHexStr(hashbytes('MD5', '" + orpwd.Trim() + "')),32)"); // 通过数据库加密 if (pwd == null || pwd.Count <= 0) { res = "登录异常!"; } object[] pwdArray = (object[])pwd[0]; //因为是共用表 选择是工作小秘书相关的角色 IList userList = baseservice.loadEntityList("select u from WkTUser u right join u.UserRole role where role.KrDESC='工作小秘书角色' and u.KuLid='" + name.Trim() + "' and u.KuPassWD='" + pwdArray[0] + "'"); if (userList == null || userList.Count <= 0) { res = "用户名或密码错误!"; } else if (userList.Count > 1) { res = "用户异常,请联系管理员!"; } else { Role role = new Role(); WkTUser u = (WkTUser)userList[0]; foreach (WkTRole r in u.UserRole) { if (r.KrDESC.Trim().Equals("工作小秘书角色"))//是本系统的用户角色 { role.RoleOrder = r.KrOrder.ToString(); role.RoleName = r.KrName; } } Dept d = new Dept(); d.Id = u.Kdid.Id.ToString(); d.DeptName = u.Kdid.KdName.Trim(); PersonInfo per = new PersonInfo(); per.Id = u.Id.ToString(); per.PersonName = u.KuName; per.PersonPhone = u.KuPhone; per.PersonDept = d; per.PersonRole = role; per.PersonAccount = u.KuLid; per.IMToken = u.IMToken; //if(u.im) per.MD5code = u.ImgMD5Code; per.Base64img = u.Base64Img; data = JsonTools.ObjectToJson(per); res = "登录成功"; } var jsonStr = "{\"Message\":" + "\""+res+"\"" + ","+" \"data\":"+ data+"}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; }
/// <summary> /// 获得所有的日程 /// </summary> /// <param name="userid"></param> /// <param name="rctime"></param> /// <returns></returns> public HttpResponseMessage GetAllRiCheng(string userid, string rctime) { string sqlstr = null; if (rctime == "0") { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where ScheduleTime > " + rctime.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where ScheduleTime < " + rctime.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } string res = ""; BaseService baseservice = new BaseService(); IList nbhstaff = baseservice.ExecuteSQL(sqlstr); List<RiChenginfo> info = new List<RiChenginfo>(); if (nbhstaff.Count > 0 && nbhstaff != null) { for (int i = 0; i < nbhstaff.Count; i++) { object[] rc = (object[])nbhstaff[i]; RiChenginfo ric = new RiChenginfo(); ric.RichengId = rc[1].ToString(); ric.PersonId = rc[6].ToString(); ric.RichengContent = rc[2].ToString(); ric.RichengTime = new DateTime(Convert.ToInt64(rc[3])).ToString("yyyy年MM月dd日 HH:mm:ss"); WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(rc[6])); ric.PersonName = user.KuName; ric.PersonDeptName = user.Kdid.KdName.ToString().Trim(); ric.RichengSub = rc[4].ToString(); ric.ArrangeManId = rc[10].ToString(); info.Add(ric); } RiChengAll l = new RiChengAll(); l.List = info; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else { res = "没有内容"; string data = "1";//JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } }
public HttpResponseMessage RiChengYo(string userid,string seeid,string rctime) { string res = null; string sqlstr = null; if (rctime == "0") { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from dbo.RiCheng where ScheduleTime > " + rctime.ToString() + "and WkTUserId=" + userid.ToString() +"and SharePersonId="+seeid.ToString()+ ") " + " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from dbo.RiCheng where ScheduleTime < " + rctime.ToString() + "and WkTUserId=" + userid.ToString() + "and SharePersonId=" + seeid.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } BaseService baseservice = new BaseService(); IList nbhstaff = baseservice.ExecuteSQL(sqlstr); List<RiChenginfo> info = new List<RiChenginfo>(); if (nbhstaff.Count > 0 && nbhstaff != null) { for (int i = 0; i < nbhstaff.Count; i++) { object[] rc = (object[])nbhstaff[i]; RiChenginfo ric = new RiChenginfo(); ric.RichengId = rc[9].ToString();//日程Id ric.PersonId = rc[2].ToString();//分享人Id ric.RichengContent = rc[5].ToString();//日程内容 ric.RichengTime = new DateTime(Convert.ToInt64(rc[4])).ToString("yyyy年MM月dd日 HH:mm:ss");//分享时间 ric.RemindTime = new DateTime(Convert.ToInt64(rc[7])).ToString("yyyy年MM月dd日 HH:mm:ss");//提醒时间 WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(rc[3])); ric.PersonName = user.KuName;//分享人姓名 ric.PersonDeptName = user.Kdid.KdName.ToString();//分享人部门 ric.RichengSub = rc[6].ToString();//日程主题 ric.Logtick = rc[4].ToString(); //ric.Contenttxt140 = HtmlToReguFormat140(rc[2].ToString());//日志内容去格式前140 ric.TimeTick = rc[4].ToString(); ric.ArrangeManId = rc[11].ToString(); info.Add(ric); } RiChengAll l = new RiChengAll(); l.List = info; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else { res = "没有内容"; string data = "1";//JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } }
/// <summary> /// 上下级查看分享 /// </summary> /// <param name="userid"></param> /// <param name="seeid"></param> /// <param name="rctime"></param> /// <returns></returns> public HttpResponseMessage GetRiCheng2(string userid, string seeid, string rctime) { string res = ""; string sql1 = "select u from WkTUser u where u.KuName='" + userid + "'"; string sql2 = "select u from WkTUser u where u.Id='" + seeid + "'"; string sql3 = "select u.DeptId from Wktuser_M_Dept u where u.WktuserId=" + userid + " and u.State = " + (int)IEntity.stateEnum.Normal; BaseService baseservice = new BaseService(); List<WkTDept> theDepts = new List<WkTDept>(); IList theone = baseservice.loadEntityList(sql3); if (theone != null && theone.Count > 0) { List<RiChenginfo> rlist = new List<RiChenginfo>(); WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(seeid)); string m = user.Kdid.Id.ToString(); int flog = 1; for (int i = 0; i < theone.Count; i++) { string a = ""; a = ((WkTDept)theone[i]).Id.ToString(); if (a == m) { flog = 0; string sqlstr = ""; if (rctime == "0") { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where WktUserId=" + seeid.ToString() + " and ScheduleTime > " + rctime.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } else { sqlstr = "with cte as " + "( " + " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where WktUserId=" + seeid.ToString() + " and ScheduleTime < " + rctime.ToString() + ") " + " select * from cte where row between " + "1" + " and " + "10"; } IList one = baseservice.ExecuteSQL(sqlstr); if (one != null && one.Count > 0) { for (int j = 0; j < one.Count; j++) { object[] sf = (object[])one[j]; RiChenginfo st = new RiChenginfo(); //// Personinfo p = new Personinfo(); st.PersonId = sf[6].ToString();//分享人的ID WkTUser user1 = new WkTUser(); user1 = (WkTUser)baseservice.loadEntity(user1, Convert.ToInt64(st.PersonId)); st.PersonName = user1.KuName;//分享人的姓名 //long mm = user1.Kdid.Id; WkTDept dept = new WkTDept(); dept = (WkTDept)baseservice.loadEntity(dept, Convert.ToInt64(m)); st.PersonDeptName = dept.KdName;//分享人的部门 st.Logtick = sf[3].ToString(); st.RichengTime = new DateTime(Convert.ToInt64(sf[3].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss");//日程时间 st.RichengId = sf[1].ToString(); //日程id st.RemindTime = new DateTime(Convert.ToInt64(sf[9].ToString())).ToString("yyyy年MM月dd日 HH:mm:ss");//提醒时间 st.RichengContent=sf[2].ToString();//日程内容 st.RichengSub=sf[4].ToString();//日程主题 st.ArrangeManId = sf[10].ToString(); st.TimeTick = sf[3].ToString(); rlist.Add(st); } } } } RiChengAll l = new RiChengAll(); l.List = rlist; res = "成功"; string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; if (flog == 1) { return RiChengYo(userid, seeid, rctime); } } else { return RiChengYo(userid, seeid, rctime); } }
/// <summary> /// 获得自己的日程 /// </summary> /// <param name="userid"></param> /// <param name="rctime"></param> /// <returns></returns> public HttpResponseMessage GetOwnRiCheng(string userid, string rctime) { string res = ""; string data = "1"; BaseService baseservice = new BaseService(); //List<RCDayBag> list = new List<RCDayBag>(); RCDayBagList rrll = new RCDayBagList(); long startick; long endtick; if (rctime == "0") { string fstr = "select top 1 LOG_T_STAFFSCHEDULE.ScheduleTime from LOG_T_STAFFSCHEDULE where WkTUserId = " + userid + " and STATE = 0 order by LOG_T_STAFFSCHEDULE.ScheduleTime desc"; IList firres = baseservice.ExecuteSQL(fstr); object[] obj; if (firres != null && firres.Count > 0) { obj = (object[])firres[0]; DateTime d = new DateTime(long.Parse(obj[0].ToString())); string str = d.ToString("yyyy-MM-dd"); long daytick = d.Date.Ticks; startick = d.AddDays(1).Ticks;//daytick; endtick = d.Date.Ticks; for (int i = 0; i < 10; i++) { RCDayBag rdb1 = new RCDayBag(); rdb1.DayString = str; rdb1.DayTick = daytick.ToString(); string sql1 = "with cte as " + "( " + " select row=row_number()over(order by LOG_T_STAFFSCHEDULE.ScheduleTime DESC ), * from LOG_T_STAFFSCHEDULE where ScheduleTime < " + startick.ToString() + " and ScheduleTime > " + endtick.ToString() + " and WkTUserId=" + userid.ToString() + ") " + " select * from cte "; //where row between " + "1" + " and " + "10"; IList nbhstaff1 = baseservice.ExecuteSQL(sql1); //List<RiChenginfo> info = new List<RiChenginfo>(); if (nbhstaff1.Count > 0 && nbhstaff1 != null) { long tick2 = 0; for (int i1 = 0; i1 < nbhstaff1.Count; i1++) { object[] rc = (object[])nbhstaff1[i1]; RiChenginfo ric = new RiChenginfo(); ric.RichengId = rc[1].ToString(); ric.PersonId = rc[6].ToString(); ric.RichengContent = rc[2].ToString(); ric.RichengTime = new DateTime(Convert.ToInt64(rc[3])).ToString("yyyy年MM月dd日 HH:mm:ss"); WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(rc[6])); ric.PersonName = user.KuName; ric.PersonDeptName = user.Kdid.KdName.ToString().Trim(); ric.RichengSub = rc[4].ToString(); ric.ArrangeManId = rc[10].ToString(); ric.TimeTick = rc[3].ToString(); ric.DoState = getDostate(rc[3].ToString(), rc[11]);//rc[11] == null ? rc[11].ToString() : "null"; ric.IsRemind = rc[5].ToString(); ric.RemindTime = new DateTime(Convert.ToInt64(rc[9])).ToString("yyyy年MM月dd日 HH:mm:ss"); rdb1.RichengDayList.Add(ric); //info.Add(ric); tick2 = long.Parse(rc[3].ToString()); } rrll.List.Add(rdb1); //list.Add(rdb1); //rdb1.RichengDayList = info; string str2 = "select top 1 LOG_T_STAFFSCHEDULE.ScheduleTime from LOG_T_STAFFSCHEDULE where WkTUserId = " + userid + " and STATE = 0 and ScheduleTime < " + tick2.ToString() + " order by LOG_T_STAFFSCHEDULE.ScheduleTime desc"; IList firtick2 = baseservice.ExecuteSQL(str2); if (firtick2 != null && firtick2.Count > 0) { object[] obj2 = (object[])firtick2[0]; DateTime d2 = new DateTime(long.Parse(obj2[0].ToString())); str = d2.ToString("yyyy-MM-dd"); daytick = d2.Date.Ticks; startick = d2.AddDays(1).Ticks; endtick = daytick;// d2.AddDays(-1).Ticks; } else { break; } } else { break; } } res = "成功"; //RCDayBagList rl = new RCDayBagList(); //rl.List = list; data = JsonTools.ObjectToJson(rrll); } else { res = "没有内容"; data = "1"; } var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } else { DateTime d = new DateTime(long.Parse(rctime)); string str = d.ToString("yyyy-MM-dd"); long daytick = 0;//d.Date.Ticks; startick = 0;// d.AddDays(1).Ticks;//daytick; endtick = 0;// d.Date.Ticks; string str3 = "select top 1 LOG_T_STAFFSCHEDULE.ScheduleTime from LOG_T_STAFFSCHEDULE where WkTUserId = " + userid + " and STATE = 0 and ScheduleTime < " + rctime.ToString() + " order by LOG_T_STAFFSCHEDULE.ScheduleTime desc"; IList firtick3 = baseservice.ExecuteSQL(str3); if (firtick3 != null && firtick3.Count > 0) { object[] obj3 = (object[])firtick3[0]; DateTime d3 = new DateTime(long.Parse(obj3[0].ToString())); str = d3.ToString("yyyy-MM-dd"); daytick = d3.Date.Ticks; startick = d3.AddDays(1).Ticks; endtick = daytick;// d2.AddDays(-1).Ticks; } else { res = "没有内容"; data = "1"; var jsonStr1 = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result1 = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr1, Encoding.UTF8, "text/json") }; return result1; } for (int i = 0; i < 10; i++) { RCDayBag rdb1 = new RCDayBag(); rdb1.DayString = str; rdb1.DayTick = daytick.ToString(); string sql1 = "with cte as " + "( " + " select row=row_number()over(order by LOG_T_STAFFSCHEDULE.ScheduleTime DESC ), * from LOG_T_STAFFSCHEDULE where ScheduleTime < " + startick.ToString() + " and ScheduleTime > " + endtick.ToString() + " and WkTUserId=" + userid.ToString() + ") " + " select * from cte "; //where row between " + "1" + " and " + "10"; IList nbhstaff1 = baseservice.ExecuteSQL(sql1); //List<RiChenginfo> info = new List<RiChenginfo>(); if (nbhstaff1.Count > 0 && nbhstaff1 != null) { long tick2 = 0; for (int i1 = 0; i1 < nbhstaff1.Count; i1++) { object[] rc = (object[])nbhstaff1[i1]; RiChenginfo ric = new RiChenginfo(); ric.RichengId = rc[1].ToString(); ric.PersonId = rc[6].ToString(); ric.RichengContent = rc[2].ToString(); ric.RichengTime = new DateTime(Convert.ToInt64(rc[3])).ToString("yyyy年MM月dd日 HH:mm:ss"); WkTUser user = new WkTUser(); user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(rc[6])); ric.PersonName = user.KuName; ric.PersonDeptName = user.Kdid.KdName.ToString().Trim(); ric.RichengSub = rc[4].ToString(); ric.ArrangeManId = rc[10].ToString(); ric.DoState = getDostate(rc[3].ToString(), rc[11]);//rc[11]==null?rc[11].ToString():"null"; ric.TimeTick = rc[3].ToString(); //info.Add(ric); rdb1.RichengDayList.Add(ric); tick2 = long.Parse(rc[3].ToString()); } //rdb1.RichengDayList = info; rrll.List.Add(rdb1); string str2 = "select top 1 LOG_T_STAFFSCHEDULE.ScheduleTime from LOG_T_STAFFSCHEDULE where WkTUserId = " + userid + " and STATE = 0 and ScheduleTime < " + tick2.ToString() + " order by LOG_T_STAFFSCHEDULE.ScheduleTime desc"; IList firtick2 = baseservice.ExecuteSQL(str2); if (firtick2 != null && firtick2.Count > 0) { object[] obj = (object[])firtick2[0]; DateTime d2 = new DateTime(long.Parse(obj[0].ToString())); str = d2.ToString("yyyy-MM-dd"); daytick = d2.Date.Ticks; startick = d2.AddDays(1).Ticks; endtick = daytick;// d2.AddDays(-1).Ticks; } else { break; } } else { break; } //list.Add(rdb1); } res = "成功"; //RCDayBagList rl = new RCDayBagList(); //rl.List = list; data = JsonTools.ObjectToJson(rrll); //} //else //{ // res = "没有内容"; // data = "1"; //} var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; } //string sqlstr = null; //if (rctime == "0") //{ // sqlstr = "with cte as " + // "( " + // " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where ScheduleTime > " + rctime.ToString() + "and WkTUserId=" + userid.ToString() + // ") " + // " select * from cte where row between " + "1" + " and " + "10"; //} //else //{ // sqlstr = "with cte as " + // "( " + // " select row=row_number()over(order by getdate()), * from LOG_T_STAFFSCHEDULE where ScheduleTime < " + rctime.ToString() + "and WkTUserId=" + userid.ToString() + // ") " + // " select * from cte where row between " + "1" + " and " + "10"; //} //IList nbhstaff = baseservice.ExecuteSQL(sqlstr); //List<RiChenginfo> info = new List<RiChenginfo>(); //if (nbhstaff.Count > 0 && nbhstaff != null) //{ // for (int i = 0; i < nbhstaff.Count; i++) // { // object[] rc = (object[])nbhstaff[i]; // RiChenginfo ric = new RiChenginfo(); // ric.RichengId = rc[1].ToString(); // ric.PersonId = rc[6].ToString(); // ric.RichengContent = rc[2].ToString(); // ric.RichengTime = new DateTime(Convert.ToInt64(rc[3])).ToString("yyyy年MM月dd日 HH:mm:ss"); // WkTUser user = new WkTUser(); // user = (WkTUser)baseservice.loadEntity(user, Convert.ToInt64(rc[6])); // ric.PersonName = user.KuName; // ric.PersonDeptName = user.Kdid.KdName.ToString().Trim(); // ric.RichengSub = rc[4].ToString(); // ric.ArrangeManId = rc[10].ToString(); // ric.TimeTick = rc[3].ToString(); // info.Add(ric); // } // RiChengAll l = new RiChengAll(); // l.List = info; // res = "成功"; // data = JsonTools.ObjectToJson(l); // var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; // var result = new HttpResponseMessage(HttpStatusCode.OK) // { // Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") // }; // return result; //} //else //{ // res = "没有内容"; // data = "1";//JsonTools.ObjectToJson(l); // var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + "\"data\":" + data + "}"; // var result = new HttpResponseMessage(HttpStatusCode.OK) // { // Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") // }; // return result; //} }