static void Main(string[] args)
{
//PreDisGenerator P = new PreDisGenerator("1000000034", "wmwhse1", "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "");
//XDocument d = P.Generator();
//d.Save("c:\\test.xml");
//test1();
//DateTime date = DateTime.Now;
//DateTime firstOfNextMonth = new DateTime(date.Year, date.Month, 1).AddMonths(1);
//DateTime lastOfThisMonth = firstOfNextMonth.AddDays(-1);
//int lastscday = lastOfThisMonth.Day - 2;
//DateTime sdt =DateTime.Now;
//if (date.Month == 1)
//{
// sdt = new DateTime((date.Year-1), 12, 21);
//}else{
// sdt = new DateTime(date.Year, (date.Month - 1), 21);
//}
//DateTime edt = new DateTime(date.Year, date.Month, 21);
//sp_zh_wmstobill( sdt.ToString("yyyyMMdd"), edt.ToString("yyyyMMdd"));
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\hddec.xml");
//HBDec.Read(doc);
//DisB2B.Read(doc);
//run();
//Console.ReadLine();
//string _excelFile="c:\\szt_vendor_alloc_quarter20151002000231.xlsx";
//FileStream stream = File.Open(_excelFile, FileMode.Open, FileAccess.Read);
// IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
// excelReader.IsFirstRowAsColumnNames = true;
// DataSet result = excelReader.AsDataSet();
// DataTable dt = result.Tables[0];
// excelReader.Close();
// stream.Close();
// MailClient.SendAllocNotificationMail(dt, _excelFile, string.Empty);
// Console.Read();
//test();
//Kaifa.B2B.Utility.SAPARReturnHelper.Update("20151105_15141", "test", "test");
//ARGenerator ar = new ARGenerator("20151105", "wmwhse1", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;", "");
//XDocument doc= ar.Generator();
//Console.WriteLine(doc);
//DateTime date = DateTime.Now;
//DateTime sdt = new DateTime(date.Year, (date.Month - 1), 21);
//DateTime edt = new DateTime(date.Year, date.Month, 21);
//SAP.ZfiCreateArForWmsRequest req = new TestConsoleApp.SAP.ZfiCreateArForWmsRequest();
//SAP.ZfiWmsStru body = new TestConsoleApp.SAP.ZfiWmsStru();
//string dt= DateTime.Now.ToString("yyyyMMddT000000.000") + "Z";
//TDN940Generator tdn = new TDN940Generator("0000000273", "wmwhse1", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;", "");
//XDocument doc= tdn.Generator();
//Console.WriteLine(doc);
//TestAPI();
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\webreponse.xml");
//string xml = doc.DocumentElement.ChildNodes[0].InnerText;
//XmlDocument ddd = new XmlDocument();
//ddd.LoadXml(xml);
//XmlNode node= ddd.DocumentElement.SelectSingleNode("/Message/Body/Error");
//if (node != null)
//{
// node.InnerText;
//}
//"Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False"
//CalendarTask t = new CalendarTask("C:\\test\\in", "C:\\test\\bk", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;");
//t.Start();
//Console.ReadLine();
//t.Stop();
//CalendarProcess p = new CalendarProcess("C:\\希捷日历11.xlsx", "Server=10.10.205.147;Database=STEST;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "wmwhse2");
//p.Read();
AllocProcess p = new AllocProcess("c:\\szd_vendor_alloc_adhoc201606030.csv", "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "wmwhse2");
p.Read();
Console.Read();
//string a = "STZ".Substring(0, 2);
//string connstring = "Server=10.10.201.154;Database=SCPRD;User ID=sa;Password=P@ssw0rd;Trusted_Connection=False";
//string warehouse = "wmwhse1";
//IEnumerable<string> r = GetReceiptKeys(connstring, warehouse);
//Console.WriteLine(r.Count());
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\4C1.xml");
//string content = Kaifa.B2B.Utility.HeaderHelper.ReturnSCWithDocType(doc, "4C1R0200");
//XmlDocument doc1 = RemoveNamespace(doc);
//string id = pipInstanceIdentifier(doc, "");
// UserInfo user = new UserInfo();
// user.UserName = "******";
// user.Password = "******";
// user.Whcode = "SCPRD_wmwhse1";
// string[] keys = new string[] { "0000000348", "0000000348", "0000000348" };
// string str = DateTime.Now.ToString("yyyyMMddTHHmmss.fff") + "Z";
//string str = DateTime.Now.ToString("MMMddyyyy", CultureInfo.CreateSpecificCulture("en-US"));
//string str = DateTime.Now.ToString("yyyyMMddHHmmssfff");
//inv();
//Console.WriteLine(str);
//AdvancedShipNoticeGenerator g = new AdvancedShipNoticeGenerator(keys, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/AdvancedShipNotice");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//string orderkey = GetOrderKey();
////IEnumerable<string> orders = GetOrderKeys();
//UpdateFlag(orders.ToArray());
//string orderkey = "1000000056";
//OrderShipmentGenerator g = new OrderShipmentGenerator(orderkey, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/OrderShipment");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//string[] orderkeys = new string[] { "0000000647" };
//OrderShipmentPODGenerator g = new OrderShipmentPODGenerator(orderkeys, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/OrderShipment");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//InventoryReportGenerator inv = new InventoryReportGenerator(true, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/InventoryReport");
//XDocument doc = inv.Generator();
//Console.WriteLine(doc);
//DataReader();
//LoginTest(user);
//AsnListTest(user);
// var xml = XElement.Parse(@"<ns0:Root xmlns:ns0=""http://Test.Schema"">
// <a>1</a>
// <a>2</a>
// </ns0:Root>");
// var xd = new XDocument(xml);
// var xmld = xd.GetXmlDocument();
// Console.WriteLine(stripNS(xml));
//XNamespace nsSys = "http://schemas.microsoft.com/2004/06/windows/eventlog/system";
//XElement head1 = Header();
//XElement details = Detail();
//foreach (XElement el in details.Elements("Detail"))
//{
// head1.LastNode.AddAfterSelf(el);
//}
////doc.AddAfterSelf(head1);
//XDocument doc = new XDocument(new XElement("Root", head1));
//string res = doc.ToString();
////doc.Root.Add(new XAttribute(XNamespace.Xmlns + "ns0", nsSys));
//foreach (XElement el in doc.Descendants())
//{
// el.Name = nsSys + el.Name.LocalName;
//}
//string res1 = doc.ToString();
//inv();
//asn();
}
static void Main(string[] args)
{
//PreDisGenerator P = new PreDisGenerator("1000000034", "wmwhse1", "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "");
//XDocument d = P.Generator();
//d.Save("c:\\test.xml");
//test1();
//DateTime date = DateTime.Now;
//DateTime firstOfNextMonth = new DateTime(date.Year, date.Month, 1).AddMonths(1);
//DateTime lastOfThisMonth = firstOfNextMonth.AddDays(-1);
//int lastscday = lastOfThisMonth.Day - 2;
//DateTime sdt =DateTime.Now;
//if (date.Month == 1)
//{
// sdt = new DateTime((date.Year-1), 12, 21);
//}else{
// sdt = new DateTime(date.Year, (date.Month - 1), 21);
//}
//DateTime edt = new DateTime(date.Year, date.Month, 21);
//sp_zh_wmstobill( sdt.ToString("yyyyMMdd"), edt.ToString("yyyyMMdd"));
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\hddec.xml");
//HBDec.Read(doc);
//DisB2B.Read(doc);
//run();
//Console.ReadLine();
//string _excelFile="c:\\szt_vendor_alloc_quarter20151002000231.xlsx";
//FileStream stream = File.Open(_excelFile, FileMode.Open, FileAccess.Read);
// IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
// excelReader.IsFirstRowAsColumnNames = true;
// DataSet result = excelReader.AsDataSet();
// DataTable dt = result.Tables[0];
// excelReader.Close();
// stream.Close();
// MailClient.SendAllocNotificationMail(dt, _excelFile, string.Empty);
// Console.Read();
//test();
//Kaifa.B2B.Utility.SAPARReturnHelper.Update("20151105_15141", "test", "test");
//ARGenerator ar = new ARGenerator("20151105", "wmwhse1", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;", "");
//XDocument doc= ar.Generator();
//Console.WriteLine(doc);
//DateTime date = DateTime.Now;
//DateTime sdt = new DateTime(date.Year, (date.Month - 1), 21);
//DateTime edt = new DateTime(date.Year, date.Month, 21);
//SAP.ZfiCreateArForWmsRequest req = new TestConsoleApp.SAP.ZfiCreateArForWmsRequest();
//SAP.ZfiWmsStru body = new TestConsoleApp.SAP.ZfiWmsStru();
//string dt= DateTime.Now.ToString("yyyyMMddT000000.000") + "Z";
//TDN940Generator tdn = new TDN940Generator("0000000273", "wmwhse1", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;", "");
//XDocument doc= tdn.Generator();
//Console.WriteLine(doc);
//TestAPI();
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\webreponse.xml");
//string xml = doc.DocumentElement.ChildNodes[0].InnerText;
//XmlDocument ddd = new XmlDocument();
//ddd.LoadXml(xml);
//XmlNode node= ddd.DocumentElement.SelectSingleNode("/Message/Body/Error");
//if (node != null)
//{
// node.InnerText;
//}
//"Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False"
//CalendarTask t = new CalendarTask("C:\\test\\in", "C:\\test\\bk", "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False;");
//t.Start();
//Console.ReadLine();
//t.Stop();
//CalendarProcess p = new CalendarProcess("C:\\希捷日历11.xlsx", "Server=10.10.205.147;Database=STEST;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "wmwhse2");
//p.Read();
AllocProcess p = new AllocProcess("c:\\szd_vendor_alloc_adhoc201606030.csv", "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False", "wmwhse2");
p.Read();
Console.Read();
//string a = "STZ".Substring(0, 2);
//string connstring = "Server=10.10.201.154;Database=SCPRD;User ID=sa;Password=P@ssw0rd;Trusted_Connection=False";
//string warehouse = "wmwhse1";
//IEnumerable<string> r = GetReceiptKeys(connstring, warehouse);
//Console.WriteLine(r.Count());
//XmlDocument doc = new XmlDocument();
//doc.Load("c:\\4C1.xml");
//string content = Kaifa.B2B.Utility.HeaderHelper.ReturnSCWithDocType(doc, "4C1R0200");
//XmlDocument doc1 = RemoveNamespace(doc);
//string id = pipInstanceIdentifier(doc, "");
// UserInfo user = new UserInfo();
// user.UserName = "******";
// user.Password = "******";
// user.Whcode = "SCPRD_wmwhse1";
// string[] keys = new string[] { "0000000348", "0000000348", "0000000348" };
// string str = DateTime.Now.ToString("yyyyMMddTHHmmss.fff") + "Z";
//string str = DateTime.Now.ToString("MMMddyyyy", CultureInfo.CreateSpecificCulture("en-US"));
//string str = DateTime.Now.ToString("yyyyMMddHHmmssfff");
//inv();
//Console.WriteLine(str);
//AdvancedShipNoticeGenerator g = new AdvancedShipNoticeGenerator(keys, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/AdvancedShipNotice");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//string orderkey = GetOrderKey();
////IEnumerable<string> orders = GetOrderKeys();
//UpdateFlag(orders.ToArray());
//string orderkey = "1000000056";
//OrderShipmentGenerator g = new OrderShipmentGenerator(orderkey, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/OrderShipment");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//string[] orderkeys = new string[] { "0000000647" };
//OrderShipmentPODGenerator g = new OrderShipmentPODGenerator(orderkeys, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.37;Database=STEST;User ID=sa;Password=1;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/OrderShipment");
//XDocument asn = g.Generator();
//Console.WriteLine(asn);
//InventoryReportGenerator inv = new InventoryReportGenerator(true, "c:\\config.xml",
// "SZT", "Seagate", "e2open", "wmwhse1",
// "Server=10.10.205.147;Database=SCPRD;User ID=sa;Password=Suwmsdb_2015;Trusted_Connection=False",
// "http://kaifa.b2b.schemas/InventoryReport");
//XDocument doc = inv.Generator();
//Console.WriteLine(doc);
//DataReader();
//LoginTest(user);
//AsnListTest(user);
// var xml = XElement.Parse(@"<ns0:Root xmlns:ns0=""http://Test.Schema"">
// <a>1</a>
// <a>2</a>
// </ns0:Root>");
// var xd = new XDocument(xml);
// var xmld = xd.GetXmlDocument();
// Console.WriteLine(stripNS(xml));
//XNamespace nsSys = "http://schemas.microsoft.com/2004/06/windows/eventlog/system";
//XElement head1 = Header();
//XElement details = Detail();
//foreach (XElement el in details.Elements("Detail"))
//{
// head1.LastNode.AddAfterSelf(el);
//}
////doc.AddAfterSelf(head1);
//XDocument doc = new XDocument(new XElement("Root", head1));
//string res = doc.ToString();
////doc.Root.Add(new XAttribute(XNamespace.Xmlns + "ns0", nsSys));
//foreach (XElement el in doc.Descendants())
//{
// el.Name = nsSys + el.Name.LocalName;
//}
//string res1 = doc.ToString();
//inv();
//asn();
}
