private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (!string.IsNullOrEmpty(txtTitle.Text.Trim()))
{
filter += "ISSUANCETITLE ^@" + paras.Count().ToString();
paras.Add(txtTitle.Text.Trim());
}
//if (!string.IsNullOrEmpty(txtContent.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CONTENT ^@" + paras.Count().ToString();
// paras.Add(txtContent.Text.Trim());
//}
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;
loadbar.Start();
client.GetIssunaceListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
//加载数据
private void GetData(int pageIndex, string checkState)
{
if (cmbVehicleInfo != null && cmbVehicleInfo.Items.Count > 0)
{
int pageCount = 0;
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
paras.Add((cmbVehicleInfo.SelectionBoxItem as T_OA_VEHICLE).ASSETID);
paras.Add(dtiStartDate.DateTimeValue);
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
vehicleManager.Gets_VDCheckedAsync(pageIndex, dataPager.PageSize, "CREATEDATE", "", paras, pageCount, loginInfo);
}
}
//加载数据
private void GetData(int pageIndex, string checkState)
{
if (cmbVehicleInfo != null && cmbVehicleInfo.Items.Count > 0)
{
int pageCount = 0;
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
paras.Add((cmbVehicleInfo.SelectionBoxItem as T_OA_VEHICLE).ASSETID);
paras.Add(dtiStartDate.DateTimeValue);
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
vehicleManager.Gets_VDCheckedAsync(pageIndex, dataPager.PageSize, "CREATEDATE", "", paras, pageCount, loginInfo);
}
}
private void InitData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (Common.CurrentLoginUserInfo != null)
{
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID))
{
filter += "(distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].PostID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].PostID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.EmployeeID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString() + ")";
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
}
if (!string.IsNullOrEmpty(txtUptown.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseInfoObj.COMMUNITY ^@" + 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());
}
loadbar.Start();
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
//if (string.IsNullOrEmpty(loginUserInfo.companyID))
//{
// Utility.GetLoginUserInfo(loginUserInfo);
//}
client.GetMemberHireHouseAppListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "houselistObj.CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (!string.IsNullOrEmpty(txtTitle.Text.Trim()))
{
filter += "ISSUANCETITLE ^@" + paras.Count().ToString();
paras.Add(txtTitle.Text.Trim());
}
//if (!string.IsNullOrEmpty(txtContent.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CONTENT ^@" + paras.Count().ToString();
// paras.Add(txtContent.Text.Trim());
//}
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;
loadbar.Start();
client.GetIssunaceListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
//加载数据
private void GetData(int pageIndex)
{
loadbar.Start();
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQuery)
{
string StrContent = "";
string StrStart = "";
string StrEnd = "";
string StrConservateType = ((SMT.Saas.Tools.PermissionWS.T_SYS_DICTIONARY)cmbConserVationName.SelectedItem).DICTIONARYNAME.ToString();
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrContent = this.txtConserVationContent.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
loadbar.Stop();
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("STARTTIMENOTNULL"));
loadbar.Stop();
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "REPAIRDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "REPAIRDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (cmbConserVationName.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CONSERVATYPE ==@" + paras.Count().ToString();//类型
paras.Add(StrConservateType);
}
if (!string.IsNullOrEmpty(StrContent))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CONTENT ^@" + paras.Count().ToString();//类型名称
paras.Add(StrContent);
}
}
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
_VM.Get_VCRecordsAsync(pageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
}
private void InitData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (Common.CurrentLoginUserInfo != null)
{
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID))
{
filter += "(distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].PostID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].PostID);
}
if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.EmployeeID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
}
filter += "distrbuteObj.VIEWER =@" + paras.Count().ToString() + ")";
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
}
if (!string.IsNullOrEmpty(txtUptown.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseInfoObj.COMMUNITY ^@" + 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());
}
loadbar.Start();
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
//if (string.IsNullOrEmpty(loginUserInfo.companyID))
//{
// Utility.GetLoginUserInfo(loginUserInfo);
//}
client.GetMemberHireHouseAppListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "houselistObj.CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
/// <summary>
/// 获取派车单数据 1
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="checkState"></param>
private void GetData()
{
loadbar.Start();
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQuery)
{
string StrTitle = "";
string StrStart = "";
string StrEnd = "";
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrTitle = this.txtRoute.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
//MessageBox.Show("结束时间不能为空");
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
//MessageBox.Show("开始时间不能为空");
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "STARTTIME >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "STARTTIME <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "ROUTE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrTitle);
}
}
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
vehicleDispatchManager.Gets_VDInfoAsync(dataPager.PageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
}
/// <summary>
/// 获取派车单数据 1
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="checkState"></param>
private void GetData()
{
loadbar.Start();
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQuery)
{
string StrTitle = "";
string StrStart = "";
string StrEnd = "";
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrTitle = this.txtRoute.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
//MessageBox.Show("结束时间不能为空");
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
//MessageBox.Show("开始时间不能为空");
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "STARTTIME >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "STARTTIME <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "ROUTE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrTitle);
}
}
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
vehicleDispatchManager.Gets_VDRecordAsync(dataPager.PageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
//filter += " OWNERID ==@" + paras.Count().ToString();
//paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
if (!string.IsNullOrEmpty(txtUptown.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
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.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " houseAppObj.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
loadbar.Start();
client.GetHireAppListPagingByMemberAsync(dataPager.PageIndex, dataPager.PageSize, "houseAppObj.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
private void LoadData()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
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.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "houseAppObj.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
loadbar.Start();
//client.GetHireAppListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
client.GetHireAppListPagingByHouseInfoOrListAsync(dataPager.PageIndex, dataPager.PageSize, "houseAppObj.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
//加载数据
private void GetData(int pageIndex)
{
loadbar.Start();
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQuery)
{
string StrContent = "";
string StrStart = "";
string StrEnd = "";
string StrConservateType = ((SMT.Saas.Tools.PermissionWS.T_SYS_DICTIONARY)cmbConserVationName.SelectedItem).DICTIONARYNAME.ToString();
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrContent = this.txtConserVationContent.Text.ToString().Trim();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
loadbar.Stop();
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("STARTTIMENOTNULL"));
loadbar.Stop();
return;
}
if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
DtStart = System.Convert.ToDateTime(StrStart);
DtEnd = System.Convert.ToDateTime(StrEnd + " 23:59:59");
if (DtStart > DtEnd)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "REPAIRDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "REPAIRDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (cmbConserVationName.SelectedIndex > 0)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CONSERVATYPE ==@" + paras.Count().ToString();//类型
paras.Add(StrConservateType);
}
if (!string.IsNullOrEmpty(StrContent))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CONTENT ^@" + paras.Count().ToString();//类型名称
paras.Add(StrContent);
}
}
SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
_VM.Get_VCRecordsAsync(pageIndex, dataPager.PageSize, "UPDATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
}