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 frmWorkBill : Form
    {
        public frmWorkBill()
        {
            InitializeComponent();
        }
        public const int HFileNameCol = 0;//huan
        public const int HFilePathCol = 1;
        public const int HUpManCol = 2;
        string BillType = "9005";
        public const int MainType = 2;
        private void cmdSelectEmps_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
            oUser.bSingle = true;
            oUser.ShowDialog();
            if (oUser.IsOk == 1)
            {
                txtrOperator.Text = oUser.sReturn;
            }
            else
            {
                txtrOperator.Text = "";
            }
        }

        private void cmdCheckFlow_Click(object sender, EventArgs e)
        {

        }

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

        private void cmdAdd_Click(object sender, EventArgs e)//huan
        {
            OpenFileDialog oDlg = new OpenFileDialog();
            oDlg.Filter = "所有文件|*.*";
            if (oDlg.ShowDialog() == DialogResult.OK)
            {
                if (oDlg.FileName != "")
                {
                    grdMain.Rows.Add();
                    grdMain.Rows[grdMain.Rows.Count - 1].Cells[HFileNameCol].Value = oDlg.SafeFileName;
                    grdMain.Rows[grdMain.Rows.Count - 1].Cells[HFilePathCol].Value = oDlg.FileName;
                    grdMain.Rows[grdMain.Rows.Count - 1].Cells[HUpManCol].Value = DBUtility.ClsPub.CurUserName;
                }
            }
        }

        private void cmdSend_Click(object sender, EventArgs e)
        {
            //DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);//huan
            if (txtContext.Text == "")
            {
                MessageBox.Show("请录入主题");
                return;
            }
            if (txtrOperator.Text == "")
            {
                if (MessageBox.Show("接受人尽量不要为空？是否确认要使用空接受人？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
                {
                    return;
                }
            }
            if (Add())
            {
                DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
                this.Close();
            }
        }

        private void cmdCancel_Click(object sender, EventArgs e)
        {
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); //huan
            this.Close();
        }
        private bool Add()
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            long MainID;
            MainID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); 
            string Context = txtContext.Text.Replace("'", "‘");
            string Desc = txtDesc.Text.Replace("'", "‘");
            if (rdbGG.Checked == true)
            {
                oCn.RunProc("Insert into oa_workbillmain(id,operator,context,description" +
                                                    ",opdate,roperator,ispublic,roperator2,fdate,HBillType" +
                                                    ",HBillNo,HCommDate,HLevel,HEvaluateStatus,HRemark,hcheckflowmainid,HBillStatus) " +
                                                    " values (" +
                                                    MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
                                                    ",'" + Desc + "',getdate(),'" + txtrOperator.Text + "',1,'" + txtRoperator2.Text + "',getdate(),4501" +
                                                    ",'" + txtHBillNo.Text + "','" + DtpHCommDate.Value + "','" + cmbHLevel.Text + "','" + cmbHEvaluateStatus.Text + "','" + txtHRemark.Text + "',0,2)");
            }
            else
            {
                oCn.RunProc("Insert into oa_workbillmain(id,operator,context,description" +
                                                     ",opdate,roperator,ispublic,roperator2,fdate,HBillType" +
                                                     ",HBillNo,HCommDate,HLevel,HEvaluateStatus,HRemark,hcheckflowmainid,HBillStatus) " +
                                                     " values (" +
                                                     MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
                                                     ",'" + Desc + "',getdate(),'" + txtrOperator.Text + "',0,'" + txtRoperator2.Text + "',getdate(),4501" +
                                                     ",'" + txtHBillNo.Text + "','" + DtpHCommDate.Value + "','" + cmbHLevel.Text + "','" + cmbHEvaluateStatus.Text + "','" + txtHRemark.Text + "',0,2)");
            }
            oCn.RunProc("Insert into oa_workbillsub(id,mainid,operator,context,opdate)" +
                                            " values (" +
                                            "-1," + MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "',getdate())");
            if (txtRoperator2.Text != "")
            {
                string[] s = txtRoperator2.Text.Split(',');
                int len = s.Length;
                for (int i = 0; i < len; i++)
                {
                    int j = i + 2;
                    string k = s[i].ToString();
                    oCn.RunProc("insert into oa_workbillsub2 (MainID,SubID,ROperator,isRead,isKnow) " +
                                "values (" +
                                MainID + "," + j + ",'" + k + "',0,0)");
                }
            }
            oCn.RunProc("insert into oa_workbillsub2 (MainID,SubID,ROperator,isRead,isKnow) " +
                           "values (" +
                           MainID + ",1,'" + txtrOperator.Text + "',0,0)");
            //上传附件
            BLL.ClsXt_FileCtrl oFile = new BLL.ClsXt_FileCtrl();
            for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
            {
                if (oFile.LoadUpFile(MainID, MainType, DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HFilePathCol].Value), 0,
                    DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HFileNameCol].Value), DBUtility.ClsPub.CurUserName) == false)
                {
                    MessageBox.Show("上传文件时失败!");
                }
            }
            //
            return true;
        }

        private void frmWorkBill_Load(object sender, EventArgs e)
        { 
            this.txtHBillNo.Text = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//得到新单号 
            initGrid();//huan
        }

        public void initGrid()//huan
        {
            grdMain.ColumnCount = 3;                       //总列数
            DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
            grdMain.ReadOnly = true;
            grdMain.RowCount = 0;
            //= 
            grdMain.Columns[HFileNameCol].HeaderText = "文件名称";
            grdMain.Columns[HFilePathCol].HeaderText = "文件路径";
            grdMain.Columns[HUpManCol].HeaderText = "上传人";
            DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
        }

        private void cmdDel_Click(object sender, EventArgs e) //huan
        {
            if (grdMain.CurrentRow == null)
            {
                return;
            }
            grdMain.Rows.RemoveAt(grdMain.CurrentRow.Index);
        }
    }
}