public static string CreateMasterTableInfo(string detailtable, string[] keys, System.Web.UI.Page page) { string strTableName = "dbo.DOKUMEN"; 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", strTableName); 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_DOKUMEN")); } } IDictionary <string, object> par = new Dictionary <string, object>(); keyField = "KODEDOKUMEN"; par[keyField] = keys[1 - 1]; DOKUMENController controller = new DOKUMENController(); DOKUMEN item = controller.FetchByManyID(par); string keylink = string.Empty; if (item != null) { keylink += "&key1=" + Control.HTMLEncodeSpecialChars(HttpUtility.UrlEncode(item.KODEDOKUMEN.ToString())); } string value = ""; Control control_KODEDOKUMEN = new Control("KODEDOKUMEN", item.KODEDOKUMEN, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODEDOKUMEN - value = control_KODEDOKUMEN.GetData(); value = control_KODEDOKUMEN.ProcessLargeText(value, "field=KODEDOKUMEN" + keylink, "", MODE.MODE_LIST); smarty.Add("KODEDOKUMEN_mastervalue", value); Control control_DESKRIPSI = new Control("DESKRIPSI", item.DESKRIPSI, false, smarty, page.Request, builder, MODE.MODE_LIST); // DESKRIPSI - value = control_DESKRIPSI.GetData(); value = control_DESKRIPSI.ProcessLargeText(value, "field=DESKRIPSI" + keylink, "", MODE.MODE_LIST); smarty.Add("DESKRIPSI_mastervalue", value); return(func.BuildOutput(page, @"~\DOKUMEN_masterlist.aspx", smarty)); }
public static string DisplayMasterTableInfo(string sourcetable, IList <object> masterkeys, System.Web.UI.Page page) { string strTableName = "JENISKEGIATAN"; 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", "JENISKEGIATAN"); 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_JENISKEGIATAN")); } } keyField = "KODEJENISKEGIATAN"; keyField = "KODEJENISKEGIATAN"; JENISKEGIATANController controller = new JENISKEGIATANController(); JENISKEGIATANCollection collection = controller.FetchByID(masterkeys[0]); string keylink = string.Empty; if (collection != null && collection.Count > 0) { keylink += "&key1=" + Control.HTMLEncodeSpecialChars(HttpUtility.UrlEncode(collection[0].KODEJENISKEGIATAN.ToString())); } string value = ""; Control control_KODEJENISKEGIATAN = new Control("KODEJENISKEGIATAN", collection[0].KODEJENISKEGIATAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODEJENISKEGIATAN - value = control_KODEJENISKEGIATAN.GetData(); value = control_KODEJENISKEGIATAN.ProcessLargeText(value, "field=KODEJENISKEGIATAN" + keylink, "", MODE.MODE_LIST); smarty.Add("KODEJENISKEGIATAN_mastervalue", value); Control control_DESKRIPSI = new Control("DESKRIPSI", collection[0].DESKRIPSI, false, smarty, page.Request, builder, MODE.MODE_LIST); // DESKRIPSI - value = control_DESKRIPSI.GetData(); value = control_DESKRIPSI.ProcessLargeText(value, "field=DESKRIPSI" + keylink, "", MODE.MODE_LIST); smarty.Add("DESKRIPSI_mastervalue", value); return(func.BuildOutput(page, @"~\JENISKEGIATAN_masterprint.aspx", smarty)); }
public static string CreateMasterTableInfo(string detailtable, string[] keys, System.Web.UI.Page page) { string strTableName = "dbo.AKTOR"; 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", strTableName); 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_AKTOR")); } } IDictionary <string, object> par = new Dictionary <string, object>(); keyField = "NIP"; par[keyField] = keys[1 - 1]; keyField = "NIP"; par[keyField] = keys[1 - 1]; AKTORController controller = new AKTORController(); AKTOR item = controller.FetchByManyID(par); string keylink = string.Empty; if (item != null) { keylink += "&key1=" + Control.HTMLEncodeSpecialChars(HttpUtility.UrlEncode(item.NIP.ToString())); } string value = ""; Control control_NIP = new Control("NIP", item.NIP, false, smarty, page.Request, builder, MODE.MODE_LIST); // NIP - value = control_NIP.GetData(); value = control_NIP.ProcessLargeText(value, "field=NIP" + keylink, "", MODE.MODE_LIST); smarty.Add("NIP_mastervalue", value); Control control_NAMA = new Control("NAMA", item.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_KODEJABATAN = new Control("KODEJABATAN", item.KODEJABATAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODEJABATAN - control_KODEJABATAN.Value = func.GetLookupValue(control_KODEJABATAN.FieldInfo); value = control_KODEJABATAN.DisplayLookupWizard(); smarty.Add("KODEJABATAN_mastervalue", value); Control control_KODETIPE = new Control("KODETIPE", item.KODETIPE, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODETIPE - control_KODETIPE.Value = func.GetLookupValue(control_KODETIPE.FieldInfo); value = control_KODETIPE.DisplayLookupWizard(); smarty.Add("KODETIPE_mastervalue", value); return(func.BuildOutput(page, @"~\AKTOR_masterlist.aspx", smarty)); }
public static string DisplayMasterTableInfo(string sourcetable, IList <object> masterkeys, System.Web.UI.Page page) { string strTableName = "PBJ"; 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", "PBJ"); 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_PBJ")); } } keyField = "KODEPBJ"; keyField = "KODEPBJ"; PBJController controller = new PBJController(); PBJCollection collection = controller.FetchByID(masterkeys[0]); string keylink = string.Empty; if (collection != null && collection.Count > 0) { keylink += "&key1=" + Control.HTMLEncodeSpecialChars(HttpUtility.UrlEncode(collection[0].KODEPBJ.ToString())); } string value = ""; Control control_KODEPBJ = new Control("KODEPBJ", collection[0].KODEPBJ, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODEPBJ - value = control_KODEPBJ.GetData(); value = control_KODEPBJ.ProcessLargeText(value, "field=KODEPBJ" + keylink, "", MODE.MODE_LIST); smarty.Add("KODEPBJ_mastervalue", value); Control control_NAMAKEGIATAN = new Control("NAMAKEGIATAN", collection[0].NAMAKEGIATAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // NAMAKEGIATAN - value = control_NAMAKEGIATAN.GetData(); value = control_NAMAKEGIATAN.ProcessLargeText(value, "field=NAMAKEGIATAN" + keylink, "", MODE.MODE_LIST); smarty.Add("NAMAKEGIATAN_mastervalue", value); Control control_NAMAPAKET = new Control("NAMAPAKET", collection[0].NAMAPAKET, false, smarty, page.Request, builder, MODE.MODE_LIST); // NAMAPAKET - value = control_NAMAPAKET.GetData(); value = control_NAMAPAKET.ProcessLargeText(value, "field=NAMAPAKET" + keylink, "", MODE.MODE_LIST); smarty.Add("NAMAPAKET_mastervalue", value); Control control_KODESKPD = new Control("KODESKPD", collection[0].KODESKPD, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODESKPD - control_KODESKPD.Value = func.GetLookupValue(control_KODESKPD.FieldInfo); value = control_KODESKPD.DisplayLookupWizard(); smarty.Add("KODESKPD_mastervalue", value); Control control_PPK = new Control("PPK", collection[0].PPK, false, smarty, page.Request, builder, MODE.MODE_LIST); // PPK - control_PPK.Value = func.GetLookupValue(control_PPK.FieldInfo); value = control_PPK.DisplayLookupWizard(); smarty.Add("PPK_mastervalue", value); Control control_PPTK = new Control("PPTK", collection[0].PPTK, false, smarty, page.Request, builder, MODE.MODE_LIST); // PPTK - control_PPTK.Value = func.GetLookupValue(control_PPTK.FieldInfo); value = control_PPTK.DisplayLookupWizard(); smarty.Add("PPTK_mastervalue", value); Control control_KODEJENISKEGIATAN = new Control("KODEJENISKEGIATAN", collection[0].KODEJENISKEGIATAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODEJENISKEGIATAN - control_KODEJENISKEGIATAN.Value = func.GetLookupValue(control_KODEJENISKEGIATAN.FieldInfo); value = control_KODEJENISKEGIATAN.DisplayLookupWizard(); smarty.Add("KODEJENISKEGIATAN_mastervalue", value); Control control_TANGGALPENGAJUAN = new Control("TANGGALPENGAJUAN", collection[0].TANGGALPENGAJUAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // TANGGALPENGAJUAN - Short Date value = control_TANGGALPENGAJUAN.GetData(); value = control_TANGGALPENGAJUAN.ProcessLargeText(value, "field=TANGGALPENGAJUAN" + keylink, "", MODE.MODE_LIST); smarty.Add("TANGGALPENGAJUAN_mastervalue", value); Control control_LENGKAP = new Control("LENGKAP", collection[0].LENGKAP, false, smarty, page.Request, builder, MODE.MODE_LIST); // LENGKAP - value = control_LENGKAP.GetData(); value = control_LENGKAP.ProcessLargeText(value, "field=LENGKAP" + keylink, "", MODE.MODE_LIST); smarty.Add("LENGKAP_mastervalue", value); Control control_DIKEMBALIKAN = new Control("DIKEMBALIKAN", collection[0].DIKEMBALIKAN, false, smarty, page.Request, builder, MODE.MODE_LIST); // DIKEMBALIKAN - value = control_DIKEMBALIKAN.GetData(); value = control_DIKEMBALIKAN.ProcessLargeText(value, "field=DIKEMBALIKAN" + keylink, "", MODE.MODE_LIST); smarty.Add("DIKEMBALIKAN_mastervalue", value); Control control_KODESTATUSPBJ = new Control("KODESTATUSPBJ", collection[0].KODESTATUSPBJ, false, smarty, page.Request, builder, MODE.MODE_LIST); // KODESTATUSPBJ - control_KODESTATUSPBJ.Value = func.GetLookupValue(control_KODESTATUSPBJ.FieldInfo); value = control_KODESTATUSPBJ.DisplayLookupWizard(); smarty.Add("KODESTATUSPBJ_mastervalue", value); return(func.BuildOutput(page, @"~\PBJ_masterprint.aspx", smarty)); }
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)); }