using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using DBUtility;
|
using SQLHelper;
|
|
namespace LMES
|
{
|
public partial class Frm_Show : Form
|
{
|
public Frm_Show()
|
{
|
InitializeComponent();
|
}
|
public OAM.OA_WorkLinkBill oFrm;
|
|
|
private void ClearTool()
|
{
|
cg.CheckState = CheckState.Unchecked;
|
xs.CheckState = CheckState.Unchecked;
|
kf.CheckState = CheckState.Unchecked;
|
jh.CheckState = CheckState.Unchecked;
|
sc.CheckState = CheckState.Unchecked;
|
cj.CheckState = CheckState.Unchecked;
|
oa.CheckState = CheckState.Unchecked;
|
tx.CheckState = CheckState.Unchecked;
|
gy.CheckState = CheckState.Unchecked;
|
xt.CheckState = CheckState.Unchecked;
|
oa.CheckState = CheckState.Unchecked;
|
mj.CheckState = CheckState.Unchecked;
|
Zp.CheckState = CheckState.Unchecked;
|
sb.CheckState = CheckState.Unchecked;
|
pz.CheckState = CheckState.Unchecked;
|
sup.CheckState = CheckState.Unchecked;
|
pay.CheckState = CheckState.Unchecked;
|
}
|
|
private void SetTool(ToolStripButton oBr)
|
{
|
oBr.CheckState = CheckState.Checked;
|
//显示子项目
|
grdList.Rows.Clear();
|
DataSet oDs;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
oDs = oCn.RunProcReturn("select * from xt_xtgnb where sjgnbm='" + oBr.Name + "' and menulist=1 Order by gnbm", "xt_xtgnb");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
grdList.Rows.Add();
|
grdList.Rows[i].Cells["NameCol"].Value = oDs.Tables[0].Rows[i]["gnmc"].ToString();
|
grdList.Rows[i].Cells["IDCol"].Value = oDs.Tables[0].Rows[i]["gnbm"].ToString();
|
//如果未购买则显示灰色
|
if (DBUtility.ClsPub.isBool(oDs.Tables[0].Rows[i]["buyFlag"]) != true)
|
{
|
grdList.Rows[i].DefaultCellStyle.ForeColor = Color.LightGray;
|
}
|
else
|
{
|
grdList.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
|
}
|
//
|
}
|
//默认将第一项目 显示出 下级项目
|
if (oDs.Tables[0].Rows.Count >= 0)
|
{
|
|
ShowSubItems(0);
|
}
|
}
|
|
//设置主菜单
|
private void ShowMainMenu()
|
{
|
InitTool();
|
}
|
|
private void SetPic()
|
{
|
//Image img = System.Drawing.Image.FromFile(ClsPub.AppPath + @"/MainToolPic.jpg"); ;
|
//panel3.BackgroundImage = img;
|
}
|
|
private void Frm_Show_Load(object sender, EventArgs e)
|
{
|
SetPic();
|
ClearTool();
|
//SetTool(cg);
|
//设置主菜单
|
ShowMainMenu();
|
//设置当前用户和企业
|
SetUserName();
|
//
|
ShowMsg();
|
}
|
|
private void SetUserName()
|
{
|
lblAccountName.Text = "本机IP：" + DBUtility.ClsPub.IPAddress;
|
lblUserName.Text = "Windows用户：" + DBUtility.ClsPub.ComputerName;
|
lblDate.Text = BLL.ClsDateToNongli.GetChineseDateTime(DateTime.Today);
|
}
|
|
private void grdList_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
|
{
|
e.Handled = true;
|
e.PaintBackground(e.CellBounds, true);
|
e.PaintContent(e.CellBounds);
|
|
}
|
|
private void grdSub_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
|
{
|
e.Handled = true;
|
e.PaintBackground(e.CellBounds, true);
|
e.PaintContent(e.CellBounds);
|
}
|
|
private void ShowSubItems(int sRow)
|
{
|
grdSub.Rows.Clear();
|
DataSet oDs;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
oDs = oCn.RunProcReturn("select * from xt_xtgnb where sjgnbm='" + grdList.Rows[sRow].Cells["IDCol"].Value + "' and menulist=1 Order by gnbm", "xt_xtgnb");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
grdSub.Rows.Add();
|
grdSub.Rows[i].Cells["SubNameCol"].Value = oDs.Tables[0].Rows[i]["gnmc"].ToString();
|
grdSub.Rows[i].Cells["SubNumberCol"].Value = oDs.Tables[0].Rows[i]["gnsy"].ToString();
|
grdSub.Rows[i].Cells["SubIDCol"].Value = oDs.Tables[0].Rows[i]["gnbm"].ToString();
|
//如果未购买则显示灰色
|
if (DBUtility.ClsPub.isBool(oDs.Tables[0].Rows[i]["buyFlag"]) != true)
|
{
|
grdSub.Rows[i].DefaultCellStyle.ForeColor = Color.LightGray;
|
}
|
else
|
{
|
grdSub.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
|
}
|
//
|
}
|
}
|
|
private void grdList_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
|
{
|
if (grdList.CurrentCell == null)
|
{
|
return;
|
}
|
ShowSubItems(grdList.CurrentCell.RowIndex);
|
}
|
|
private void grdSub_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
|
{
|
if (grdSub.CurrentCell == null)
|
{
|
return;
|
}
|
//判断颜色
|
if (grdSub.Rows[grdSub.CurrentCell.RowIndex].DefaultCellStyle.ForeColor == Color.LightGray)
|
{
|
MessageBox.Show("对不起,您尚未购买本模块,请求不被允许！");
|
return;
|
}
|
//
|
string gnmc = grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells["SubNameCol"].Value.ToString();
|
string gnsy = grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells["SubNumberCol"].Value.ToString();
|
string gnbm = grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells["SubIDCol"].Value.ToString();
|
ClsShowMod oMod = new ClsShowMod();
|
oMod.Zxxymk(gnsy.ToLower().Trim(), gnbm.ToLower().Trim(),gnmc.Trim() ,this.MdiParent);
|
}
|
|
private void ShowMsg()
|
{
|
DataSet oDs;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
oDs = oCn.RunProcReturn("h_p_OA_EmpMinMessageList " + DBUtility.ClsPub.CurUserName.ToString(), "xt_xtgnb");
|
if (oDs != null)
|
{
|
grdList1.DataSource = oDs.Tables[0].DefaultView;
|
//grdList2.DataSource = oDs.Tables[0].DefaultView;
|
grdList1.Columns[0].Visible = false;
|
grdList1.Columns[1].Visible = false;
|
|
}
|
//
|
|
oDs = oCn.RunProcReturn("exec h_p_OA_WorkBillList " + DBUtility.ClsPub.CurUserName.ToString(), "xt_xtgnb");
|
if (oDs == null)
|
{
|
return;
|
}
|
grdList2.DataSource = oDs.Tables[0].DefaultView;
|
grdList2.Columns[0].Visible = false;
|
grdList2.Columns[1].Visible = false;
|
|
//
|
DBUtility.ClsPub.GetGridView(this.grdList1, this.Name + "grdList1", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(this.grdList2, this.Name + "grdList2", DBUtility.ClsPub.AppPath);
|
}
|
|
private void Frm_Show_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
|
DBUtility.ClsPub.SaveGridView(this.grdList1, this.Name + "grdList1", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.SaveGridView(this.grdList2, this.Name + "grdList2", DBUtility.ClsPub.AppPath);
|
}
|
//
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdList2);
|
}
|
//双击显示grdList1
|
private void grdList1_DoubleClick(object sender, EventArgs e)
|
{
|
//Int64 lngBillKey = 0;
|
//if (grdList1.CurrentRow == null)
|
// return;
|
//lngBillKey = DBUtility.ClsPub.isLong(grdList1.Rows[grdList1.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
|
//if (lngBillKey == 0)
|
// return;
|
//DAL.ClsOA_EmpMinMessage oBill = new DAL.ClsOA_EmpMinMessage();
|
//if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
//{
|
// oFrm = new OAM.OA_EmpMinMessage();
|
// oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
// oFrm.BillOld = oBill;
|
// oFrm.ShowDialog();
|
//}
|
|
}
|
//双击显示grdList2
|
private void grdList2_DoubleClick(object sender, EventArgs e)
|
{
|
Int64 lngBillKey = 0;
|
if (grdList2.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdList2.Rows[grdList2.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
|
if (lngBillKey == 0)
|
return;
|
DAL.ClsOA_WorkLinkBill oBill = new DAL.ClsOA_WorkLinkBill();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
oFrm = new OAM.OA_WorkLinkBill();
|
oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
oFrm.BillOld = oBill;
|
oFrm.ShowDialog();
|
}
|
}
|
|
|
|
private void gy_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(gy);
|
}
|
|
private void cg_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(cg);
|
}
|
|
private void xs_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(xs);
|
}
|
|
private void ck_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(kf);
|
}
|
|
|
private void jh_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(jh);
|
}
|
|
private void sc_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(sc);
|
}
|
|
private void cj_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(cj);
|
}
|
|
private void tx_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(tx);
|
}
|
|
private void xt_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(xt);
|
}
|
|
|
private void oa_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(oa);
|
}
|
|
|
ClsCN oCn = new ClsCN();
|
public const int MaxNum = 100;
|
public int NowNum = 0;
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
if (NowNum > MaxNum)
|
{
|
NowNum = 0;
|
FindCheckBill();
|
}
|
else
|
{
|
NowNum++;
|
}
|
}
|
|
|
//查询待审核单据
|
private void FindCheckBill()
|
{
|
try
|
{
|
DataSet ds;
|
ds = oCn.RunProcReturn("exec h_p_Xt_GetNeedMessageList '" + ClsPub.CurUserName + "'", "xt_xtgnb");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
else
|
{
|
ShowMessage(ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]), ds.Tables[0].Rows[0]["单据号"].ToString(), ds.Tables[0].Rows[0]["单据类型"].ToString(), ds.Tables[0].Rows[0]["单据类型名称"].ToString());
|
}
|
}
|
catch (Exception e)
|
{
|
return;
|
}
|
|
}
|
|
//显示消息框
|
private void ShowMessage(Int64 HInterID, string HBillNo, string HBillType, string HBillTypeName)
|
{
|
OA_MessageBox oBox = new OA_MessageBox();
|
int x = System.Windows.Forms.Screen.PrimaryScreen.WorkingArea.Size.Width - 300;
|
int y = System.Windows.Forms.Screen.PrimaryScreen.WorkingArea.Size.Height - 230;
|
oBox.SetDesktopLocation(x, y);
|
oBox.HInterID = HInterID;
|
oBox.HBillNo = HBillNo;
|
oBox.HBillType = HBillType;
|
oBox.HBillTypeName = HBillTypeName;
|
timer1.Enabled = false;
|
oBox.ShowDialog();
|
timer1.Enabled = true;
|
}
|
|
|
public void InitTool()
|
{
|
ClsCN ocn = new ClsCN();
|
DataSet ds = new DataSet();
|
string sh = "";
|
ds = ocn.RunProcReturn("select hname from Xt_MainMenuSet where HShowFlag=0", "Xt_MainMenuSet");
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
sh = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["hname"]);
|
Sub_HideButton(this.toolStrip2, sh);
|
}
|
|
|
}
|
|
//隐藏按钮
|
public void Sub_HideButton(ToolStrip otool, string sName)
|
{
|
|
foreach (object ct in otool.Items)
|
{
|
if (ct.GetType().Name == "ToolStripButton")
|
{
|
if (((System.Windows.Forms.ToolStripButton)ct).Tag.ToString().Trim() == sName)
|
{
|
((System.Windows.Forms.ToolStripButton)ct).Visible = false;
|
}
|
}
|
if (ct.GetType().Name == "ToolStripSeparator")
|
{
|
if (((System.Windows.Forms.ToolStripSeparator)ct).Tag.ToString().Trim() == sName)
|
{
|
((System.Windows.Forms.ToolStripSeparator)ct).Visible = false;
|
}
|
}
|
}
|
}
|
|
private void kq_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(mj);
|
}
|
|
private void pct_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(Zp);
|
}
|
|
|
private void lblMore2_Click(object sender, EventArgs e)
|
{
|
//morebt oMo = new morebt();
|
|
//oMo.Huoqu(1);
|
//oMo.ShowDialog();
|
}
|
|
|
private void lblMore_Click(object sender, EventArgs e)
|
{
|
//morebt oMo = new morebt();
|
|
//oMo.Huoqu(0);
|
//oMo.ShowDialog();
|
}
|
|
private void sb_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(sb);
|
}
|
|
|
|
private void pz_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(pz);
|
}
|
|
private void sup_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(sup);
|
}
|
|
private void pBarCodeEdit_Click(object sender, EventArgs e)
|
{
|
WarM.Sc_ICMOToBarCode oSc_ICMOToBarCode = new WarM.Sc_ICMOToBarCode();
|
oSc_ICMOToBarCode.ModCaption = "条码快速生成";
|
oSc_ICMOToBarCode.ShowDialog();
|
}
|
|
private void pay_Click(object sender, EventArgs e)
|
{
|
ClearTool();
|
SetTool(pay);
|
}
|
}
|
}
|
