void BindGrid_Details()
{
this.UcGrid_Details.Setup("User_Rights", this.mObj.pDt_Rights, "TmpKey", true);
//[-]
DataTable Dt_FilterFields = new DataTable();
Dt_FilterFields.Columns.Add("Desc", typeof(string));
Dt_FilterFields.Columns.Add("Field", typeof(string));
Dt_FilterFields.Columns.Add("DataType", typeof(string));
List <ClsBindGridColumn_EO> List_Gc = Layer01_Methods_Web_EO.GetBindGridColumn_EO("User_Rights");
foreach (ClsBindGridColumn Gc in List_Gc)
{
if (Gc.mVisible && Gc.mFieldName != "")
{
List <QueryParameter> Sp = new List <QueryParameter>();
Sp.Add(new QueryParameter("Field", Gc.mFieldName));
Sp.Add(new QueryParameter("Desc", Gc.mFieldDesc));
Sp.Add(new QueryParameter("DataType", this.mObj.pDt_Rights.Columns[Gc.mFieldName].DataType.Name));
Do_Methods.AddDataRow(ref Dt_FilterFields, Sp);
}
}
Layer01_Methods_Web.BindCombo(ref this.Cbo_SearchFilter, Dt_FilterFields, "Field", "Desc");
this.ViewState[CnsDt_FilterFields] = Dt_FilterFields;
}
void SetupPage_Lookups()
{
Layer01_Methods_Web.BindCombo(ref this.Cbo_Category, Do_Methods_Query.GetLookup("Category"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_ItemType, Do_Methods_Query.GetLookup("ItemType"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_Brand, Do_Methods_Query.GetLookup("Brand"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_Retailer, Do_Methods_Query.GetLookup("Retailer"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_ItemUOM, Do_Methods_Query.GetLookup("UOM"), "LookupID", "Desc", 0, "-Select-");
}
void SetupPage_Lookups()
{
Layer01_Methods_Web.BindCombo(ref this.Cbo_Currency, Do_Methods_Query.GetLookup("Currency"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_PaymentTerm, Do_Methods_Query.GetLookup("PaymentTerm"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_ShipVia, Do_Methods_Query.GetLookup("ShipVia"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(
ref this.Cbo_TaxCode
, Do_Methods_Query.GetQuery("LookupTaxCode", "", "IsNull(IsDeleted,0) = 0 And IsNull(IsActive,0) = 1")
, "LookupTaxCodeID"
, "Desc"
, 0
, "-Select-");
Layer01_Methods_Web.BindCombo(
ref this.Cbo_ClientType
, Do_Methods_Query.GetQuery("LookupClientType", "", "IsNull(IsDeleted,0) = 0 And IsNull(IsActive,0) = 1")
, "LookupClientTypeID"
, "Desc"
, 0
, "-Select-");
}
void Details_SetPaginator(Int64 Top, Int64 Items)
{
Int64 Pages = (Int64)Items / (Int64)Top;
if ((Items % Top) > 0)
{
Pages++;
}
DataTable Dt = new DataTable();
Dt.Columns.Add("Page", typeof(Int64));
for (Int64 Ct = 1; Ct <= Pages; Ct++)
{
List <QueryParameter> Sp = new List <QueryParameter>();
Sp.Add(new QueryParameter("Page", Ct));
Do_Methods.AddDataRow(ref Dt, Sp);
}
Layer01_Methods_Web.BindCombo(ref this.Cbo_Page, Dt, "Page", "Page");
this.ViewState[CnsItemsMax] = Items;
}
void SetupPage_Lookups()
{
Layer01_Methods_Web.BindCombo(ref this.Cbo_State, Do_Methods_Query.GetLookup("States"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_Country, Do_Methods_Query.GetLookup("Country"), "LookupID", "Desc", 0, "-Select-");
}
void SetupPage_Lookups()
{
Layer01_Methods_Web.BindCombo(ref this.Cbo_Department, Do_Methods_Query.GetLookup("Department"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_PayRate, Do_Methods_Query.GetLookup("PayRate"), "LookupID", "Desc", 0, "-Select-");
Layer01_Methods_Web.BindCombo(ref this.Cbo_EmployeeType, Do_Methods_Query.GetLookup("EmployeeType"), "LookupID", "Desc", 0, "-Select-");
}
