/*MDataset, документы на складе, из открытого периода, новые, X дней*/ public bool FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source, DateTime begin) { MDataSet.ReceiptMasterDataTable _tmpMaster = new MDataSet.ReceiptMasterDataTable(); MDataSet.ReceiptDetailDataTable _tmpDetail = new MDataSet.ReceiptDetailDataTable(); try { this.receiptMasterTableAdapter.FillByPeriod(_tmpMaster, begin); this.receiptDetailTableAdapter.FillByPeriod(_tmpDetail, begin); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else { caughtGlobalError(sqlerr); } Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return(false); } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return(false); } finally { this.mDataSet.ReceiptMaster.Merge(_tmpMaster); this.mDataSet.ReceiptDetail.Merge(_tmpDetail); } return(true); }
/*FillNew + Merge + FillDetailsById*/ public bool RefreshData(MDataSet.ReceiptMasterRow sourceRow) { MDataSet.ReceiptMasterDataTable _ReceiptMasterDataTable = new MDataSet.ReceiptMasterDataTable(); MDataSet.ReceiptDetailDataTable _ReceiptDetailDataTable = new MDataSet.ReceiptDetailDataTable(); MDataSet.ProductDataTable _productDataTable = new MDataSet.ProductDataTable(); try { this.receiptMasterTableAdapter.FillNew(_ReceiptMasterDataTable); this.receiptDetailTableAdapter.FillByReceiptMasterRef(_ReceiptDetailDataTable, sourceRow.ID); foreach (MDataSet.ReceiptDetailRow detrow in _ReceiptDetailDataTable) { if (detrow.ProductRow == null) { this.productTableAdapter.FillById(_productDataTable, detrow.ProductRef); } this.mDataSet.Product.Merge(_productDataTable); } } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.ReceiptMasterRow sourceRow) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return(false); } finally { this.mDataSet.ReceiptMaster.Merge(_ReceiptMasterDataTable); this.mDataSet.ReceiptDetail.Merge(_ReceiptDetailDataTable); this.mDataSet.ReceiptMaster.AcceptChanges(); this.mDataSet.ReceiptDetail.AcceptChanges(); } return(true); }
public virtual MDataSet.ReceiptDetailDataTable GetDataByReceiptMasterRef(System.Nullable<int> ReceiptMasterRef) { this.Adapter.SelectCommand = this.CommandCollection[2]; if ((ReceiptMasterRef.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ReceiptMasterRef.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } MDataSet.ReceiptDetailDataTable dataTable = new MDataSet.ReceiptDetailDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.ReceiptDetailDataTable GetDataByPeriod(System.Nullable<System.DateTime> begin) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((begin.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(begin.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } MDataSet.ReceiptDetailDataTable dataTable = new MDataSet.ReceiptDetailDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.ReceiptDetailDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; MDataSet.ReceiptDetailDataTable dataTable = new MDataSet.ReceiptDetailDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
/*MDataset, документы на складе, из открытого периода, новые, X дней*/ public bool FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source, DateTime begin) { MDataSet.ReceiptMasterDataTable _tmpMaster = new MDataSet.ReceiptMasterDataTable(); MDataSet.ReceiptDetailDataTable _tmpDetail = new MDataSet.ReceiptDetailDataTable(); MDataSet.ProductDataTable _prod = new MDataSet.ProductDataTable(); try { this.receiptMasterTableAdapter.FillByPeriod(_tmpMaster, begin); /* foreach(DataRow masRow in _tmpMaster ) * { * * MDataSet.ManufacturerDataTable _man = new MDataSet.ManufacturerDataTable(); * * * this.manufacturerTableAdapter.FillByReceiptMasterRef(_man, (masRow as MDataSet.ReceiptMasterRow).ID); * * * * this.productTableAdapter.FillByReceiptId(_prod, (masRow as MDataSet.ReceiptMasterRow).ID); * * // this.manufacturerTableAdapter.FillByReceiptMasterRef(_man , (masRow as MDataSet.ReceiptMasterRow).ID); * * * this.mDataSet.Product.Merge(_prod); * this.mDataSet.Manufacturer.Merge(_man); * * } * * * this.receiptDetailTableAdapter.FillByPeriod(_tmpDetail, begin); * this.mDataSet.ReceiptDetail.Merge(_tmpDetail);*/ this.mDataSet.ReceiptMaster.Merge(_tmpMaster); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else { caughtGlobalError(sqlerr); } Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return(false); } catch (Exception err) { DataRow[] dr = this.mDataSet.Manufacturer.GetErrors(); DataColumn[] dc = dr[0].GetColumnsInError(); MessageBox.Show(err.Message); Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message + " " + err.Source); return(false); } finally { } return(true); }