private void GetAllRows() { if (all) { collection = controller.FetchAll(OrderBy, OwnerColumn, OwnerID); } else { string[] selection = this.Request.Params.GetValues("selection[]"); if (selection == null) { collection = controller.FetchAllPaged((PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID); } else { StringBuilder columns = new StringBuilder(); columns.Append("KD_VENDOR"); columns.Append('\0'); collection = controller.FetchSelected(columns.ToString().Split(new char[] { '\0' }, StringSplitOptions.RemoveEmptyEntries), selection, OrderBy, OwnerColumn, OwnerID); } } }
private void GetAllRows() { if (Selection == null) { if (all) { collection = controller.FetchAll(OrderBy, OwnerColumn, OwnerID); numrows = controller.FetchAllCount(OwnerColumn, OwnerID); } else { collection = controller.FetchAllPaged((PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID); numrows = controller.FetchAllCount(OwnerColumn, OwnerID); } } else { StringBuilder columns = new StringBuilder(); columns.Append("KD_VENDOR"); columns.Append('\0'); collection = controller.FetchSelected(columns.ToString().Split(new char[] { '\0' }, StringSplitOptions.RemoveEmptyEntries), Selection, OrderBy, OwnerColumn, OwnerID); numrows = collection.Count; Selection = null; } }
private void GetSearchRows() { string oCol = OwnerColumn; string oID = OwnerID; IDictionary <string, object> par = new Dictionary <string, object>(); if (func.IsAdminUser() || func.GetsAdvSecurityMethod(strTableName) == "2") { oCol = string.Empty; oID = string.Empty; } if (string.IsNullOrEmpty(SearchField)) { if (par.Count > 0) { collection = controller.FetchByAllParameters(SearchOption, SearchFor, (PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID, par); numrows = controller.FetchByAllParametersCount(SearchOption, SearchFor, oCol, oID, par); } else { collection = controller.FetchByAllParameters(SearchOption, SearchFor, (PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID); numrows = controller.FetchByAllParametersCount(SearchOption, SearchFor, oCol, oID); } } else { if (par.Count > 0) { collection = controller.FetchByParameter(SearchField, SearchOption, SearchFor, (PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID, par); numrows = controller.FetchByParameterCount(SearchField, SearchOption, SearchFor, oCol, oID, par); } else { collection = controller.FetchByParameter(SearchField, SearchOption, SearchFor, (PageNumber - 1) * PageSize, PageSize, OrderBy, OwnerColumn, OwnerID); numrows = controller.FetchByParameterCount(SearchField, SearchOption, SearchFor, oCol, oID); } } }
public static string DisplayMasterTableInfo(string sourcetable, IList <object> masterkeys, System.Web.UI.Page page) { string strTableName = "Tb_Vendor"; string oldTableName = strTableName; string keyField = string.Empty; string output = string.Empty; Dictionary <string, object> smarty = new Dictionary <string, object>(); Builder builder = Factory.CreateBuilder(); smarty.Add("__table", "Tb_Vendor"); string sCulture = ConfigurationManager.AppSettings["LCID"]; if (!String.IsNullOrEmpty(sCulture)) { int nCulture = int.Parse(sCulture); smarty.Add("LCID", nCulture); System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(nCulture, false); } if (System.Web.HttpContext.Current.Session["locale_xml"] != null) { smarty.Add("Captions", AspNetRunnerPage.GetTableCaptions((XmlNode)System.Web.HttpContext.Current.Session["locale_xml"], (string)System.Web.HttpContext.Current.Session["language"])); if (!string.IsNullOrEmpty(strTableName)) { smarty.Add("Labels", AspNetRunnerPage.GetFieldCaptions((XmlNode)System.Web.HttpContext.Current.Session["locale_xml"], (string)System.Web.HttpContext.Current.Session["language"], "dbo_Tb_Vendor")); } } keyField = "KD_VENDOR"; Tb_VendorController controller = new Tb_VendorController(); Tb_VendorCollection collection = controller.FetchByID(masterkeys[0]); string keylink = string.Empty; if (collection != null && collection.Count > 0) { keylink += "&key1=" + Control.HTMLEncodeSpecialChars(HttpUtility.UrlEncode(collection[0].KD_VENDOR.ToString())); } string value = ""; Control control_KD_VENDOR = new Control("KD_VENDOR", collection[0].KD_VENDOR, false, smarty, page.Request, builder, MODE.MODE_LIST); // KD_VENDOR - value = control_KD_VENDOR.GetData(); value = control_KD_VENDOR.ProcessLargeText(value, "field=KD%5FVENDOR" + keylink, "", MODE.MODE_LIST); smarty.Add("KD_VENDOR_mastervalue", value); Control control_NAMA = new Control("NAMA", collection[0].NAMA, false, smarty, page.Request, builder, MODE.MODE_LIST); // NAMA - value = control_NAMA.GetData(); value = control_NAMA.ProcessLargeText(value, "field=NAMA" + keylink, "", MODE.MODE_LIST); smarty.Add("NAMA_mastervalue", value); Control control_ALAMAT = new Control("ALAMAT", collection[0].ALAMAT, false, smarty, page.Request, builder, MODE.MODE_LIST); // ALAMAT - value = control_ALAMAT.GetData(); value = control_ALAMAT.ProcessLargeText(value, "field=ALAMAT" + keylink, "", MODE.MODE_LIST); smarty.Add("ALAMAT_mastervalue", value); Control control_NPWP = new Control("NPWP", collection[0].NPWP, false, smarty, page.Request, builder, MODE.MODE_LIST); // NPWP - value = control_NPWP.GetData(); value = control_NPWP.ProcessLargeText(value, "field=NPWP" + keylink, "", MODE.MODE_LIST); smarty.Add("NPWP_mastervalue", value); Control control_TELEPON = new Control("TELEPON", collection[0].TELEPON, false, smarty, page.Request, builder, MODE.MODE_LIST); // TELEPON - value = control_TELEPON.GetData(); value = control_TELEPON.ProcessLargeText(value, "field=TELEPON" + keylink, "", MODE.MODE_LIST); smarty.Add("TELEPON_mastervalue", value); Control control_FAX = new Control("FAX", collection[0].FAX, false, smarty, page.Request, builder, MODE.MODE_LIST); // FAX - value = control_FAX.GetData(); value = control_FAX.ProcessLargeText(value, "field=FAX" + keylink, "", MODE.MODE_LIST); smarty.Add("FAX_mastervalue", value); Control control_EMAIL = new Control("EMAIL", collection[0].EMAIL, false, smarty, page.Request, builder, MODE.MODE_LIST); // EMAIL - value = control_EMAIL.GetData(); value = control_EMAIL.ProcessLargeText(value, "field=EMAIL" + keylink, "", MODE.MODE_LIST); smarty.Add("EMAIL_mastervalue", value); Control control_STATUS = new Control("STATUS", collection[0].STATUS, false, smarty, page.Request, builder, MODE.MODE_LIST); // STATUS - Checkbox value = control_STATUS.GetData(); smarty.Add("STATUS_mastervalue", value); return(func.BuildOutput(page, @"~\Tb_Vendor_masterprint.aspx", smarty)); }
private void GetAdvancedSearchRows() { string[] asearchfield = this.Request.Form.GetValues("asearchfield[]"); if (asearchfield == null) { asearchfield = Asearchfield; } IDictionary <string, object> par = new Dictionary <string, object>(); string oCol = OwnerColumn; string oID = OwnerID; if (func.IsAdminUser() || func.GetsAdvSecurityMethod(strTableName) == "2") { oCol = string.Empty; oID = string.Empty; } if (par.Count > 0) { collection = controller.FetchForAdvancedSearch(asearchfield, Asearchopt, Asearchfor, Asearchfor2, Asearchnot, (Asearchtype == "and"), (PageNumber - 1) * PageSize, PageSize, OrderBy, oCol, oID, par); numrows = controller.FetchForAdvancedSearchCount(asearchfield, Asearchopt, Asearchfor, Asearchfor2, Asearchnot, (Asearchtype == "and"), (PageNumber - 1) * PageSize, PageSize, OrderBy, oCol, oID, par); } else { collection = controller.FetchForAdvancedSearch(asearchfield, Asearchopt, Asearchfor, Asearchfor2, Asearchnot, (Asearchtype == "and"), (PageNumber - 1) * PageSize, PageSize, OrderBy, oCol, oID); numrows = controller.FetchForAdvancedSearchCount(asearchfield, Asearchopt, Asearchfor, Asearchfor2, Asearchnot, (Asearchtype == "and"), (PageNumber - 1) * PageSize, PageSize, OrderBy, oCol, oID); } }