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

namespace SCM
{
    public partial class Sc_PackUnionBillList : Form
    {
        public Sc_PackUnionBillList()
        {
            InitializeComponent();
        }
        public string ViewName = "h_v_ProductionLinePackagingList";
        public string ModCaption = "生产包装单列表";
        public const string ModRightName = "Sc_PackUnionBillList";
        public string HSourceBillType = "";
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();

        private void initGrid()
        {
            ClsPub1.initGridList(grdMain, this.Name);
            grdMain.RowTemplate.Height = 60;//行高
            grdMain.ColumnHeadersHeight = 60;//设置表头行高
            grdMain.RowHeadersWidth = 260;
            grdMain.RowsDefaultCellStyle.Font = new Font("宋体", 22);
            grdMain.ReadOnly = true;
        }

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

        private void Sc_PackUnionBillList_Load(object sender, EventArgs e)
        {
            //设置动态URL
            oWeb.Url = SCM.ClsPub1.WEBSURL;
            //
            //frmCondition = new frmBillQueryCondition_Base();
            this.Text = ModCaption;
            //lblCaption.Text = ModCaption;
            //oSumGrid.ogrdMain = grdMain;  //初始化 new
            //oSumGrid.oGridsum = grdSum;
            initGrid(); 
        }


        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            //cmbHSourceBillType.Text = HSourceBillType;
            //txtHSourceBillNo.Focus();
            //txtHSourceBillNo.SelectAll();
        }

        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            GraphicsGrid();
        }

        private void GraphicsGrid()
        {
            //画底线
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
            //画横线
            //DBUtility.Xt_BaseBillFun.GraphicsRowGrid(grdMain, iTopRow, iTopRow + 50, Fun_GetCol("hmainid"));
        }

        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }

        //保存列宽
        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 Display()
        {
            string sql = " where 1 = 1 ";
            if (txtHSourceBillNo.Text.Trim() != "")
            {
                sql += " and 唯一条码 like '%" + txtHSourceBillNo.Text.Trim() + "%'";
            }
            if (txtHBarCode.Text.Trim() != "")
            {
                sql += " and 条码 like '%" + txtHBarCode.Text.Trim() + "%'";
            }
            //得到信息
            string sql2 = "select * from " + ViewName + sql +" order by 唯一条码 desc";
            DataSet DS = oWeb.getDataSetBySQL(sql2, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
            if (DS==null ||  DS.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("没有找到相关源单信息！" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            grdMain.DataSource = DS.Tables[0].DefaultView;

            
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            int FrCol =0;
            string s = "是";
            ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);
        }





        //双击列表
        private void grdMain_DoubleClick(object sender, EventArgs e)
        {

        }


        private void txtHSourceBillNo_TextChanged(object sender, EventArgs e)
        {

        }

        private void Tool_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            Display();
        }

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

        private void cmbHSourceBillType_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        //删除按钮
        private void button1_Click(object sender, EventArgs e)
        {
            Sub_DeleteBill();
        }

        //删除
        private void Sub_DeleteBill()
        {

            try
            {
                if (AllowRow())
                {
                    if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    {
                        //得到HInterID
                        //long sHInterID;
                        //sHInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("hmainid")].Value);
                        //MessageBox.Show("id" + DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HIntterID")].Value));
                        MessageBox.Show("单据号：" + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HInterID")].Value) + " 删除成功！(实际未成功，功能开发中。。。)", "提示");
                
                        //oWeb.getRunProc("Delete from Xs_SeOutStockBackBillMain where HInterID=" + sHInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                        //oWeb.getRunProc("Delete from Xs_SeOutStockBackBillSub where HInterID=" + sHInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                        //oWeb.getRunProc("insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除单据：" + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("单据号")].Value) + "' ,'退货通知单列表','','删除')", ref DBUtility.ClsPub.sExeReturnInfo);
                    }
                }
                //MessageBox.Show("单据号：" + DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HInterID")].Value) + " 删除成功！", "提示");
                //MessageBox.Show("id" + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HIntterID")].Value));
                        
                Display();
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //选中行是否正常
        private bool AllowRow()
        {
            if (grdMain.CurrentRow == null)
            {
                return false;
            }
            if (grdMain.CurrentRow.Index >= 0 && grdMain.CurrentRow.Index <= grdMain.RowCount - 1)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        
    }
}