namespace FormExample
{
    public partial class Form2 : Form
    {
//Created by zhuhl on 2014-11-16
        private int nPrintIdTmp;
        private int LabelType;
        private string LabelFile = string.Empty;
        

        public Form2()
        {
            InitializeComponent();
        }

        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (this.txtProlot.Text.Trim().Length > 15)
            {
                MessageBox.Show("批号长度不能超过15位","系统提示",MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            if (this.ChkProlot())
            {
                string strPath = Application.StartupPath.ToString();
                string str2 = "";
                str2 = strPath + @"\Label\FontLib.xml"; //设置字体
                // string barFontlist = ;
                PrintersAndPrintType type = new PrintersAndPrintType();
                if (type.ShowDialog() != DialogResult.Cancel) // 取消选打印机及语言，直接取默认，即EPLII 和 默认打印机
                {

                    string strSql = "PRODUCT_GETBARCODEDATA ‘" + this.nPrintIdTmp + "‘,‘" + this.LabelType + "‘";
                    ITPrintClass class2 = new ITPrintClass();
                    // class2.ChineseFontName = "宋体";
                    // class2.BeginPrint(); // 直接发送到默认打印机
                    class2.BeginPrintAt(type.ITPrinterName); //指定打印机                

                    if (string.Compare(type.ITPrinterType, "ZPLII") == 0)
                    {
                        class2.PrinterType = tagITPrinterType.ZPLII;
                    }
                    if ((str2 != null) && (str2.Length > 0))
                    {
                        //获取定义标签的文件的内容
                        class2.LoadFontLibIndexFromText(this.GetDefineLabelXmlText(str2));
                    }
                    string strFile = strPath + @"\Label\" + LabelFile;//添加路径信息
                    class2.SetBarcodeDefineXmlText(this.GetDefineLabelXmlText(strFile)); //标贴定义档

                    if (strSql.Length > 0)
                    {
                        class2.PrintDefinedBarcodeLabel(this.GetSqlDataXmlText(strSql));//从数据库取的

                    }
                    else
                    {
                        class2.PrintDefinedBarcodeLabel(null);
                    }
                    class2.EndPrint();
                    class2 = null;
                }
            }
                       
        }


        private string GetDefineLabelXmlText(string filepath)
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load(filepath);
            StringWriter w = new StringWriter();
            XmlTextWriter writer = new XmlTextWriter(w);
            writer.Formatting = Formatting.Indented;
            xmlDoc.Save(writer);
            writer.Close();
            return w.ToString();
        }

        private string GetSqlDataXmlText(string strSql)
        {
            XmlDocument document = new XmlDocument();
           
            document.LoadXml("<BarcodeSqlData/>");
            SqlConnection connection = new SqlConnection(this.ConnectionString);
            SqlCommand command = new SqlCommand(strSql, connection);
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                XmlElement newChild = document.CreateElement("FieldData");
                int num2 = reader.FieldCount - 1;
                for (int i = 0; i <= num2; i++)
                {
                    newChild.SetAttribute(reader.GetName(i), Convert.ToString(RuntimeHelpers.GetObjectValue(reader.GetValue(i))).Trim());
                }
                document.DocumentElement.AppendChild(newChild);
            }
            reader.Close();
            connection.Close();
            StringWriter w = new StringWriter();
            XmlTextWriter writer = new XmlTextWriter(w);
            writer.Formatting = Formatting.Indented;
            document.Save(writer);
            writer.Close();
            return w.ToString();
        }

        protected string ConnectionString
        {
            get
            {
                string str = "SERVER";
                string str2 = "USER";
                string str3 = "PASSWORD";
                string str4 = "DATABASE";
                string str5 = string.Empty;
                // str5 = "Persist Security Info=True;Password=" + str3 + ";User ID=" + str2;
                str5 = "Persist Security Info=True;Password=" + str3 + ";User ID=" + str2;
                return (str5 + ";Initial Catalog=" + str4 + ";Data Source=" + str + ";Connect Timeout=60");
            }
        }

        private bool ChkProlot()
        {
            string str2 = "";
            SqlConnection connection = new SqlConnection(this.ConnectionString);
            SqlCommand command = new SqlCommand("ZZLABEL_TEST ‘" + this.txtProlot.Text + "‘", connection); //检测生产批号的有效性
            bool flag = true;
            connection.Open();
            try
            {
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    flag = false;
                    str2 = reader.GetString(1).Trim();
                    this.nPrintIdTmp = reader.GetInt32(2);
                }
                reader.Close();
                reader = new SqlCommand("PRODUCT_GETLABELFILE ‘" + str2 + "‘,‘" + this.nPrintIdTmp.ToString() + "‘", connection).ExecuteReader();//这个批号对应的标签定义文件名
                while (reader.Read())
                {
                    LabelFile = reader.GetString(0).Trim();
                    LabelType = reader.GetInt32(1);
                }
                reader.Close();
                connection.Close();
                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
        }

     
    }
}