public MessageSql()
 {
     a_sqlServer = new SqlServer(ConfigurationInfo.DBConnectionString);
 }
 public ReceiptSql()
 {
     a_sqlServer = new SqlServer(ConfigurationInfo.DBConnectionString);
 }
        private void Method1(string path)
        {
            XElement ele = XElement.Load(path);
            IEnumerable<XElement> eles = ele.Elements().First().Elements();
            string orderNoFake = eles.Where(e => e.Name.LocalName == "copNo").First().Value;
            string preNo = eles.Where(e => e.Name.LocalName == "preNo").First().Value;

            SqlServer sql = new SqlServer(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
            sql.ExePROCNonQuery("ToolPro", ConvertToSqlParameters(orderNoFake, preNo));
            sql.CloseConnect();
        }