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(); ScannedProductsDataSet ds = new ScannedProductsDataSet(); 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 = "ScannedBarcodesDataTable"; 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; }
//public ViewDocsForm(ProductsDataSet.ProductsTblRow productRow):this() //{ // this.panel2.SuspendLayout(); // this.SuspendLayout(); // _productRow = productRow; // StringBuilder sb = new StringBuilder(); // sb.AppendFormat(System.Globalization.CultureInfo.CurrentCulture, // "Код: {0} \nШтрихкод: {1} \nНазвание: {2}", // _productRow.NavCode, // _productRow.Barcode, // _productRow.ProductName); // this.label.Text = sb.ToString(); // Label l = new Label(); // l.Size = new System.Drawing.Size(231, 90); // l.Name = string.Format("label{0}", 0); // l.Left = 0; // l.Top = 0; // l.Text = "По данному товару \nнет никаких документов, \nнажмите желтую кнопку \nеще раз для выхода"; // l.BackColor = System.Drawing.Color.PaleGreen; // this.panel2.Controls.Add(l); // this.panel1.ResumeLayout(false); // this.ResumeLayout(); //} public ViewDocsForm(ProductsDataSet.ProductsTblRow productRow, ProductsDataSet.DocsTblRow[] docsRows, ScannedProductsDataSet scannedProducts):this() { this.panel2.SuspendLayout(); this.SuspendLayout(); _productRow = productRow; _scannedProducts = scannedProducts; _docsRows = docsRows; //this.listBox1.KeyDown += new KeyEventHandler(listBox1_KeyDown); this.Load += new EventHandler(ViewDocsForm_Load); int docCounter = 0; //this.Paint += new PaintEventHandler(ViewDocsForm_Paint); if (_productRow != null) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(System.Globalization.CultureInfo.CurrentCulture, "Код: {0} \nШтрихкод: {1} \nНазвание: {2}", _productRow.NavCode, _productRow.Barcode, _productRow.ProductName); this.label.Text = sb.ToString(); if (_docsRows != null && _docsRows.Length > 0) { foreach (ProductsDataSet.DocsTblRow doc in _docsRows) { ScannedProductsDataSet.ScannedBarcodesRow srow = _scannedProducts .ScannedBarcodes .FindByBarcodeDocTypeDocId(_productRow.Barcode, doc.DocType, doc.DocId); DocumentClass d = new DocumentClass(); d.DocDate = doc.DocumentDate; d.DocId = doc.DocId; d.DocType = doc.DocType; d.Text1 = doc.Text1; d.Text2 = doc.Text2; d.Text3 = doc.Text3; d.PlanQuantity = doc.Quantity; if (srow != null && srow["FactQuantity"] != System.DBNull.Value) d.FactQuantity = srow.FactQuantity; else d.FactQuantity = 0; Label l = new Label(); l.Size = new System.Drawing.Size(231, 60); l.Name = string.Format("label{0}", documents.Count); l.Left = 0; l.Top = documents.Count * 60; l.Text = d.ToString(); l.BackColor = System.Drawing.Color.PaleGreen; l.TextAlign = ContentAlignment.TopCenter; documents.Add(d); this.panel2.Controls.Add(l); selectedItem = 0; docCounter++; } } else { Label l = new Label(); l.Size = new System.Drawing.Size(231, 60); l.Name = string.Format("label{0}", 0); l.Left = 0; l.Top = 0; l.Text = "По данному товару \nнет никаких документов"; l.BackColor = System.Drawing.Color.PaleGreen; l.TextAlign = ContentAlignment.TopCenter; this.panel2.Controls.Add(l); docCounter++; } Label l1 = new Label(); l1.Size = new System.Drawing.Size(231, 30); l1.Name = string.Format("label{0}", docCounter + 1); l1.Left = 0; l1.Top = (docCounter * 60); l1.Text = "Нажмите желтую кнопку или Clr-Fn\nеще раз для выхода"; l1.BackColor = System.Drawing.Color.PaleGreen; l1.TextAlign = ContentAlignment.TopCenter; this.panel2.Controls.Add(l1); } this.panel1.ResumeLayout(false); this.ResumeLayout(); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ScannedProductsDataSet ds = new ScannedProductsDataSet(); 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; }
void Action_OnActionCompleted(ProductsDataSet.DocsTblRow docsRow, ScannedProductsDataSet.ScannedBarcodesRow scannedRow) { if (this.InvokeRequired) { ActionsClass.ActionCompleted del = new ActionsClass.ActionCompleted(Action_OnActionCompleted); this.Invoke(del, docsRow, scannedRow); } else { this.label18.Text = ""; currentDocRow = docsRow; this.actionLabel.Text = TSDUtils.ActionCodeDescription.ActionDescription[docsRow.DocType]; label20.Text = (scannedRow["PlanQuanity"] == System.DBNull.Value || scannedRow["PlanQuanity"] == null) ? string.Empty : scannedRow.PlanQuanity.ToString(); label21.Text = (scannedRow["FactQuantity"] == System.DBNull.Value || scannedRow["FactQuantity"] == null) ? string.Empty : scannedRow.FactQuantity.ToString(); if (docsRow.DocType == (byte)TSDUtils.ActionCode.BoxWProducts) { //label21.Text = (scannedRow["FactQuantity"] == System.DBNull.Value || // scannedRow["FactQuantity"] == null) ? string.Empty : scannedRow.FactQuantity.ToString(); ScannedProductsDataSet.ScannedBarcodesRow[] rowsS = ActionsClass.Action.FindByDocIdAndDocType(scannedRow.DocId, scannedRow.DocType); int fQty = 0; for (int i = 0; i < rowsS.Length; i++) { if (rowsS[i].Barcode == currentProductRow.Barcode) fQty += rowsS[i].FactQuantity; } label21.Text = fQty.ToString(); if (fQty == scannedRow.PlanQuanity) { ProductsDataSet.DocsTblRow[] docsRows = ActionsClass.Action.GetDataByDocIdAndType(scannedRow.DocId, scannedRow.DocType); int pQuantity = 0; int fQuantity = 0; for (int i = 0; i < docsRows.Length; i++) pQuantity += docsRows[i].Quantity; for (int i = 0; i < rowsS.Length; i++) fQuantity += rowsS[i].FactQuantity; if (pQuantity == fQuantity) { //907218|3001011908672|7|1|8|2011-09-03|7|7|7|907218|002355438|03.09.2011 ProductsDataSet.DocsTblRow[] docsNaklRows = ActionsClass.Action.GetDataByDocIdAndType(scannedRow.DocId, (byte)TSDUtils.ActionCode.IncomeBox); //using (DialogForm dlgfrm = // new DialogForm( DialogResult dr = DialogFrm.ShowMessage( "Короб по накладной" , docsNaklRows[0].Text2 , "принят полностью!" , "Прием товара/nПо нажатию ЭНТЕР ВЫЙТИ в меню");//) ActionsClass.Action.PlaySound(250); //{ if (dr == DialogResult.Yes) { //inventRow.NavCode = row.NavCode; //ActionsClass.Action.InvokeAction(TSDUtils.ActionCode.BoxWProducts, // row, // inventRow // ); } this.navCodeTB.Text = ""; //} } } } this.Refresh(); } }
void WriteDbTxt(ScannedProductsDataSet.ScannedBarcodesRow row) { //WriteDbTxt(row, row.FactQuantity); }
void WriteDbTxt(ScannedProductsDataSet.ScannedBarcodesRow row, int quantity) { if (row.RowState == System.Data.DataRowState.Detached || row.RowState == System.Data.DataRowState.Deleted || row["FactQuantity"] == System.DBNull.Value || //row.FactQuantity <= 0 || //quantity <=0 || DoScanEvents == false) return; /*using (System.IO.StreamWriter wr = new System.IO.StreamWriter( System.IO.Path.Combine(Program.Default.DatabaseStoragePath, "scannedbarcodes.txt"), true)) {*/ //if (row["FactQuantity"] != System.DBNull.Value // && row.FactQuantity > 0) { string s = string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}", row.Barcode, row.DocId, row.DocType, quantity, (row["ScannedDate"] == System.DBNull.Value) ? DateTime.Today.AddHours(_timeShift).ToString("dd.MM.yyyy") : row.ScannedDate.AddHours(_timeShift).ToString("dd.MM.yyyy"), (row["TerminalId"] == System.DBNull.Value) ? string.Empty : row.TerminalId.ToString(), row.Priority, row.PlanQuanity ); byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, "\r\n")); //byte[] buff = new byte[] { 0xD, 0xA }; writer.Write(buff, 0, buff.Length); writer.Flush(); //byte[] buff = System.Text.Encoding.UTF8.GetBytes(s); //writer.Write(buff, 0, buff.Length); //writer.WriteLine(System. // s); } //} if (row.DocType == (byte)TSDUtils.ActionCode.Reprice) { using (System.IO.StreamWriter wr = new System.IO.StreamWriter( System.IO.Path.Combine(Program.Default.DatabaseStoragePath, "register.txt"), true)) { string s = string.Format("{0},{1,11:D}, {2,7:D}", row.Barcode, 1, quantity); wr.WriteLine(s); } } }
public void ChangeQtyPosition( ProductsDataSet.DocsTblRow docsRow, ScannedProductsDataSet.ScannedBarcodesRow scannedRow, int diffQty) { //ScannedProductsDataSet.ScannedBarcodesRow[] r = //_scannedProducts.ScannedBarcodes.FindByBarcodeAndDocType(datarow.Barcode, docsRow.DocType); //if (scannedRow != null && //existing row // scannedRow.Priority == 0 //not closed // && scannedRow["FactQuantity"] != System.DBNull.Value // && scannedRow.FactQuantity > 0 //scanned already // && Program.СurrentInvId != string.Empty // ) //{ //DoScanEvents = false; scannedRow.FactQuantity = scannedRow.FactQuantity + diffQty; if (OnActionCompleted != null && docsRow != null) OnActionCompleted(docsRow, scannedRow); return; #region old action if (diffQty < 0) { //scannedRow.FactQuantity = 1; for (int i = diffQty; i < 0; i++) { scannedRow.FactQuantity -= 1; //using (System.IO.StreamWriter wr = //new System.IO.StreamWriter( // System.IO.Path.Combine(Program.Default.DatabaseStoragePath, "scannedbarcodes.txt"), true)) { //if (row["FactQuantity"] != System.DBNull.Value // && row.FactQuantity > 0) //{ string s = string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}", scannedRow.Barcode, scannedRow.DocId, scannedRow.DocType, -1, (scannedRow["ScannedDate"] == System.DBNull.Value) ? DateTime.Today.AddHours(_timeShift).ToString("dd.MM.yyyy") : scannedRow.ScannedDate.AddHours(_timeShift).ToString("dd.MM.yyyy"), (scannedRow["TerminalId"] == System.DBNull.Value) ? string.Empty : scannedRow.TerminalId.ToString(), scannedRow.Priority, scannedRow.PlanQuanity ); //writer.WriteLine(s); //byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, '\n')); byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, "\r\n")); writer.Write(buff, 0, buff.Length); writer.Flush(); } } } else { if (diffQty > 0) { for (int i = 0; i < diffQty; i++) { scannedRow.FactQuantity += 1; //using (System.IO.StreamWriter wr = // new System.IO.StreamWriter( // System.IO.Path.Combine(Program.Default.DatabaseStoragePath, "scannedbarcodes.txt"), true)) { //if (row["FactQuantity"] != System.DBNull.Value // && row.FactQuantity > 0) //{ string s = string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}", scannedRow.Barcode, scannedRow.DocId, scannedRow.DocType, 1, (scannedRow["ScannedDate"] == System.DBNull.Value) ? DateTime.Today.AddHours(_timeShift).ToString("dd.MM.yyyy") : scannedRow.ScannedDate.AddHours(_timeShift).ToString("dd.MM.yyyy"), (scannedRow["TerminalId"] == System.DBNull.Value) ? string.Empty : scannedRow.TerminalId.ToString(), scannedRow.Priority, scannedRow.PlanQuanity ); //writer.WriteLine(s); byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, "\r\n")); //byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, '\n')); writer.Write(buff, 0, buff.Length); writer.Flush(); } } } } #endregion //DoScanEvents = true; //if (OnActionCompleted != null && docsRow != null) // OnActionCompleted(docsRow, scannedRow); //} //} }
/// <summary> /// Добавление записи о сканированном коробе, при режиме проверки коробов свой - чужой ///ScannedProductsDataSet.ScannedBarcodesRow ///long.Parse(barcode), ///(byte)TSDUtils.ActionCode.IncomeBox, ///row.DocId, ///row.Quantity, ///row.Priority); ///scannedRow.FactQuantity += 1; /// </summary> /// <param name="row"> ScannedProductsDataSet.ScannedBarcodesRow</param> public void IncomeBoxAction(ScannedProductsDataSet.ScannedBarcodesRow scannedRow) { // using (System.IO.StreamWriter wr = //new System.IO.StreamWriter( // System.IO.Path.Combine(Program.Default.DatabaseStoragePath, "scannedbarcodes.txt"), true)) { string s = string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}", scannedRow.Barcode, scannedRow.DocId, scannedRow.DocType, 1, DateTime.Today.ToString("dd.MM.yyyy"), Program.Default.TerminalID, 0 ); byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s, "\r\n")); //byte[] buff = System.Text.Encoding.UTF8.GetBytes(string.Concat(s,'\n')); //byte[] buff = new byte[] { 0xD, 0xA }; writer.Write(buff, 0, buff.Length); writer.Flush(); //writer.WriteLine(s); } }