///<summary> ///Get conditions by object with Multi-TokenType. ///</summary> public static ParameterCollection GetConditionsByObject(DO_Goods_lable.UO_Goods_lable parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Goods_lable.Columns, TokenTypes> extTokens) { ParameterCollection objectConditions = new ParameterCollection(); TokenTypes tt = tokenTypes; ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or; if (parameterObj.lableid != 0 || (extTokens != null && extTokens.ContainsKey(DO_Goods_lable.Columns.lableid))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lableid,extTokens), DO_Goods_lable.Columns.lableid,parameterObj.lableid); } if (parameterObj.merchantid != 0 || (extTokens != null && extTokens.ContainsKey(DO_Goods_lable.Columns.merchantid))) { objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.merchantid,extTokens), DO_Goods_lable.Columns.merchantid,parameterObj.merchantid); } if (!string.IsNullOrEmpty(parameterObj.lablename)) { objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lablename,extTokens), DO_Goods_lable.Columns.lablename,parameterObj.lablename); } if (!string.IsNullOrEmpty(parameterObj.lablecolor)) { objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.lablecolor,extTokens), DO_Goods_lable.Columns.lablecolor,parameterObj.lablecolor); } if (!string.IsNullOrEmpty(parameterObj.addTime)) { objectConditions.AddCondition(pt, GetColumnTokenType(tt,DO_Goods_lable.Columns.addTime,extTokens), DO_Goods_lable.Columns.addTime,parameterObj.addTime); } return objectConditions; }
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_Goods_lable.GetObjectById(id); } if (UO == null) UO = new DO_Goods_lable.UO_Goods_lable(); if (Request.Form.Keys.Count > 0) { GetTogether.Web.WebHelper.SetValues<DO_Goods_lable.UO_Goods_lable>(UO, "Goods_lable_"); 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_Goods_lable.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("Goods_lable.aspx"); } }
private void GetList() { Database_Output_Goods_lable_Result c = (Database_Output_Goods_lable_Result)Page.LoadControl("Goods_lable_Result.ascx"); DO_Goods_lable.UO_Goods_lable l = new DO_Goods_lable.UO_Goods_lable(); GetTogether.Web.WebHelper.SetValues <DO_Goods_lable.UO_Goods_lable>(l, "Goods_lable_"); if (string.IsNullOrEmpty(Sort)) { Sort = DO_Goods_lable.Columns.lableid.ToString(); } PagingResult <DO_Goods_lable.UO_Goods_lable, DO_Goods_lable.UOList_Goods_lable> resultPaging = BO_Goods_lable.GetPagingList(l, PageIndex, PageSize, Sort, IsAsc); c.JsFunction = "Goods_lable_Search"; c.SetData <DO_Goods_lable.UO_Goods_lable, DO_Goods_lable.UOList_Goods_lable>(resultPaging.Result); c.Total = resultPaging.Total; c.Sort = Sort; c.PageIndex = PageIndex; c.PageSize = PageSize; c.IsAsc = IsAsc; this.Controls.Add(c); }
///<summary> ///Get list by object. ///</summary> public static DO_Goods_lable.UOList_Goods_lable GetList(DO_Goods_lable.UO_Goods_lable parameterObj) { return GetList(parameterObj, true, TokenTypes.Equal, null); }
///<summary> ///Get list by object. ///</summary> public static DO_Goods_lable.UOList_Goods_lable GetList(DO_Goods_lable.UO_Goods_lable parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Goods_lable.Columns, TokenTypes> extTokens) { return parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens)); }
///<summary> ///Get records count. ///</summary> public static int GetRecordsCount(DO_Goods_lable.UO_Goods_lable parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<DO_Goods_lable.Columns, TokenTypes> extTokens) { DO_Goods_lable da = new DO_Goods_lable(); return da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens)); }
///<summary> ///Get records count. ///</summary> public static int GetRecordsCount(DO_Goods_lable.UO_Goods_lable parameterObj) { return GetRecordsCount(parameterObj, true, TokenTypes.Equal,null); }
///<summary> ///Update object by primary key string(with transation). ///</summary> public static bool UpdateObjectByPrimaryKeyString(DO_Goods_lable.UO_Goods_lable 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_Goods_lable.UO_Goods_lable obj, string primaryKeyString) { return(obj.Update(GetConditionsByPrimaryKeyString(primaryKeyString)) > 0); }
///<summary> ///Update object by primary key(with transation). ///</summary> public static bool UpdateObject(DO_Goods_lable.UO_Goods_lable obj, System.Int32 lableid, IDbConnection connection, IDbTransaction transaction) { return(obj.Update(connection, transaction, GetConditionsByPrimaryKey(lableid)) > 0); }
///<summary> ///Update object by primary key. ///</summary> public static bool UpdateObject(DO_Goods_lable.UO_Goods_lable obj, System.Int32 lableid) { return(obj.Update(GetConditionsByPrimaryKey(lableid)) > 0); }
///<summary> ///Get paging list. ///</summary> public static PagingResult <DO_Goods_lable.UO_Goods_lable, DO_Goods_lable.UOList_Goods_lable> GetPagingList(DO_Goods_lable.UO_Goods_lable 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_Goods_lable.UO_Goods_lable, DO_Goods_lable.UOList_Goods_lable> GetPagingList(DO_Goods_lable.UO_Goods_lable parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_Goods_lable.Columns, TokenTypes> extTokens) { return(parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens), pageNumber, pageSize, sortBy, isAsc)); }