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

namespace SCM
{
    public partial class Gy_UserSupplierRelationList : Form
    {
        private int HItemIDCol = 0;
        private int HNumberCol = 0;
        public DBUtility.frmBillQueryCondition_New frmCondition;
        public const string ViewName = "h_v_Gy_UserSupplierRelationList";
        public string ModName = "用户供应商权限表资料";
        public string TreeTableName = "";
        //权限
        public const string ModRightName = "Gy_UserSupplierRelation";
        public const string ModRightNameEdit = ModRightName + "_Edit";
        public const string ModRightNameCheck = ModRightName + "_Check";
        //
        public DBUtility.ClsPub.Enum_InputMode InputMode;  //录入状态标志(0-非录入状态 1-增加 2-修改)
        public long  HItemID;//项目ID
        public long HItemGroupID;
        WMSWeb.Service oWeb = new WMSWeb.Service();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        WMSWeb.ClsGy_UserSupplierRelation_Ctl oMatePrce = new WMSWeb.ClsGy_UserSupplierRelation_Ctl();
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        WMSWeb.ClsGy_UserSupplierRelation_Model om = new WMSWeb.ClsGy_UserSupplierRelation_Model();
        TreeNode CurNode = new TreeNode();
        //拆分字符
        char spChar =Convert.ToChar( "~");
        public Gy_UserSupplierRelation oFrm;
        public Gy_UserSupplierRelationList()
        {
            InitializeComponent();
        }


        //以下代码基本不需要修改
        #region 固定代码
        private void kh_Click(object sender, EventArgs e)
        {
            //kh.Checked = true;
            //wl.Checked = false;
            LoadTree();
            Display();
        }

