public HttpResponseMessage GetAlldeptAndusers() { BaseService baseservice = new BaseService(); IList nhbdepts = baseservice.loadEntityList("select u from WkTDept u"); IList nhbpersons = baseservice.loadEntityList("select u from WkTUser u "); List<DeptsandPerson> dplist = new List<DeptsandPerson>(); foreach (WkTDept o in nhbdepts) { DeptsandPerson dp = new DeptsandPerson(); Dept d = new Dept(); d.Id = o.Id.ToString(); d.DeptName = o.KdName.Trim(); dp.Dept = d; List<PersonInfo> pers = new List<PersonInfo>(); foreach (WkTUser n in nhbpersons) { if (n.Kdid.Id == o.Id) { PersonInfo per = new PersonInfo(); per.Id = n.Id.ToString(); per.PersonName = n.KuName; per.PersonPhone = n.KuPhone; per.MD5code = n.ImgMD5Code; //per.Base64img = n.Base64Img; per.IMToken = n.IMToken; per.PersonDept = d; pers.Add(per); } } dp.Persons = pers; dplist.Add(dp); } DeptsandPersonlist l = new DeptsandPersonlist(); l.List = dplist; string 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; }
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 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 IEnumerable<long> Get() { BaseService baseservice = new BaseService(); IList i = baseservice.loadEntityList("select u from Comments u "); long[] b = new long[2000]; int num = 0; foreach (Comments o in i) { b[num] = o.Id; num++; } return b; //return new string[] { "value1", "value2" }; }
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; }
//签退 public HttpResponseMessage GetsignExitInfo(int id) { string res = ""; string timetxt = ""; BaseService baseService = new BaseService(); DateTime today; today = DateTime.Now; WkTUser user = new WkTUser(); user = (WkTUser)baseService.loadEntity(user, id); if (CNDate.isworkDay(today.Date.Ticks)) { IList attendanceList = baseService.loadEntityList("from Attendance where STATE=" + (int)IEntity.stateEnum.Normal + " and User="******" and SignDate=" + today.Date.Ticks); if (attendanceList != null && attendanceList.Count == 1) { Attendance todaySignStart = (Attendance)attendanceList[0]; IList usuallyDayList = baseService.loadEntityList("from UsuallyDay where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + today.Date.Ticks + " order by StartTime desc"); if (usuallyDayList != null && usuallyDayList.Count == 1) { UsuallyDay u = (UsuallyDay)usuallyDayList[0]; if (u.WorkTimeEnd <= today.TimeOfDay.Ticks)//未早退 { if (todaySignStart.LateOrLeaveEarly == (int)Attendance.lateOrLeaveEarlyEnum.LateAndEarly) //登陆为LateAndEarly表示迟到 { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.Late; // 只是迟到 } else { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.Normal; // 正常签到 } } else //早退 { if (todaySignStart.LateOrLeaveEarly == (int)Attendance.lateOrLeaveEarlyEnum.LateAndEarly) { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.LateAndEarly; //迟到并且早退 } else { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.Early; //只是早退 } } } todaySignStart.SignEndTime = today.TimeOfDay.Ticks; todaySignStart.SignDate = today.Date.Ticks; todaySignStart.SignDay = today.Day; todaySignStart.SignMonth = today.Month; todaySignStart.SignYear = today.Year; todaySignStart.State = (int)IEntity.stateEnum.Normal; todaySignStart.TimeStamp = DateTime.Now.Ticks; todaySignStart.User = user; try { baseService.SaveOrUpdateEntity(todaySignStart); res = "签退成功"; } catch { res = "签退失败"; } timetxt = CNDate.getTimeByTimeTicks(todaySignStart.SignStartTime) + "-" + CNDate.getTimeByTimeTicks(today.TimeOfDay.Ticks); } } var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + " \"data\":\"" + timetxt + "\"}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; }
public HttpResponseMessage GetAttenceInfo(int id) { BaseService baseService = new BaseService (); string res = ""; string timetxt = "" ; WkTUser user = new WkTUser () ; user = (WkTUser)baseService.loadEntity(user, id); DateTime today; today = DateTime.Now; if (CNDate.isworkDay(today.Date.Ticks))//工作日登录 { //查询最近的工作起始时间安排 IList attendanceList = baseService.loadEntityList("from Attendance where STATE=" + (int)IEntity.stateEnum.Normal + " and User="******" and SignDate=" + today.Date.Ticks); if (attendanceList != null && attendanceList.Count == 1)//今天登录过 { res = "今天登录过"; Attendance atd = (Attendance)attendanceList[0]; timetxt += atd.SignStartTime != 0 ? CNDate.getTimeByTimeTicks(atd.SignStartTime) : ""; timetxt += "-"; timetxt += atd.SignEndTime != 0 ? CNDate.getTimeByTimeTicks(atd.SignEndTime) : "未签退"; } else // 今天没有登陆过 { Attendance todaySignStart = new Attendance();//用于记录考勤信息 IList usuallyDayList = baseService.loadEntityList("from UsuallyDay where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + today.Date.Ticks + " order by StartTime desc"); //查询作息时间 if (usuallyDayList != null && usuallyDayList.Count == 1) //存在作息时间设置 { UsuallyDay u = (UsuallyDay)usuallyDayList[0]; if (u.WorkTimeStart >= today.TimeOfDay.Ticks) { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.Early; // 正常签到 } else { todaySignStart.LateOrLeaveEarly = (int)Attendance.lateOrLeaveEarlyEnum.LateAndEarly; // 迟到 } } todaySignStart.SignStartTime = today.TimeOfDay.Ticks; todaySignStart.SignDate = today.Date.Ticks; todaySignStart.SignDay = today.Day; todaySignStart.SignMonth = today.Month; todaySignStart.SignYear = today.Year; todaySignStart.State = (int)IEntity.stateEnum.Normal; todaySignStart.TimeStamp = DateTime.Now.Ticks; todaySignStart.User = user; try { baseService.SaveOrUpdateEntity(todaySignStart); res = "签到成功"; } catch { res = "签到失败"; } timetxt = CNDate.getTimeByTimeTicks(todaySignStart.SignStartTime) + "-"+"未签退"; } } else { timetxt = "今天是休息日"; //this.attendance_label.Text = "今天是休息日"; } //string data = JsonTools.ObjectToJson(l); var jsonStr = "{\"Message\":" + "\"" + res + "\"" + "," + " \"data\":\"" + timetxt + "\"}"; var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(jsonStr, Encoding.UTF8, "text/json") }; return result; }
/// <summary> /// 判断是否是工作日,工作日为true /// </summary> /// <param name="ticks">Date的Ticks</param> /// <returns></returns> public static bool isworkDay(long ticks) { DateTime today = new DateTime(ticks); BaseService baseService = new BaseService(); IList holidayList = baseService.loadEntityList("from Holiday where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + ticks + " and EndTime>=" + ticks); if (holidayList != null && holidayList.Count == 1) { return false; } IList workDayList = baseService.loadEntityList("from WorkDay where STATE=" + (int)IEntity.stateEnum.Normal + " and WorkDateTime=" + ticks); if (workDayList != null && workDayList.Count == 1) { return false; } IList usuallyDayList = baseService.loadEntityList("from UsuallyDay where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + ticks + " order by StartTime desc"); if (usuallyDayList != null && usuallyDayList.Count == 1) { UsuallyDay u = (UsuallyDay)usuallyDayList[0]; char[] workDays = u.WorkDay.ToCharArray(); if (((int)today.DayOfWeek != 0 && workDays[(int)today.DayOfWeek - 1].Equals((char)UsuallyDay.workDayEnum.Holiday)) || ((int)today.DayOfWeek == 0 && workDays[6].Equals((char)UsuallyDay.workDayEnum.Holiday))) { return false; } else if (((int)today.DayOfWeek != 0 && workDays[(int)today.DayOfWeek - 1].Equals((char)UsuallyDay.workDayEnum.WorkDay)) || ((int)today.DayOfWeek == 0 && workDays[6].Equals((char)UsuallyDay.workDayEnum.WorkDay))) { return true; } } return true; }
public static List<long> getWorkDayNum(DateTime startDate, DateTime endDate) { BaseService baseService = new BaseService(); IList workDays = new List<int>(); IList holidayList = baseService.loadEntityList("from Holiday where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + startDate.Date.Ticks + " and EndTime>=" + endDate.Date.Ticks); if (holidayList == null || holidayList.Count == 0) { holidayList = new List<long>(); } IList workDayList = baseService.loadEntityList("from WorkDay where STATE=" + (int)IEntity.stateEnum.Normal + " and WorkDateTime<=" + startDate.Date.Ticks + " and WorkDateTime>=" + endDate.Date.Ticks); if (workDayList == null || holidayList.Count == 0) { workDayList = new List<long>(); } IList usuallyDayList = baseService.loadEntityList("from UsuallyDay where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + startDate.Date.Ticks + " order by StartTime desc"); if (usuallyDayList != null && usuallyDayList.Count == 1) { UsuallyDay u = (UsuallyDay)usuallyDayList[0]; char[] wd = u.WorkDay.ToCharArray(); for (int i = 0; i < wd.Length; i++) { if (wd[i].Equals((char)UsuallyDay.workDayEnum.WorkDay)) { workDays.Add(i); } } } List<long> dateList = new List<long>(); long ticks = startDate.Date.Ticks; while (ticks <= endDate.Date.Ticks) { DateTime date = new DateTime(ticks); if (holidayList.Contains(ticks)) { ticks = new DateTime(ticks).AddDays(1).Date.Ticks; continue; } if (workDayList.Contains(ticks)) { dateList.Add(ticks); ticks = new DateTime(ticks).AddDays(1).Date.Ticks; continue; } if (IsInWorkDay(date, workDays)) { dateList.Add(ticks); } //foreach (int dayOfWeek in workDays) //{ // if ((dayOfWeek + 1 == (int)date.DayOfWeek)||(dayOfWeek == 6 && (int)date.DayOfWeek == 0)) //一个星期中的第几天 // { // ticks = new DateTime(ticks).AddDays(1).Date.Ticks; // break; // continue; // } //} ticks = new DateTime(ticks).AddDays(1).Date.Ticks; } return dateList; }
/// <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); } }