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

namespace DAL
{
    public class ClsWeb_BarCodeBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsCg_POInStockBillMain omodel = new Model.ClsCg_POInStockBillMain();
        public SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
        public string MvarItemKeySubForWeb3 = "h_v_Web_BarCodeBill_ForWeb1";
        public string MvarItemKeySubForWeb4 = "h_v_Web_BarCodeBill_ForWeb2";

        public ClsWeb_BarCodeBill()
        {
            base.MvarItemKeyForWeb = "h_v_SRM_POInStockBillMain_ForWeb2";          
            base.MvarItemKeySubForWeb = "h_v_SRM_POInStockBillSub_ForWeb2"; 
            base.MvarItemKeySubForWeb2 = "h_v_Web_BarCodeBill_ForWeb";
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "";
            base.MvarReportTitle = "";
            base.BillType = "";
            
           
        }

        #region 固定代码

        ~ClsWeb_BarCodeBill()
        {
            //DetailColl = null;
        }

        #endregion   自定义方法

 

        public DataSet ShowBillMain(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = "Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString();
                DataSet set = oCn.RunProcReturn("Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(), this.MvarItemKeyForWeb);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据头未找到！";
                    return null;
                }
                sReturn = "显示单据头成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message;
                return null;
            }
        }
        public DataSet ShowBillMain1(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = "Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString();
                DataSet set = oCn.RunProcReturn("Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(), this.MvarItemKeyForWeb);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据头未找到！";
                    return null;
                }
                sReturn = "显示单据头成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message;
                return null;
            }
        }
        public DataSet ShowBillSub(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = "Select " + sShowItem + "  from " + this.MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ";
                DataSet set = oCn.RunProcReturn("Select " + sShowItem + "  from " + this.MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", this.MvarItemKeySubForWeb);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }
        public DataSet ShowBillSub1(long lngBillKey, long HEntryID, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " }), this.MvarItemKeySubForWeb);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }

        public DataSet ShowBillSub2(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb4);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }
        public DataSet ShowBillSub3(long lngBillKey, long HEntryID, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " }), this.MvarItemKeySubForWeb2);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }
        public DataSet ShowBillSub4(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb2);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }
        public DataSet ShowBillSub5(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb3, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb3, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb3);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }
        public DataSet ShowBillSub6(long lngBillKey, string sShowItem, ref string sReturn)
        {
            string str = "";
            try
            {
                str = string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
                DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, "  from ", this.MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb4);
                if ((set == null) || (set.Tables[0].Rows.Count == 0))
                {
                    sReturn = "单据体未找到！";
                    return null;
                }
                sReturn = "显示单据体成功！";
                return set;
            }
            catch (Exception exception)
            {
                sReturn = exception.Message + str;
                return null;
            }
        }

        //生成条码
        public bool SaveBarCode(Int64 HMaterID, Int64 HUnitID, Int64 HSupID, Int64 HQty, Int64 HMinQty, Int64 HSourceInterID, Int64 HSourceEntryID, string HSourceBillNo, string HSourceBillType, string HMTONO, Int64 HQty2)
        {
            oCn.RunProc("exec h_p_Web_BarCodeBill " + HMaterID + "," + HUnitID + "," + HSupID + "," + HQty + "," + HMinQty + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO+"'," + HQty2);
            return true;
        }
        //检查是否已经生成条码
        public bool CheckBarCode(Int64 HSourceInterID, Int64 HSourceEntryID)
        {
            
            DataSet Ds;
            Ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HSourceInterID=" + HSourceInterID + " and HSourceEntryID=" + HSourceEntryID, "Gy_BarCodeBill");
            if (Ds == null)
            {
                return false;
            }
            if (Ds.Tables[0].Rows.Count == 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

    }
}