public override global::System.Data.DataSet Clone()
{
OutsoleWHAccumulatingDataSet cln = ((OutsoleWHAccumulatingDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
OutsoleWHAccumulatingDataSet ds = new OutsoleWHAccumulatingDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
OutsoleWHAccumulatingDataSet ds = new OutsoleWHAccumulatingDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "OutsoleWHAccumulatingTableDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void bwPreview_DoWork(object sender, DoWorkEventArgs e)
{
var productNoAvailableList = orderList.Select(s => s.ProductNo).ToList();
outsoleMaterialDetailList = OutsoleMaterialDetailController.SelectAll().Where(w => productNoAvailableList.Contains(w.ProductNo)).ToList();
outsoleMaterialDetailFromToList = outsoleMaterialDetailList.Where(w => dateFrom.Date <= w.UpdatedTime.Date && w.UpdatedTime.Date <= dateTo.Date).ToList();
DataTable dt = new OutsoleWHAccumulatingDataSet().Tables["OutsoleWHAccumulatingTable"];
List <OutsoleWHAccumulatingModel> outsoleWHAccumulatingList = new List <OutsoleWHAccumulatingModel>();
var productNoPerSupplierList = outsoleMaterialDetailFromToList.Select(s => new { ProductNo = s.ProductNo, OutsoleSupplierId = s.OutsoleSupplierId }).Distinct().ToList();
foreach (var poPerSupp in productNoPerSupplierList)
{
var order = orderList.Where(w => w.ProductNo == poPerSupp.ProductNo).FirstOrDefault();
if (order == null)
{
continue;
}
string supplierName = supplierList.Where(w => w.OutsoleSupplierId == poPerSupp.OutsoleSupplierId).FirstOrDefault().Name;
if (outsoleMaterialDetailFromToList.Where(w => w.OutsoleSupplierId == poPerSupp.OutsoleSupplierId && w.ProductNo == poPerSupp.ProductNo).Select(s => s.Reject).Sum() > 0)
{
OutsoleWHAccumulatingModel outsoleWHAccumulating = new OutsoleWHAccumulatingModel()
{
OutsoleCode = order.OutsoleCode,
SupplierName = supplierName,
SupplierId = poPerSupp.OutsoleSupplierId,
ProductNo = poPerSupp.ProductNo,
ArticleNo = order.ArticleNo
};
outsoleWHAccumulatingList.Add(outsoleWHAccumulating);
}
}
outsoleWHAccumulatingList = outsoleWHAccumulatingList.OrderBy(o => o.OutsoleCode)
.ThenBy(t => t.SupplierName)
.ThenBy(t => t.ProductNo)
.ThenBy(t => t.ArticleNo)
.ToList();
foreach (var outsoleWHAccumulating in outsoleWHAccumulatingList)
{
var sizeRunList = SizeRunController.Select(outsoleWHAccumulating.ProductNo).ToList();
if (outsoleMaterialDetailFromToList.Where(w => w.ProductNo == outsoleWHAccumulating.ProductNo).Select(s => s.Quantity).Sum() < sizeRunList.Select(s => s.Quantity).Sum() ||
outsoleMaterialDetailFromToList.Where(w => w.ProductNo == outsoleWHAccumulating.ProductNo).Select(s => s.Reject).Sum() <= 0)
{
continue;
}
int indexColumn = 0;
var regex = new Regex(@"[A-Z]|[a-z]");
foreach (var sizeRun in sizeRunList)
{
var outsoleMaterialDetail = outsoleMaterialDetailFromToList.Where(w => w.ProductNo == outsoleWHAccumulating.ProductNo &&
w.OutsoleSupplierId == outsoleWHAccumulating.SupplierId &&
w.SizeNo == sizeRun.SizeNo).FirstOrDefault();
if (outsoleMaterialDetail == null)
{
continue;
}
DataRow dr = dt.NewRow();
dr["OutsoleCode"] = outsoleWHAccumulating.OutsoleCode;
dr["SupplierName"] = outsoleWHAccumulating.SupplierName;
dr["ProductNo"] = outsoleWHAccumulating.ProductNo;
dr["ArticleNo"] = outsoleWHAccumulating.ArticleNo;
dr["SizeNo"] = regex.IsMatch(sizeRun.SizeNo) ? regex.Replace(sizeRun.SizeNo, "") : sizeRun.SizeNo;
if (outsoleMaterialDetail.Reject > 0)
{
dr["QtyReject"] = outsoleMaterialDetail.Reject;
}
dt.Rows.Add(dr);
indexColumn++;
}
}
e.Result = dt;
}
