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