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()+"'", "h_p_OA_EmpMinMessageList"); 
 | 
            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() + "'", "h_p_OA_WorkBillList"); 
 | 
            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); 
 | 
        } 
 | 
    } 
 | 
} 
 |