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.返修信息;
}