        private void wl_Click(object sender, EventArgs e)
        {
            //kh.Checked = false;
            //wl.Checked = true;
            LoadTree();
            Display();
        }
        //窗体加载
        private void Gy_UserSupplierRelation_Load(object sender, EventArgs e)
        {
            lblCaption.Text = ModName;
            this.Text = ModName;
            frmCondition = new DBUtility.frmBillQueryCondition_New();  //WEBS
            LoadTree();
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            initGrid();
            InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
        }
        //退出模块
        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 DBUtility.frmBillQueryCondition_New();   //WEBS
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = this.Name;
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                Display();
            }
        }
        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }
        
        //删除项目
        public void Delete()
        {
            //删除权限
            if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))    //WEBS
            {
                return;
            }
            //
            if (AllowRow())
            {
                if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    //得到HITEMID
                    long sItemID;
                    sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[HItemIDCol].Value);
                    if (oWeb.set_DeleteUserSupplierRelation(sItemID, ref ClsPub.sExeReturnInfo))
                    {
                        MessageBox.Show(ClsPub.sExeReturnInfo);
                        return;
                    }
                }

            }
        }
         
        //树型 单击
        private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            CurNode = e.Node;
            if (CurNode != null)
            {
                if (CurNode.Nodes.Count == 0)
                {
                    LoadAllNodes(CurNode);
                }
                frmCondition.SqlStr = "";
                //找到选中结点
                Display();
            }

        }
        
        //删除
        private void sc_Click(object sender, EventArgs e)
        {
            Delete();
        }
        //新增按钮   
        private void xz_Click(object sender, EventArgs e)
        {
            oFrm = new Gy_UserSupplierRelation();
            oFrm.ShowDialog();
        }
        //修改  
        private void Sub_ShowBill()
        {
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
            if (lngBillKey == 0)
                return;
            WMSWeb.ClsGy_UserSupplierRelation_Ctl oBillMain = new WMSWeb.ClsGy_UserSupplierRelation_Ctl();    //WEBS
            WMSWeb.ClsGy_UserSupplierRelation_Model oBill = new WMSWeb.ClsGy_UserSupplierRelation_Model();
            if (oWeb.set_ShowUserSupplierRelation(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                oFrm = new Gy_UserSupplierRelation();
                oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
                //foreach (Model.ClsGy_UserSupplierRelation_Model oSub in oBillMain.DetailColl)
                //{
                //    if (oSub.HChecker.Trim() != "")
                //    {
                //        oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
                //    }
                //}
                oBill.HItemID = lngBillKey; 
                oFrm.BillOld = oBill;
                oFrm.BillNew = oBillMain;
                oFrm.ShowDialog();
                if (oFrm.BillChange)
                {
                    if (MessageBox.Show("单据列表已经发生变化,是否刷新", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    {
                        timer1.Enabled = true;
                    }
                }
            }
            else
            {
                MessageBox.Show("单据未找到", "提示");
            }
            oBill = null;
            oBillMain = null;
        }
        //修改按钮
        private void xg_Click(object sender, EventArgs e)
        {
            Sub_ShowBill();
        }
        //选中行是否正常
        private bool AllowRow()
        {
            if (grdMain.CurrentRow.Index >= 0 && grdMain.CurrentRow.Index <= grdMain.RowCount - 1)
                return true;
            else
                return false;
        }

        //保存列宽
        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);
        }
        //时间控件
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            Display();
        }
       
        //初始化GRID
        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
        }
        
       
        #endregion

        //显示列表
        private void Display()
        {
            SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
            DataSet DSet = new DataSet();
            string sSql = "";
            string sWhere = "";
            string HParentID ="";
            if (CurNode.Name.Trim().Length == 0 || CurNode.Text == ModName)
            {
                HParentID ="";
            }
            else
            {
                char c = Convert.ToChar(spChar);
                string[] sr;
                sr = CurNode.Text.Split(c);
                HParentID = sr[0].ToString();
            }
            //过滤条件
            DSet = oWeb.GetDisplayUserSupplierRelation(HParentID, sSql, ViewName, sWhere);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //释放冻结
            DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
            //绑定
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            //  
            //冻结
            int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
            string s = frmCondition.cmbHComplete.Text;
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
            //画线
            //
            Total();
        }

        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
        }

        //加载子结点        //WEBS
        private void LoadAllNodes(TreeNode sNode)
        {
            string sBill;
            sBill = "h_v_Gy_UserRelation";
            if (sNode != null)
            {
                try
                {
                    sNode.Nodes.Clear();
                    DataSet Ds = oWeb.GetLoadAllNodes(sNode, sBill);
                    for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
                    {
                        TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + spChar + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1);
                    }
                    sNode.Expand();
                }
                catch (Exception e)
                {
                    MessageBox.Show("加载子项目失败！" + e.Message, "提示");
                }
            }
        }
        //加载树形
        private void LoadTree()
        {
            string sItemName;
            sItemName = ModName;
            try
            {
                tv.Nodes.Clear();
                tv.ImageList = imageList1;
                TreeNode sNode = tv.Nodes.Add("T0", sItemName, 0, 1);
                LoadAllNodes(sNode);
            }
            catch (Exception e)
            {
                MessageBox.Show("加载树型失败！" + e.Message, "提示");
            }
        }

        private void sh_Click(object sender, EventArgs e)
        {
            //审核权限
            //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
            //{
            //    return;
            //}
            //
            //Int64 lngBillKey = 0;
            //if (grdMain.SelectedRows.Count == 0)
            //{
            //    MessageBox.Show("请至少选择一行！", "提示");
            //    return;
            //}
            //for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
            //{
            //    lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
            //    if (lngBillKey == 0)
            //        return;
            //    DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl();    //WEBS
            //    //审核
            //    //查看是否已审核,关闭,作废
            //    if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            //    {

            //    }
            //    else
            //    {
            //        MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            //        return;
            //    }
            //    //审核
            //    if (oItem.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
            //    {
            //        //MessageBox.Show("审核成功!第"+i.ToString()+"行", "提示"); 
            //    }
            //    else
            //    {
            //        MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            //        return;
            //    }
            //}
            //MessageBox.Show("审核成功，请刷新！", "提示");
            //return;
        }

        private void fsh_Click(object sender, EventArgs e)
        {
            //审核权限
            //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
            //{
            //    return;
            //}
            //
            //Int64 lngBillKey = 0;
            //if (grdMain.SelectedRows.Count == 0)
            //{
            //    MessageBox.Show("请至少选择一行！", "提示");
            //    return;
            //}
            //for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
            //{
            //    lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
            //    if (lngBillKey == 0)
            //        return;
            //    DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl();    //WEBS
            //    //审核
            //    //查看是否已审核,关闭,作废
            //    if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            //    {

            //    }
            //    else
            //    {
            //        MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            //        return;
            //    }
            //    //审核
            //    if (oItem.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
            //    {
            //        //MessageBox.Show("审核成功!第"+i.ToString()+"行", "提示"); 
            //    }
            //    else
            //    {
            //        MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            //        return;
            //    }
            //}
            //MessageBox.Show("审核成功，请刷新！", "提示");
            //return;
        }

        private void pg_Click(object sender, EventArgs e)
        {
            ////审核权限
            ////if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
            ////{
            ////    return;
            ////}
            ////
            //double sPrice = 0;
            //Int64 lngBillKey = 0;
            //if (grdMain.SelectedRows.Count == 0)
            //{
            //    MessageBox.Show("请至少选择一行！", "提示");
            //    return;
            //}
            ////
            ////弹出窗体
            ////Gy_UserSupplierRelationDlg oDlg = new Gy_UserSupplierRelationDlg();
            ////oDlg.ShowDialog();
            ////if (oDlg.IsOk != 2)
            ////{
            ////    return;
            ////}
            ////sPrice = DBUtility.ClsPub.isDoule(oDlg.textBox1.Text);
            ////
            //DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl();
            //for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
            //{
            //    lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HItemIDCol].Value);
            //    //
            //    if (lngBillKey == 0)
            //        continue;
            //    //查看是否已审核,关闭,作废
            //    //if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            //    //{
            //    //    foreach (Model.ClsGy_UserSupplierRelation_Model oSub in oItem.DetailColl)
            //    //    {
            //    //        if (oSub.HChecker.Trim() != "")
            //    //        {
            //    //            MessageBox.Show("单据已审核!不能批量修改!", "提示");
            //    //            return;
            //    //        }
            //    //    }
            //    //}
            //    //else
            //    //{
            //    //    MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            //    //    return;
            //    //}
            //    //审核
            //}
            //MessageBox.Show("操作完毕，请刷新", "提示");
            //return;
        }

        //private void fz_Click(object sender, EventArgs e)
        //{
        //    //审核权限
        //    //if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
        //    //{
        //    //    return;
        //    //}
        //    //
        //    Gy_UserSupplierRelationCopy oFrm = new Gy_UserSupplierRelationCopy();
        //    oFrm.ShowDialog();
        //}

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }


    }
}