private void LoadData()
{
loadbar.Start(); //打开转动动画
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (!string.IsNullOrEmpty(txtSYSTEMCODE.Text.Trim())) //系统类型
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SYSCODE ^@" + paras.Count().ToString();
paras.Add(txtSYSTEMCODE.Text.Trim());
}
if (!string.IsNullOrEmpty(txtAGENTMODULE.Text.Trim()))//代理模块
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MODELCODE ^@" + paras.Count().ToString();
paras.Add(txtAGENTMODULE.Text.Trim());
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
SoaChannel.GetAgentSetListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
void LoadMeetingTypeTemplateInfos()
{
string filter = ""; //查询过滤条件
int pageCount = 0;
string StrMeetingType = "";
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQueryBtn)
{
if (!string.IsNullOrEmpty(txtTemplateName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "TEMPLATENAME ^@" + paras.Count().ToString();
paras.Add(txtTemplateName.Text.Trim());
}
//if (!string.IsNullOrEmpty(txtContent.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CONTENT ^@" + paras.Count().ToString();
// paras.Add(txtContent.Text.Trim());
//}
if (cbMeetingType.SelectedItem != null && cbMeetingType.SelectedIndex != 0)
{
StrMeetingType = ((cbMeetingType.SelectedItem) as T_OA_MEETINGTYPE).MEETINGTYPE;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_OA_MEETINGTYPE.MEETINGTYPE ==@" + paras.Count().ToString();
paras.Add(StrMeetingType);
}
IsQueryBtn = false;
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetTypeTemplateInfosAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadMeetingTypeInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQueryBtn)
{
if (!string.IsNullOrEmpty(txtSearchType.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MEETINGTYPE ^@" + paras.Count().ToString();
paras.Add(txtSearchType.Text.Trim());
}
}
//if (!string.IsNullOrEmpty(txtSearchMemo.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "REMARK ^@" + paras.Count().ToString();
// paras.Add(txtSearchMemo.Text.Trim());
//}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loadbar.Start();
MeetingClient.GetMeetingTypeInfosAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadSendDocInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrTitle = ""; //标题
string StrStart = ""; //添加文档的起始时间
string StrEnd = ""; //添加文档的结束时间
string StrIsSave = ""; //是否归档
string StrDistrbute = ""; //是否发布
string StrGrade = ""; //级别
string StrProritity = ""; //缓急
string StrDocType = ""; //文档类型
bool IsNull = false; //用来控制是否有查询条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
//if (checkState != ((int)CheckStates.Approving).ToString())
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "OACompanySendDoc.OWNERID==@" + paras.Count().ToString();
// paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
//}
if (IsQueryBtn)
{
StrTitle = this.txtSendDocTitle.Text.Trim().ToString();
T_SYS_DICTIONARY GradeObj = cbxGrade.SelectedItem as T_SYS_DICTIONARY; //级别
T_SYS_DICTIONARY ProritityObj = cbxProritity.SelectedItem as T_SYS_DICTIONARY; //缓急
T_OA_SENDDOCTYPE DocType = new T_OA_SENDDOCTYPE();
StrStart = this.dpStart.Text.Trim().ToString();
StrEnd = this.dpEnd.Text.Trim().ToString();
if (this.cbxdoctype.SelectedIndex > 0)
{
StrDocType = this.cbxdoctype.SelectedItem.ToString();
DocType = this.cbxdoctype.SelectedItem as T_OA_SENDDOCTYPE;
}
if (this.cbxGrade.SelectedIndex > 0)
{
StrGrade = GradeObj.DICTIONARYNAME.ToString();
}
if (this.cbxProritity.SelectedIndex > 0)
{
StrProritity = ProritityObj.DICTIONARYNAME.ToString();
}
if (!string.IsNullOrEmpty(StrTitle))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrProritity))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.PRIORITIES ==@" + paras.Count().ToString();//缓急名称
paras.Add(StrProritity);
}
if (!string.IsNullOrEmpty(StrDocType))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "doctype.SENDDOCTYPEID ==@" + paras.Count().ToString();//类型名称
paras.Add(DocType.SENDDOCTYPEID);
}
if (!string.IsNullOrEmpty(StrGrade))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.GRADED ==@" + paras.Count().ToString();//级别名称
paras.Add(StrGrade);
}
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("ENDTIMENOTNULL"));
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("STARTTIMENOTNULL"));
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("dtSearch"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
else
{
IsNull = true;
}
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loginUserInfo.postID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
loadbar.Start();
//SendDocClient.GetSendDocInfosListByWorkFlowAsync(dataPager.PageIndex, dataPager.PageSize, "OACompanySendDoc.CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
SendDocClient.GetMYSendDocInfosListAsync(dataPager.PageIndex, dataPager.PageSize, "OACompanySendDoc.CREATEDATE", filter, paras, pageCount, "2", loginUserInfo);
}
void LoadSendDocInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrTitle = ""; //标题
string StrStart = "";//添加文档的起始时间
string StrEnd = "";//添加文档的结束时间
string StrIsSave = "";//是否归档
string StrDistrbute = "";//是否发布
string StrGrade = "";//级别
string StrProritity = "";//缓急
string StrDocType = "";//文档类型
bool IsNull = false; //用来控制是否有查询条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
//if (checkState != ((int)CheckStates.Approving).ToString())
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "OACompanySendDoc.OWNERID==@" + paras.Count().ToString();
// paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
//}
if (IsQueryBtn)
{
StrTitle = this.txtSendDocTitle.Text.Trim().ToString();
T_SYS_DICTIONARY GradeObj = cbxGrade.SelectedItem as T_SYS_DICTIONARY;//级别
T_SYS_DICTIONARY ProritityObj = cbxProritity.SelectedItem as T_SYS_DICTIONARY;//缓急
T_OA_SENDDOCTYPE DocType = new T_OA_SENDDOCTYPE();
StrStart = this.dpStart.Text.Trim().ToString();
StrEnd = this.dpEnd.Text.Trim().ToString();
if (this.cbxdoctype.SelectedIndex >0)
{
StrDocType = this.cbxdoctype.SelectedItem.ToString();
DocType = this.cbxdoctype.SelectedItem as T_OA_SENDDOCTYPE;
}
if (this.cbxGrade.SelectedIndex>0)
{
StrGrade = GradeObj.DICTIONARYNAME.ToString();
}
if (this.cbxProritity.SelectedIndex > 0)
{
StrProritity = ProritityObj.DICTIONARYNAME.ToString();
}
if (!string.IsNullOrEmpty(StrTitle))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrProritity))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.PRIORITIES ==@" + paras.Count().ToString();//缓急名称
paras.Add(StrProritity);
}
if (!string.IsNullOrEmpty(StrDocType))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "doctype.SENDDOCTYPEID ==@" + paras.Count().ToString();//类型名称
paras.Add(DocType.SENDDOCTYPEID);
}
if (!string.IsNullOrEmpty(StrGrade))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.GRADED ==@" + paras.Count().ToString();//级别名称
paras.Add(StrGrade);
}
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("ENDTIMENOTNULL"));
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("STARTTIMENOTNULL"));
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("dtSearch"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
else
{
IsNull = true;
}
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loginUserInfo.postID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
loginUserInfo.departmentID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
loadbar.Start();
//SendDocClient.GetSendDocInfosListByWorkFlowAsync(dataPager.PageIndex, dataPager.PageSize, "OACompanySendDoc.CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
SendDocClient.GetMYSendDocInfosListAsync(dataPager.PageIndex, dataPager.PageSize, "OACompanySendDoc.CREATEDATE", filter, paras, pageCount, "2", loginUserInfo);
}
void LoadDocTypeInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrName = "";
string StrRecord = "";
string StrStart = "";
string StrEnd = "";
string StrTypeFlag = ""; //文档类型
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrRecord = this.cbxIsSave.SelectedIndex.ToString();
StrName = this.txtDocType.Text.Trim().ToString();
switch (this.cbxIsSave.SelectedIndex)
{
case 0:
break;
case 1:
StrTypeFlag = "1";
break;
case 2:
StrTypeFlag = "0";
break;
}
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
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.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
//if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
//{
// DtStart = System.Convert.ToDateTime(StrStart);
// DtEnd = System.Convert.ToDateTime(StrEnd);
// if (DtStart > DtEnd)
// {
// //MessageBox.Show("开始时间不能大于结束时间");
// Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
// return;
// }
// else
// {
// }
//}
if (!string.IsNullOrEmpty(StrName))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTYPE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrName);
}
if (!string.IsNullOrEmpty(StrTypeFlag))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OPTFLAG ==@" + paras.Count().ToString();//类型名称
paras.Add(StrTypeFlag);
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
//client.GetLendingListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "archivesLending.CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
start = DateTime.Now;
BumfClient.GetDocTypeInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadMeetingTypeTemplateInfos()
{
string filter = ""; //查询过滤条件
int pageCount = 0;
string StrMeetingType = "";
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQueryBtn)
{
if (!string.IsNullOrEmpty(txtTemplateName.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "TEMPLATENAME ^@" + paras.Count().ToString();
paras.Add(txtTemplateName.Text.Trim());
}
//if (!string.IsNullOrEmpty(txtContent.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "CONTENT ^@" + paras.Count().ToString();
// paras.Add(txtContent.Text.Trim());
//}
if (cbMeetingType.SelectedItem != null && cbMeetingType.SelectedIndex != 0)
{
StrMeetingType = ((cbMeetingType.SelectedItem) as T_OA_MEETINGTYPE).MEETINGTYPE;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "T_OA_MEETINGTYPE.MEETINGTYPE ==@" + paras.Count().ToString();
paras.Add(StrMeetingType);
}
IsQueryBtn = false;
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetTypeTemplateInfosAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
private void LoadData()
{
loadbar.Start();//打开转动动画
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>();//参数值
if (!string.IsNullOrEmpty(txtSYSTEMCODE.Text.Trim())) //系统类型
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SYSCODE ^@" + paras.Count().ToString();
paras.Add(txtSYSTEMCODE.Text.Trim());
}
if (!string.IsNullOrEmpty(txtAGENTMODULE.Text.Trim()))//代理模块
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MODELCODE ^@" + paras.Count().ToString();
paras.Add(txtAGENTMODULE.Text.Trim());
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
SoaChannel.GetAgentSetListByIdAsync(dpGrid.PageIndex, dpGrid.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
void LoadDocTypeTemplateInfos()
{
int pageCount = 0;
string filter = "";
string StrTitle = ""; //标题
string StrStart = ""; //添加文档的起始时间
string StrEnd = ""; //添加文档的结束时间
string StrGrade = ""; //级别
string StrProritity = ""; //缓急
string StrDocType = ""; //文档类型
bool IsNull = false; //用来控制是否有查询条件
string StrTemplateName = ""; //模板名称
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
StrTitle = this.txtSendDocTitle.Text.Trim().ToString();
StrStart = this.dpStart.Text.Trim().ToString();
StrEnd = this.dpEnd.Text.Trim().ToString();
StrTemplateName = this.txtTemplateName.Text.Trim().ToString();
if (IsQueryBtn)
{
T_SYS_DICTIONARY GradeObj = cbxGrade.SelectedItem as T_SYS_DICTIONARY; //级别
T_SYS_DICTIONARY ProritityObj = cbxProritity.SelectedItem as T_SYS_DICTIONARY; //缓急
if (this.cbxGrade.SelectedIndex > 0)
{
StrGrade = GradeObj.DICTIONARYNAME.ToString();
}
if (this.cbxProritity.SelectedIndex > 0)
{
StrProritity = ProritityObj.DICTIONARYNAME.ToString();
}
if (this.cbxdoctype.SelectedItem.ToString() != "请选择")
{
StrDocType = this.cbxdoctype.SelectedItem.ToString();
}
if (!string.IsNullOrEmpty(StrTitle))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrTemplateName))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "TEMPLATENAME ^@" + paras.Count().ToString();//模板名称
paras.Add(StrTemplateName);
}
if (!string.IsNullOrEmpty(StrProritity))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "PRIORITIES==@" + paras.Count().ToString();//缓急名称
paras.Add(StrProritity);
}
if (!string.IsNullOrEmpty(StrDocType))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTYPE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrDocType);
}
if (!string.IsNullOrEmpty(StrGrade))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "GRADED==@" + paras.Count().ToString();//级别名称
paras.Add(StrGrade);
}
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("ENDTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
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.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
else
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
//if (!IsNull)
//{
// Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("REQUIRED","SEARCH"));
// return;
//}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
DocTypeTemplateClient.GetDocTypeTemplateInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, "", loginUserInfo);
}
void LoadMeetingInfos()
{
string StrTitle = "";
string StrType = "";
string StrDepartment = "";
string StrContent = "";
string StrStart = "";
string StrEnd = "";
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (checkState == ((int)CheckStates.UnSubmit).ToString())
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.OWNERID==@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
if (IsQueryBtn)
{
StrTitle = txtMeetingTitle.Text.Trim().ToString();
if (cbMeetingType.SelectedIndex > 0) //if (cbMeetingType.SelectedItem.ToString() != "请选择")
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
StrType = ((cbMeetingType.SelectedItem) as T_OA_MEETINGTYPE).MEETINGTYPE.ToString();
filter += "meetingtype.meetingtype ==@" + paras.Count().ToString();
paras.Add(StrType);
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.MEETINGTITLE ^@" + paras.Count().ToString();
paras.Add(StrTitle);
}
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))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
}
}
else
{
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))//选择了开始时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(System.Convert.ToDateTime(StrStart));
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))//选择了结束时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(System.Convert.ToDateTime(StrEnd));
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetMeetingInfoListByFlowAsync(dataPager.PageIndex, dataPager.PageSize, "meetinginfo.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadMeetingRoomAppInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrRoomName = "";
string StrDepartment = "";
string StrStart = "";
string StrEnd = "";
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQueryBtn)
{
StrRoomName = this.txtMeetingRoomName.Text.ToString().Trim();
//StrDepartment = this.PostsObject.Text.ToString().Trim();
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)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " roomapp.STARTTIME >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " roomapp.ENDTIME <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
if (checkState == ((int)CheckStates.UnSubmit).ToString())
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "roomapp.OWNERID==@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
if (!string.IsNullOrEmpty(StrRoomName))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "room.MEETINGROOMNAME ^@" + paras.Count().ToString();
paras.Add(StrRoomName);
}
//if (!string.IsNullOrEmpty(StrDepartment))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "roomapp.DEPARTNAME ==@" + paras.Count().ToString();
// paras.Add(StrDepartment);
//}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetMeetingRoomAppInfosByFlowAsync(dataPager.PageIndex, dataPager.PageSize, "roomapp.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadPriorityInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQueryBtn)
{
string StrStart = "";
string StrEnd = "";
string StrTitle = "";
StrTitle = this.txtGrade.Text.Trim().ToString();
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
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"));
//MessageBox.Show("开始时间不能大于结束时间");
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (filter != "")
{
filter += " and ";
}
filter += "PRIORITIES ^@" + paras.Count().ToString();//类型名称
paras.Add(StrTitle);
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
BumfClient.GetDocPriorityInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
void LoadPriorityInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQueryBtn)
{
string StrStart = "";
string StrEnd = "";
string StrTitle = "";
StrTitle = this.txtGrade.Text.Trim().ToString();
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
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"));
//MessageBox.Show("开始时间不能大于结束时间");
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (filter != "")
{
filter += " and ";
}
filter += "PRIORITIES ^@" + paras.Count().ToString();//类型名称
paras.Add(StrTitle);
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
BumfClient.GetDocPriorityInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
}
void LoadSendDocInfos(string checkState)
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrTitle = ""; //标题
string StrContent = "";//内容
string StrStart = "";//添加文档的起始时间
string StrEnd = "";//添加文档的结束时间
string StrIsSave = "";//是否归档
string StrDistrbute = "";//是否发布
string StrGrade = "";//级别
string StrProritity = "";//缓急
string StrDocType = "";//文档类型
bool IsNull = false; //用来控制是否有查询条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
//if (checkState != ((int)CheckStates.Approving).ToString())
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "OACompanySendDoc.OWNERID==@" + paras.Count().ToString();
// paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
//}
if (SearchUserID == Common.CurrentLoginUserInfo.EmployeeID)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "( OWNERID =@" + paras.Count().ToString();
paras.Add(SearchUserID);//员工ID值
filter += " or ";
filter += "CREATEUSERID =@" + paras.Count().ToString();//添加人的ID
paras.Add(SearchUserID);
filter += " ) ";
}
else
{
if (!string.IsNullOrEmpty(SearchUserID))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OWNERID =@" + paras.Count().ToString();
paras.Add(SearchUserID);
}
}
if (IsQueryBtn)
{
T_SYS_DICTIONARY GradeObj = cbxGrade.SelectedItem as T_SYS_DICTIONARY;//级别
T_SYS_DICTIONARY ProritityObj = cbxProritity.SelectedItem as T_SYS_DICTIONARY;//缓急
T_OA_SENDDOCTYPE sendtype = new T_OA_SENDDOCTYPE();
switch (cbxIsSave.SelectedIndex)
{
case 0:
break;
case 1:
StrIsSave = "0";
break;
case 2:
StrIsSave = "1";
break;
}
switch (cbxDistrbute.SelectedIndex)
{
case 0:
break;
case 1:
StrDistrbute = "0";
break;
case 2:
StrDistrbute = "1";
break;
}
if (!string.IsNullOrEmpty(StrIsSave))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.ISSAVE =@" + paras.Count().ToString();//标题名称
paras.Add(StrIsSave);
}
if (!string.IsNullOrEmpty(StrDistrbute))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.ISDISTRIBUTE =@" + paras.Count().ToString();//标题名称
paras.Add(StrDistrbute);
}
StrTitle = this.txtSendDocTitle.Text.Trim().ToString();
//StrContent = this.txtDocContent.Text.Trim().ToString();
StrStart = this.dpStart.Text.Trim().ToString();
StrEnd = this.dpEnd.Text.Trim().ToString();
if (this.cbxGrade.SelectedIndex>0)
{
StrGrade = GradeObj.DICTIONARYNAME.ToString();
}
if (this.cbxProritity.SelectedIndex >0)
{
StrProritity = ProritityObj.DICTIONARYNAME.ToString();
}
if (this.cbxdoctype.SelectedIndex >0)
{
sendtype = this.cbxdoctype.SelectedItem as T_OA_SENDDOCTYPE;
StrDocType = sendtype.SENDDOCTYPE;
}
if (!string.IsNullOrEmpty(StrTitle))
{
IsNull = true;
//if (!string.IsNullOrEmpty(filter))
//{
// filter += " and ";
//}
//filter += "OACompanySendDoc.SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
//paras.Add(StrTitle);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "@" + paras.Count().ToString() + ".Contains(OACompanySendDoc.SENDDOCTITLE) ";
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrProritity))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.PRIORITIES ^@" + paras.Count().ToString();//缓急名称
paras.Add(StrProritity);
}
if (this.cbxdoctype.SelectedIndex >0)
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " doctype.SENDDOCTYPE ==@" + paras.Count().ToString();
paras.Add(sendtype.SENDDOCTYPE);
}
if (!string.IsNullOrEmpty(StrGrade))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.GRADED ^@" + paras.Count().ToString();//级别名称
paras.Add(StrGrade);
}
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("ENDTIMENOTNULL"));
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("dtSearch"), Utility.GetResourceStr("STARTTIMENOTNULL"));
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("dtSearch"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
else
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OACompanySendDoc.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
//IsQueryBtn = false;
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
SendDocClient.GetSendDocInfosListByWorkFlowAsync(dataPager.PageIndex, dataPager.PageSize, "OACompanySendDoc.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadMeetingRoomAppInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrRoomName = "";
string StrDepartment = "";
string StrStart = "";
string StrEnd = "";
ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值
if (IsQueryBtn)
{
StrRoomName = this.txtMeetingRoomName.Text.ToString().Trim();
//StrDepartment = this.PostsObject.Text.ToString().Trim();
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)
{
Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
return;
}
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " roomapp.STARTTIME >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += " roomapp.ENDTIME <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
if (checkState == ((int)CheckStates.UnSubmit).ToString())
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "roomapp.OWNERID==@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
if (!string.IsNullOrEmpty(StrRoomName))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "room.MEETINGROOMNAME ^@" + paras.Count().ToString();
paras.Add(StrRoomName);
}
//if (!string.IsNullOrEmpty(StrDepartment))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "roomapp.DEPARTNAME ==@" + paras.Count().ToString();
// paras.Add(StrDepartment);
//}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetMeetingRoomAppInfosByFlowAsync(dataPager.PageIndex, dataPager.PageSize, "roomapp.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadMeetingTypeInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (IsQueryBtn)
{
if (!string.IsNullOrEmpty(txtSearchType.Text.Trim()))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "MEETINGTYPE ^@" + paras.Count().ToString();
paras.Add(txtSearchType.Text.Trim());
}
}
//if (!string.IsNullOrEmpty(txtSearchMemo.Text.Trim()))
//{
// if (!string.IsNullOrEmpty(filter))
// {
// filter += " and ";
// }
// filter += "REMARK ^@" + paras.Count().ToString();
// paras.Add(txtSearchMemo.Text.Trim());
//}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
if (string.IsNullOrEmpty(loginUserInfo.companyID))
{
Utility.GetLoginUserInfo(loginUserInfo);
}
loadbar.Start();
MeetingClient.GetMeetingTypeInfosAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadMeetingInfos()
{
string StrTitle = "";
string StrType = "";
string StrDepartment = "";
string StrContent = "";
string StrStart = "";
string StrEnd = "";
int pageCount = 0;
string filter = ""; //查询过滤条件
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (checkState == ((int)CheckStates.UnSubmit).ToString())
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.OWNERID==@" + paras.Count().ToString();
paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
}
if (IsQueryBtn)
{
StrTitle = txtMeetingTitle.Text.Trim().ToString();
if (cbMeetingType.SelectedIndex >0) //if (cbMeetingType.SelectedItem.ToString() != "请选择")
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
StrType = ((cbMeetingType.SelectedItem) as T_OA_MEETINGTYPE).MEETINGTYPE.ToString();
filter += "meetingtype.meetingtype ==@" + paras.Count().ToString();
paras.Add(StrType);
}
if (!string.IsNullOrEmpty(StrTitle))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.MEETINGTITLE ^@" + paras.Count().ToString();
paras.Add(StrTitle);
}
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))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
}
}
else
{
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))//选择了开始时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE >=@" + paras.Count().ToString();
paras.Add(System.Convert.ToDateTime(StrStart));
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))//选择了结束时间
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "meetinginfo.CREATEDATE <=@" + paras.Count().ToString();
paras.Add(System.Convert.ToDateTime(StrEnd));
}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
MeetingClient.GetMeetingInfoListByFlowAsync(dataPager.PageIndex, dataPager.PageSize, "meetinginfo.CREATEDATE descending", filter, paras, pageCount, checkState, loginUserInfo);
}
void LoadDocTypeInfos()
{
int pageCount = 0;
string filter = ""; //查询过滤条件
string StrName = "";
string StrRecord = "";
string StrStart = "";
string StrEnd = "";
string StrTypeFlag = ""; //文档类型
StrStart = dpStart.Text.ToString();
StrEnd = dpEnd.Text.ToString();
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
StrRecord = this.cbxIsSave.SelectedIndex.ToString();
StrName = this.txtDocType.Text.Trim().ToString();
switch (this.cbxIsSave.SelectedIndex)
{
case 0:
break;
case 1:
StrTypeFlag ="1";
break;
case 2:
StrTypeFlag ="0";
break;
}
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ENDTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
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.Caution, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERRORSTARTDATEGTENDDATE"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
else
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();//开始时间
paras.Add(DtStart);
filter += " and ";
filter += "CREATEDATE <=@" + paras.Count().ToString();//结束时间
paras.Add(DtEnd);
}
}
//if (!string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
//{
// DtStart = System.Convert.ToDateTime(StrStart);
// DtEnd = System.Convert.ToDateTime(StrEnd);
// if (DtStart > DtEnd)
// {
// //MessageBox.Show("开始时间不能大于结束时间");
// Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), Utility.GetResourceStr("MEETINGSTARTTIMENOTNULL"));
// return;
// }
// else
// {
// }
//}
if (!string.IsNullOrEmpty(StrName))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTYPE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrName);
}
if(!string.IsNullOrEmpty(StrTypeFlag))
{
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "OPTFLAG ==@" + paras.Count().ToString();//类型名称
paras.Add(StrTypeFlag);
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
//client.GetLendingListByUserIdAsync(dataPager.PageIndex, dataPager.PageSize, "archivesLending.CREATEDATE", filter, paras, pageCount, checkState, loginUserInfo);
start = DateTime.Now;
BumfClient.GetDocTypeInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, loginUserInfo);
}
void LoadDocTypeTemplateInfos()
{
int pageCount = 0;
string filter = "";
string StrTitle = ""; //标题
string StrStart = "";//添加文档的起始时间
string StrEnd = "";//添加文档的结束时间
string StrGrade = "";//级别
string StrProritity = "";//缓急
string StrDocType = "";//文档类型
bool IsNull = false; //用来控制是否有查询条件
string StrTemplateName = ""; //模板名称
ObservableCollection<object> paras = new System.Collections.ObjectModel.ObservableCollection<object>(); //参数值
StrTitle = this.txtSendDocTitle.Text.Trim().ToString();
StrStart = this.dpStart.Text.Trim().ToString();
StrEnd = this.dpEnd.Text.Trim().ToString();
StrTemplateName = this.txtTemplateName.Text.Trim().ToString();
if (IsQueryBtn)
{
T_SYS_DICTIONARY GradeObj = cbxGrade.SelectedItem as T_SYS_DICTIONARY;//级别
T_SYS_DICTIONARY ProritityObj = cbxProritity.SelectedItem as T_SYS_DICTIONARY;//缓急
if (this.cbxGrade.SelectedIndex >0)
{
StrGrade = GradeObj.DICTIONARYNAME.ToString();
}
if (this.cbxProritity.SelectedIndex >0)
{
StrProritity = ProritityObj.DICTIONARYNAME.ToString();
}
if (this.cbxdoctype.SelectedItem.ToString() != "请选择")
{
StrDocType = this.cbxdoctype.SelectedItem.ToString();
}
if (!string.IsNullOrEmpty(StrTitle))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTITLE ^@" + paras.Count().ToString();//标题名称
paras.Add(StrTitle);
}
if (!string.IsNullOrEmpty(StrTemplateName))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "TEMPLATENAME ^@" + paras.Count().ToString();//模板名称
paras.Add(StrTemplateName);
}
if (!string.IsNullOrEmpty(StrProritity))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "PRIORITIES==@" + paras.Count().ToString();//缓急名称
paras.Add(StrProritity);
}
if (!string.IsNullOrEmpty(StrDocType))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "SENDDOCTYPE ^@" + paras.Count().ToString();//类型名称
paras.Add(StrDocType);
}
if (!string.IsNullOrEmpty(StrGrade))
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "GRADED==@" + paras.Count().ToString();//级别名称
paras.Add(StrGrade);
}
DateTime DtStart = new DateTime();
DateTime DtEnd = new DateTime();
if (!string.IsNullOrEmpty(StrStart) && string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("ENDTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ENDTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
if (string.IsNullOrEmpty(StrStart) && !string.IsNullOrEmpty(StrEnd))
{
//Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTNULL"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTNULL"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
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.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"));
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STARTTIMENOTGREATENDTIME"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
return;
}
else
{
IsNull = true;
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE >=@" + paras.Count().ToString();
paras.Add(DtStart);
if (!string.IsNullOrEmpty(filter))
{
filter += " and ";
}
filter += "CREATEDATE <=@" + paras.Count().ToString();
paras.Add(DtEnd);
}
}
//if (!IsNull)
//{
// Utility.ShowCustomMessage(MessageTypes.Caution, Utility.GetResourceStr("SEARCH"), Utility.GetResourceStr("REQUIRED","SEARCH"));
// return;
//}
}
SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonOfficeService.LoginUserInfo();
loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID;
loadbar.Start();
DocTypeTemplateClient.GetDocTypeTemplateInfosListBySearchAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE descending", filter, paras, pageCount, "", loginUserInfo);
}
