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