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 frm_MeetingBill : Form
    {
        public string id;
        public bool zt;
        public Int64 HInterID = 0;
        public frm_MeetingBill()
        {
            InitializeComponent();
        }


        private void cmdOK_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            if (zt == false)
            {
                oCN.RunProc("update oa_meetingbill set " +
                    " HDate= '" + dtpHDate.Value.ToShortDateString() + "'" +
                    " ,HMeetID=  '" + DBUtility.ClsPub.isLong(txtHMeetID.Tag).ToString() + "'" +
                    " ,HItem=  '" + txtHItem.Text + "'" +
                    " ,HReason=  '" + txtHReason.Text + "'" +
                    " ,HDept= '" + txtHDept.Text + "'" +
                    " ,HEmp=  '" + txtHEmp.Text + "'" +
                    " ,HRemark= '" + txtHRemark.Text + "'" +
                    " ,HModel= '" + txtHModel.Text + "'" +
                    " ,HEDate= '" + dtpHEDate.Value.ToShortDateString() + "'" +
                    " where HInterID=" + HInterID.ToString());

                MessageBox.Show("Ð޸ijɹ¦£¡");
            }
            else
            {
                if (HInterID == 0)
                {
                    oCN.RunProc(" insert into oa_meetingbill (HDate,HMeetID,HItem,HReason,HDept,HEmp,HRemark,HMaker,HMakeDate,HType,HEDate,HModel) values  (" +
                        "'" + dtpHDate.Value.ToShortDateString() + "'," + DBUtility.ClsPub.isLong(txtHMeetID.Tag).ToString() + ",'" + txtHItem.Text + "','" + txtHReason.Text +
                        "','" + txtHDept.Text + "','" + txtHEmp.Text + "','" + txtHRemark.Text + "','" + DBUtility.ClsPub.CurUserName +
                        "',getdate(),0,'" + dtpHEDate.Value.ToShortDateString() + "','" + txtHModel.Text + "') ");
                }

                MessageBox.Show("±£´æ³É¹¦£¡");
            }
            InitUI(); 
            this.Close();

        }

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

        private void InitUI()
        {
            txtHMeetID.Text = "";
            txtHItem.Text = "";
            txtHReason.Text = "";
            txtHDept.Text = "";
            txtHEmp.Text = "";
            txtHRemark.Text = "";
            txtHModel.Text = "";
            HInterID = 0;
        }

        private void Display()
        {

        }

        private void frm_MeetingBill_Load(object sender, EventArgs e)
        {
            dtpHDate.Value = DateTime.Today;
            dtpHEDate.Value = DateTime.Today; 
            if (zt == false)
            {

                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                DataSet Ds;
                Ds = oCn.RunProcReturn("Select * from Oa_Meetingbill where HInterID='" + id + "'", "Oa_Meetingbill");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    return;
                }
                //oDeptid = Ds.Tables[0].Rows[0]["Deptid"].ToString().Trim();
                //DataSet Ds2;
                //Ds2 = oCn.RunProcReturn("Select * from deptlist where fitemid='" + oDeptid + "'", "deptlist");
                //if (Ds.Tables[0].Rows.Count == 0)
                //{
                //    return;
                //}
                //¸³Öµ 
                DAL.ClsOa_Meetingitem_View omee = new DAL.ClsOa_Meetingitem_View();
                string oHMeetID = Ds.Tables[0].Rows[0]["HMeetID"].ToString();
               
                int result;
                if (int.TryParse(oHMeetID, out result))
                {
                    Console.WriteLine("ת»»ºóµÄÕûÐÍÊýֵΪ£º{0}", result);
                }
                else
                {
                    Console.WriteLine("ÎÞ·¨Íê³Éת»»£¡");
}
                txtHModel.Tag = Ds.Tables[0].Rows[0]["HMeetID"].ToString().Trim();
                if (omee.GetInfoByID(result))//²¿ÃÅ
                {
                    this.txtHMeetID.Text = omee.omodel.HName;
                    this.txtHMeetID.Tag = omee.omodel.HItemID.ToString().Trim();
                }
                else
                {
                    this.txtHMeetID.Text = "";
                } 

                txtHModel.Text = Ds.Tables[0].Rows[0]["HModel"].ToString().Trim();
                txtHItem.Text = Ds.Tables[0].Rows[0]["HItem"].ToString().Trim();
                txtHReason.Text = Ds.Tables[0].Rows[0]["HReason"].ToString().Trim();
                txtHDept.Text = Ds.Tables[0].Rows[0]["HDept"].ToString().Trim();
                txtHEmp.Text = Ds.Tables[0].Rows[0]["HEmp"].ToString().Trim();
                dtpHEDate.Text = Ds.Tables[0].Rows[0]["HEDate"].ToString().Trim();
                txtHRemark.Text = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim();
                dtpHDate.Text = Ds.Tables[0].Rows[0]["HDate"].ToString().Trim();
            }
            else
            {
                InitUI();
            }
            
        }

        private void timer1_Tick(object sender, EventArgs e)
        {

            timer1.Enabled = false;
         
            Display();
        }

        private void cmdHMeetID_Click(object sender, EventArgs e)
        {

            DAL.ClsOa_Meetingitem_View omee = new DAL.ClsOa_Meetingitem_View();
            if (omee.RefreshView())
            {
                this.txtHMeetID.Text = omee.oModel.HName;
                this.txtHMeetID.Tag = omee.oModel.HItemID.ToString();
            }
            else
            {
                this.txtHMeetID.Text = "";
            }
        }

        private void dtpHDate_ValueChanged(object sender, EventArgs e)
        {

        }



    }
}