void SetupPage() { DataTable Dt = Do_Methods_Query.GetQuery( "System_Modules" , "" , "System_ModulesID = " + this.mSystem_ModulesID); string Override_ModuleName = (string)this.ViewState[CnsModuleName]; if (Override_ModuleName == "") { if (Dt.Rows.Count > 0) { Override_ModuleName = (string)Do_Methods.IsNull(Dt.Rows[0]["Name"], ""); } } this.Lbl_ModuleName.Text = Override_ModuleName; if (!this.mCurrentUser.CheckAccess(this.mSystem_ModulesID, Layer01_Common.Common.Layer01_Constants.eAccessLib.eAccessLib_Access)) { throw new Exception("You have no access in this page."); } if (!this.mCurrentUser.CheckAccess(this.mSystem_ModulesID, Layer01_Common.Common.Layer01_Constants.eAccessLib.eAccessLib_New)) { this.Btn_New.Enabled = false; } this.Txt_Top.Text = "50"; this.BindGrid(); this.Lbl_AppliedFilters.Text = this.Details_ItemsCount(); this.RaiseSetupPage_Done(); }
void SetupPage() { this.Txt_Name.Text = (string)Do_Methods.IsNull(this.mObj.pDr_RowProperty["Name"], ""); this.Txt_Desc.Text = (string)Do_Methods.IsNull(this.mObj.pDr_RowProperty["Remarks"], ""); this.BindGrid_Details(); }
void Details_FormatPhoneNo(ref TextBox TextBox) { System.Text.RegularExpressions.MatchCollection Matches = System.Text.RegularExpressions.Regex.Matches(TextBox.Text, "[0-9]"); TextBox.Text = ""; System.Text.StringBuilder Sb = new System.Text.StringBuilder(); foreach (System.Text.RegularExpressions.Match Match in Matches) { Sb.Append(Match.Value); } string Formatted = ""; Formatted = Sb.ToString(); Sb.Clear(); try { Sb.Append("(" + Do_Methods.TextFiller(Strings.Mid(Formatted, 1, 3), "0", 3) + ")"); } catch { } try { Sb.Append("-" + Do_Methods.TextFiller(Strings.Mid(Formatted, 4, 3), "0", 3) + ""); } catch { } try { Sb.Append("-" + Do_Methods.TextFiller(Strings.Mid(Formatted, 7, 4), "0", 3) + ""); } catch { } TextBox.Text = Sb.ToString(); }
protected Int64 List_Count(QueryCondition Condition = null) { DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(this.mSystem_BinDefinition_Name); string Bind_Condition = (string)Do_Methods.IsNull(Dr_Bind["Condition"], ""); string Bind_Sort = (string)Do_Methods.IsNull(Dr_Bind["Sort"], ""); string Query_Condition = ""; if (Bind_Condition.Trim() != "") { Query_Condition = " Where " + Bind_Condition; } string Source = (string)this.ViewState[CnsSource]; if (Source == "") { Source = this.mObj_Base.pHeader_ViewName; } string Query = @"(Select * From " + Source + " " + Query_Condition + " ) As [Tb]"; Interface_DataAccess Da = this.mObj_Base.CreateDataAccess(); //DataTable Dt = Do_Methods_Query.GetQuery(Query, "Count(1) As [Ct]", Condition); DataTable Dt = Da.GetQuery(Query, "Count(1) As [Ct]", Condition); Int64 Rv = 0; try { Rv = Convert.ToInt64(Do_Methods.IsNull(Dt.Rows[0]["Ct"], 0)); } catch { } return(Rv); }
public static List <ClsBindGridColumn> GetBindGridColumn(string Name) { List <ClsBindGridColumn> List_Gc = new List <ClsBindGridColumn>(); ClsBindGridColumn Gc; DataTable Dt_Def = Do_Methods_Query.GetQuery(@"udf_System_BindDefinition('" + Name + "')", "", "", "OrderIndex"); foreach (DataRow Dr in Dt_Def.Rows) { Gc = new ClsBindGridColumn( (string)Do_Methods.IsNull(Dr["Name"], "") , (string)Do_Methods.IsNull(Dr["Desc"], "") , (Int32)Do_Methods.IsNull(Dr["Width"], 0) , (string)Do_Methods.IsNull(Dr["NumberFormat"], "") , (Layer01_Common.Common.Layer01_Constants.eSystem_Lookup_FieldType)Do_Methods.IsNull(Dr["System_LookupID_FieldType"], Layer01_Common.Common.Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Static) , !(bool)Do_Methods.IsNull(Dr["IsHidden"], false) , !(bool)Do_Methods.IsNull(Dr["IsReadOnly"], false)); Gc.mButtonType = (ButtonColumnType)Do_Methods.IsNull(Dr["System_LookupID_ButtonType"], ButtonColumnType.LinkButton); Gc.mFieldText = (string)Do_Methods.IsNull(Dr["FieldText"], ""); List_Gc.Add(Gc); } return(List_Gc); }
void SetupPage() { this.SetupPage_Lookups(); this.Txt_EmployeeCode.Text = (string)Do_Methods.IsNull(this.mObj.pDr["EmployeeCode"], ""); this.Txt_LeaveVacation.Text = Convert.ToInt32(Do_Methods.IsNull(this.mObj.pDr["Leave_Vacation"], 0)).ToString("#,##0"); //Methods.Convert_Int32(this.mObj.pDr["Leave_Vacation"]).ToString(); this.Txt_LeaveSick.Text = Convert.ToInt32(Do_Methods.IsNull(this.mObj.pDr["Leave_Sick"], 0)).ToString("#,##0"); //Methods.Convert_Int32(this.mObj.pDr["Leave_Sick"]).ToString(); this.Txt_LeaveBereavement.Text = Convert.ToInt32(Do_Methods.IsNull(this.mObj.pDr["Leave_Bereavement"], 0)).ToString("#,##0"); //Methods.Convert_Int32(this.mObj.pDr["Leave_Bereavement"]).ToString(); this.Txt_Position.Text = (string)Do_Methods.IsNull(this.mObj.pDr["Position"], ""); this.Txt_Pay.Text = Do_Methods.Convert_Double(this.mObj.pDr["Pay"].ToString()).ToString("#,##0.00"); this.Txt_SIN.Text = (string)Do_Methods.IsNull(this.mObj.pDr["SIN"], ""); this.EODtp_DateHired.VisibleDate = DateTime.Now; this.EODtp_DateHired.SelectedDate = !Microsoft.VisualBasic.Information.IsDBNull(this.mObj.pDr["DateHired"]) ? (DateTime)this.mObj.pDr["DateHired"] : new DateTime(); this.EODtp_DateTerminate.VisibleDate = DateTime.Now; this.EODtp_DateTerminate.SelectedDate = !Microsoft.VisualBasic.Information.IsDBNull(this.mObj.pDr["DateTerminate"]) ? (DateTime)this.mObj.pDr["DateTerminate"] : new DateTime(); DataTable Dt_Defaults = Do_Methods_Query.GetQuery("uvw_Lookup"); this.Cbo_Department.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_Department"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.Department))).ToString(); this.Cbo_PayRate.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_PayRate"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.PayRate))).ToString(); this.Cbo_EmployeeType.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_EmployeeType"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.EmployeeType))).ToString(); this.UcPerson.Setup(this.mObj.pObj_Person); this.UcAddress.Setup(this.mObj.pObj_Address); }
void EOCb_Accept_Execute(object sender, EO.Web.CallbackEventArgs e) { if (this.mIsMultipleSelect) { this.PostGrid_Selected(); } else { Int64 ID = 0; try { ID = Convert.ToInt64(e.Parameter); } catch { } DataTable Inner_Dt = new DataTable(); Inner_Dt.Columns.Add("ID", typeof(Int64)); List <QueryParameter> Sp = new List <QueryParameter>(); Sp.Add(new QueryParameter("ID", ID)); Do_Methods.AddDataRow(ref Inner_Dt, Sp); this.mDt_Selected = Inner_Dt; } DataTable Dt = this.Selected(); string Data = (string)this.ViewState[CnsData]; if (EvAccept != null) { EvAccept(Dt, e, Data); } }
void SetupPage() { this.SetupPage_ControlAttributes(); ClsPerson Obj = this.mObj_Person; this.Txt_FirstName.Text = (string)Do_Methods.IsNull(Obj.pDr["FirstName"], ""); this.Txt_MiddleName.Text = (string)Do_Methods.IsNull(Obj.pDr["MiddleName"], ""); this.Txt_LastName.Text = (string)Do_Methods.IsNull(Obj.pDr["LastName"], ""); this.Txt_Phone.Text = (string)Do_Methods.IsNull(Obj.pDr["Phone"], ""); this.Txt_Mobile.Text = (string)Do_Methods.IsNull(Obj.pDr["Mobile"], ""); this.Txt_Fax.Text = (string)Do_Methods.IsNull(Obj.pDr["Fax"], ""); this.Txt_Email.Text = (string)Do_Methods.IsNull(Obj.pDr["Email"], ""); this.Txt_Email_Work.Text = (string)Do_Methods.IsNull(Obj.pDr["WorkEmail"], ""); this.EODtp_BirthDate.VisibleDate = DateTime.Now; if (!Microsoft.VisualBasic.Information.IsDBNull(Obj.pDr["BirthDate"])) { this.EODtp_BirthDate.SelectedDate = (DateTime)Obj.pDr["BirthDate"]; } else { this.EODtp_BirthDate.SelectedDate = new DateTime(); } }
public void Update() { ClsPerson Obj = this.mObj_Person; Obj.pDr["FirstName"] = this.Txt_FirstName.Text; Obj.pDr["MiddleName"] = this.Txt_MiddleName.Text; Obj.pDr["LastName"] = this.Txt_LastName.Text; System.Text.StringBuilder Sb_FullName = new System.Text.StringBuilder(); Sb_FullName.Append(this.Txt_FirstName.Text); Sb_FullName.Append(" "); Sb_FullName.Append(this.Txt_MiddleName.Text); Sb_FullName.Append(" "); Sb_FullName.Append(this.Txt_LastName.Text); Obj.pDr["FullName"] = Sb_FullName.ToString(); this.Details_FormatPhoneNo(ref this.Txt_Phone); this.Details_FormatPhoneNo(ref this.Txt_Mobile); this.Details_FormatPhoneNo(ref this.Txt_Fax); Obj.pDr["Phone"] = this.Txt_Phone.Text; Obj.pDr["Mobile"] = this.Txt_Mobile.Text; Obj.pDr["Fax"] = this.Txt_Fax.Text; Obj.pDr["Email"] = this.Txt_Email.Text; Obj.pDr["WorkEmail"] = this.Txt_Email_Work.Text; try { Obj.pDr["BirthDate"] = this.EODtp_BirthDate.SelectedDate; } catch { Obj.pDr["BirthDate"] = DBNull.Value; } Do_Methods.ConvertCaps(Obj.pDr); }
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() { this.Txt_Username.Text = (string)Do_Methods.IsNull(this.mObj.pDr["UserName"], ""); this.Txt_Employee.Text = (string)Do_Methods.IsNull(this.mObj.pDr["EmployeeName"], ""); this.BindGrid_Details(); }
public static List <ClsBindGridColumn_EO> BindEOGrid( ref EO.Web.Grid EOGrid , string Name , string TableKey = "" , bool AllowSort = true , bool HasDelete = false) { DataTable Dt_Bind = Do_Methods_Query.GetQuery("System_BindDefinition", "", @"Name = '" + Name + "'"); DataRow Dr_Bind; if (Dt_Bind.Rows.Count > 0) { Dr_Bind = Dt_Bind.Rows[0]; } else { throw new Exception("Bind Definition not found."); } List <ClsBindGridColumn_EO> Gc = GetBindGridColumn_EO(Name); DataTable Dt = Do_Methods_Query.GetQuery( (string)Do_Methods.IsNull(Dr_Bind["TableName"], "") , "" , (string)Do_Methods.IsNull(Dr_Bind["Condition"], "") , (string)Do_Methods.IsNull(Dr_Bind["Sort"], "")); if (TableKey.Trim() != "") { TableKey = (string)Do_Methods.IsNull(Dr_Bind["TableKey"], ""); } BindEOGrid(ref EOGrid, Dt, Gc, TableKey, AllowSort, HasDelete); return(Gc); }
public override bool Validate() { base.mList_ValidationError.Clear(); ClsItem Obj = (ClsItem)base.mBase; if (Do_Methods.Convert_String(Obj.pDr_RowProperty["Code"]) == "") { Obj.pDr_RowProperty["Code"] = Layer02_Common.GetSeriesNo("Item"); } if ( Layer02_Common.CheckSeriesDuplicate( "uvw_Item" , "Code" , Obj.GetKeys() , Do_Methods.Convert_String(Obj.pDr_RowProperty["Code"])) ) { base.AddError( eErrors.Err_Code.ToString() , "Duplicate Item No. found. Please change the Item No.");; } if (Do_Methods.Convert_String(Obj.pDr_RowProperty["Name"]) != "") { base.AddError( eErrors.Err_Name.ToString() , "Item Name is required."); } return(base.mList_ValidationError.Count == 0); }
public void UpdatePriceHistory(Int64 ItemID) { DataTable Dt_Item = Do_Methods_Query.GetQuery("Item", "", "ItemID = " + ItemID); DataRow Dr_Item = null; if (Dt_Item.Rows.Count > 0) { Dr_Item = Dt_Item.Rows[0]; } else { return; } DateTime ServerDate = Layer02_Common.GetServerDate(); DataTable Dt_PriceHistory = Do_Methods_Query.GetQuery("Item_PriceHistory", "", "1 = 0"); DataRow Dr_PriceHistory = Dt_PriceHistory.NewRow(); Dr_PriceHistory["ItemID"] = ItemID; Dr_PriceHistory["Price"] = Dr_Item["Price"]; Dr_PriceHistory["EmployeeID_PostedBy"] = this.mCurrentUser.pDrUser["EmployeeID"]; Dr_PriceHistory["DatePosted"] = ServerDate; Interface_DataAccess Da = Do_Methods.CreateDataAccess(); try { Da.Connect(); Da.SaveDataRow(Dr_PriceHistory, "Item_PriceHistory"); } catch { } finally { Da.Close(); } }
void AddNode(ref DataTable Dt_Menu, TreeNode TvNode, Int64 System_ModulesID) { DataRow[] ArrDr = Dt_Menu.Select("Parent_System_ModulesID = " + System_ModulesID.ToString()); foreach (DataRow Dr in ArrDr) { TreeNode Node = new TreeNode(); Node.Text = @" " + Dr["Name"]; if ((string)Do_Methods.IsNull(Dr["PageUrl_List"], "") != "") { string Arguments = (string)Do_Methods.IsNull(Dr["Arguments"], ""); if (Arguments != "") { Arguments = @"?" + Arguments; } Node.NavigateUrl = @"~/" + (string)Dr["PageUrl_List"] + Arguments; } else { Node.SelectAction = TreeNodeSelectAction.None; } TvNode.ChildNodes.Add(Node); DataRow[] Inner_ArrDr = Dt_Menu.Select("Parent_System_ModulesID = " + ((Int64)Do_Methods.IsNull(Dr["System_ModulesID"], 0)).ToString()); if (Inner_ArrDr.Length > 0) { this.AddNode(ref Dt_Menu, Node, (Int64)Do_Methods.IsNull(Dr["System_ModulesID"], 0)); } } }
//[-] void Selection_AddFilter() { DataTable Dt_FilterFields = (DataTable)this.ViewState[CnsDt_FilterFields]; string FilterSt = ""; QueryCondition Qc = (QueryCondition)this.ViewState[CnsObj_QueryCondition]; if (Qc == null) { Qc = new QueryCondition(); } DataRow[] ArrDr = Dt_FilterFields.Select("Field = '" + this.Cbo_SearchFilter.SelectedValue + "'"); if (ArrDr.Length > 0) { Qc.Add( (string)Do_Methods.IsNull(ArrDr[0]["Field"], "") , this.Txt_Search.Text , (string)Do_Methods.IsNull(ArrDr[0]["DataType"], "")); FilterSt = this.Cbo_SearchFilter.SelectedItem.Text + " by " + this.Txt_Search.Text; } this.ViewState[CnsObj_QueryCondition] = Qc; string ViewState_DisplayFilterString = (string)this.ViewState[CnsDisplayFilterString]; ViewState_DisplayFilterString += @"<br />" + FilterSt; this.ViewState[CnsDisplayFilterString] = ViewState_DisplayFilterString; }
protected override void Save() { System.Text.StringBuilder Sb_ErrorMsg = new System.Text.StringBuilder(); if (!this.Save_Validation(ref Sb_ErrorMsg)) { this.Show_EventMsg(Sb_ErrorMsg.ToString(), ClsBaseMasterDetails.eStatus.Event_Error); return; } //[-] this.mObj.pDr_RowProperty["Code"] = this.Txt_EmployeeCode.Text; this.mObj.pDr["Leave_Vacation"] = Do_Methods.Convert_Int32(this.Txt_LeaveSick.Text); this.mObj.pDr["Leave_Sick"] = Do_Methods.Convert_Int32(this.Txt_LeaveSick.Text); this.mObj.pDr["Leave_Bereavement"] = Do_Methods.Convert_Int32(this.Txt_LeaveBereavement.Text); this.mObj.pDr["Position"] = this.Txt_Position.Text; this.mObj.pDr["LookupID_Department"] = Do_Methods.Convert_Int64(this.Cbo_Department.SelectedValue); this.mObj.pDr["LookupID_PayRate"] = Do_Methods.Convert_Int64(this.Cbo_PayRate.SelectedValue); this.mObj.pDr["LookupID_EmployeeType"] = Do_Methods.Convert_Int64(this.Cbo_EmployeeType.SelectedValue); this.mObj.pDr["SIN"] = this.Txt_SIN.Text; this.mObj.pDr["Pay"] = Do_Methods.Convert_Double(this.Txt_Pay.Text); this.UcPerson.Update(); this.UcAddress.Update(); Do_Methods.ConvertCaps(this.mObj.pDr_RowProperty); Do_Methods.ConvertCaps(this.mObj.pDr_Person); Do_Methods.ConvertCaps(this.mObj.pDr); //[-] base.Save(); }
//[-] void Handle_Selection(DataTable Dt, EO.Web.CallbackEventArgs e, string Data) { if (Dt.Rows.Count > 0) { Int64 ID = Convert.ToInt64(Do_Methods.IsNull(Dt.Rows[0]["ID"], 0)); e.Data = this.Details_SelectEmployee(ID); } }
public void Show_UseQuery( string SelectionName , string SelectionQuery , string SelectionQuery_Key , string Title = "" , bool IsMultipleSelect = false , string Data = "") { this.ViewState[CnsData] = Data; this.ViewState[CnsQuery_Selection] = @"( " + SelectionQuery + @") As [Tb]"; this.ViewState[CnsQuery_Selection_Key] = SelectionQuery_Key; this.ViewState[CnsObj_QueryCondition] = null; this.mSelectionName = SelectionName; this.mIsMultipleSelect = IsMultipleSelect; this.mQuery_Selection = (string)this.ViewState[CnsQuery_Selection]; this.mQuery_Selection_Key = (string)this.ViewState[CnsQuery_Selection_Key]; this.ViewState[CnsSelectionName] = SelectionName; this.ViewState[CnsIsMultipleSelect] = IsMultipleSelect; this.Panel_Check.Visible = IsMultipleSelect; //[-] DataTable Dt = new DataTable(); Dt.Columns.Add("ID", typeof(Int64)); Dt.Columns.Add("IsSelect", typeof(bool)); this.mDt_Selected = Dt; this.ViewState[CnsDt_Selected] = Dt; //[-] this.BindGrid(); this.Lbl_AppliedFilters.Text = this.Details_ItemsCount(); //[-] DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(SelectionName); if (Title == "") { Title = (string)Do_Methods.IsNull(Dr_Bind["Desc"], ""); } if (Title == "") { Title = "Select"; } this.EODialog_Selection.HeaderHtml = Title; this.EODialog_Selection.ClientSideOnAccept = "Selection_Accept_" + this.ClientID; this.EODialog_Selection.Show(); try { this.EOCbp_EODialog_Selection.Update(); } catch { } }
public eLoginResult Login(string UserName, string Password) { Interface_DataAccess Da = new ClsBase().pDa; try { Da.Connect(); //Administrator Login if (UserName.ToUpper() == "Administrator".ToUpper()) { string System_Password = Da.GetSystemParameter("Administrator_Password", "Administrator"); if (System_Password != "") { string Decrypted_Password = System_Password; if (Decrypted_Password == Password) { this.AdministratorLogin(); return(eLoginResult.Administrator); } else { return(eLoginResult.WrongPassword); } } else { throw new CustomException("Administrator Password is not set. Contact your System Administrator."); } } //User Login QueryCondition Qc = new QueryCondition(); Qc.Add("UserName", UserName, typeof(string).ToString()); DataTable Dt = Da.GetQuery("uvw_User", "", Qc, "UserID"); if (Dt.Rows.Count > 0) { string Decrypted_Password = (string)Do_Methods.IsNull(Dt.Rows[0]["Password"], ""); if (Decrypted_Password == Password) { this.mDrUser = Dt.Rows[0]; return(eLoginResult.LoggedIn); } else { return(eLoginResult.WrongPassword); } } return(eLoginResult.WrongUser); } catch (Exception ex) { throw ex; } finally { Da.Close(); } }
public override void RebindGrid() { Int64 Top = 0; try { Top = Do_Methods.Convert_Int64(this.Txt_Top.Text); } catch { } Int32 Page = 0; try { Page = Do_Methods.Convert_Int32(this.Cbo_Page.SelectedValue); } catch { } string ViewState_DisplayFilterString = (string)this.ViewState[CnsDisplayFilterString]; string ViewState_DisplayOrderString = (string)this.ViewState[CnsDisplayOrderString]; string ViewState_OrderString = (string)this.ViewState[CnsOrderString]; QueryCondition Qc = null; try { Qc = (QueryCondition)this.ViewState[CnsObj_QueryCondition]; } catch { } if (Qc == null) { Qc = new QueryCondition(); } this.Details_SetPaginator(Top, this.List_Count(Qc)); try { this.Cbo_Page.SelectedValue = Page.ToString(); } catch { try { Page = Convert.ToInt32(this.Cbo_Page.SelectedValue); } catch { } } DataTable Dt; try { Dt = this.List(Qc, ViewState_OrderString, Top, Page); } catch { Dt = this.List(Qc, "", Top, Page); ViewState_OrderString = ""; ViewState_DisplayOrderString = ""; this.ViewState[CnsOrderString] = ViewState_OrderString; this.ViewState[CnsDisplayOrderString] = ViewState_DisplayOrderString; } this.BindGrid(Dt); try { this.EOCbp_Grid.Update(); } catch { } }
List <ClsBindGridColumn_EO> BindGrid(DataTable Dt_List) { bool IsReadOnly = false; if ( !(this.mCurrentUser.CheckAccess(this.mSystem_ModulesID, Layer01_Common.Common.Layer01_Constants.eAccessLib.eAccessLib_Edit) || this.mCurrentUser.CheckAccess(this.mSystem_ModulesID, Layer01_Common.Common.Layer01_Constants.eAccessLib.eAccessLib_View)) ) { IsReadOnly = true; } bool IsNoSelect = false; try { IsNoSelect = (bool)this.ViewState[CnsIsNoSelect]; } catch { } if (IsNoSelect) { IsReadOnly = true; } DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(this.mSystem_BinDefinition_Name); List <ClsBindGridColumn_EO> List_Gc = Layer01_Methods_Web_EO.GetBindGridColumn_EO(this.mSystem_BinDefinition_Name); if (!IsReadOnly) { ClsBindGridColumn_EO Gc = new ClsBindGridColumn_EO("", "", 50, "", Layer01_Common.Common.Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button); Gc.mCommandName = "Select"; Gc.mFieldText = ">>"; Gc.mButtonType = ButtonColumnType.LinkButton; List_Gc.Insert(0, Gc); } string TableKey = ""; if (this.mObj_Base != null) { TableKey = this.mObj_Base.pHeader_TableKey; } else { TableKey = (string)this.ViewState[CnsSourceKey]; if (TableKey == "") { TableKey = (string)Do_Methods.IsNull(Dr_Bind["TableKey"], ""); } } this.EOGrid_List.ClientSideOnItemCommand = "EOGrid_ItemCommand"; this.EOGrid_List.FullRowMode = true; Layer01_Methods_Web_EO.BindEOGrid(ref this.EOGrid_List, Dt_List, List_Gc, TableKey, false, false); return(List_Gc); }
void Back() { DataTable Dt = Do_Methods_Query.GetQuery("System_Modules", "", "System_ModulesID = " + this.mSystem_ModulesID.ToString()); string Url = ""; if (Dt.Rows.Count > 0) { Url = "~/" + (string)Do_Methods.IsNull(Dt.Rows[0]["PageUrl_List"], ""); } this.Response.Redirect(Url); }
protected Int64 SetupPage_GetLookupDefault(DataTable Dt_Lookup, Layer01_Common.Common.Layer01_Constants.eLookup Lkp) { Int64 DefaultID = 0; DataRow[] ArrDr = Dt_Lookup.Select("LookupID = " + ((Int32)Lkp).ToString()); if (ArrDr.Length > 0) { DefaultID = Convert.ToInt64(Do_Methods.IsNull(ArrDr[0]["Lookup_DetailsID_Default"], 0)); } return(DefaultID); }
public static void NativeExcel_CreateExcel( DataTable Dt , ClsExcel_Columns Columns , string SaveFileName = "" , Excel.XlFileFormat FileFormat = Excel.XlFileFormat.xlExcel5 , string Title = "") { Excel.Application Obj_Excel = new Excel.Application(); Excel.Workbook owbook = Obj_Excel.Workbooks.Add(); Excel.Worksheet owsheet = owbook.Worksheets.Add(); Int32 RowCt = 2; Int32 ColCt = 1; foreach (ClsExcel_Columns.Str_Columns?Obj in Columns.pObj) { owsheet.Cells[RowCt, ColCt].Value = Obj.Value.FieldDesc; owsheet.Cells[RowCt, ColCt].Font.Bold = true; Excel.Range Inner_ExRange = owsheet.Range[ Do_Methods.GenerateChr(ColCt) + RowCt.ToString() + ":" + Do_Methods.GenerateChr(ColCt) + (RowCt + Dt.Rows.Count).ToString()]; Inner_ExRange.NumberFormat = Obj.Value.NumberFormat; ColCt++; } RowCt++; ColCt = 1; Excel.Range ExRange = owsheet.Range[ Do_Methods.GenerateChr(ColCt) + RowCt.ToString() + ":" + Do_Methods.GenerateChr(ColCt + Columns.pObj.Count) + (RowCt + Dt.Rows.Count - 1).ToString()]; ExRange.Value = Do_Methods.ConvertDataTo2DimArray(Dt, Columns.pFieldName); owsheet.Range["A1;IV65536"].AutoFit(); if (SaveFileName == "") { SaveFileName = "Excel_File"; } owsheet.Range["A1:A1"].Select(); owbook.SaveAs(SaveFileName, FileFormat); }
//[-] List <ClsBindGridColumn_EO> BindGrid( DataTable Dt_List , eCheck Check = eCheck.None) { DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(this.mSelectionName); List <ClsBindGridColumn_EO> List_Gc = Layer01_Methods_Web_EO.GetBindGridColumn_EO(this.mSelectionName); string Bind_TableKey = (string)Do_Methods.IsNull(Dr_Bind["TableKey"], ""); string TableKey = (string)this.ViewState[CnsQuery_Selection_Key]; if (TableKey != "") { Bind_TableKey = TableKey; } Dt_List.Columns.Add("IsSelect", typeof(bool)); ClsBindGridColumn_EO Gc = new ClsBindGridColumn_EO( "IsSelect" , "Select?" , 80 , "" , Layer01_Common.Common.Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Checkbox , this.mIsMultipleSelect); List_Gc.Insert(0, Gc); if (Check == eCheck.None) { foreach (DataRow Dr in this.mDt_Selected.Rows) { DataRow[] Inner_ArrDr = Dt_List.Select(Bind_TableKey + " = " + Convert.ToInt64(Dr["ID"]).ToString()); if (Inner_ArrDr.Length > 0) { Inner_ArrDr[0]["IsSelect"] = Do_Methods.IsNull(Dr["IsSelect"], false); } } } else { bool Inner_IsSelect = Check == eCheck.CheckAll; foreach (DataRow Dr in Dt_List.Rows) { Dr["IsSelect"] = Inner_IsSelect; } } this.EOGrid_Selection.FullRowMode = true; Layer01_Methods_Web_EO.BindEOGrid(ref this.EOGrid_Selection, Dt_List, List_Gc, Bind_TableKey, false, false); return(List_Gc); }
void SetupPage() { this.SetupPage_Lookups(); this.Txt_Code.Text = (string)Do_Methods.IsNull(this.mObj.pDr_RowProperty["Code"], ""); this.Txt_Company.Text = (string)Do_Methods.IsNull(this.mObj.pDr["Company"], ""); this.Lbl_SalesPerson.Text = (string)Do_Methods.IsNull(this.mObj.pDr["EmployeeCodeName_SalesPerson"], "-Select-"); this.Txt_CreditCard_AccountName.Text = (string)Do_Methods.IsNull(this.mObj.pDr["CreditCard_AccountName"], ""); if (!Information.IsDBNull(this.mObj.pDr["CreditCard_Expiration"])) { DateTime CreditCard_Expiration = (DateTime)this.mObj.pDr["CreditCard_Expiration"]; this.Txt_CreditCardExpiration_Month.Text = CreditCard_Expiration.Month.ToString(); this.Txt_CreditCardExpiration_Year.Text = Strings.Right(CreditCard_Expiration.Year.ToString(), 2); } else { this.Txt_CreditCardExpiration_Month.Text = ""; this.Txt_CreditCardExpiration_Year.Text = ""; } this.Txt_CreditCard_Part1.Text = (string)Do_Methods.IsNull(this.mObj.pDr["CreditCardNo1"], ""); this.Txt_CreditCard_Part2.Text = (string)Do_Methods.IsNull(this.mObj.pDr["CreditCardNo2"], ""); this.Txt_CreditCard_Part3.Text = (string)Do_Methods.IsNull(this.mObj.pDr["CreditCardNo3"], ""); this.Txt_CreditCard_Part4.Text = (string)Do_Methods.IsNull(this.mObj.pDr["CreditCardNo4"], ""); this.Chk_IsCreditHold.Checked = (bool)Do_Methods.IsNull(this.mObj.pDr["IsCreditHold"], false); this.Lbl_PST_Value.Text = Strings.Format(Do_Methods.IsNull(this.mObj.pDr["PST_Value"], 0), "#,##0.00"); this.Lbl_HST_Value.Text = Strings.Format(Do_Methods.IsNull(this.mObj.pDr["HST_Value"], 0), "#,##0.00"); this.Lbl_GST_Value.Text = Strings.Format(Do_Methods.IsNull(this.mObj.pDr["GST_Value"], 0), "#,##0.00"); DataTable Dt_Defaults = Do_Methods_Query.GetQuery("uvw_Lookup"); this.Cbo_Currency.SelectedValue = Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["LookupID_Currency"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Common.Common.Layer01_Constants.eLookup.Currency))).ToString(); this.Cbo_PaymentTerm.SelectedValue = Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["LookupID_PaymentTerm"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Common.Common.Layer01_Constants.eLookup.PaymentTerm))).ToString(); this.Cbo_TaxCode.SelectedValue = Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["LookupTaxCodeID"], 0)).ToString(); this.Cbo_ClientType.SelectedValue = Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["LookupClientTypeID"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Common.Common.Layer01_Constants.eLookup.ClientType))).ToString(); this.UcPerson.Setup(this.mObj.pObj_Person); this.UcAddress.Setup(this.mObj.pObj_Address); this.UcGrid_ShippingAddress.Setup( "Customer_ShippingAddress" , this.mObj.pDt_ShippingAddress , "TmpKey" , false , true , this.mMaster.pIsReadOnly); this.UcGrid_ShippingAddress.pGrid.ClientSideOnItemCommand = "EOGrid_ItemCommand"; }
private void LoadMenu() { ClsSysCurrentUser CurrentUser = this.mMaster.pCurrentUser; DataTable Dt_Menu; if (CurrentUser.pIsAdmin) { Dt_Menu = Do_Methods_Query.GetQuery("uvw_System_Modules", "", "IsNull(IsHidden,0) = 0", "Parent_OrderIndex, OrderIndex"); } else { List <QueryParameter> Sp = new List <QueryParameter>(); Sp.Add(new QueryParameter(@"@UserID", CurrentUser.pDrUser["UserID"])); Dt_Menu = Do_Methods_Query.ExecuteQuery("usp_System_Modules_Load", Sp).Tables[0]; } this.trvMenus.Nodes.Clear(); foreach (DataRow Dr in Dt_Menu.Rows) { if ((Int64)Do_Methods.IsNull(Dr["Parent_System_ModulesID"], 0) == 0) { TreeNode Node = new TreeNode(); Node.Text = @" " + Dr["Name"]; //Node.ImageUrl = ""; if ((string)Do_Methods.IsNull(Dr["PageUrl_List"], "") != "") { string Arguments = (string)Do_Methods.IsNull(Dr["Arguments"], ""); if (Arguments != "") { Arguments = @"?" + Arguments; } Node.NavigateUrl = @"~/" + Dr["PageUrl_List"] + Arguments; } else { Node.SelectAction = TreeNodeSelectAction.None; } this.trvMenus.Nodes.Add(Node); DataRow[] ArrDr = Dt_Menu.Select("Parent_System_ModulesID = " + ((Int64)Do_Methods.IsNull(Dr["System_ModulesID"], 0)).ToString()); if (ArrDr.Length > 0) { this.AddNode(ref Dt_Menu, Node, (Int64)Do_Methods.IsNull(Dr["System_ModulesID"], 0)); } } } }
string Details_SelectEmployee(Int64 ID) { this.mObj.pDr["EmployeeID_SalesPerson"] = ID; System.Text.StringBuilder Sb_Js = new System.Text.StringBuilder(); DataTable Dt = Do_Methods_Query.GetQuery("uvw_Employee", "", "EmployeeID = " + ID.ToString()); if (Dt.Rows.Count > 0) { this.Lbl_SalesPerson.Text = (string)Do_Methods.IsNull(Dt.Rows[0]["EmployeeCodeName"], ""); Layer01_Methods_Web.Eval_AppendJs(this.Server, ref Sb_Js, this.Lbl_SalesPerson.ClientID, "innerHTML", this.Lbl_SalesPerson.Text); } return(Sb_Js.ToString()); }
public override bool Save(DataObjects_Framework.DataAccess.Interface_DataAccess Da = null) { DateTime ServerDate = Layer02_Common.GetServerDate(); if (Convert.ToInt64(Do_Methods.IsNull(this.mHeader_Dr[this.mHeader_TableName + "ID"], 0)) == 0) { this.mHeader_Dr["EmployeeID_CreatedBy"] = this.mCurrentUser.pDrUser["EmployeeID"]; this.mHeader_Dr["DateCreated"] = ServerDate; } this.mHeader_Dr["EmployeeID_UpdatedBy"] = this.mCurrentUser.pDrUser["EmployeeID"]; this.mHeader_Dr["DateUpdated"] = ServerDate; return(base.Save(Da)); }