private void 财务toolStripButton_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = "零星采购申请财务综合查询"; string[] pare = { dataGridView1.CurrentRow.Cells["单据号"].Value.ToString() }; IQueryResult qr = authorization.QueryMultParam(businessID, null, pare); List <string> lstFindField = new List <string>(); if (qr.DataCollection == null || qr.DataCollection.Tables.Count == 0) { return; } DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text); formFindCondition.ShowDialog(); }
private void 综合查询toolStripButton3_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = ""; IQueryResult qr = null; List <string> lstFindField = new List <string>(); IQueryable <View_HR_PersonnelArchive> directorGroup3 = m_personnerServer.GetDeptDirector(BasicInfo.DeptCode, "0"); IQueryable <View_HR_PersonnelArchive> directorGroup = m_personnerServer.GetDeptDirector(BasicInfo.DeptCode, "1"); IQueryable <View_HR_PersonnelArchive> directorGroup2 = m_personnerServer.GetDeptDirector(BasicInfo.DeptCode, "2"); authorization = PlatformFactory.GetObject <IAuthorization>(); businessID = "出差综合查询"; string[] pare = { BasicInfo.DeptCode }; qr = authorization.QueryMultParam(businessID, null, pare); DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text); formFindCondition.ShowDialog(); }
private void 综合查询toolStripButton_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = "零星采购申请综合查看"; IQueryResult qr = authorization.Query(businessID, null, null, 0); List <string> lstFindField = new List <string>(); if (qr.DataCollection == null || qr.DataCollection.Tables.Count == 0) { return; } DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text); formFindCondition.ShowDialog(); }
private void 供应商挂账表_Load(object sender, EventArgs e) { string[] fileNameAccount = new string[] { "挂账年月", "图号型号", "物品名称", "规格", "供应商", "挂账方式", "协议单价", "税率", "单位", "上月未挂", "本月入库", "本月应挂", "本月未挂", "转结数量", "到票数量", "到票金额", "审核人", "审核时间", "复审人", "复审时间", "最后打印人", "最后打印时间" }; FormConditionFind fcfAccount = new FormConditionFind(this.挂账表查询, fileNameAccount, this.挂账表查询.Name, this.Name + this.挂账表查询.Name); fcfAccount.TopLevel = false; fcfAccount.Dock = DockStyle.Fill; fcfAccount.FormBorderStyle = FormBorderStyle.None; fcfAccount.Show(); fcfAccount.Parent = this.挂账表查询; string[] fileNameAccountDetail = new string[] { "挂账年月", "供应商", "单据号", "图号型号", "物品名称", "规格", "批次号", "数量" }; FormConditionFind fcfAccountDetail = new FormConditionFind(this.挂账表明细查询, fileNameAccountDetail, this.挂账表明细查询.Name, this.Name + this.挂账表明细查询.Name); fcfAccountDetail.TopLevel = false; fcfAccountDetail.Dock = DockStyle.Fill; fcfAccountDetail.FormBorderStyle = FormBorderStyle.None; fcfAccountDetail.Show(); fcfAccountDetail.Parent = this.挂账表明细查询; }
private void btnAdvSearch_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = "会议信息普通查询"; IQueryResult qr = authorization.QueryMultParam("会议信息普通查询", null, new object[] { BasicInfo.LoginID }); List <string> lstFindField = new List <string>(); if (qr.DataCollection == null || qr.DataCollection.Tables.Count == 0) { return; } DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text); formFindCondition.ShowDialog(); }
private void btnSearch_Click(object sender, EventArgs e) { if (m_formFindCondition == null) { m_formFindCondition = new FormConditionFind(this, m_findField, labelTitle.Text, labelTitle.Text); } m_formFindCondition.ShowDialog(); }
private void 导出EXCEL表单ToolStripMenuItem_Click(object sender, EventArgs e) { if (m_formFindCondition != null && !m_formFindCondition.SaveFlag) { m_formFindCondition = null; } if (m_formFindCondition == null) { m_formFindCondition = new FormConditionFind(this, m_findField, labelTitle.Text, labelTitle.Text); } m_formFindCondition.ShowDialog(); }
private void UserControlReceiveSendSaveGatherBill_Load(object sender, EventArgs e) { string[] fileNameAccount = new string[] { "年月", "图号型号", "物品名称", "规格", "供货单位", "批次号", "库房名称", "物品ID", "实际单价", "实际金额", "入库时间", "物品状态", "材料类别编码", "材料类别名称" }; FormConditionFind fcfAccount = new FormConditionFind(this.月度结存, fileNameAccount, this.月度结存.Name, this.Name + this.月度结存.Name); fcfAccount.TopLevel = false; fcfAccount.Dock = DockStyle.Fill; fcfAccount.FormBorderStyle = FormBorderStyle.None; fcfAccount.Show(); fcfAccount.Parent = this.月度结存; }
private void 综合查询toolStripButton3_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = "查看储备人才库"; IQueryResult qr = authorization.Query(businessID, null, null, 0); List <string> lstFindField = new List <string>(); DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1); for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, labelTitle.Text); formFindCondition.ShowDialog(); }
private void btnIntegrativeQuery_Click(object sender, EventArgs e) { IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>(); string businessID = "订单入库单综合查询"; string[] pare = { m_strProvider, dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString() }; IQueryResult qr = authorization.QueryMultParam(businessID, pare); List <string> lstFindField = new List <string>(); DataColumnCollection columns = qr.DataCollection.Tables[0].Columns; if (qr.Succeeded && columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { lstFindField.Add(columns[i].ColumnName); } } FormConditionFind formFindCondition = new FormConditionFind(this, lstFindField.ToArray(), businessID, "订单入库单综合查询", pare); formFindCondition.ShowDialog(); }
private void MES数据查询_Load(object sender, EventArgs e) { string[] fileNameData = new string[] { "总成编码", "父级编码", "数据名", "数据值", "流程名", "操作步骤", "操作内容", "工位", "记录时间", "版本号", "记录类型" }; FormConditionFind fcfData = new FormConditionFind(this.数据信息, fileNameData, this.数据信息.Name, this.Name + this.数据信息.Name); fcfData.TopLevel = false; fcfData.Dock = DockStyle.Fill; fcfData.FormBorderStyle = FormBorderStyle.None; fcfData.Show(); fcfData.Parent = this.数据信息; string[] fileNameGoods = new string[] { "总成编码", "流程名", "图号型号", "物品名称", "规格", "供应商", "批次号", "耗用数", "工位", "操作时间" }; FormConditionFind fcfGoods = new FormConditionFind(this.零件信息, fileNameGoods, this.零件信息.Name, this.Name + this.零件信息.Name); fcfGoods.TopLevel = false; fcfGoods.Dock = DockStyle.Fill; fcfGoods.FormBorderStyle = FormBorderStyle.None; fcfGoods.Show(); fcfGoods.Parent = this.零件信息; string[] fileNameRepair = new string[] { "流程名", "总成编码", "记录时间", "记录员", "情况说明", "旧箱号" }; FormConditionFind fcfRepair = new FormConditionFind(this.返修信息, fileNameRepair, this.返修信息.Name, this.Name + this.返修信息.Name); fcfRepair.TopLevel = false; fcfRepair.Dock = DockStyle.Fill; fcfRepair.FormBorderStyle = FormBorderStyle.None; fcfRepair.Show(); fcfRepair.Parent = this.返修信息; }