public void UpdateFlag(AdvancedShipNoticeProviderParameters para, IEnumerable <string> receiptKeys)
{
using (SqlConnection conn = new SqlConnection(para.connectionstring))
{
conn.Open();
string whereexpression = " WHERE RECEIPTKEY IN (" + string.Join(",", receiptKeys.Select(t => "'" + t + "'").ToArray()) + ")";
string sqlcmd = string.Format("UPDATE [{0}].[RECEIPT] SET B2BFLAG = 1 {1}", para.warehous, whereexpression);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
cmd.ExecuteNonQuery();
}
}
public void UpdateFlag(AdvancedShipNoticeProviderParameters para, IEnumerable<string> receiptKeys)
{
using (SqlConnection conn = new SqlConnection(para.connectionstring))
{
conn.Open();
string whereexpression = " WHERE RECEIPTKEY IN (" + string.Join(",", receiptKeys.Select(t => "'" + t + "'").ToArray()) + ")";
string sqlcmd = string.Format("UPDATE [{0}].[RECEIPT] SET B2BFLAG = 1 {1}", para.warehous, whereexpression);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
cmd.ExecuteNonQuery();
}
}
public IEnumerable <string> GetReceiptKeys(AdvancedShipNoticeProviderParameters para)
{
using (SqlConnection conn = new SqlConnection(para.connectionstring))
{
conn.Open();
string sqlcmd = string.Format("SELECT T.RECEIPTKEY FROM [{0}].[RECEIPT] T WHERE (T.B2BFLAG=0 OR T.B2BFLAG IS NULL) AND STATUS=N'11' AND T.[TYPE]!=N'30' ", para.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
yield return(reader.GetString(0));
}
}
}
public IEnumerable<string> GetReceiptKeys(AdvancedShipNoticeProviderParameters para) {
using (SqlConnection conn = new SqlConnection(para.connectionstring))
{
conn.Open();
string sqlcmd = string.Format("SELECT T.RECEIPTKEY FROM [{0}].[RECEIPT] T WHERE (T.B2BFLAG=0 OR T.B2BFLAG IS NULL) AND STATUS=N'11' AND T.[TYPE]!=N'30' ", para.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
yield return reader.GetString(0);
}
}
}
public System.IO.Stream GetStream(object args)
{
AdvancedShipNoticeProviderParameters _args = new AdvancedShipNoticeProviderParameters();
_args = args as AdvancedShipNoticeProviderParameters;
_args.tagnamespace = "http://kaifa.b2b.schemas/AdvancedShipNotice";
IEnumerable<string> keys = GetReceiptKeys(_args);
if (keys.Count() > 0)
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
AdvancedShipNoticeGenerator report = new AdvancedShipNoticeGenerator(keys.ToArray(), _args.configPath, _args.fromRole, _args.tostxRole, _args.toe2openRole, _args.warehous, _args.connectionstring, _args.tagnamespace);
XDocument doc = report.Generator();
doc.WriteTo(xw);
}
ms.Seek(0, SeekOrigin.Begin);
System.Diagnostics.Trace.WriteLine("");
UpdateFlag(_args, keys);
System.Diagnostics.Trace.WriteLine(string.Format("Create AdvancedShipNotice {0}", string.Join(",", keys.Select(t => "" + t + "").ToArray())), "AdvancedShipNoticeProvider");
return ms;
}
else
{
System.Diagnostics.Trace.WriteLine(" Null ", "AdvancedShipNoticeProvider");
MailClient.SendNoHubReceiptNotificationMail(_args.toAddresses);
return null;
}
}
public System.IO.Stream GetStream(object args)
{
AdvancedShipNoticeProviderParameters _args = new AdvancedShipNoticeProviderParameters();
_args = args as AdvancedShipNoticeProviderParameters;
_args.tagnamespace = "http://kaifa.b2b.schemas/AdvancedShipNotice";
IEnumerable <string> keys = GetReceiptKeys(_args);
if (keys.Count() > 0)
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
AdvancedShipNoticeGenerator report = new AdvancedShipNoticeGenerator(keys.ToArray(), _args.configPath, _args.fromRole, _args.tostxRole, _args.toe2openRole, _args.warehous, _args.connectionstring, _args.tagnamespace);
XDocument doc = report.Generator();
doc.WriteTo(xw);
}
ms.Seek(0, SeekOrigin.Begin);
System.Diagnostics.Trace.WriteLine("");
UpdateFlag(_args, keys);
System.Diagnostics.Trace.WriteLine(string.Format("Create AdvancedShipNotice {0}", string.Join(",", keys.Select(t => "" + t + "").ToArray())), "AdvancedShipNoticeProvider");
return(ms);
}
else
{
System.Diagnostics.Trace.WriteLine(" Null ", "AdvancedShipNoticeProvider");
MailClient.SendNoHubReceiptNotificationMail(_args.toAddresses);
return(null);
}
}