using System;
using System.Collections.Generic;
using System.Text;
using SQLHelper;
using DBUtility;
using System.Data;

namespace DAL
{
    public class Cls_S_Xt_BaseBill1
    {
       
        public string mvarReportTitle;
        public string mvarItemKey;
        public string ViewName = "";
        public string sCondtion = "";
        public string sOrderSql = "";
        public string sKeyCol = "";
        public string sShowItemSql = "";
        //================================
        public string mvarReportTitle2;
        public string mvarItemKey2;
        public string ViewName2 = "";
        public string sCondtion2 = "";
        public string sOrderSql2 = "";
        public string sKeyCol2 = "";
        public string sShowItemSql2 = "";
        public frmHlpBillList1 oFrm;
        //public DAL.frmHlpBillList oFrm = new DAL.frmHlpBillList();
        public List<DBUtility.BillSelect> oBillSelectColl = new List<DBUtility.BillSelect>();
        public List<DBUtility.BillSelect_A3> oBillSelectColl2 = new List<DBUtility.BillSelect_A3>();
        //
        public Cls_S_Xt_BaseBill1()
        {
            //---
        }


        //显示数据
        /// <summary>
        /// 显示数据
        /// </summary>
        /// <param name="sWhere">主SQL</param>
        /// <param name="sCondtion">过滤条件</param>
        /// <param name="sOrderSql">排序条件</param>
        /// <param name="sKeyCol">不可重复列</param>
        /// <returns></returns>
        public virtual bool Refresh(string sWhere)
        {
            string sErr = "";
            int MainIDCol, SubIDCol, BillNoCol;
            string tSQL;
            ClsCN oCn = new ClsCN();
            tSQL = sWhere + sCondtion + sOrderSql;
            try
            {
                oFrm = new frmHlpBillList1();
                oFrm.sPrimaryCol = sKeyCol;
                oFrm.Text = mvarReportTitle;
                oFrm.lblCaption.Text = mvarReportTitle;
                oFrm.tSQL = tSQL;
                oFrm.ViewName = ViewName;
                
                oFrm.ShowDialog();
                if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
                {
                    //返回数据到集合中
                    oBillSelectColl.Clear();
                    MainIDCol = oFrm.Fun_GetCol("hmainid");
                    SubIDCol = oFrm.Fun_GetCol("hsubid");
                    BillNoCol = oFrm.Fun_GetCol("单据号");

                    //循环 选中行
                    for (int i = 0; i < oFrm.grdMain.SelectedRows.Count; i++)
                    {
                        BillSelect oSelect = new BillSelect();
                        oSelect.BillNo = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value);
                        oSelect.BillMainID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
                        oSelect.BillSubID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value);
                        oSelect.BillTitle = mvarReportTitle;
                        oSelect.BillType = mvarItemKey;
                        oBillSelectColl.Add(oSelect);
                    }
                }
                //
                if (oBillSelectColl.Count > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                sErr = e.Message;
            }
            return true;
        }


