void Update() { DataRow[] ArrDr = this.mObj_ContactPerson.pDt_ContactPerson.Select("TmpKey = " + this.mTmpKey, "", DataViewRowState.CurrentRows); DataRow Dr_ContactPerson = null; if (ArrDr.Length > 0) { Dr_ContactPerson = ArrDr[0]; } else { //Int64 TmpKey = 0; //ArrDr = this.mObj_ContactPerson.pDt_ContactPerson.Select("", "TmpKey Desc", DataViewRowState.CurrentRows); //if (ArrDr.Length > 0) //{ TmpKey = System.Convert.ToInt64(ArrDr[0]["TmpKey"]); } //TmpKey++; //Dr_ContactPerson = this.mObj_ContactPerson.pDt_ContactPerson.NewRow(); //Dr_ContactPerson["TmpKey"] = TmpKey; //this.mObj_ContactPerson.pDt_ContactPerson.Rows.Add(Dr_ContactPerson); //this.mObj_ContactPerson.pBO_ContactPerson_Persons.Add(TmpKey.ToString(), this.mObj_Person); Dr_ContactPerson = this.mObj_ContactPerson.pObj_ContactPerson_Details.Add_Item(); } this.UcPerson.Update(); Dr_ContactPerson["Position"] = this.Txt_Position.Text; Dr_ContactPerson["FullName"] = Do_Methods.IsNull(this.mObj_Person.pDr["FullName"], ""); Dr_ContactPerson["Phone"] = Do_Methods.IsNull(this.mObj_Person.pDr["Phone"], ""); Dr_ContactPerson["Mobile"] = Do_Methods.IsNull(this.mObj_Person.pDr["Mobile"], ""); Dr_ContactPerson["Fax"] = Do_Methods.IsNull(this.mObj_Person.pDr["Fax"], ""); Dr_ContactPerson["Email"] = Do_Methods.IsNull(this.mObj_Person.pDr["Email"], ""); Dr_ContactPerson["WorkEmail"] = Do_Methods.IsNull(this.mObj_Person.pDr["WorkEmail"], ""); Do_Methods.ConvertCaps(Dr_ContactPerson); this.mTmpKey = System.Convert.ToInt64(Do_Methods.IsNull(Dr_ContactPerson["TmpKey"], 0)); if (EvAccept != null) { EvAccept(); } }
Int64 List_Count(QueryCondition Condition = null) { DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(this.mSelectionName); string Bind_Desc = (string)Do_Methods.IsNull(Dr_Bind["Desc"], ""); string Bind_TableName = (string)Do_Methods.IsNull(Dr_Bind["TableName"], ""); string Bind_TableKey = (string)Do_Methods.IsNull(Dr_Bind["TableKey"], ""); string Bind_Condition = (string)Do_Methods.IsNull(Dr_Bind["Condition"], ""); string Bind_Sort = (string)Do_Methods.IsNull(Dr_Bind["Sort"], ""); string Query_Source = ""; string Query_Condition = ""; if (this.mQuery_Selection != "") { Query_Condition = this.mQuery_Selection; } else { Query_Source = Bind_TableName; if (Bind_Condition != "") { Query_Condition = "Where " + Bind_Condition; } } if (Query_Source == "") { throw new Exception("Selection Source not set."); } string Query = @"(Select * From " + Query_Source + " " + Query_Condition + @") As [Tb]"; DataTable Dt_List = Do_Methods_Query.GetQuery(Query, "Count(1) As [Ct]", Condition); Int64 Rv = 0; try { Rv = Convert.ToInt64(Do_Methods.IsNull(Dt_List.Rows[0]["Ct"], 0)); } catch { } return(Rv); }
public void Save_ReloadPage() { this.Session.Remove(this.mObjID); Collection PageCollection = new Collection(); PageCollection.Add(true, "IsSave"); this.Session[Layer01_Constants_Web.CnsSession_TmpObj] = PageCollection; this.Session[Layer01_Constants_Web.CnsSession_Keys] = this.mObj_Base.GetKeys(); 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_Details"], ""); } this.Response.Redirect(Url); }
void Details_SelectPdfOthers(string SelectedFile) { System.IO.FileInfo Fi = new System.IO.FileInfo(SelectedFile); this.mObj.pDr["PdfOthers_Path"] = Fi.Name; if ((string)Do_Methods.IsNull(this.mObj.pDr["PdfOthers_Path"], "") == "") { this.Btn_PdfOther.CssClass = Layer01_Constants_Web.CnsCssControlEnabledFalse; this.Btn_PdfOther.Enabled = false; } else { this.Btn_PdfOther.CssClass = Layer01_Constants_Web.CnsCssControlEnabled; this.Btn_PdfOther.Enabled = true; } try { this.EOCbp_PdfOther.Update(); } catch { } }
//[-] protected string Details_PrepareNew() { 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_Details"], ""); } string Override_PageUrl_Details_New = (string)this.ViewState[CnsOverride_PageUrl_Details_New]; if (Override_PageUrl_Details_New != "") { Url = Override_PageUrl_Details_New; } this.Session[Layer01_Constants_Web.CnsSession_Keys] = null; return(Url); }
//[-] protected DataTable List( QueryCondition Condition = null , string Sort = "" , Int64 Top = 0 , Int32 Page = 0) { 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; } if (Sort == "") { Sort = Bind_Sort; } string Query_Table = @"(Select * From " + Source + " " + Query_Condition + " ) As [Tb]"; Interface_DataAccess Da = this.mObj_Base.CreateDataAccess(); //DataTable Dt = Do_Methods_Query.GetQuery(Query_Table, "", Condition, Sort, Top, Page); DataTable Dt = Da.GetQuery(Query_Table, "", Condition, Sort, Top, Page); Da.Close(); return(Dt); }
protected void Page_Load(object sender, EventArgs e) { this.Btn_Logout.Click += Btn_Logout_Click; try { if (this.pMaster.pCurrentUser == null) { return; } if (!this.pMaster.pCurrentUser.pIsLoggedIn) { return; } if (!this.IsPostBack) { this.LoadMenu(); this.Lbl_Name.Text = (string)Do_Methods.IsNull(this.pMaster.pCurrentUser.pDrUser["EmployeeName"], ""); } } catch { } }
public override void Load(Keys Keys = null) { base.Load(Keys); //[-] Int64 ContactPersonID = Convert.ToInt64(Do_Methods.IsNull(this.pDr["ContactPersonID"], 0)); if (ContactPersonID != 0) { Keys = new Keys(); Keys.Add("ContactPersonID", ContactPersonID); } else { Keys = null; } this.mObj_ContactPerson.Load(Keys); //this.mObj_ShippingAddress.Load(Keys, this); //[-] //foreach (DataRow Dr in this.pDt_ShippingAddress.Rows) //{ // ClsAddress Inner_Obj = new ClsAddress(this.mCurrentUser); // Keys Inner_Keys = null; // Int64 Inner_ID = Convert.ToInt64(Do_Methods.IsNull(Dr["AddressID"], 0)); // if (Inner_ID != 0) // { // Inner_Keys = new Keys(); // Inner_Keys.Add("AddressID", Inner_ID); // } // Inner_Obj.Load(Inner_Keys); // this.mBO_ShippingAddress_Address.Add(Convert.ToInt64(Do_Methods.IsNull(Dr["TmpKey"], 0)).ToString(), Inner_Obj); //} }
void BindGrid_Details_Filter() { DataTable Dt_FilterFields = (this.ViewState[CnsDt_FilterFields] != null) ? (DataTable)this.ViewState[CnsDt_FilterFields] : null; string FilterText = ""; DataRow[] ArrDr = Dt_FilterFields.Select("Field = '" + this.Cbo_SearchFilter.SelectedValue + "'"); if (ArrDr.Length > 0) { Type Inner_DataType = Type.GetType(Do_Methods.Convert_String(ArrDr[0]["DataType"])); //FilterText = Do_Methods.PrepareFilterText( // (string)Do_Methods.IsNull(ArrDr[0]["Field"], "") // , (string)Do_Methods.IsNull(ArrDr[0]["DataType"], "") // , this.Txt_Search.Text); FilterText = Do_Methods.PrepareFilterText( (string)Do_Methods.IsNull(ArrDr[0]["Field"], "") , Inner_DataType , this.Txt_Search.Text); } this.UcGrid_Details.pDt_Source.DefaultView.RowFilter = FilterText; }
protected string Details_PrepareOpen(Int64 ID) { 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_Details"], ""); } this.Session[Layer01_Constants_Web.CnsSession_Keys] = null; QueryCondition Qc = new QueryCondition(); Qc.Add(this.mObj_Base.pHeader_TableKey, "=", ID, typeof(Int64).ToString()); Dt = this.List(Qc); if (Dt.Rows.Count > 0) { this.Session[Layer01_Constants_Web.CnsSession_Keys] = this.mObj_Base.GetKeys(Dt.Rows[0]); } return(Url); }
void SetupPage() { DataRow[] ArrDr = this.mObj_ContactPerson.pDt_ContactPerson.Select("TmpKey = " + this.mTmpKey); DataRow Dr_ContactPerson = null; if (ArrDr.Length > 0) { Dr_ContactPerson = ArrDr[0]; } else { this.mTmpKey = 0; } //string Title = ""; if (this.mTmpKey == 0) { //Title = "Add Contact Person"; this.Txt_Position.Text = ""; this.mObj_Person = new ClsPerson(this.mObj_ContactPerson.pCurrentUser); this.mObj_Person.Load(); } else { //Title = "Update Contact Person"; this.Txt_Position.Text = (string)Do_Methods.IsNull(Dr_ContactPerson["Position"], ""); //this.mObj_Person = (ClsPerson)this.mObj_ContactPerson.pBO_ContactPerson_Persons[this.mTmpKey.ToString()]; this.mObj_Person = this.mObj_ContactPerson.pObj_ContactPerson_Details.pObj_Person_Get(this.mTmpKey); } this.UcPerson.Setup(this.mObj_Person); this.Session[this.mObjID + CnsObj_Person] = this.mObj_Person; try { this.EOCbp_Dialog_ContactPerson.Update(); } catch { } }
public static string GetSeriesNo(string Name) { string Rv = ""; DataTable Dt; string TableName; string FieldName; string Prefix; Int32 Digits; Dt = Do_Methods_Query.GetQuery("System_DocumentSeries", "", "ModuleName = '" + Name + "'"); if (Dt.Rows.Count > 0) { TableName = (string)Do_Methods.IsNull(Dt.Rows[0]["TableName"], ""); FieldName = (string)Do_Methods.IsNull(Dt.Rows[0]["FieldName"], ""); Prefix = (string)Do_Methods.IsNull(Dt.Rows[0]["Prefix"], ""); Digits = (Int32)Do_Methods.IsNull(Dt.Rows[0]["Digits"], ""); } else { return(Rv); } List <QueryParameter> Sp = new List <QueryParameter>(); Sp.Add(new QueryParameter("@TableName", TableName)); Sp.Add(new QueryParameter("@FieldName", FieldName)); Sp.Add(new QueryParameter("@Prefix", Prefix)); Sp.Add(new QueryParameter("@Digits", Digits)); Dt = Do_Methods_Query.ExecuteQuery("usp_GetSeriesNo", Sp).Tables[0]; if (Dt.Rows.Count > 0) { Rv = (string)Dt.Rows[0][0]; } return(Rv); }
//[-] void Handle_Selection(DataTable Dt, EO.Web.CallbackEventArgs e, string Data) { Int64 ID = 0; if (Dt.Rows.Count > 0) { ID = (Int64)Do_Methods.IsNull(Dt.Rows[0]["ID"], 0); } System.Text.StringBuilder Sb_Js = new System.Text.StringBuilder(); if (Data == this.Btn_AddItemPart.ID) { this.Details_AddItemPart(Dt); } else if (Data == this.Btn_AddItemLocation.ID) { this.Details_AddItemLocation(Dt); } if (Data == this.Btn_AddItemSupplier.ID) { this.Details_AddItemSupplier(Dt); } }
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 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)); } } }
string Details_TaxCode() { System.Text.StringBuilder Sb_Js = new System.Text.StringBuilder(); Int64 LookupTaxCodeID = 0; try { LookupTaxCodeID = Convert.ToInt64(this.Cbo_TaxCode.SelectedValue); } catch { } DataTable Dt = Do_Methods_Query.GetQuery("LookupTaxCode", "", "LookupTaxCodeID = " + LookupTaxCodeID); if (Dt.Rows.Count > 0) { DataRow Dr = Dt.Rows[0]; Layer01_Methods_Web.Eval_AppendJs(this.Server, ref Sb_Js, this.Lbl_PST_Value.ClientID, "innerHTML", Strings.Format(Do_Methods.IsNull(Dr["PST_Value"], 0), "#,##0.00")); Layer01_Methods_Web.Eval_AppendJs(this.Server, ref Sb_Js, this.Lbl_GST_Value.ClientID, "innerHTML", Strings.Format(Do_Methods.IsNull(Dr["GST_Value"], 0), "#,##0.00")); Layer01_Methods_Web.Eval_AppendJs(this.Server, ref Sb_Js, this.Lbl_HST_Value.ClientID, "innerHTML", Strings.Format(Do_Methods.IsNull(Dr["HST_Value"], 0), "#,##0.00")); } return(Sb_Js.ToString()); }
bool Save_Validation(ref System.Text.StringBuilder Sb_Msg) { WebControl Wc; bool IsValid = true; this.Txt_Code.CssClass = Layer01_Constants_Web.CnsCssTextbox; if (this.Txt_Code.Text.Trim() == "") { this.Txt_Code.Text = Layer02_Common.GetSeriesNo("Customer"); } Wc = this.Txt_Code; Layer01_Methods_Web.Save_Validation( ref Sb_Msg , ref Wc , ref IsValid , Layer01_Constants_Web.CnsCssTextbox , Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight , Layer02_Common.CheckSeriesDuplicate("uvw_Customer", "CustomerCode", this.mObj.GetKeys(), this.Txt_Code.Text) , "Duplicate Customer ID found. Please change the Customer ID. <br />"); Int64 LookupClientTypeID = Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["LookupClientTypeID"], 0)); DataTable Dt = Do_Methods_Query.GetQuery("LookupClientType", "", "LookupClientTypeID = " + LookupClientTypeID.ToString()); if (Dt.Rows.Count > 0) { DataRow Dr_ClientType = Dt.Rows[0]; if ((bool)Do_Methods.IsNull(Dr_ClientType["IsCurrency"], false)) { Wc = this.Cbo_Currency; Layer01_Methods_Web.Save_Validation( ref Sb_Msg , ref Wc , ref IsValid , Layer01_Constants_Web.CnsCssTextbox , Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight , (Convert.ToInt64(this.Cbo_Currency.SelectedValue) == 0) , "Currency is required. <br />"); } if ((bool)Do_Methods.IsNull(Dr_ClientType["IsCreditCard_AccountName"], false)) { Wc = this.Txt_CreditCard_AccountName; Layer01_Methods_Web.Save_Validation( ref Sb_Msg , ref Wc , ref IsValid , Layer01_Constants_Web.CnsCssTextbox , Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight , (this.Txt_CreditCard_AccountName.Text == "") , "Account Name is required. <br />"); } if ((bool)Do_Methods.IsNull(Dr_ClientType["IsCreditCard"], false)) { bool Inner_IsValid = true; this.Txt_CreditCard_Part1.CssClass = Layer01_Constants_Web.CnsCssTextbox; this.Txt_CreditCard_Part2.CssClass = Layer01_Constants_Web.CnsCssTextbox; this.Txt_CreditCard_Part3.CssClass = Layer01_Constants_Web.CnsCssTextbox; this.Txt_CreditCard_Part4.CssClass = Layer01_Constants_Web.CnsCssTextbox; if (this.Txt_CreditCard_Part1.Text.Trim() == "") { Inner_IsValid = false; } if (this.Txt_CreditCard_Part2.Text.Trim() == "") { Inner_IsValid = false; } if (this.Txt_CreditCard_Part3.Text.Trim() == "") { Inner_IsValid = false; } if (this.Txt_CreditCard_Part4.Text.Trim() == "") { Inner_IsValid = false; } if (!Inner_IsValid) { IsValid = false; this.Txt_CreditCard_Part1.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCard_Part2.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCard_Part3.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCard_Part4.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; Sb_Msg.Append("Credit Card is required. <br />"); } } Int32 CreditCardExpiration_Month = 0; Int32 CreditCardExpiration_Year = 0; try { Int32.TryParse(this.Txt_CreditCardExpiration_Month.Text, out CreditCardExpiration_Month); if (this.Txt_CreditCardExpiration_Year.Text.Trim() != "") { Int32.TryParse("20" + this.Txt_CreditCardExpiration_Year.Text, out CreditCardExpiration_Year); } } catch { } this.Txt_CreditCardExpiration_Month.CssClass = Layer01_Constants_Web.CnsCssTextbox; this.Txt_CreditCardExpiration_Year.CssClass = Layer01_Constants_Web.CnsCssTextbox; if (! (this.Txt_CreditCardExpiration_Month.Text.Trim() == "" || this.Txt_CreditCardExpiration_Year.Text.Trim() == "")) { DateTime Inner_DateTime; try { Inner_DateTime = new DateTime(CreditCardExpiration_Year, CreditCardExpiration_Month, 1); if (Inner_DateTime < DateTime.Now) { IsValid = false; this.Txt_CreditCardExpiration_Month.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCardExpiration_Year.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; Sb_Msg.Append("Credit Card Date Expiry must be earlier than today. <br />"); } } catch { IsValid = false; this.Txt_CreditCardExpiration_Month.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCardExpiration_Year.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; Sb_Msg.Append("Credit Card Date Expiry is incorrect. <br />"); } } if ((bool)Do_Methods.IsNull(Dr_ClientType["IsCreditCard_Expiration"], false)) { if (this.Txt_CreditCardExpiration_Month.Text.Trim() == "" || this.Txt_CreditCardExpiration_Year.Text.Trim() == "") { IsValid = false; this.Txt_CreditCardExpiration_Month.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; this.Txt_CreditCardExpiration_Year.CssClass = Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight; Sb_Msg.Append("Credit Card Date Expiry is required. <br />"); } } if ((bool)Do_Methods.IsNull(Dr_ClientType["IsPaymentTerm"], false)) { Wc = this.Cbo_PaymentTerm; Layer01_Methods_Web.Save_Validation( ref Sb_Msg , ref Wc , ref IsValid , Layer01_Constants_Web.CnsCssTextbox , Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight , (Convert.ToInt64(this.Cbo_PaymentTerm.SelectedValue) == 0) , "Payment Term is required. <br />"); } if ((bool)Do_Methods.IsNull(Dr_ClientType["IsTaxCode"], false)) { Wc = this.Cbo_TaxCode; Layer01_Methods_Web.Save_Validation( ref Sb_Msg , ref Wc , ref IsValid , Layer01_Constants_Web.CnsCssTextbox , Layer01_Constants_Web.CnsCssTextbox_ValidateHighlight , (Convert.ToInt64(this.Cbo_TaxCode.SelectedValue) == 0) , "Tax Code is required. <br />"); } } return(IsValid); }
public void Setup( string Name , DataTable Dt , string Key = "" , bool AllowSort = false , bool HasDelete = false , bool IsReadOnly = false) { ClsSysCurrentUser Obj_CurrentUser = (ClsSysCurrentUser)this.Session[Layer01_Constants_Web.CnsSession_CurrentUser]; this.mObjID = Obj_CurrentUser.GetNewPageObjectID(); this.mDt_Source = Dt; this.ViewState[CnsObjID] = this.mObjID; this.Session[this.mObjID + CnsDt_Source] = this.mDt_Source; //[-] DataRow Dr_Bind = Do_Methods_Query.GetSystemBindDefinition(Name); string Bind_TableKey = (string)Do_Methods.IsNull(Dr_Bind["TableKey"], ""); List <ClsBindGridColumn_EO> List_Gc = Layer01_Methods_Web_EO.GetBindGridColumn_EO(Name); foreach (ClsBindGridColumn_EO Gc in List_Gc) { if (Gc.mEnabled) { Gc.mEnabled = !IsReadOnly; } } if (!IsReadOnly) { if (HasDelete) { ClsBindGridColumn_EO Gc = new ClsBindGridColumn_EO( "" , "" , 80 , "" , Layer01_Common.Common.Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Delete); Gc.mFieldText = "Delete"; Gc.mClientSideBeginEdit = "EOGrid_RowEdit"; List_Gc.Add(Gc); } } if (Key.Trim() == "") { Key = Bind_TableKey; } this.EOGrid_List.EnableKeyboardNavigation = true; this.EOGrid_List.StyleSetIDField = "Item_Style"; Layer01_Methods_Web_EO.BindEOGrid(ref this.EOGrid_List, Dt, List_Gc, Key, AllowSort); this.ViewState[CnsKey] = Key; this.ViewState[CnsHasDelete] = HasDelete; //[-] this.Page_Load(null, null); }
void EOCb_View_Execute(object sender, EO.Web.CallbackEventArgs e) { string Url = ""; if (e.Parameter == this.Btn_PdfDesc.ID) { Url = Layer01_Constants_Web.CnsPdfPath + HttpUtility.UrlPathEncode((string)Do_Methods.IsNull(this.mObj.pDr["PdfDesc_Path"], "")); } else if (e.Parameter == this.Btn_PdfFaq.ID) { Url = Layer01_Constants_Web.CnsPdfPath + HttpUtility.UrlPathEncode((string)Do_Methods.IsNull(this.mObj.pDr["PdfFaq_Path"], "")); } else if (e.Parameter == this.Btn_PdfFaq.ID) { Url = Layer01_Constants_Web.CnsPdfPath + HttpUtility.UrlPathEncode((string)Do_Methods.IsNull(this.mObj.pDr["PdfOthers_Path"], "")); } else if (e.Parameter == this.Btn_ViewImage.ID) { Url = Layer01_Constants_Web.CnsImagePath + HttpUtility.UrlPathEncode((string)Do_Methods.IsNull(this.mObj.pDr["Image_Path"], "")); } e.Data = this.Page.ResolveUrl(Url); }
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)); } } } }
public static void PostEOGrid( ref EO.Web.Grid EOGrid , DataTable Dt , string KeyField , bool HasDelete = true) { DataTable Dt_DeletedKeys = new DataTable(); Dt_DeletedKeys.Columns.Add("Key", typeof(Int64)); List <Int64> List_DeletedKeys = new List <long>(); foreach (EO.Web.GridItem Gi in EOGrid.Items) { Int64 Key = (Int64)Do_Methods.IsNull(Gi.Key, 0); DataRow[] ArrDr = Dt.Select(KeyField + " = " + Key); DataRow Dr; if (Gi.Deleted) { if (Key > 0) { List_DeletedKeys.Add(Key); } continue; } if (ArrDr.Length > 0) { Dr = ArrDr[0]; } else { Int64 Ct = 0; DataRow[] Inner_ArrDr = Dt.Select("", KeyField + " Desc"); if (Inner_ArrDr.Length > 0) { Ct = (Int64)Inner_ArrDr[0][KeyField]; } Ct++; Dr = Dt.NewRow(); Dr[KeyField] = Ct; Dt.Rows.Add(Dr); } foreach (EO.Web.GridCell Cell in Gi.Cells) { if (Cell.Column.ReadOnly) { continue; } if (Cell.Column.Name == null) { continue; } if (Cell.Column.Name == "") { continue; } try { Dr[Cell.Column.DataField] = Cell.Value; } catch { Dr[Cell.Column.DataField] = DBNull.Value; } } } if (HasDelete) { foreach (Int64 Key in List_DeletedKeys) { DataRow[] ArrDr = Dt.Select(KeyField + " = " + Key); if (ArrDr.Length > 0) { ArrDr[0].Delete(); } } } }
//[-] public static void AddSelected( DataTable Dt_Target , DataTable Dt_Selected , string Query_Selected_Source , string Query_Selected_Key , string Target_Key , List <Str_AddSelectedFields> Obj_Fields = null , List <Str_AddSelectedFieldsDefault> Obj_FieldsDefault = null) { if (!(Dt_Selected.Rows.Count > 0)) { return; } PreparedQuery Pq = Do_Methods.CreateDataAccess().CreatePreparedQuery(); Pq.pQuery = @"Select * From " + Query_Selected_Source + @" Where " + Query_Selected_Key + @" = @ID"; Pq.Add_Parameter("ID", Do_Constants.eParameterType.Long); Pq.Prepare(); foreach (DataRow Dr_Selected in Dt_Selected.Rows) { //Pq.pParameters["ID"].Value = (Int64)Do_Methods.IsNull(Dr_Selected["ID"], 0); Pq.pParameter_Set("ID", Do_Methods.Convert_Int64(Dr_Selected["ID"])); DataTable Inner_Dt_Selected = Pq.ExecuteQuery().Tables[0]; if (Inner_Dt_Selected.Rows.Count > 0) { DataRow Inner_Dr_Selected = Inner_Dt_Selected.Rows[0]; DataRow[] Inner_ArrDr; DataRow Inner_Dr_Target = null; bool Inner_IsFound = false; Inner_ArrDr = Dt_Target.Select(Target_Key + " = " + Convert.ToInt64(Inner_Dr_Selected[Query_Selected_Key])); if (Inner_ArrDr.Length > 0) { Inner_Dr_Target = Inner_ArrDr[0]; if ((bool)Do_Methods.IsNull(Inner_Dr_Target["IsDeleted"], false)) { Inner_Dr_Target["IsDeleted"] = DBNull.Value; Inner_IsFound = true; } } if (!Inner_IsFound) { Int64 Ct = 0; Inner_ArrDr = Dt_Target.Select("", "TmpKey Desc"); if (Inner_ArrDr.Length > 0) { Ct = (Int64)Inner_ArrDr[0]["TmpKey"]; } Ct++; DataRow Nr = Dt_Target.NewRow(); Nr["TmpKey"] = Ct; Nr["Item_Style"] = ""; Nr[Target_Key] = (Int64)Inner_Dr_Selected[Query_Selected_Key]; Dt_Target.Rows.Add(Nr); Inner_Dr_Target = Nr; } if (Obj_Fields != null) { foreach (Str_AddSelectedFields Inner_Obj in Obj_Fields) { Inner_Dr_Target[Inner_Obj.Field_Target] = Inner_Dr_Selected[Inner_Obj.Field_Selected]; } } if (Obj_FieldsDefault != null) { foreach (Str_AddSelectedFieldsDefault Inner_Obj in Obj_FieldsDefault) { Inner_Dr_Target[Inner_Obj.Field_Target] = Inner_Obj.Value; } } } } }
public bool Save(eSaveAction SaveAction = eSaveAction.Save) { bool IsSave = false; if (this.mCurrentUser == null) { throw new Exception("User is not initialized"); } Interface_DataAccess Da = this.mDa; try { Da.Connect(); Da.BeginTransaction(); DateTime ServerDate = Layer02_Common.GetServerDate(Da); switch (SaveAction) { case eSaveAction.Save: if ((bool)Do_Methods.IsNull(this.mHeader_Dr["IsCancelled"], false)) { throw new Exception("Document is already cancelled."); } if ((bool)Do_Methods.IsNull(this.mHeader_Dr["IsPosted"], false)) { throw new Exception("Document is already posted."); } break; case eSaveAction.Post: if ((bool)Do_Methods.IsNull(this.mHeader_Dr["IsPosted"], false)) { throw new Exception("Document is already posted."); } this.mHeader_Dr["IsPosted"] = true; this.mHeader_Dr["DatePosted"] = ServerDate; this.mHeader_Dr["EmployeeID_PostedBy"] = this.mCurrentUser.pDrUser["EmployeeID"]; break; case eSaveAction.Cancel: if ((bool)Do_Methods.IsNull(this.mHeader_Dr["IsCancelled"], false)) { throw new Exception("Document is already cancelled."); } this.mHeader_Dr["IsCancelled"] = true; this.mHeader_Dr["DateCancelled"] = ServerDate; this.mHeader_Dr["EmployeeID_CancelledBy"] = this.mCurrentUser.pDrUser["EmployeeID"]; break; } Da.SaveDataRow(this.mHeader_Dr, this.mHeader_TableName); Da.CommitTransaction(); IsSave = true; } catch (Exception ex) { Da.RollbackTransaction(); throw ex; } finally { Da.Close(); } return(IsSave); }
void SetupPage() { this.SetupPage_ControlAttributes(); this.SetupPage_Lookups(); //[-] this.Txt_ItemCode.Text = Do_Methods.Convert_String(this.mObj.pDr_RowProperty["Code"]); this.Txt_ItemName.Text = Do_Methods.Convert_String(this.mObj.pDr_RowProperty["Name"]); this.Txt_Remarks.Text = Do_Methods.Convert_String(this.mObj.pDr_RowProperty["Remarks"]); this.Txt_Warranty.Text = Do_Methods.Convert_String(this.mObj.pDr["Warranty"]); this.Chk_IsSerial.Checked = Do_Methods.Convert_Boolean(this.mObj.pDr["IsSerial"]); this.Txt_Length.Text = Do_Methods.Convert_Double(this.mObj.pDr["Size_Length"]).ToString("#,##0.0000"); this.Txt_Width.Text = Do_Methods.Convert_Double(this.mObj.pDr["Size_Width"]).ToString("#,##0.0000"); this.Txt_Height.Text = Do_Methods.Convert_Double(this.mObj.pDr["Size_Height"]).ToString("#,##0.0000"); this.Txt_Weight.Text = Do_Methods.Convert_Double(this.mObj.pDr["Size_Weight"]).ToString("#,##0.0000"); this.Txt_FloorLevel.Text = Do_Methods.Convert_Int64(this.mObj.pDr["Inv_FloorLevel"]).ToString("#,##0"); this.Txt_CeilingLevel.Text = Do_Methods.Convert_Int64(this.mObj.pDr["Inv_CeilingLevel"]).ToString("#,##0"); this.Txt_ReorderLevel.Text = Do_Methods.Convert_Int64(this.mObj.pDr["Inv_ReorderLevel"]).ToString("#,##0"); this.Txt_EstimatedCost.Text = Do_Methods.Convert_Double(this.mObj.pDr["Cost"]).ToString("#,##0.00"); this.Txt_ListPrice.Text = Do_Methods.Convert_Double(this.mObj.pDr["Price"], 0).ToString("#,##0.00"); bool IsImageFile = false; if ((string)Do_Methods.IsNull(this.mObj.pDr["Image_Path"], "") != "") { IsImageFile = true; System.IO.FileInfo Fi_Thumb = new System.IO.FileInfo( this.MapPath(Layer01_Constants_Web.CnsImageThumbPath + "Thumb_" + (string)Do_Methods.IsNull(this.mObj.pDr["Image_Path"], ""))); if (!Fi_Thumb.Exists) { try { Layer01_Methods_Web.ImageThumbnail( this.MapPath(Layer01_Constants_Web.CnsImageThumbPath + (string)Do_Methods.IsNull(this.mObj.pDr["Image_Path"], "")) , Fi_Thumb.FullName); } catch { IsImageFile = false; } } this.Img_Box.ImageUrl = Layer01_Constants_Web.CnsImageThumbPath + "Thumb_" + (string)Do_Methods.IsNull(this.mObj.pDr["Image_Path"], ""); this.Btn_ViewImage.Visible = true; } if (!IsImageFile) { this.Img_Box.ImageUrl = "~/System/Images/QuestionMark001.jpg"; this.Btn_ViewImage.Visible = false; } if ((string)Do_Methods.IsNull(this.mObj.pDr["PdfDesc_Path"], "") == "") { this.Btn_PdfDesc.CssClass = Layer01_Constants_Web.CnsCssControlEnabledFalse; this.Btn_PdfDesc.Enabled = false; } else { this.Btn_PdfDesc.CssClass = Layer01_Constants_Web.CnsCssControlEnabled; this.Btn_PdfDesc.Enabled = true; } if ((string)Do_Methods.IsNull(this.mObj.pDr["PdfFaq_Path"], "") == "") { this.Btn_PdfFaq.CssClass = Layer01_Constants_Web.CnsCssControlEnabledFalse; this.Btn_PdfFaq.Enabled = false; } else { this.Btn_PdfFaq.CssClass = Layer01_Constants_Web.CnsCssControlEnabled; this.Btn_PdfFaq.Enabled = true; } if ((string)Do_Methods.IsNull(this.mObj.pDr["PdfOthers_Path"], "") == "") { this.Btn_PdfOther.CssClass = Layer01_Constants_Web.CnsCssControlEnabledFalse; this.Btn_PdfOther.Enabled = false; } else { this.Btn_PdfOther.CssClass = Layer01_Constants_Web.CnsCssControlEnabled; this.Btn_PdfOther.Enabled = true; } DataTable Dt_Defaults = Do_Methods_Query.GetQuery("uvw_Lookup"); this.Cbo_Category.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_Category"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.Category))).ToString(); this.Cbo_ItemType.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_ItemType"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.ItemType))).ToString(); this.Cbo_Brand.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_Brand"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.Brand))).ToString(); this.Cbo_Retailer.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_Category"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.Retailer))).ToString(); this.Cbo_ItemUOM.SelectedValue = ((Int64)Do_Methods.IsNull(this.mObj.pDr["LookupID_ItemUOM"], this.SetupPage_GetLookupDefault(Dt_Defaults, Layer01_Constants.eLookup.UOM))).ToString(); //[-] this.UcGrid_ItemPart.Setup( "Item_Part" , this.mObj.pDt_Part , "TmpKey" , false , true , this.mMaster.pIsReadOnly); this.UcGrid_ItemPart.pGrid.FullRowMode = false; this.UcGrid_ItemLocation.Setup( "Item_Location" , this.mObj.pDt_Location , "TmpKey" , false , true , this.mMaster.pIsReadOnly); this.UcGrid_ItemLocation.pGrid.FullRowMode = false; this.UcGrid_ItemSupplier.Setup( "Item_Supplier" , this.mObj.pDt_Supplier , "TmpKey" , false , true , this.mMaster.pIsReadOnly); this.UcGrid_ItemSupplier.pGrid.FullRowMode = false; DataTable Dt = Do_Methods_Query.GetQuery( "uvw_Materialized_InventoryWarehouse_Current_Item" , "" , "ItemID = " + Convert.ToInt64(Do_Methods.IsNull(this.mObj.pDr["ItemID"], 0)).ToString() , "WarehouseCodeName"); this.mObj.AddRequired(Dt); this.UcGrid_OnHand.Setup("Item_Inventory", Dt); this.UcGrid_OnHand.pGrid.FullRowMode = false; }