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

namespace OAM
{
    public partial class frmWorkBillList : Form
    {
        public frmWorkBillList()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
            oUser.bSingle = true;
            oUser.ShowDialog();
            if (oUser.IsOk == 1)
            {
                txtEmp2.Text = oUser.sReturn;
            }
            else
            {
                txtEmp2.Text = "";
            }
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            LoadData();
        }

        private void LoadData()
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet Ds;
            string sSQL;
            string sWhere = "";
            if (txtEmp.Text != "")
            {
                sWhere = " and roperator like '%" + txtEmp.Text + "%'";
            }
            if (txtEmp2.Text != "")
            {
                sWhere = sWhere + " and operator like '%" + txtEmp2.Text + "%'";
            }
            if (OpGG1.Checked == true)
            {
                sSQL = "select a.ID,a.Operator 发送人,a.rOperator 接收人,a.Context 主题,a.Description 内容,a.opdate 时间" +
                        ",case when isnull(a.isend,0)=0 then case when a.isread=0 then '未阅' else case when a.isBack=0 then '已阅' else '已回复' end  end else '结案' end 状态" +
                        ",a.hasten 催促次数 from(select distinct a.*,b.operator as boperator " +
                        "from(Select a.isend,a.isback,a.hasten,a.id,operator,context,Description,b.opdate,roperator,isread " +
                        "from (select * from oa_workbillmain  where ispublic<>0)as a left join (select mainid,max(opdate)as opdate from oa_workbillsub group by mainid)as b " +
                        "on a.id=b.mainid)as a left join oa_workbillsub  b on a.roperator=b.operator and a.id=b.mainid)as a " +
                        "where opdate between '" + DBUtility.ClsPub.isDate(dtpBDate.Value).ToShortDateString() + "' and '" + DBUtility.ClsPub.isDate(dtpEDate.Value).ToShortDateString() + " 23:59:59' " + sWhere + " order by opdate desc";
            }
            else
            {
                sSQL = "select  a.ID,a.Operator 发送人,a.rOperator 接收人,a.Context 主题,a.Description 内容,a.opdate 时间 " +
                    ",case when isnull(a.isend,0)=0 then case when a.isread=0 then '未阅' else case when a.isBack=0 then '已阅' else '已回复' end  end else '结案' end 状态,a.hasten 催促次数 " +
                    "from(select distinct a.roperator,id,operator,description,opdate,ispublic,a.isread,a.isend,context,isback,hasten from oa_workbillmain a,oa_workbillsub2 b where" +
                    " a.id=b.mainid and (''='" + txtHUser.Text + "' or a.operator='" + txtHUser.Text + "' or b.roperator='" + txtHUser.Text + "'))as a where opdate between '" + DBUtility.ClsPub.isDate(dtpBDate.Value).ToShortDateString() + "' and '" + DBUtility.ClsPub.isDate(dtpEDate.Value).ToShortDateString() + " 23:59:59'  " + sWhere + " order by opdate desc";
            }
            Ds = oCn.RunProcReturn(sSQL, "oa_workbillmain", ref DBUtility.ClsPub.sExeReturnInfo);
            if (Ds == null)
            {
                MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            grdMain.DataSource = Ds.Tables[0].DefaultView;
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "", 0);
        }

        private void frmWorkBillList_Load(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
            txtHUser.Text = DBUtility.ClsPub.CurUserName;
            txtHUser.Enabled = false;
            button1.Enabled = false;
            dtpBDate.Value = DateTime.Now.AddDays(-30);
            dtpEDate.Value = DateTime.Now;
        }

        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            frmWorkBillView oWork = new frmWorkBillView();
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("id")].Value);
            if (lngBillKey == 0)
                return;
            oWork.ID = lngBillKey;
            oWork.Show();
            oWork.Display();
        }
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }

        private void OpGG1_CheckedChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void OpGG2_CheckedChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void dtpBDate_ValueChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void dtpEDate_ValueChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void txtEmp_TextChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void txtEmp2_TextChanged(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void bclk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }

        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }
    }
}