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));
}