private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
//checkState =
//if (!string.IsNullOrEmpty(StrTitle))
//{
// IsNull = true;
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "OACompanySendDoc.SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
// paras.Add(StrTitle);
//}
if (checkState != "2")
{
filter += "HouseRecordObj.ISSETTLEMENT ^@" + paras.Count().ToString();//标题名称
paras.Add(checkState);
}
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
//Utility.GetLoginUserInfo(loginUserInfo);
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
}
if (!string.IsNullOrEmpty(txtUptown.Text.Trim()))
{
filter += "houseInfoObj.UPTOWN^@" + paras.Count().ToString();
paras.Add(txtUptown.Text.Trim());
}
if (!string.IsNullOrEmpty(txtHouseName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseInfoObj.HOUSENAME^@" + paras.Count().ToString();
paras.Add(txtHouseName.Text.Trim());
}
string StrStart = "";
string StrEnd = "";
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
//MessageBox.Show("开始时间不能大于结束时间");
Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseAppObj.STARTDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseAppObj.STARTDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
loadbar.Start();
client.GetHireRecordListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "HouseRecordObj.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
