public System.IO.Stream GetStream(object args)
{
InventoryReportProviderParameters _args = new InventoryReportProviderParameters();
_args = args as InventoryReportProviderParameters;
if (string.IsNullOrEmpty(_args.connectionstring) || string.IsNullOrEmpty(_args.warehous))
{
throw new NullReferenceException();
}
if (getCount(_args) > 0)
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
_args.tagnamespace = "http://kaifa.b2b.schemas/InventoryReport";
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
InventoryReportGenerator report = new InventoryReportGenerator(false, _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("Create Inventory Report ", "InventoryReportProvider");
return(ms);
}
else
{
return(null);
}
}
public System.IO.Stream GetStream(object args)
{
InventoryReportProviderParameters _args = new InventoryReportProviderParameters();
_args = args as InventoryReportProviderParameters;
if (string.IsNullOrEmpty(_args.connectionstring) || string.IsNullOrEmpty(_args.warehous))
{
throw new NullReferenceException();
}
if (getCount(_args) > 0)
{
MemoryStream ms = new MemoryStream();
XmlWriterSettings xws = new XmlWriterSettings();
xws.OmitXmlDeclaration = true;
xws.Indent = true;
_args.tagnamespace = "http://kaifa.b2b.schemas/InventoryReport";
using (XmlWriter xw = XmlWriter.Create(ms, xws))
{
InventoryReportGenerator report = new InventoryReportGenerator(false, _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("Create Inventory Report ", "InventoryReportProvider");
return ms;
}
else
{
return null;
}
}
private int getCount(InventoryReportProviderParameters _args)
{
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
string sqlcmd = string.Format(@"SELECT COUNT(*) FROM [{0}].[INVENTORYREPORT_SGHUB]
", _args.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
object result = cmd.ExecuteScalar();
return(result == null ? 0 : Convert.ToInt32(result.ToString()));
}
}
private int getCount(InventoryReportProviderParameters _args) {
using (SqlConnection conn = new SqlConnection(_args.connectionstring))
{
conn.Open();
string sqlcmd = string.Format(@"SELECT COUNT(*) FROM [{0}].[INVENTORYREPORT_SGHUB]
", _args.warehous);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlcmd;
object result = cmd.ExecuteScalar();
return (result == null ? 0 : Convert.ToInt32(result.ToString()));
}
}
