public System.IO.Stream GetStream(object args)
{
TDN940ProviderParameters _args = new TDN940ProviderParameters();
_args = args as TDN940ProviderParameters;
_args.tagnamespace = "http://Kaifa.B2B.Schemas.OrderTDN940";
string orderkey = GetOrderKey(_args);
if (!string.IsNullOrEmpty(orderkey))
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
TDN940Generator tdn = new TDN940Generator(orderkey, _args.warehous, _args.connectionstring, _args.tagnamespace);
XDocument doc = tdn.Generator();
doc.WriteTo(xw);
}
ms.Seek(0, SeekOrigin.Begin);
//System.Diagnostics.Trace.WriteLine("");
UpdateFlag(_args, orderkey);
System.Diagnostics.Trace.WriteLine(string.Format("Create TND {0}", orderkey), "TDN940Provider");
return(ms);
}
else
{
return(null);
}
}
private void UpdateFlag(TDN940ProviderParameters _args, string orderkey)
{
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
//string whereexpression = " WHERE RECEIPTKEY IN (" + string.Join(",", receiptKeys.Select(t => "'" + t + "'").ToArray()) + ")";
string sqlcmd = string.Format("UPDATE [{0}].[ORDERS] SET B2BFLAG3 = 1 where ORDERKEY = N'{1}'", _args.warehous, orderkey);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
cmd.ExecuteNonQuery();
}
}
private string GetOrderKey(TDN940ProviderParameters _args)
{
try
{
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
string sqlcmd = string.Format(@"SELECT TOP 1 T.ORDERKEY FROM [{0}].[ORDERS] T WHERE (T.B2BFLAG3 = 0) AND ( STATUS=N'88'
OR ( T.STATUS=N'92' AND NOT EXISTS (SELECT 1 FROM [{0}].[ORDERDETAIL] T2 WHERE T2.STATUS<'88' AND T.ORDERKEY=T2.ORDERKEY ) ))
AND EXISTS (SELECT ORDERKEY FROM [{0}].[CM_TDN_940] T1 WHERE T.ORDERKEY = T1.ORDERKEY )
", _args.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
object result = cmd.ExecuteScalar();
conn.Close();
return(result == null ? string.Empty : result.ToString());
}
}
catch {
return(string.Empty);
}
}
private string GetOrderKey(TDN940ProviderParameters _args)
{
try
{
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
string sqlcmd = string.Format(@"SELECT TOP 1 T.ORDERKEY FROM [{0}].[ORDERS] T WHERE (T.B2BFLAG3 = 0) AND ( STATUS=N'88'
OR ( T.STATUS=N'92' AND NOT EXISTS (SELECT 1 FROM [{0}].[ORDERDETAIL] T2 WHERE T2.STATUS<'88' AND T.ORDERKEY=T2.ORDERKEY ) ))
AND EXISTS (SELECT ORDERKEY FROM [{0}].[CM_TDN_940] T1 WHERE T.ORDERKEY = T1.ORDERKEY )
", _args.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
object result = cmd.ExecuteScalar();
conn.Close();
return (result == null ? string.Empty : result.ToString());
}
}
catch {
return string.Empty;
}
}
public System.IO.Stream GetStream(object args)
{
TDN940ProviderParameters _args = new TDN940ProviderParameters();
_args = args as TDN940ProviderParameters;
_args.tagnamespace = "http://Kaifa.B2B.Schemas.OrderTDN940";
string orderkey = GetOrderKey(_args);
if (!string.IsNullOrEmpty(orderkey))
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
TDN940Generator tdn = new TDN940Generator(orderkey, _args.warehous, _args.connectionstring, _args.tagnamespace);
XDocument doc = tdn.Generator();
doc.WriteTo(xw);
}
ms.Seek(0, SeekOrigin.Begin);
//System.Diagnostics.Trace.WriteLine("");
UpdateFlag(_args, orderkey);
System.Diagnostics.Trace.WriteLine(string.Format("Create TND {0}", orderkey), "TDN940Provider");
return ms;
}
else
{
return null;
}
}
private void UpdateFlag(TDN940ProviderParameters _args, string orderkey) {
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
//string whereexpression = " WHERE RECEIPTKEY IN (" + string.Join(",", receiptKeys.Select(t => "'" + t + "'").ToArray()) + ")";
string sqlcmd = string.Format("UPDATE [{0}].[ORDERS] SET B2BFLAG3 = 1 where ORDERKEY = N'{1}'", _args.warehous, orderkey);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
cmd.ExecuteNonQuery();
}
}
