using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_WORKFLOW;
using System.Data.Common;
using GThinking.N_MODEL.Dialog;
using GThinking.N_PUBLIC;
using GThinking.N_MISPRO.Utility;
using GThinking.N_MISPRO.MISPROAS;
using System.IO;
using GThinking.N_CONTROL;
using System.Drawing;


namespace GThinking.N_XLJC
{
    public partial class XLJCYWDH_SZDHYM : SingleCardBase
    {
        SZDHYM entity = new SZDHYM();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421005;
            this.UMName = "线缆基础业务导航";
            base.CurMaster = Master;
            base.CurEntity = entity;
            this.PageHeight = 180;
            this.PageWidth = 420;
            Master.EnableAttachBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableInsertBtn = false;
            Master.EnablePrintBtn = false;
            Master.EnableRefreshBtn = false;
            Master.EnableSaveBtn = false;

            //设置文件选择框的过滤条件等
            fupdPost.FileSaveType = gtAsyncFileUpload.DFileSaveType.SaveToPath;
            fupdPost.Filter = "htm,html,mht";
            base.InitPage();
            if (!IsPostBack)
            {
                txtXLDHBH.Value = PageParam.GetRTrimString("XLDHBH").Trim();
            }
        }

        private int GetMaxBH()
        {
            int iBH = 0;
            string SQL = "select max(XLJCYWDH_XLDHBH) as MXBH from XLJCYWDH where 1=1 ";
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Add(SQL);
            DataSet ds = dberp.OpenDataSet(sSQL);
            iBH = CMISproConvert.StrToInt(ds.Tables[0].Rows[0][0].ToString().Trim());
            return iBH + 1;
        }

        protected void btnQD_Click(object sender, EventArgs e)
        {
            //判断是否存在文件
            if (String.IsNullOrEmpty(fupdPost.FilePath.Trim()))
            {
                ShowMessage("请选择需要上传的文件！");
                return;
            }

            try
            {
                FileStream ofilestream = File.OpenRead(fupdPost.FilePath);
                byte[] oFileBytes = new byte[ofilestream.Length];
                ofilestream.Read(oFileBytes, 0, oFileBytes.Length);
                ofilestream.Close();
                string FileName = fupdPost.FileName;
                int iNewBH = 0;

                try
                {
                    TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                    TSQL sSQL = new TSQL(dberp);
                    string sSQLText = @" insert into XLJCYWDH(XLJCYWDH_XLDHBH,XLJCYWDH_XLDHMC,XLJCYWDH_QSXS,XLJCYWDH_PTLX,XLJCYWDH_XLDHNR) 
                                     values(:XLJCYWDH_XLDHBH,:XLJCYWDH_XLDHMC,'N','N',:XLJCYWDH_XLDHNR) ";
                    sSQL.Clear();
                    sSQL.Text = sSQLText;
                    iNewBH = GetMaxBH();
                    sSQL.ParamByName("XLJCYWDH_XLDHBH").Value = iNewBH;
                    sSQL.ParamByName("XLJCYWDH_XLDHMC").Value = FileName;
                    sSQL.ParamByName("XLJCYWDH_XLDHNR").Value = oFileBytes;
                    dberp.ExecSQL(sSQL);
                }
                catch
                {
                    ShowMessage("当前文件名过长，请调整后重试！");
                    return;
                }

                //将新的文件编号传递给上一个界面
                DialogOperationScript dos = new DialogOperationScript(this);
                dos.SetOwnerControlValue("ctl00_CPHForm_txtDHBH", iNewBH.ToString());
                dos.Execute();

                CloseWindow();
            }
            catch
            {
                //ShowMessage("文件损坏或网络故障，错误信息：" + ex.Message);
                ShowMessage("文件损坏或网络故障！");
                CloseWindow();
            }
        }

        protected void btnQX_Click(object sender, EventArgs e)
        {
            CloseWindow();
        }
    }
}