        //显示数据2
        /// <summary>
        /// 显示数据2
        /// </summary>
        /// <param name="sWhere">主SQL</param>
        /// <param name="sCondtion">过滤条件</param>
        /// <param name="sOrderSql">排序条件</param>
        /// <param name="sKeyCol">不可重复列</param>
        /// <returns></returns>
        public virtual bool Refresh2(string sWhere)
        {
            string sErr = "";
            int MainIDCol, SubIDCol, BillNoCol;
            string tSQL;
            ClsCN oCn = new ClsCN();
            tSQL = sWhere + sCondtion2 + sOrderSql2;
            try
            {
                oFrm = new frmHlpBillList1();
                oFrm.sPrimaryCol = sKeyCol2;
                oFrm.Text = mvarReportTitle2;
                oFrm.lblCaption.Text = mvarReportTitle2;
                oFrm.tSQL = tSQL;
                oFrm.ViewName = ViewName2;
                oFrm.ShowDialog();
                if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
                {
                    //返回数据到集合中
                    oBillSelectColl.Clear();
                    MainIDCol = oFrm.Fun_GetCol("hmainid");
                    SubIDCol = oFrm.Fun_GetCol("hsubid");
                    BillNoCol = oFrm.Fun_GetCol("单据号");
                    //循环 选中行
                    for (int i = 0; i < oFrm.grdMain.SelectedRows.Count; i++)
                    {
                        BillSelect oSelect = new BillSelect();
                        oSelect.BillNo = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value);
                        oSelect.BillMainID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
                        oSelect.BillSubID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value);
                        oSelect.BillTitle = mvarReportTitle2;
                        oSelect.BillType = mvarItemKey2;
                        oBillSelectColl.Add(oSelect);
                    }
                }
                //
                if (oBillSelectColl.Count > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                sErr = e.Message;
            }
            return true;
        }

        //显示数据3
        /// <summary>
        /// 显示数据3
        /// </summary>
        /// <param name="sWhere">主SQL</param>
        /// <param name="sCondtion">过滤条件</param>
        /// <param name="sOrderSql">排序条件</param>
        /// <param name="sKeyCol">不可重复列</param>
        /// <returns></returns>
        public virtual bool Refresh_A3(string sWhere)
        {
            string sErr = "";
            int MainIDCol, SubIDCol, BillNoCol;
            string tSQL;
            ClsCN oCn = new ClsCN();
            tSQL = sWhere + sCondtion2 + sOrderSql2;
            try
            {
                oFrm = new frmHlpBillList1();
                oFrm.sPrimaryCol = sKeyCol2;
                oFrm.Text = mvarReportTitle2;
                oFrm.lblCaption.Text = mvarReportTitle2;
                oFrm.tSQL = tSQL;
                oFrm.ViewName = ViewName2;
                oFrm.ShowDialog();
                if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
                {
                    //返回数据到集合中
                    oBillSelectColl2.Clear();
                    MainIDCol = oFrm.Fun_GetCol("hmainid");
                    SubIDCol = oFrm.Fun_GetCol("hsubid");
                    BillNoCol = oFrm.Fun_GetCol("单据号");
                    //循环 选中行
                    for (int i = 0; i < oFrm.grdMain.SelectedRows.Count; i++)
                    {
                        BillSelect_A3 oSelect = new BillSelect_A3();
                        oSelect.BillNo = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value);
                        oSelect.BillMainID = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
                        oSelect.BillSubID = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value);
                        oSelect.BillTitle = mvarReportTitle2;
                        oSelect.BillType = mvarItemKey2;
                        oBillSelectColl2.Add(oSelect);
                    }
                }
                //
                if (oBillSelectColl2.Count > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                sErr = e.Message;
            }
            return true;
        }





        //返回单据列表
        /// <summary>
        /// 返回单据列表
        /// </summary>
        /// <param name="sWhere">过滤条件</param>
        public DataSet DisSourceBillList(string sWhere)
        {
            try
            {
                ClsCN oCn = new ClsCN();
                return oCn.RunProcReturn("select "+sShowItemSql+" from " + ViewName + "  " + sWhere + sCondtion + sOrderSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
            }
            catch (Exception e)
            {
                DBUtility.ClsPub.sExeReturnInfo += "返回单据列表失败！" + e.Message;
                return null;
            }
        }

        //返回单据列表
        /// <summary>
        /// 返回单据列表
        /// </summary>
        /// <param name="sWhere">过滤条件</param>
        public  DataSet DisSourceBillList2(string sWhere)
        {
            try
            {
                ClsCN oCn = new ClsCN();
                return oCn.RunProcReturn("select " + sShowItemSql2 + " from " + ViewName2 + "  " + sWhere + sCondtion2 + sOrderSql2, ViewName2, ref DBUtility.ClsPub.sExeReturnInfo);
            }
            catch (Exception e)
            {
                DBUtility.ClsPub.sExeReturnInfo += "返回单据列表失败！" + e.Message;
                return null;
            }
        }

        public virtual bool Refresh3(string sWhere)
        {
            string sErr = "";
            int MainIDCol, SubIDCol, BillNoCol;
            string tSQL;
            ClsCN oCn = new ClsCN();
            tSQL = sWhere + sCondtion + sOrderSql;
            try
            {
                oFrm = new frmHlpBillList1();
                oFrm.sPrimaryCol = sKeyCol;
                oFrm.Text = mvarReportTitle;
                oFrm.lblCaption.Text = mvarReportTitle;
                oFrm.tSQL = tSQL;
                oFrm.ViewName = ViewName;
                oFrm.ShowDialog();
                //返回数据到集合中
                oBillSelectColl.Clear();
                if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
                {
                    MainIDCol = oFrm.Fun_GetCol("HMaterID");
                    //SubIDCol = oFrm.Fun_GetCol("hsubid");
                    //BillNoCol = oFrm.Fun_GetCol("单据号");
                    //循环 选中行
                    for (int i = 0; i < oFrm.grdMain.SelectedRows.Count; i++)
                    {
                        BillSelect oSelect = new BillSelect();
                        //oSelect.BillNo = ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value);
                        oSelect.BillMainID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
                        //oSelect.BillSubID = ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value);
                        oSelect.BillTitle = mvarReportTitle;
                        oSelect.BillType = mvarItemKey;
                        oBillSelectColl.Add(oSelect);
                    }
                }
                //
                if (oBillSelectColl.Count > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                sErr = e.Message;
            }
            return true;
        }

        //根据源单号 模拟查询数据
        /// <summary>
        /// 显示数据
        /// </summary>
        /// <param name="sWhere">主SQL</param>
        /// <param name="sCondtion">过滤条件</param>
        /// <param name="sOrderSql">排序条件</param>
        /// <param name="sKeyCol">不可重复列</param>
        /// <returns></returns>
        public virtual bool RefreshBySourceBillNo(string sWhere)
        {
            string sErr = "";
            string tSQL;
            ClsCN oCn = new ClsCN();
            tSQL = " select hmainid,hsubid,单据号 from " + ViewName + sWhere + sOrderSql;
            try
            {
                DataSet ds = oCn.RunProcReturn(tSQL, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                //返回数据到集合中
                oBillSelectColl.Clear();

                //循环 选中行
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    BillSelect oSelect = new BillSelect();
                    oSelect.BillNo = ClsPub.isStrNull(ds.Tables[0].Rows[i]["单据号"]);
                    oSelect.BillMainID = ClsPub.isLong(ds.Tables[0].Rows[i]["hmainid"]);
                    oSelect.BillSubID = ClsPub.isLong(ds.Tables[0].Rows[i]["hsubid"]);
                    oSelect.BillTitle = mvarReportTitle;
                    oSelect.BillType = mvarItemKey;
                    oBillSelectColl.Add(oSelect);
                }
                //
                if (oBillSelectColl.Count > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                sErr = e.Message;
            }
            return true;
        }



    }
}