/// <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;
}
}
/// <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);
}
}
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="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;
//}
}
