private GetUser GetUser(string currentUser)
{
GetUser result = new GetUser();
try
{
string url = SPContext.Current.Site.Url;
using (SPSite site = new SPSite(url))
{
using (SPWeb web = site.OpenWeb())
{
List<string> phongBan = new List<string>();
string pb = string.Empty;
SPList list = web.Lists["NguoiDung"];
SPQuery query = new SPQuery();
query.Query = "<OrderBy><FieldRef Name='ID' Ascending='TRUE' /></OrderBy>";
query.ViewFields = "<FieldRef Name='ID'/><FieldRef Name='User'/><FieldRef Name='NhomNguoiDung'/><FieldRef Name='HoVaTen'/>";
query.ViewFieldsOnly = true;
DataTable dtGetData = list.GetItems(query).GetDataTable();
var _node = dtGetData.AsEnumerable().Where(x => !string.IsNullOrEmpty(x.Field<string>("User")) && x.Field<string>("User").Equals(currentUser) && !string.IsNullOrEmpty(x.Field<string>("NhomNguoiDung")));
//count.Add(_countDangXuLy);
if (_node.Any())
{
DataTable temp = _node.CopyToDataTable();
phongBan = temp.AsEnumerable().Select(x => x.Field<string>("NhomNguoiDung")).ToList();
for (int i = 0; i < phongBan.ToArray().Length; i++)
{
pb = phongBan.ToArray()[i];
}
}
if (!string.IsNullOrEmpty(pb))
{
var _temp = dtGetData.AsEnumerable().Where(x => !string.IsNullOrEmpty(x.Field<string>("NhomNguoiDung")) && x.Field<string>("NhomNguoiDung").Equals(pb));
if (_temp.Any())
{
DataTable totemp = _temp.CopyToDataTable();
result.User = totemp.AsEnumerable().Select(x => x.Field<string>("User")).ToArray();
result.HoVaTen = totemp.AsEnumerable().Select(x => x.Field<string>("HoVaTen")).ToArray();
}
}
}
}
}
catch (Exception)
{
}
return result;
}
private void Page_Load(object sender, EventArgs e)
{
try
{
DateTime today = DateTime.Now;
int tuan = GetWeekOrderInYear(today);
DateTime firstDay = GetFirstDayOfWeek(DateTime.Now.Year.ToString(), tuan);
DateTime lastDay = GetLastDayOfWeek(DateTime.Now.Year.ToString(), tuan);
DateTime now = DateTime.Now;
DateTime fd = new DateTime(now.Year, now.Month, 1);
DateTime ld = fd.AddMonths(1).AddDays(-1);
string[] user;
//categories.Tuan1 = "Tuần " + (tuan - 3);
//categories.Tuan2 = "Tuần " + (tuan - 2);
//categories.Tuan3 = "Tuần " + (tuan - 1);
//categories.Tuan4 = "Tuần " + (tuan);
//categoryStr = ConvertObjectToJson(categories);
string url = Tandan.Utilities.Utility.GetAbsoluteSiteUrl(this.SiteUrl);
using (SPSite site = new SPSite(url))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists["CongViec"];
SPQuery query = new SPQuery();
query.Query = string.Concat("<Where>",
"<Or>",
"<IsNull>",
"<FieldRef Name='HanHoanThanh'/>",
"</IsNull>",
"<And>",
"<IsNotNull>",
"<FieldRef Name='HanHoanThanh'/>",
"</IsNotNull>",
"<Geq>",
"<FieldRef Name='HanHoanThanh'/>",
"<Value IncludeTimeValue='FALSE' Type='DateTime'>" + fd.ToString("yyyy-MM-ddThh:mm:ssZ") + "</Value>",
"</Geq>",
"</And>",
"</Or>",
"</Where>",
"<OrderBy><FieldRef Name='ID' Ascending='TRUE' /></OrderBy>");
query.ViewFields = string.Concat("<FieldRef Name='ID'/>",
"<FieldRef Name='NgayBatDau'/>",
"<FieldRef Name='NguoiThucHien'/>",
"<FieldRef Name='DaKetThuc'/>",
"<FieldRef Name='HanHoanThanh'/>",
"<FieldRef Name='NgayKetThuc'/>",
"<FieldRef Name='NgayChuyenXuLy'/>",
"<FieldRef Name='NguoiChuyenXuLy'/>",
"<FieldRef Name='NguoiDaThucHien'/>");
query.ViewFieldsOnly = true;
getUser = GetUser(web.CurrentUser.ToString());
//category = getUser.HoVaTen;
category = ConvertObjectToJson(getUser.HoVaTen);
SPListItemCollection items = list.GetItems(query);
if (items != null && items.Count != 0)
{
DataTable dtGetData = items.GetDataTable();
user = getUser.User;
DangXuLy = GetDataByLinQ(tuan, "Đang xử lý", dtGetData, user);
ChuyenXuLy = GetDataByLinQ(tuan, "Đã chuyển xử lý", dtGetData, user);
DaXuLy = GetDataByLinQ(tuan, "Đã xử lý", dtGetData, user);
DangXuLyStr = ConvertObjectToJson(DangXuLy);
ChuyenXuLyStr = ConvertObjectToJson(ChuyenXuLy);
DaXuLyStr = ConvertObjectToJson(DaXuLy);
}
}
}
}
catch (Exception ex)
{
//TextBox1.Text = ex.ToString();
}
}