using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
//using SQLHelper;
using DBUtility;

namespace SCM
{
    public partial class Xt_SystemLog : Form
    {
        private int HItemIDCol = 0;
        private int HNumberCol = 0;
        public frmBillQueryCondition_Base frmCondition;
        const string ViewName = "h_v_Xt_SystemLogList";
        const string ModName = "用户";
        public Pub_Class.ClsPub.Enum_InputMode InputMode;  //录入状态标志(0-非录入状态 1-增加 2-修改)
        public long HItemID;//项目ID
        //ClsCN oCn = new ClsCN();
        ClsXt_SystemLog oSS = new ClsXt_SystemLog();
        ClsXt_SystemLogHlp oSSHlp = new ClsXt_SystemLogHlp();
        TreeNode CurNode = new TreeNode();
        ClsPub oPub = new ClsPub();
        public SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();



        public Xt_SystemLog()
        {
            InitializeComponent();
        }

        #region 固定代码
        //保存GRID列宽
        private void Xt_SystemLog_FormClosing(object sender, FormClosingEventArgs e)
        {
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);  
        }
        //窗体加载
        private void Xt_SystemLog_Load(object sender, EventArgs e)
        {
            oWeb.Url = ClsPub1.WEBSURL;
            frmCondition = new frmBillQueryCondition_Base();
            LoadTree();
            initGrid();
            InputMode = Pub_Class.ClsPub.Enum_InputMode.InputMode_View;
        }
        //加载树形
        private void LoadTree()
        {
            try
            {
                tv.Nodes.Clear();
                tv.ImageList = imageList1;
                TreeNode sNode = tv.Nodes.Add("T0", this.Text, 0, 1);
            }
            catch (Exception e)
            {
                MessageBox.Show("加载树型失败！" + e.Message, "提示");
            }
        }
      
        //初始化GRID
        private void initGrid()
        {
            DBUtility.Gy_BaseFun.initGrid(grdMain);
        }
        //显示列表
        private void Display()
        {
            //ClsCN SubCn = new ClsCN();
            DataSet DSet ;
            string sSql = "";
            string sWhere = "";
            //过滤条件
            //过滤条件
            if (frmCondition.SqlStr.Trim().Length == 0)
            {
                sSql = "Select top 1000 * from " + ViewName + " order by 日期 desc";
            }
            else
            {
                sSql = frmCondition.SqlStr + sWhere + " order by 日期 desc";
            }
            //
            DSet = oWeb.getDataSetBySQL(sSql, ViewName,ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题

            if (DSet == null)
            {
                MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            grdMain.DataSource = DSet.Tables[0].DefaultView;
         
            //加载列宽
            DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name);
            //
            HItemIDCol = Fun_GetCol("id");
        }
        //退出模块
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //刷新
        private void xs_Click(object sender, EventArgs e)
        {
            Display();
        }
        //查询
        private void cx_Click(object sender, EventArgs e)
        {
            frmCondition = new frmBillQueryCondition_Base();
            SetCondition(frmCondition, ViewName, this.Name);
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                Display();
            }
        }

        public void SetCondition(frmBillQueryCondition_Base frmCondition, string ViewName, string Name)
        {
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = Name;
        }


        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Gy_BaseFun.Fun_GetCol(sCol, grdMain);
        }
        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);  
        }

        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.ClsPub.DefaultGridView(grdMain);
            //参数解释  开始列 ，结束列，是否以最大列宽为准，最小列宽
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);  
        }
       
        //选中行是否正常
        //private bool AllowRow()
        //{
        //    if (grdMain.Row >= grdMain.FixedRows && grdMain.Row <= grdMain.Rows - 1)
        //        return true;
        //    else
        //        return false;
        //}
        //删除项目
        public void Delete()
        {
            if (DBUtility.Gy_BaseFun.AllowRow(grdMain))
            {
                if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    //得到HITEMID
                    long sItemID;
                    sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); 
                    //判断存在性
                    if (oSSHlp.GetInfoByID(sItemID))
                    {

                        if (oSS.DeleteByID(sItemID))
                        {
                            MessageBox.Show("删除项目成功！", "提示");
                            Display();
                        }
                        else
                            MessageBox.Show("删除项目成功！", "提示");
                    }
                }

            }
        }
        
        //删除
        private void sc_Click(object sender, EventArgs e)
        {
            Delete();
        }
        //时间控件
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            Display();
        }

        #endregion


        #region 类的读写
        #endregion


        #region 界面控件处理
        
        #endregion

        private void yl_Click(object sender, EventArgs e)
        {
            //Frm_PrintDesign frm = new Frm_PrintDesign();
            //frm.Show();
        }

        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            
        }


    }
}