void RiempiGrid() { string filterstock = QHS.IsNull("idinvkind"); string sqlCmd = " SELECT * " + " FROM ddt_inview " + " WHERE " + filter + " AND EXISTS (SELECT * FROM stock WHERE " + " ddt_inview.idddt_in = stock.idddt_in AND " + filterstock + " ) " + " ORDER BY ddt_inview.idddt_in asc "; DataTable ddt_in = Meta.Conn.SQLRunner(sqlCmd); if (ddt_in.Rows.Count != 0) { ddt_in.PrimaryKey = new DataColumn[] { ddt_in.Columns["idddt_in"] }; //Ora ha messo in ddt_in tutto ciò che da DB risulta 'da fatturare'. if (ddt_in.Select().Length > 0) { MetaData MAP; MAP = Meta.Dispatcher.Get("ddt_inview"); MAP.DescribeColumns(ddt_in, "default"); DataSet D = new DataSet(); D.Tables.Add(ddt_in); HelpForm.SetDataGrid(gridDettagli, ddt_in); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, ddt_in); formatgrids format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(ddt_in, true); SelezionaTutto(); } } }
public void MetaData_AfterLink() { meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = meta.Conn.GetQueryHelper(); HelpForm.SetAllowMultiSelection(DS.proceedsview, true); GetData.SetSorting(DS.proceedsview, "npro"); MetaData.SetDefault(DS.banktransaction, "kind", "C"); MetaData.SetDefault(DS.banktransaction, "yban", meta.GetSys("esercizio")); }
public void MetaData_AfterLink() { meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = meta.Conn.GetQueryHelper(); esercizio = (int)meta.GetSys("esercizio"); HelpForm.SetAllowMultiSelection(DS.expenseview, true); GetData.SetSorting(DS.expenseview, "ymov, nmov"); MetaData.SetDefault(DS.banktransaction, "kind", "D"); MetaData.SetDefault(DS.banktransaction, "yban", esercizio); }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); GetData.SetSorting(DS.payrollview, "idcon, fiscalyear, npayroll"); GetData.SetStaticFilter(DS.payrollview, QHS.AppAnd(QHS.CmpEq("flagcomputed", 'N'), QHS.CmpEq("fiscalyear", Meta.GetSys("esercizio")), QHS.CmpLe("start", Meta.GetSys("datacontabile")), QHS.CmpEq("year(stop)", Meta.GetSys("esercizio")), QHS.CmpEq("flagbalance", 'N'))); HelpForm.SetAllowMultiSelection(DS.payrollview, true); }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); esercizio = CfgFn.GetNoNullInt32(Meta.GetSys("esercizio")); string filterEsercizio = QHS.CmpEq("ayear", esercizio); GetData.CacheTable(DS.config, filterEsercizio, null, false); GetData.CacheTable(DS.accountkind); HelpForm.SetAllowMultiSelection(DS.proceeds, true); btnIstitutoCassiere.Enabled = false; cmbCodiceIstituto.Enabled = false; HelpForm.SetDenyNull(DS.proceedstransmission.Columns["transmissionkind"], true); EPM = new EP_Manager(Meta, null, null, null, null, null, null, null, null, "proceedstransmission"); }
void SetDataGrid(DataGrid G, string table, string listtype) { MetaData M = Dispatcher.Get(table); if (listtype == null) { listtype = M.DefaultListType; } if (listtype == null) { listtype = "default"; } M.DescribeColumns(DS.Tables[table], listtype); HelpForm.SetAllowMultiSelection(DS.Tables[table], true); HelpForm.SetDataGrid(G, DS.Tables[table]); }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); esercizio = Convert.ToInt32(Meta.GetSys("esercizio")); DataAccess.RUN_SELECT_INTO_TABLE(Meta.Conn, DS.incomephase, null, null, null, true); codicefase = CfgFn.GetNoNullInt32(Meta.GetSys("maxincomephase")); GetData.LockRead(DS.incomeview); GetData.DenyClear(DS.incomeview); GetData.LockRead(DS.proceedspart); FillEntrataView(); QueryCreator.SetTableForPosting(DS.incomeview, "income"); HelpForm.SetAllowMultiSelection(DS.incomeview, true); Meta.CanCancel = false; Meta.CanInsert = false; Meta.CanInsertCopy = false; Meta.CanSave = false; Meta.SearchEnabled = false; }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); esercizio = Convert.ToInt32(Meta.GetSys("esercizio")); codicefase = Convert.ToInt32(Meta.GetSys("incomefinphase")); GetData.LockRead(DS.incomeview); GetData.DenyClear(DS.incomeview); GetData.LockRead(DS.creditpart); FillEntrataView(); QueryCreator.SetTableForPosting(DS.incomeview, "income"); HelpForm.SetAllowMultiSelection(DS.incomeview, true); Meta.CanCancel = false; Meta.CanInsert = false; Meta.CanInsertCopy = false; Meta.CanSave = false; Meta.SearchEnabled = false; }
public void MetaData_AfterLink() { HelpForm.SetAllowMultiSelection(DS.assetpieceview, true); Meta = MetaData.GetMetaData(this); Conn = Meta.Conn; QHS = Conn.GetQueryHelper(); QHC = new CQueryHelper(); string filter = QHS.CmpEq("ayear", Conn.GetSys("esercizio")); GetData.CacheTable(DS.config, filter, null, false); GetData.CacheTable(DS.incomephase, null, "nphase", true); Mentrataview = MetaData.GetMetaData(this, "incomeview"); //Tooltip Tip.SetToolTip(btnInizia, "Cliccare qui per far partire la generazione automatica"); Tip.SetToolTip(grpIncludi, "Selezionare una delle voci per filtrare la generazione completa"); Tip.SetToolTip(rdoAll, "Selezionare questa voce se si vogliono tutti i tipi di scarico"); Tip.SetToolTip(rdoBene, "Selezionare questa voce se si vuole scaricare solo i cespiti"); Tip.SetToolTip(rdoParte, "Selezionare questa voce se si vuole scaricare solo gli aumenti di valore"); Tip.SetToolTip(btnGeneraTutto, "Cliccare qui per avviare in qualsiasi momento la generazione automatica"); //Tip.SetToolTip(btnAddAll,"Cliccare qui per collegare al buono sia gli scarichi cespiti che gli scarichi parti"); Tip.SetToolTip(btnAddBene, "Cliccare qui per scaricare i cespiti e gli eumenti di valore selezionati"); Tip.SetToolTip(btnSuccessivo, "Cliccare qui per passare al buono successivo"); }
void riempiGrid() { if (!HasDDT) { labDDT.Visible = false; } string filtercurrency = QHS.CmpEq("idcurrency", idcurrency); filtercurrency = QHS.DoPar(QHS.AppOr(filtercurrency, QHS.IsNull("idcurrency"))); string filter = QHS.AppAnd(filterregistry, filterflagmixed); filter = QHS.AppAnd(filter, filtercurrency); filter = QHS.AppAnd(filter, QHS.CmpNe("toinvoice", 'N'), QHS.CmpEq("linktoinvoice", 'S')); filter = QHS.AppAnd(filter, QHS.CmpEq("idmandatestatus", 5)); // stato approvato object currency = Conn.DO_READ_VALUE("currency", filtercurrency, "description"); if (currency != null) { lblValuta.Text = currency.ToString().ToUpper(); } DataTable mandateDetail; if (HasDDT) { mandateDetail = Conn.RUN_SELECT("mandatedetailstockedtoinvoice", "*", "idmankind ASC,yman DESC,nman DESC,rownum ASC, idgroup ASC", filter, null, false); } else { mandateDetail = Conn.RUN_SELECT("mandatedetailnoddttoinvoice", "*", "idmankind ASC,yman DESC,nman DESC,rownum ASC, idgroup ASC", filter, null, false); } Conn.DeleteAllUnselectable(mandateDetail); if (mandateDetail.Rows.Count != 0) { mandateDetail.PrimaryKey = new[] { mandateDetail.Columns["idmankind"], mandateDetail.Columns["yman"], mandateDetail.Columns["nman"], mandateDetail.Columns["rownum"] }; //Ora ha messo in MandateDetail tutto ciò che da DB risulta 'da fatturare'. //Effettua ora una serie di allineamenti sul DataTable per renderlo più coerente con quello // che c'è nel DataSet del form padre. //Per ogni riga del DataSet in stato di INSERT/UPDATE effettua una sottrazione ed eventualmente // un delete su MandateDetail se la riga corrispondente risulta essere esaurita. foreach (DataRow R in InvoiceDetail.Select()) { if (R.RowState != DataRowState.Added) { continue; } if (R["idmankind"] == DBNull.Value) { continue; //Non è una riga collegata a dettagli ordine } string filtermand = QHC.CmpMulti(R, "idmankind", "yman", "nman"); filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("rownum", R["manrownum"])); DataRow [] RM = mandateDetail.Select(filtermand); if ((RM.Length == 0)) { continue; } var detail = RM[0]; decimal oldnumber = 0; decimal newnumber = CfgFn.GetNoNullDecimal(R["number", DataRowVersion.Current]); decimal oldresidual = CfgFn.GetNoNullDecimal(detail["residual"]); decimal newresidual = oldresidual - newnumber + oldnumber; detail["residual"] = newresidual; } foreach (DataRow R in InvoiceDetail.Select()) { if (R.RowState != DataRowState.Modified) { continue; } string filtermand = QHC.CmpMulti(R, "idmankind", "yman", "nman"); filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("rownum", R["manrownum"])); DataRow[] RM = mandateDetail.Select(filtermand); if ((RM.Length == 0)) { continue; } DataRow detail = RM[0]; decimal oldnumber; if (R["idmankind", DataRowVersion.Original] == DBNull.Value) { oldnumber = 0; } else { oldnumber = CfgFn.GetNoNullDecimal(R["number", DataRowVersion.Original]); } decimal newnumber; if (R["idmankind", DataRowVersion.Current] == DBNull.Value) { newnumber = 0; } else { newnumber = CfgFn.GetNoNullDecimal(R["number", DataRowVersion.Current]); } decimal oldresidual = CfgFn.GetNoNullDecimal(detail["residual"]); decimal newresidual = oldresidual - newnumber + oldnumber; detail["residual"] = newresidual; } foreach (DataRow r in InvoiceDetail.Rows) { if (r.RowState != DataRowState.Deleted) { continue; } if (r["idmankind", DataRowVersion.Original] == DBNull.Value) { continue; } string filtermand = QHC.CmpMulti(r, "idmankind", "yman", "nman"); filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("rownum", r["manrownum", DataRowVersion.Original])); DataRow [] RM = mandateDetail.Select(filtermand); if ((RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal oldnumber = CfgFn.GetNoNullDecimal(r["number", DataRowVersion.Original]); decimal newnumber = 0; decimal oldresidual = CfgFn.GetNoNullDecimal(Detail["residual"]); decimal newresidual = oldresidual - newnumber + oldnumber; Detail["residual"] = newresidual; } foreach (DataRow R in mandateDetail.Select()) { decimal residual = CfgFn.GetNoNullDecimal(R["residual"]); if (residual == 0) { R.Delete(); } } mandateDetail.AcceptChanges(); if (mandateDetail.Select().Length > 0) { MetaData MAP; if (HasDDT) { MAP = Meta.Dispatcher.Get("mandatedetailstockedtoinvoice"); } else { MAP = Meta.Dispatcher.Get("mandatedetailnoddttoinvoice"); } MAP.DescribeColumns(mandateDetail, "default"); DataSet D = new DataSet(); D.Tables.Add(mandateDetail); HelpForm.SetDataGrid(gridDettagli, mandateDetail); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, mandateDetail); formatgrids format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(mandateDetail, true); SelezionaTutto(); } } }
void RiempiGrid() { DataTable MandateDetail = Conn.RUN_SELECT("mandatedetail_tostock", "*", "idmankind ASC,yman DESC,nman DESC, idgroup ASC", filtersql, null, false); Conn.DeleteAllUnselectable(MandateDetail); if (MandateDetail.Rows.Count != 0) { MandateDetail.PrimaryKey = new DataColumn[] { MandateDetail.Columns["idmankind"], MandateDetail.Columns["yman"], MandateDetail.Columns["nman"], MandateDetail.Columns["idgroup"] }; //Ora ha messo in MandateDetail tutto ciò che da DB risulta 'da inserire nella bolla'. //Effettua ora una serie di allineamenti sul DataTable per renderlo più coerente con quello // che c'è nel DataSet del form padre. //Per ogni riga del DataSet in stato di INSERT/UPDATE effettua una sottrazione ed eventualmente // un delete su MandateDetail se la riga corrispondente risulta essere esaurita. foreach (DataRow rStock in DS.Tables["stock"].Select()) { if (rStock.RowState != DataRowState.Added) { continue; } if (rStock["idmankind"] == DBNull.Value) { continue; //Non è una riga collegata a dettagli ordine } string filtermand = QHC.CmpMulti(rStock, "idmankind", "yman", "nman"); filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("idgroup", rStock["man_idgroup"])); DataRow[] RM = MandateDetail.Select(filtermand); if ((RM == null) || (RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal oldnumber = 0; decimal newnumber = CfgFn.GetNoNullDecimal(rStock["number", DataRowVersion.Current]); decimal oldstocked = CfgFn.GetNoNullDecimal(Detail["stocked"]); decimal newstocked = oldstocked + newnumber - oldnumber; Detail["stocked"] = newstocked; } foreach (DataRow rStock in DS.Tables["stock"].Select()) { if (rStock.RowState != DataRowState.Modified) { continue; } string filtermand = QHC.CmpMulti(rStock, "idmankind", "yman", "nman"); filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("idgroup", rStock["man_idgroup"])); DataRow[] RM = MandateDetail.Select(filtermand); if ((RM == null) || (RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal oldnumber; if (rStock["idmankind", DataRowVersion.Original] == DBNull.Value) { oldnumber = 0; } else { oldnumber = CfgFn.GetNoNullDecimal(rStock["number", DataRowVersion.Original]); } decimal newnumber; if (rStock["idmankind", DataRowVersion.Current] == DBNull.Value) { newnumber = 0; } else { newnumber = CfgFn.GetNoNullDecimal(rStock["number", DataRowVersion.Current]); } decimal oldstocked = CfgFn.GetNoNullDecimal(Detail["stocked"]); decimal newstocked = oldstocked + newnumber - oldnumber; Detail["stocked"] = newstocked; } //foreach (DataRow rStock in DS.Tables["stock"].Rows){ // if (rStock.RowState != DataRowState.Deleted) continue; // if (rStock["idmankind", DataRowVersion.Original] == DBNull.Value) continue; // string filtermand = QHC.CmpMulti(rStock, "idmankind", "yman", "nman"); // filtermand = QHC.AppAnd(filtermand, QHC.CmpEq("idgroup", rStock["man_idgroup", DataRowVersion.Original])); // DataRow[] RM = MandateDetail.Select(filtermand); // if ((RM == null) || (RM.Length == 0)) continue; // DataRow Detail = RM[0]; // decimal oldnumber = CfgFn.GetNoNullDecimal(rStock["number", DataRowVersion.Original]); // decimal newnumber = 0; // decimal oldstocked = CfgFn.GetNoNullDecimal(Detail["stocked"]); // decimal newstocked = oldstocked + newnumber - oldnumber; // Detail["stocked"] = newstocked; //} foreach (DataRow rMandatedetail in MandateDetail.Select()) { decimal stocked = CfgFn.GetNoNullDecimal(rMandatedetail["stocked"]); decimal ordered = CfgFn.GetNoNullDecimal(rMandatedetail["ordered"]); decimal ntostock = ordered - stocked; rMandatedetail["ntostock"] = ntostock; if (ntostock == 0) { rMandatedetail.Delete(); } } MandateDetail.AcceptChanges(); if (MandateDetail.Select().Length > 0) { MetaData MAP = Meta.Dispatcher.Get("mandatedetail_tostock"); MAP.DescribeColumns(MandateDetail, "default"); DataSet D = new DataSet(); D.Tables.Add(MandateDetail); HelpForm.SetDataGrid(gridDettagli, MandateDetail); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, MandateDetail); formatgrids format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(MandateDetail, true); SelezionaTutto(); } } }
bool GetFiltro() { string Filtro = ""; if (txtIDUbicazione.Text != "") { Filtro = QHS.CmpEq("idcurrlocation", txtIDUbicazione.Text); } if (cboResponsabile.SelectedIndex > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpEq("idcurrman", cboResponsabile.SelectedValue)); } if (txt_idbene_da.Text.Trim() != "") { int N1 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_idbene_da.Text, "x.y")); if (N1 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpGe("idasset", N1)); } } if (txt_idbene_a.Text.Trim() != "") { int N2 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_idbene_a.Text, "x.y")); if (N2 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpLe("idasset", N2)); } } if (txt_numcarico_da.Text.Trim() != "") { int N3 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_numcarico_da.Text, "x.y")); if (N3 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpGe("nassetacquire", N3)); } } if (txt_numcarico_a.Text.Trim() != "") { int N4 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_numcarico_a.Text, "x.y")); if (N4 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpLe("nassetacquire", N4)); } } if (txt_numinv_da.Text.Trim() != "") { int N5 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_numinv_da.Text, "x.y")); if (N5 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpGe("ninventory", N5)); } } if (txt_numinv_a.Text.Trim() != "") { int N6 = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txt_numinv_a.Text, "x.y")); if (N6 > 0) { Filtro = QHS.AppAnd(Filtro, QHS.CmpLe("ninventory", N6)); } } if (cmbInventario.SelectedIndex > 0) { Filtro = QHS.AppAnd(Filtro, "(namortization in (SELECT namortization from assetamortization " + " WHERE " + GetInventoryFilter(QHS, cmbInventario.SelectedValue) + //QHS.CmpEq("idinventory", cmbInventario.SelectedValue) + "))"); } if (txtDescrizione.Text.Trim() != "") { string descr = txtDescrizione.Text.Trim(); if (!descr.StartsWith("%")) { descr = "%" + descr; } if (!descr.EndsWith("%")) { descr = descr + "%"; } Filtro = QHS.AppAnd(Filtro, QHS.Like("description", descr + "%")); } if (Filtro == "") { if (MessageBox.Show("Non è stato selezionato alcun filtro. Conferma?", "Conferma", MessageBoxButtons.OKCancel) != DialogResult.OK) { return(false); } } if (!chkIncludiAsset.Checked && chkIncludiAumenti.Checked) { Filtro = QHS.AppAnd(Filtro, QHS.CmpGt("idpiece", 1)); } if (chkIncludiAsset.Checked && !chkIncludiAumenti.Checked) { Filtro = QHS.AppAnd(Filtro, QHS.CmpEq("idpiece", 1)); } Filtro = QHS.AppAnd(Filtro, QHS.IsNull("idassetload"), QHS.IsNull("idassetunload"), QHS.CmpEq("flagunload", 'S'), QHS.CmpGt("amortizationquota", 0) ); AssetAmortization = Conn.RUN_SELECT("assetamortizationunloadview", "*", "idinventory asc,ninventory asc", Filtro, null, false); MetaData MAP = Meta.Dispatcher.Get("assetamortizationunloadview"); MAP.DescribeColumns(AssetAmortization, "default"); DataSet D = new DataSet(); D.Tables.Add(AssetAmortization); gridBeni.DataSource = null; HelpForm.SetDataGrid(gridBeni, AssetAmortization); HelpForm.SetAllowMultiSelection(AssetAmortization, true); SelezionaTuttiICespiti(); return(true); }
void riempiGrid() { var filtercurrency = QHS.CmpEq("idcurrency", _idcurrency); filtercurrency = QHS.DoPar(QHS.AppOr(filtercurrency, QHS.IsNull("idcurrency"))); var filter = QHS.AppAnd(filtercurrency, filterregistry); filter = QHS.AppAnd(filter, QHS.CmpNe("toinvoice", "N"), QHS.CmpEq("linktoinvoice", "S")); var currency = Conn.DO_READ_VALUE("currency", filtercurrency, "description"); if (currency != null) { lblValuta.Text = currency.ToString().ToUpper(); } var estimateDetail = Conn.RUN_SELECT("estimatedetailtoinvoice", "*", "idestimkind ASC,yestim DESC,nestim DESC,rownum ASC, idgroup ASC", filter, null, false); Conn.DeleteAllUnselectable(estimateDetail); if (estimateDetail.Rows.Count != 0) { estimateDetail.PrimaryKey = new[] { estimateDetail.Columns["idestimkind"], estimateDetail.Columns["yestim"], estimateDetail.Columns["nestim"], estimateDetail.Columns["rownum"] }; //Ora ha messo in EstimateDetail tutto ciò che da DB risulta 'da fatturare'. //Effettua ora una serie di allineamenti sul DataTable per renderlo più coerente con quello //che c'è nel DataSet del form padre. //Per ogni riga del DataSet in stato di INSERT/UPDATE effettua una sottrazione ed eventualmente //un delete su MandateDetail se la riga corrispondente risulta essere esaurita. foreach (var r in InvoiceDetail.Select()) { if (r.RowState != DataRowState.Added) { continue; } if (r["idmankind"] == DBNull.Value) { continue; //Non è una riga collegata a dettagli ordine } var filterestim = QHC.CmpMulti(r, "idestimkind", "yestim", "nestim"); filterestim = QHC.AppAnd(filterestim, QHC.CmpEq("rownum", r["estimrownum"])); var rm = estimateDetail.Select(filterestim); if (rm.Length == 0) { continue; } var detail = rm[0]; decimal oldnumber = 0; decimal newnumber = CfgFn.GetNoNullDecimal(r["number", DataRowVersion.Current]); decimal oldinvoiced = CfgFn.GetNoNullDecimal(detail["invoiced"]); decimal newinvoiced = oldinvoiced + newnumber - oldnumber; detail["invoiced"] = newinvoiced; } foreach (var r in InvoiceDetail.Select()) { if (r.RowState != DataRowState.Modified) { continue; } string filterestim = QHC.CmpMulti(r, "idestimkind", "yestim", "nestim"); filterestim = QHC.AppAnd(filterestim, QHC.CmpEq("rownum", r["estimrownum"])); var rm = estimateDetail.Select(filterestim); if ((rm.Length == 0)) { continue; } DataRow detail = rm[0]; decimal oldnumber; if (r["idestimkind", DataRowVersion.Original] == DBNull.Value) { oldnumber = 0; } else { oldnumber = CfgFn.GetNoNullDecimal(r["number", DataRowVersion.Original]); } decimal newnumber; if (r["idestimkind", DataRowVersion.Current] == DBNull.Value) { newnumber = 0; } else { newnumber = CfgFn.GetNoNullDecimal(r["number", DataRowVersion.Current]); } var oldinvoiced = CfgFn.GetNoNullDecimal(detail["invoiced"]); var newinvoiced = oldinvoiced + newnumber - oldnumber; detail["invoiced"] = newinvoiced; } foreach (DataRow r in InvoiceDetail.Rows) { if (r.RowState != DataRowState.Deleted) { continue; } if (r["idestimkind", DataRowVersion.Original] == DBNull.Value) { continue; } string filterestim = QHC.CmpMulti(r, "idestimkind", "yestim", "nestim"); filterestim = QHC.AppAnd(filterestim, QHC.CmpEq("rownum", r["estimrownum", DataRowVersion.Original])); var rm = estimateDetail.Select(filterestim); if ((rm.Length == 0)) { continue; } var detail = rm[0]; var oldnumber = CfgFn.GetNoNullDecimal(r["number", DataRowVersion.Original]); decimal newnumber = 0; var oldinvoiced = CfgFn.GetNoNullDecimal(detail["invoiced"]); var newinvoiced = oldinvoiced + newnumber - oldnumber; detail["invoiced"] = newinvoiced; } foreach (var r in estimateDetail.Select()) { var invoiced = CfgFn.GetNoNullDecimal(r["invoiced"]); var ordered = CfgFn.GetNoNullDecimal(r["ordered"]); var residual = ordered - invoiced; r["residual"] = residual; if (residual == 0) { r.Delete(); } } estimateDetail.AcceptChanges(); if (estimateDetail.Select().Length <= 0) { return; } var map = Meta.Dispatcher.Get("estimatedetailtoinvoice"); map.DescribeColumns(estimateDetail, "default"); var d = new DataSet(); d.Tables.Add(estimateDetail); HelpForm.SetDataGrid(gridDettagli, estimateDetail); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, estimateDetail); var format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(estimateDetail, true); selezionaTutto(); } }
void RiempiGrid() { string filter = ""; filter = QHS.AppAnd(QHS.IsNull("iduniqueformcode"), QHS.IsNull("idflussocrediti")); if (cmbTipocontrattoattivo.SelectedValue != null) { filter = QHS.AppAnd(filter, QHS.CmpEq("idestimkind", cmbTipocontrattoattivo.SelectedValue)); } if (txtAnagrafica.Text != "") { filter = QHS.AppAnd(filter, QHS.CmpEq("registry", txtAnagrafica.Text.ToString())); } if (txtDataStart.Text != "") { object datainizio = HelpForm.GetObjectFromString(typeof(DateTime), txtDataStart.Text, txtDataStart.Tag.ToString()); filter = QHS.AppAnd(filter, QHS.CmpGe("adate", datainizio)); } if (txtDataStop.Text != "") { object datafine = HelpForm.GetObjectFromString(typeof(DateTime), txtDataStop.Text, txtDataStop.Tag.ToString()); filter = QHS.AppAnd(filter, QHS.CmpLe("adate", datafine)); } DataTable EstimateDetail = Conn.RUN_SELECT("estimatedetailview", "*", "idestimkind ASC,yestim DESC,nestim DESC,rownum ASC, idgroup ASC", filter, null, false); Conn.DeleteAllUnselectable(EstimateDetail); if (EstimateDetail.Rows.Count != 0) { EstimateDetail.PrimaryKey = new DataColumn[] { EstimateDetail.Columns["idestimkind"], EstimateDetail.Columns["yestim"], EstimateDetail.Columns["nestim"], EstimateDetail.Columns["rownum"] }; //Ora ha messo in EstimateDetail tutto ciò che da DB risulta 'da fatturare'. //Effettua ora una serie di allineamenti sul DataTable per renderlo più coerente con quello //che c'è nel DataSet del form padre. foreach (DataRow R in Flussocreditidetail.Select()) { if (R.RowState != DataRowState.Added) { continue; } if (R["idestimkind"] == DBNull.Value) { continue; //Non è una riga collegata a dettagli contratto attivo } string filterestim = QHC.CmpMulti(R, "idestimkind", "yestim", "nestim", "rownum"); foreach (DataRow Re in EstimateDetail.Select(filterestim)) { Re.Delete(); } } EstimateDetail.AcceptChanges(); if (EstimateDetail.Select().Length > 0) { MetaData MAP = Meta.Dispatcher.Get("estimatedetailview"); MAP.DescribeColumns(EstimateDetail, "flussocrediti"); DataSet D = new DataSet(); D.Tables.Add(EstimateDetail); HelpForm.SetDataGrid(gridDettagli, EstimateDetail); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, EstimateDetail); formatgrids format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(EstimateDetail, true); SelezionaTutto(); } } }
void RiempiGrid(string Filtro) { //if (RBooking == null) return; //string keyfilter = QHS.CmpEq("idbooking", RBooking["idbooking"]); //string lista = ""; foreach (DataRow rDetail in DS.storeunloaddetail.Rows) { if ((rDetail.RowState == DataRowState.Deleted) || (rDetail.RowState == DataRowState.Modified)) { if (rDetail["idbooking", DataRowVersion.Original] != DBNull.Value) { Filtro = QHS.AppOr(QHS.DoPar(Filtro), QHS.DoPar(QHS.CmpEq("idbooking", rDetail["idbooking", DataRowVersion.Original]))); } } } //Details contiene la vista delle righe interessate dalle prenotazioni associate allo scarico // ed in più quelle selezionate in base ai filtri DataTable Details = Conn.RUN_SELECT("booktotalview", "*", null, Filtro, null, false); if (Details.Rows.Count != 0) { Details.PrimaryKey = new DataColumn[] { Details.Columns["idbooking"], Details.Columns["idlist"], Details.Columns["idstore"] }; // Ora ha messo in Detail tutto ciò che da DB risulta 'da inserire nello scarico'. // Effettua ora una serie di allineamenti sul DataTable per renderlo più coerente con quello // che c'è nel DataSet del form padre. // Per ogni riga del DataSet in stato di INSERT/UPDATE effettua una sottrazione ed eventualmente // un delete su Detail se la riga corrispondente risulta essere esaurita. //Esamina le righe cancellate da DS foreach (DataRow rDetail in DS.Tables["storeunloaddetail"].Rows) { if (rDetail.RowState != DataRowState.Deleted) { continue; } if (rDetail["idbooking", DataRowVersion.Original] == DBNull.Value) { continue; } decimal oldnumber = CfgFn.GetNoNullDecimal(rDetail["number", DataRowVersion.Original]); string filter = QHC.AppAnd( QHC.CmpEq("idstore", GetIDStore(rDetail["idstock", DataRowVersion.Original])), QHC.CmpEq("idlist", GetIDList(rDetail["idstock", DataRowVersion.Original])), QHC.CmpEq("idbooking", rDetail["idbooking", DataRowVersion.Original]) ); DataRow[] RM = Details.Select(filter); if ((RM == null) || (RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal newnumber = 0; decimal oldbooknumber = CfgFn.GetNoNullDecimal(Detail["number"]); decimal oldallocated = CfgFn.GetNoNullDecimal(Detail["allocated"]); decimal newallocated = oldallocated - newnumber + oldnumber; decimal newbooknumber = oldbooknumber - newnumber + oldnumber; Detail["number"] = newbooknumber; Detail["allocated"] = newallocated; } //Esamina le righe aggiunte al DS foreach (DataRow rDetail in DS.Tables["storeunloaddetail"].Select()) { if (rDetail.RowState != DataRowState.Added) { continue; } if (rDetail["idbooking"] == DBNull.Value) { continue; } //Non è una riga collegata a dettagli ordine string filter = QHC.AppAnd( QHC.CmpEq("idstore", GetIDStore(rDetail["idstock"])), QHC.CmpEq("idlist", GetIDList(rDetail["idstock"])), QHC.CmpEq("idbooking", rDetail["idbooking"]) ); DataRow[] RM = Details.Select(filter); if ((RM == null) || (RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal oldnumber = 0; decimal newnumber = CfgFn.GetNoNullDecimal(rDetail["number", DataRowVersion.Current]); decimal oldbooknumber = CfgFn.GetNoNullDecimal(Detail["number"]); decimal oldallocated = CfgFn.GetNoNullDecimal(Detail["allocated"]); decimal newallocated = oldallocated - newnumber + oldnumber; decimal newbooknumber = oldbooknumber + newnumber - oldnumber; Detail["number"] = newbooknumber; Detail["allocated"] = newallocated; } foreach (DataRow rDetail in DS.Tables["storeunloaddetail"].Select()) { if (rDetail.RowState != DataRowState.Modified) { continue; } //Non è una riga collegata a dettagli ordine string filter = QHC.AppAnd( QHC.CmpEq("idstore", GetIDStore(rDetail["idstock"])), QHC.CmpEq("idlist", GetIDList(rDetail["idstock"])), QHC.CmpEq("idbooking", rDetail["idbooking"]) ); DataRow[] RM = Details.Select(filter); if ((RM == null) || (RM.Length == 0)) { continue; } DataRow Detail = RM[0]; decimal oldnumber; if (rDetail["idbooking", DataRowVersion.Original] == DBNull.Value) { oldnumber = 0; } else { oldnumber = CfgFn.GetNoNullDecimal(rDetail["number", DataRowVersion.Original]); } decimal newnumber; if (rDetail["idbooking", DataRowVersion.Current] == DBNull.Value) { newnumber = 0; } else { newnumber = CfgFn.GetNoNullDecimal(rDetail["number", DataRowVersion.Current]); } decimal oldbooknumber = CfgFn.GetNoNullDecimal(Detail["number"]); decimal newbooknumber = oldbooknumber - newnumber + oldnumber; decimal oldallocated = CfgFn.GetNoNullDecimal(Detail["allocated"]); decimal newallocated = oldallocated - newnumber + oldnumber; Detail["number"] = newbooknumber; Detail["allocated"] = newallocated; } foreach (DataRow rDetail in Details.Select()) { if (CfgFn.GetNoNullDecimal(rDetail["allocated"]) == 0) { rDetail.Delete(); } } Details.AcceptChanges(); if (Details.Select().Length > 0) { MetaData MAP = Meta.Dispatcher.Get("booktotalview"); MAP.DescribeColumns(Details, "default"); DataSet D = new DataSet(); D.Tables.Add(Details); HelpForm.SetDataGrid(gridDettagli, Details); gridDettagli.TableStyles.Clear(); HelpForm.SetGridStyle(gridDettagli, Details); formatgrids format = new formatgrids(gridDettagli); format.AutosizeColumnWidth(); HelpForm.SetAllowMultiSelection(Details, true); SelezionaTutto(); } } }