//初始化菜单
private void InitMenu()
{
// MainMenuStrip.AutoSize = false;
//初始化datatable
//MainMenu.Items.Clear();
string menuGroupName = string.Empty;
string funcationName = string.Empty;
string frmName = string.Empty;
int icoIndex;
Common.DataProces dp = new Common.DataProces();
DataTable dt_role = dp.GetMenuDt(Common.MenuData.RoleTable);
//遍历datatable增加菜单项
for (int i = 0; i < dt_role.Rows.Count; i++)
{
DataRow dr = dt_role.Rows[i];
menuGroupName = dr["MenuGroupName"].ToString();
funcationName = dr["FunctionName"].ToString();
frmName = dr["FrmName"].ToString();
icoIndex = int.Parse(dr["ICO"].ToString());
//创建二级子菜单
ToolStripMenuItem tsi = new ToolStripMenuItem(funcationName, icoLargeList.Images[icoIndex]);
tsi.Tag = frmName;
tsi.Click += new EventHandler(tsi_Click);
//创建工具栏
ToolStripButton tsb = new ToolStripButton(funcationName, icoLargeList.Images[icoIndex]);
tsb.Tag = frmName;
tsb.ToolTipText = funcationName;
tsb.Click += new EventHandler(tsb_Click);
tsb.TextImageRelation = TextImageRelation.ImageAboveText;
MainToolStrip.Items.Add(tsb);
MainToolStrip.Items.Add(new ToolStripSeparator());
MenuAddNewFunction(menuGroupName, tsi);
}
}
private void frmTools_Load(object sender, EventArgs e)
{
//dt_role = new BLL.sys_SetRoleManager().GetUserRoleByUserID(allensingleton.UserID);
_outlookBar = new LumiSoft.UI.Controls.WOutlookBar.WOutlookBar();
//_outlookBar.BorderStyle = BorderStyle.FixedSingle;
_outlookBar.ImageList = singleton.m_FrmMain.icoLargeList;
_outlookBar.ImageListSmall = singleton.m_FrmMain.icoLargeList;
_outlookBar.Dock = DockStyle.Fill;
_outlookBar.ItemClicked += wOutlookBar_ItemClicked;
_outlookBar.BarClicked += wOutlookBar_BarClicked;
_outlookBar.ViewStyle.BarClientAreaColor = Color.Wheat;//工具箱的背影颜色
_outlookBar.ViewStyle.BarItemHotTextColor = Color.Blue;//鼠标悬浮在菜单上面的时候菜单的文字前景色
_outlookBar.ViewStyle.BarItemTextColor = Color.Black;//菜单的文字前景色
_outlookBar.ViewStyle.BarColor = Color.CadetBlue;//主菜单名称的背景颜色
//_outlookBar.ViewStyle.BarClientAreaColor = Color.LightBlue;//工具箱的背影颜色
_outlookBar.ViewStyle.BarItemHotTextColor = Color.Red;//鼠标悬浮在菜单上面的时候菜单的文字前景色
//_outlookBar.ViewStyle.BarItemTextColor = Color.Black;//菜单的文字前景色
//_outlookBar.ViewStyle.BarColor = Color.Violet;//主菜单名称的背景颜色
Item it = null;
Bar bar = null;
string strMenu = string.Empty;
Common.DataProces dp = new Common.DataProces();
DataTable dt_role = dp.GetMenuDt(Common.MenuData.RoleTable);
for (int i = 0; i < dt_role.Rows.Count; i++)
{
if (string.IsNullOrEmpty(strMenu) || strMenu != dt_role.Rows[i]["MenuGroupName"].ToString())
{
//处理快捷键如“系统设置(&M)”
string str = dt_role.Rows[i]["MenuGroupName"].ToString();
int index = str.IndexOf("(");
if (index != -1)
str = str.Remove(index);
bar = _outlookBar.Bars.Add(str);
bar.ItemsStyle = ItemsStyle.IconSelect;
strMenu = dt_role.Rows[i]["MenuGroupName"].ToString();
}
it = bar.Items.Add(dt_role.Rows[i]["FunctionName"].ToString(), dt_role.Rows[i]["FrmName"].ToString(),
int.Parse(dt_role.Rows[i]["ICO"].ToString()), true, dt_role.Rows[i]["FrmName"].ToString());
it.AllowStuck = false;
}
//_outlookBar.BackColor = Color.Red;
ploutlookBar.Controls.AddRange(new Control[] { _outlookBar });
}
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = (DataTable)dgvbtdj.DataSource;
Common.DataProces toexcel = new Common.DataProces();
toexcel.DataTableToExcel(dt, true);
}
private void btnToEx_Click(object sender, EventArgs e)
{
string Cycle = string.Empty;
string town = string.Empty;
string townn = string.Empty;
string group = " group by a.ACCOUNTNUM,a.SSSSOBJECTNAME,d.GH,a.SSSSIDCARDNUM order by a.ACCOUNTNUM DESC,d.GH";
string batch = "null";
string bank = cmbBank.SelectedValue.ToString();
if (cmbbatch.Text != null && cmbbatch.Text != "")
{
batch = cmbbatch.SelectedValue.ToString();
}
if (checkBox1.Checked)
{
town = " AND INSTR(c.OBJECTCODE,'" + cmbTown.SelectedValue.ToString() + "')>0";
townn = "乡镇：" + cmbTown.Text.ToString();
}
if (cmbCycle.SelectedValue.ToString() == "3")
{
Cycle = " and c.OFFSET='" + cmbbatch.SelectedValue.ToString() + "'";
}
if (cmbCycle.SelectedValue.ToString() == "4")
{
Cycle = " and c.batchcode='" + cmbbatch.SelectedValue.ToString() + "'";
}
if (lbselect.Items.Count > 0)
{
string sqlstr = string.Empty;
for (int i = 0; i < this.lbselect.Items.Count; i++)
{
lbselect.SelectedIndex = i;
sqlstr = sqlstr + "," + lbselect.SelectedValue.ToString();
}
sqlstr = sqlstr.Substring(1);
DataTable dv = Common.DataProces.OutPutTable(B_sjdc.ExpToEx(" and c.TYPECODE in (" + sqlstr + ")" + Cycle.ToString() + " and c.FSYEAR=" + DateTime.Now.Year + town.ToString() + " and bankcode='" + bank.ToString() + "'" + group.ToString()).Tables[0]);
Common.DataProces toexcel = new Common.DataProces();
toexcel.DataTableToExcel(dv, true);
label4.Text = "共导出" + dv.Rows.Count.ToString() + "条记录！";
}
else
{
MessageBox.Show("请选择补贴类型！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
#region 方法二，建立临时表
//按身份证查询
if (cmbType.SelectedValue.ToString() == "1")
{
DbHelperOra.ExecuteSql("update countydata.querytb set queryid='^1'||translate(queryid,'1234567890X','BA@GFEDKJC+') where queryid not like '^1%'");
dt = b_basic.GetByCardTemp("").Tables[0];
}
//按银行账号查询
else
{
dt = b_basic.GetByYhzhTemp("").Tables[0];
}
DataTable dtExcel = new DataTable();
//dtExcel = (DataTable)dgvPreview.DataSource;
dtExcel = b_basic.getquery("").Tables[0];
dtExcel.Columns[0].ColumnName = "QUERY";
Common.DataProces dp = new Common.DataProces();
dgvShow.DataSource = dp.MergeDataTable(dtExcel, dt, "QUERY");
btnToExcel.Enabled = true;
}
