///<summary> ///Get conditions by object with Multi-TokenType. ///</summary> public static ParameterCollection GetConditionsByObject(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareMarkupMode.Columns, TokenTypes> extTokens) { ParameterCollection objectConditions = new ParameterCollection(); TokenTypes tt = tokenTypes; ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or; if (parameterObj.ID != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.ID))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.ID, extTokens), DO_AirfareMarkupMode.Columns.ID, parameterObj.ID); } if (parameterObj.DetailId != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.DetailId))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.DetailId, extTokens), DO_AirfareMarkupMode.Columns.DetailId, parameterObj.DetailId); } if (parameterObj.Rank != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Rank))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Rank, extTokens), DO_AirfareMarkupMode.Columns.Rank, parameterObj.Rank); } if (parameterObj.MarkupBy != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.MarkupBy))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.MarkupBy, extTokens), DO_AirfareMarkupMode.Columns.MarkupBy, parameterObj.MarkupBy); } if (parameterObj.Amount != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Amount))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Amount, extTokens), DO_AirfareMarkupMode.Columns.Amount, parameterObj.Amount); } if (parameterObj.Rate != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.Rate))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Rate, extTokens), DO_AirfareMarkupMode.Columns.Rate, parameterObj.Rate); } if (parameterObj.RoundUpBy != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.RoundUpBy))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.RoundUpBy, extTokens), DO_AirfareMarkupMode.Columns.RoundUpBy, parameterObj.RoundUpBy); } if (!string.IsNullOrEmpty(parameterObj.MarkupByValue)) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.MarkupByValue, extTokens), DO_AirfareMarkupMode.Columns.MarkupByValue, parameterObj.MarkupByValue); } if (!string.IsNullOrEmpty(parameterObj.Description)) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.Description, extTokens), DO_AirfareMarkupMode.Columns.Description, parameterObj.Description); } if (parameterObj.AirfareMarkupModeType != 0 || (extTokens != null && extTokens.ContainsKey(DO_AirfareMarkupMode.Columns.AirfareMarkupModeType))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_AirfareMarkupMode.Columns.AirfareMarkupModeType, extTokens), DO_AirfareMarkupMode.Columns.AirfareMarkupModeType, parameterObj.AirfareMarkupModeType); } return(objectConditions); }
private void GetList() { Database_Output_AirfareMarkupMode_Result c = (Database_Output_AirfareMarkupMode_Result)Page.LoadControl("AirfareMarkupMode_Result.ascx"); DO_AirfareMarkupMode.UO_AirfareMarkupMode l = new DO_AirfareMarkupMode.UO_AirfareMarkupMode(); GetTogether.Web.WebHelper.SetValues <DO_AirfareMarkupMode.UO_AirfareMarkupMode>(l, "AirfareMarkupMode_"); if (string.IsNullOrEmpty(Sort)) { Sort = DO_AirfareMarkupMode.Columns.ID.ToString(); } PagingResult <DO_AirfareMarkupMode.UO_AirfareMarkupMode, DO_AirfareMarkupMode.UOList_AirfareMarkupMode> resultPaging = BO_AirfareMarkupMode.GetPagingList(l, PageIndex, PageSize, Sort, IsAsc); c.JsFunction = "AirfareMarkupMode_Search"; c.SetData <DO_AirfareMarkupMode.UO_AirfareMarkupMode, DO_AirfareMarkupMode.UOList_AirfareMarkupMode>(resultPaging.Result); c.Total = resultPaging.Total; c.Sort = Sort; c.PageIndex = PageIndex; c.PageSize = PageSize; c.IsAsc = IsAsc; this.Controls.Add(c); }
protected void Page_Load(object sender, EventArgs e) { Int32 id = 0; if (!string.IsNullOrEmpty(Request["id"])) { id = Convert.ToInt32(Request["id"]); } if (id > 0) { UO = BO_AirfareMarkupMode.GetObjectById(id); } if (UO == null) { UO = new DO_AirfareMarkupMode.UO_AirfareMarkupMode(); } if (Request.Form.Keys.Count > 0) { GetTogether.Web.WebHelper.SetValues <DO_AirfareMarkupMode.UO_AirfareMarkupMode>(UO, "AirfareMarkupMode_"); if (id > 0) { //Pending UO["UpdateOn", "yyyy-MM-dd"] = DateTime.Now.ToString("yyyy-MM-dd"); UO["UpdateBy"] = string.Concat("WS-", Request.UserHostAddress); UO.Update(BO_AirfareMarkupMode.GetConditionsById(id)); } else { //Pending UO["CreateOn", "yyyy-MM-dd"] = DateTime.Now.ToString("yyyy-MM-dd"); UO["CreateBy"] = string.Concat("WS-", Request.UserHostAddress); UO.Insert(); } Response.Redirect("AirfareMarkupMode.aspx"); } }
///<summary> ///Update object by primary key string(with transation). ///</summary> public static bool UpdateObjectByPrimaryKeyString(DO_AirfareMarkupMode.UO_AirfareMarkupMode obj, string primaryKeyString, IDbConnection connection, IDbTransaction transaction) { return(obj.Update(connection, transaction, GetConditionsByPrimaryKeyString(primaryKeyString)) > 0); }
///<summary> ///Update object by primary key string. ///</summary> public static bool UpdateObjectByPrimaryKeyString(DO_AirfareMarkupMode.UO_AirfareMarkupMode obj, string primaryKeyString) { return(obj.Update(GetConditionsByPrimaryKeyString(primaryKeyString)) > 0); }
///<summary> ///Update object by primary key(with transation). ///</summary> public static bool UpdateObject(DO_AirfareMarkupMode.UO_AirfareMarkupMode obj, System.Int32 ID, IDbConnection connection, IDbTransaction transaction) { return(obj.Update(connection, transaction, GetConditionsByPrimaryKey(ID)) > 0); }
///<summary> ///Update object by primary key. ///</summary> public static bool UpdateObject(DO_AirfareMarkupMode.UO_AirfareMarkupMode obj, System.Int32 ID) { return(obj.Update(GetConditionsByPrimaryKey(ID)) > 0); }
///<summary> ///Get paging list. ///</summary> public static PagingResult <DO_AirfareMarkupMode.UO_AirfareMarkupMode, DO_AirfareMarkupMode.UOList_AirfareMarkupMode> GetPagingList(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc) { return(parameterObj.GetPagingList(GetConditionsByObject(parameterObj, true, TokenTypes.Like, null), pageNumber, pageSize, sortBy, isAsc)); }
///<summary> ///Get paging list. ///</summary> public static PagingResult <DO_AirfareMarkupMode.UO_AirfareMarkupMode, DO_AirfareMarkupMode.UOList_AirfareMarkupMode> GetPagingList(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareMarkupMode.Columns, TokenTypes> extTokens) { return(parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens), pageNumber, pageSize, sortBy, isAsc)); }
///<summary> ///Get list by object. ///</summary> public static DO_AirfareMarkupMode.UOList_AirfareMarkupMode GetList(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj) { return(GetList(parameterObj, true, TokenTypes.Equal, null)); }
///<summary> ///Get list by object. ///</summary> public static DO_AirfareMarkupMode.UOList_AirfareMarkupMode GetList(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareMarkupMode.Columns, TokenTypes> extTokens) { return(parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens))); }
///<summary> ///Get records count. ///</summary> public static int GetRecordsCount(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_AirfareMarkupMode.Columns, TokenTypes> extTokens) { DO_AirfareMarkupMode da = new DO_AirfareMarkupMode(); return(da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens))); }
///<summary> ///Get records count. ///</summary> public static int GetRecordsCount(DO_AirfareMarkupMode.UO_AirfareMarkupMode parameterObj) { return(GetRecordsCount(parameterObj, true, TokenTypes.Equal, null)); }