private static string GetList()
{
string strreturn;
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string strSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strSearch");
string strCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strCompany");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "createdTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearch = false;
if (strSearch != "")
{
isSearch = true;
}
bool isSearchCompany = false;
if (strCompany != "")
{
isSearchCompany = true;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间";
if (string.IsNullOrEmpty(serBeginTime))
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if (string.IsNullOrEmpty(serEndTime))
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
var eduCompanyList = NetSchool.BLL.EduCompany.Search(IsSearchCompany: isSearchCompany, company: strCompany, IsSearchTerritory: isSearch, territory: strSearch, startTime: stamp.startTime, endTime: stamp.endTime, pageInfo: pageInfo);
packageDatatable(eduCompanyList);
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = eduCompanyList }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strreturn);
}
private static Common.Enums.StampStruct[] GetStampParas(int Year)
{
Common.Enums.StampStruct[] stamps = new Common.Enums.StampStruct[12];
string stTime;
string eTime;
for (int i = 0; i < 12; i++)
{
stamps[i].name = months[i];
int st = i + 1;
int et = i + 2;
if (et > 12)
{
Year += 1;
et = 1;
}
stTime = Year.ToString() + "-" + st.ToString() + "-01 00:00:00";
eTime = Year.ToString() + "-" + et.ToString() + "-01 00:00:00";
stamps[i].startTime = Common.Library.ChangeTime.GetStamp(stTime);
stamps[i].endTime = Common.Library.ChangeTime.GetStamp(eTime);
}
return(stamps);
}
private static string ExportExcel(HttpRequest Request)
{
string strReturn;
string serCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serCompany");
string serIDCard = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serIDCard");
string serTerritory = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serTerritory");
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string serStatus = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serStatus");
string userName = NetSchool.Common.Info.CurUserInfo.Username;
bool searchCompany = true;
if ("" == serCompany)
{
searchCompany = false;
}
bool searchIDCard = true;
if ("" == serIDCard)
{
searchIDCard = false;
}
bool searchTerritory = true;
if ("" == serTerritory)
{
searchTerritory = false;
}
bool searchStatus = true;
if ("all" == serStatus)
{
searchStatus = false;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间1";
if ("" == serBeginTime)
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if ("" == serEndTime)
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
DataTable dtExamInfoList = new DataTable();
dtExamInfoList = NetSchool.BLL.EduExamInfo.Search(IsSearchCompany: searchCompany, Company: serCompany, IsSearchIdcard: searchIDCard, Idcard: serIDCard, IsSearchTerritory: searchTerritory, Territory: serTerritory, IsSearchStatus: searchStatus, Status: serStatus, StartTime: stamp.startTime, EndTime: stamp.endTime);
packageDatatable(dtExamInfoList);
DataTable dt = new DataTable();
dt.Columns.Add("ID", Type.GetType("System.Int32"));
dt.Columns[0].AutoIncrement = true;
dt.Columns[0].AutoIncrementSeed = 1;
dt.Columns[0].AutoIncrementStep = 1;
dt.Columns.Add("姓名", Type.GetType("System.String"));
dt.Columns.Add("性别", Type.GetType("System.String"));
dt.Columns.Add("发证日期", Type.GetType("System.String"));
dt.Columns.Add("卡号", Type.GetType("System.String"));
for (int i = 0; i < dtExamInfoList.Rows.Count; i++)
{
DataRow dtRow = dt.NewRow();;
dtRow["姓名"] = "'" + dtExamInfoList.Rows[i]["EduUserName"];
switch (dtExamInfoList.Rows[i]["gender"].ToString())
{
case "female":
dtRow["性别"] = "男"; break;
case "male":
dtRow["性别"] = "女"; break;
case "secret":
dtRow["性别"] = "保密"; break;
default:
dtRow["性别"] = ""; break;
}
dtRow["发证日期"] = DateTime.Now.ToString("yyyy-MM-dd");
dtRow["卡号"] = "'" + dtExamInfoList.Rows[i]["idcard"];
dt.Rows.Add(dtRow);
}
string fileName = "/File/Excel/ExportExcel" + userName + "(" + DateTime.Now.ToString().Replace("/", "").Replace(":", "").Replace(" ", "") + ").xls";
string tabName = "CardInfo";
string reMsg = string.Empty;
bool result = NetSchool.Common.Library.ExcelOP.DataTableExportToExcel(dt, Request.PhysicalApplicationPath + fileName, tabName, ref reMsg);
if (result)
{
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", dUrl = fileName }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = reMsg, dUrl = "/File/Excel/" + fileName + ".xls" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
return(strReturn);
}
private static string GetList()
{
string strReturn;
string serCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serCompany");
string serIDCard = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serIDCard");
string serTerritory = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serTerritory");
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string serStatus = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serStatus");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "endTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool searchCompany = true;
if ("" == serCompany)
{
searchCompany = false;
}
bool searchIDCard = true;
if ("" == serIDCard)
{
searchIDCard = false;
}
bool searchTerritory = true;
if ("" == serTerritory)
{
searchTerritory = false;
}
bool searchStatus = true;
if ("all" == serStatus)
{
searchStatus = false;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间1";
if ("" == serBeginTime)
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if ("" == serEndTime)
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
DataTable dtExamInfoList = new DataTable();
dtExamInfoList = NetSchool.BLL.EduExamInfo.Search(IsSearchCompany: searchCompany, Company: serCompany, IsSearchIdcard: searchIDCard, Idcard: serIDCard, IsSearchTerritory: searchTerritory, Territory: serTerritory, IsSearchStatus: searchStatus, Status: serStatus, StartTime: stamp.startTime, EndTime: stamp.endTime, pageInfo: pageInfo);
packageDatatable(dtExamInfoList);
//NetSchool.Common.Library.ExcelOP.didExport(dtExamInfoList, "", "ExportExcel");
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = dtExamInfoList }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strReturn);
}
private static string CountStamp()
{
string strReturn;
string serCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serCompany");
string serIDCard = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serIDCard");
string serTerritory = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serTerritory");
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string serStatus = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serStatus");
int year = NetSchool.Common.Library.GetPostBack.GetPostBackInt("strYear", DateTime.Now.Year);
bool searchCompany = true;
if ("" == serCompany)
{
searchCompany = false;
}
bool searchIDCard = true;
if ("" == serIDCard)
{
searchIDCard = false;
}
bool searchTerritory = true;
if ("" == serTerritory)
{
searchTerritory = false;
}
bool searchStatus = true;
if ("all" == serStatus || "" == serStatus)
{
searchStatus = false;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间1";
if ("" == serBeginTime)
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if ("" == serEndTime)
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
DataTable dtCountStatusList = new DataTable();
dtCountStatusList = NetSchool.BLL.EduExamInfo.GetCountListByStamp(year, IsSearchCompany: searchCompany, Company: serCompany, IsSearchIdcard: searchIDCard, Idcard: serIDCard, IsSearchTerritory: searchTerritory, Territory: serTerritory, IsSearchStatus: searchStatus, Status: serStatus, StartTime: stamp.startTime, EndTime: stamp.endTime);
List <object> lists = new List <object>();
foreach (DataRow dr in dtCountStatusList.Rows)
{
var obj = new { name = dr["Month"], value = dr["Count"] };
lists.Add(obj);
}
int[] monthCountList = new int[months.Length];
for (int i = 0; i < months.Length; i++)
{
monthCountList[i] = (int)dtCountStatusList.Rows[i]["Count"];
}
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", year = year, list = lists, countList = monthCountList, monthList = months }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strReturn);
}
private static string CountTerritory()
{
string strReturn;
string serCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serCompany");
string serIDCard = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serIDCard");
string serTerritory = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serTerritory");
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string serStatus = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serStatus");
bool searchCompany = true;
if ("" == serCompany)
{
searchCompany = false;
}
bool searchIDCard = true;
if ("" == serIDCard)
{
searchIDCard = false;
}
bool searchTerritory = true;
if ("" == serTerritory)
{
searchTerritory = false;
}
bool searchStatus = true;
if ("all" == serStatus)
{
searchStatus = false;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间1";
if ("" == serBeginTime)
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if ("" == serEndTime)
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
DataTable dtCountStatusList = new DataTable();
string cloumn = "territory";
dtCountStatusList = NetSchool.BLL.EduExamInfo.SearchCount(Cloumn: cloumn, IsSearchCompany: searchCompany, Company: serCompany, IsSearchIdcard: searchIDCard, Idcard: serIDCard, IsSearchTerritory: searchTerritory, Territory: serTerritory, IsSearchStatus: searchStatus, Status: serStatus, StartTime: stamp.startTime, EndTime: stamp.endTime);
packOutNull(dtCountStatusList);
List <object> lists = new List <object>();
foreach (DataRow dr in dtCountStatusList.Rows)
{
var obj = new { name = dr["territory"], value = dr["Count"] };
lists.Add(obj);
}
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", list = lists }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strReturn);
}
private static string GetList()
{
string strreturn;
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string strCompanySearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("searchCompanyTxt");
string strIdcardSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strIdcardSearch");
string strRolesSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strRolesSearch");
string strGenderSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strGenderSearch");
string strNicknameSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strNicknameSearch");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "createdTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearchByCompany = false;
bool isSearchByIdcard = false;
bool isSearchByGender = false;
bool isSearchByRoles = false;
bool isSearchByNickname = false;
if (!string.IsNullOrEmpty(strNicknameSearch))
{
isSearchByNickname = true;
}
if (!string.IsNullOrEmpty(strCompanySearch))
{
isSearchByCompany = true;
}
if (!string.IsNullOrEmpty(strIdcardSearch))
{
isSearchByIdcard = true;
}
if (!string.IsNullOrEmpty(strGenderSearch))
{
isSearchByGender = true;
}
if (!string.IsNullOrEmpty(strRolesSearch))
{
isSearchByRoles = true;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间";
if (string.IsNullOrEmpty(serBeginTime))
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if (string.IsNullOrEmpty(serEndTime))
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
var allRoles = NetSchool.BLL.EduUser.GetALLRolesDistinct();
var eduUserList = NetSchool.BLL.EduUser.Search(IsSearchCompany: isSearchByCompany, Company: strCompanySearch, IsSearchNickName: isSearchByNickname, NickName: strNicknameSearch, IsSearchIdcard: isSearchByIdcard, Idcard: strIdcardSearch, IsSearchRoles: isSearchByRoles, Roles: strRolesSearch, IsSearchGender: isSearchByGender, Gender: strGenderSearch, StartTime: stamp.startTime, EndTime: stamp.endTime, pageInfo: pageInfo);
packageDatatable(eduUserList);
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = eduUserList, rolesList = allRoles }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strreturn);
}
