Invoke(string entity, int j72id, int go2pid, string master_entity, int master_pid, int contextmenuflag, string ondblclick, string master_flag, int masterviewflag) { var ret = new TheGridViewModel(); ret.Entity = entity; var mq = new BO.myQuery(entity); BO.TheGridState gridState = null; if (j72id > 0) { gridState = _f.j72TheGridTemplateBL.LoadState(j72id, _f.CurrentUser.pid); } if (gridState == null) { gridState = _f.j72TheGridTemplateBL.LoadState(entity, _f.CurrentUser.pid, master_entity); //výchozí, systémový grid: j72IsSystem=1 } if (gridState == null) //pro uživatele zatím nebyl vygenerován záznam v j72 -> vygenerovat { var cols = _colsProvider.getDefaultPallete(false, mq); //výchozí paleta sloupců var recJ72 = new BO.j72TheGridTemplate() { j72IsSystem = true, j72Entity = entity, j03ID = _f.CurrentUser.pid, j72Columns = String.Join(",", cols.Select(p => p.UniqueName)), j72MasterEntity = master_entity }; var intJ72ID = _f.j72TheGridTemplateBL.Save(recJ72, null, null, null); gridState = _f.j72TheGridTemplateBL.LoadState(intJ72ID, _f.CurrentUser.pid); } gridState.j75CurrentRecordPid = go2pid; gridState.ContextMenuFlag = contextmenuflag; gridState.j72MasterEntity = master_entity; gridState.MasterPID = master_pid; gridState.OnDblClick = ondblclick; gridState.MasterViewFlag = masterviewflag; gridState.MasterFlag = master_flag; var cc = new TheGridController(_colsProvider, _pp); cc.Factory = _f; ret.firstdata = cc.render_thegrid_html(gridState); ret.ondblclick = ondblclick; ret.GridState = gridState; ret.Columns = _colsProvider.ParseTheGridColumns(mq.Prefix, gridState.j72Columns); ret.AdhocFilter = _colsProvider.ParseAdhocFilterFromString(gridState.j75Filter, ret.Columns); ret.MasterEntity = master_entity; ret.MasterPID = master_pid; return(View("Default", ret)); }
public string GetWorkTable(string entity, string tableid, string param1, string pids, string delete_function, string edit_function, string queryfield, string queryvalue, string master_entity, int master_pid) { var mq = new BO.myQuery(entity); mq.SetPids(pids); var grid = Factory.j72TheGridTemplateBL.LoadState(entity, Factory.CurrentUser.pid, master_entity); if (grid == null) { mq.explicit_columns = _colsProvider.getDefaultPallete(false, mq); } else { mq.explicit_columns = _colsProvider.ParseTheGridColumns(mq.Prefix, grid.j72Columns); mq.explicit_orderby = grid.j75SortDataField; if (grid.j75SortDataField != null && grid.j75SortOrder != null) { mq.explicit_orderby += " " + grid.j75SortOrder; } } mq.InhaleMasterEntityQuery(master_entity, master_pid); if (string.IsNullOrEmpty(queryfield) == false) { BO.Reflexe.SetPropertyValue(mq, queryfield, queryvalue); } var dt = Factory.gridBL.GetList(mq); var intRows = dt.Rows.Count; var sb = new System.Text.StringBuilder(); sb.Append(string.Format("<table id='{0}' class='table table-sm table-hover'>", tableid)); sb.Append("<thead><tr class='bg-light'>"); if (edit_function != null) { sb.Append(("<th></th>")); } foreach (var c in mq.explicit_columns) { if (c.NormalizedTypeName == "num") { sb.Append(string.Format("<th style='text-align:right;'>{0}</th>", c.Header)); } else { sb.Append(string.Format("<th>{0}</th>", c.Header)); } } if (delete_function != null) { sb.Append(("<th></th>")); } sb.Append("</tr></thead>"); sb.Append("<tbody>"); for (int i = 0; i < intRows; i++) { sb.Append(string.Format("<tr data-v='{0}'>", dt.Rows[i]["pid"])); if (edit_function != null) { sb.Append(string.Format("<td><button type='button' class='btn btn-sm btn-light' onclick='{0}({1})'>Upravit</button></td>", edit_function, dt.Rows[i]["pid"])); } foreach (var col in mq.explicit_columns) { if (col.NormalizedTypeName == "num") { sb.Append(string.Format("<td style='text-align: right;'>{0}</td>", BO.BAS.ParseCellValueFromDb(dt.Rows[i], col))); } else { sb.Append(string.Format("<td>{0}</td>", BO.BAS.ParseCellValueFromDb(dt.Rows[i], col))); } } if (delete_function != null) { sb.Append(string.Format("<td><button type='button' class='btn btn-sm btn-danger' title='Odstranit řádek' onclick='{0}({1})'>×</button></td>", delete_function, dt.Rows[i]["pid"])); } sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); return(sb.ToString()); }
public string GetHtml4TheCombo(string entity, string tableid, string param1, string pids, string filterflag, string searchstring, string masterprefix, int masterpid) //Vrací HTML zdroj tabulky pro MyCombo { var mq = new BO.myQuery(entity); mq.SetPids(pids); mq.query_by_entity_prefix = param1; mq.IsRecordValid = true; //v combo nabídce pouze časově platné záznamy if (filterflag == "1") { mq.SearchString = searchstring; //filtrování na straně serveru mq.TopRecordsOnly = 50; //maximálně prvních 50 záznamů, které vyhovují podmínce } var cols = _colsProvider.getDefaultPallete(true, mq); mq.explicit_columns = cols; mq.explicit_orderby = BL.TheEntities.ByPrefix(mq.Prefix).SqlOrderByCombo; switch (mq.Prefix) { case "p18": mq.p18flag = BO.BAS.InInt(param1); mq.explicit_orderby = "a.p18Code"; if (masterprefix == "p25" && masterpid == 0) //v recepturách je kódy operací povinné zobrazovat v kontextu k typu zařízení { return("<p>Na vstupu chybí vybrat typ zařízení.</p>"); } break; } mq.InhaleMasterEntityQuery(masterprefix, masterpid); var dt = Factory.gridBL.GetList(mq); var intRows = dt.Rows.Count; var s = new System.Text.StringBuilder(); if (mq.TopRecordsOnly > 0) { if (intRows >= mq.TopRecordsOnly) { s.AppendLine(string.Format("<small style='margin-left:10px;'>Zobrazeno prvních {0} záznamů. Zpřesněte filtrovací podmínku.</small>", intRows)); } else { s.AppendLine(string.Format("<small style='margin-left:10px;'>Počet záznamů: {0}.</small>", intRows)); } } s.Append(string.Format("<table id='{0}' class='table table-hover'>", tableid)); s.Append("<thead><tr>"); foreach (var col in cols) { s.Append(string.Format("<th>{0}</th>", col.Header)); } s.Append(string.Format("</tr></thead><tbody id='{0}_tbody'>", tableid)); for (int i = 0; i < intRows; i++) { s.Append(string.Format("<tr class='txz' data-v='{0}'", dt.Rows[i]["pid"])); if (mq.Prefix == "p18" || mq.Prefix == "p19" || mq.Prefix == "p21" || mq.Prefix == "p26" || mq.Prefix == "p10" || mq.Prefix == "p13" || mq.Prefix == "p12" || mq.Prefix == "p11") { //po výběru hodnoty z comba bude SelectedText kód + název a nikoliv hodnota prvního sloupce s.Append(string.Format(" data-t='{0} - {1}'", dt.Rows[i]["a__" + mq.Entity + "__" + mq.Prefix + "Code"], dt.Rows[i]["a__" + mq.Entity + "__" + mq.Prefix + "Name"])); } //if (mq.Prefix == "p51") //{ // s.Append(string.Format(" data-t='{0} - {1} ## {2}'", dt.Rows[i]["a__p51Order__p51Code"], dt.Rows[i]["a__p51Order__p51Name"], dt.Rows[i]["p51_p28_p28Company_p28Name"])); //} s.Append(">"); foreach (var col in cols) { if (col.NormalizedTypeName == "num") { s.Append(string.Format("<td style='text-align:right;'>{0}</td>", BO.BAS.ParseCellValueFromDb(dt.Rows[i], col))); } else { s.Append(string.Format("<td>{0}</td>", BO.BAS.ParseCellValueFromDb(dt.Rows[i], col))); } } s.Append("</tr>"); } s.Append("</tbody></table>"); return(s.ToString()); }