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