private void GetList()
{
Database_Output_SaleShop_Member_Result c = (Database_Output_SaleShop_Member_Result)Page.LoadControl("SaleShop_Member_Result.ascx");
DO_SaleShop_Member.UO_SaleShop_Member l = new DO_SaleShop_Member.UO_SaleShop_Member();
GetTogether.Web.WebHelper.SetValues <DO_SaleShop_Member.UO_SaleShop_Member>(l, "SaleShop_Member_");
if (string.IsNullOrEmpty(Sort))
{
Sort = DO_SaleShop_Member.Columns.UId.ToString();
}
PagingResult <DO_SaleShop_Member.UO_SaleShop_Member, DO_SaleShop_Member.UOList_SaleShop_Member> resultPaging = BO_SaleShop_Member.GetPagingList(l, PageIndex, PageSize, Sort, IsAsc);
c.JsFunction = "SaleShop_Member_Search";
c.SetData <DO_SaleShop_Member.UO_SaleShop_Member, DO_SaleShop_Member.UOList_SaleShop_Member>(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_SaleShop_Member.GetObjectById(id);
}
if (UO == null)
{
UO = new DO_SaleShop_Member.UO_SaleShop_Member();
}
if (Request.Form.Keys.Count > 0)
{
GetTogether.Web.WebHelper.SetValues <DO_SaleShop_Member.UO_SaleShop_Member>(UO, "SaleShop_Member_");
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_SaleShop_Member.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("SaleShop_Member.aspx");
}
}
///<summary>
///Update object by primary key string(with transation).
///</summary>
public static bool UpdateObjectByPrimaryKeyString(DO_SaleShop_Member.UO_SaleShop_Member 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_SaleShop_Member.UO_SaleShop_Member obj, string primaryKeyString)
{
return(obj.Update(GetConditionsByPrimaryKeyString(primaryKeyString)) > 0);
}
///<summary>
///Update object by primary key(with transation).
///</summary>
public static bool UpdateObject(DO_SaleShop_Member.UO_SaleShop_Member obj, System.Int32 UId, IDbConnection connection, IDbTransaction transaction)
{
return(obj.Update(connection, transaction, GetConditionsByPrimaryKey(UId)) > 0);
}
///<summary>
///Update object by primary key.
///</summary>
public static bool UpdateObject(DO_SaleShop_Member.UO_SaleShop_Member obj, System.Int32 UId)
{
return(obj.Update(GetConditionsByPrimaryKey(UId)) > 0);
}
///<summary>
///Get paging list.
///</summary>
public static PagingResult <DO_SaleShop_Member.UO_SaleShop_Member, DO_SaleShop_Member.UOList_SaleShop_Member> GetPagingList(DO_SaleShop_Member.UO_SaleShop_Member 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_SaleShop_Member.UO_SaleShop_Member, DO_SaleShop_Member.UOList_SaleShop_Member> GetPagingList(DO_SaleShop_Member.UO_SaleShop_Member parameterObj, int pageNumber, int pageSize, string sortBy, bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_Member.Columns, TokenTypes> extTokens)
{
return(parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens), pageNumber, pageSize, sortBy, isAsc));
}
///<summary>
///Get list by object.
///</summary>
public static DO_SaleShop_Member.UOList_SaleShop_Member GetList(DO_SaleShop_Member.UO_SaleShop_Member parameterObj)
{
return(GetList(parameterObj, true, TokenTypes.Equal, null));
}
///<summary>
///Get list by object.
///</summary>
public static DO_SaleShop_Member.UOList_SaleShop_Member GetList(DO_SaleShop_Member.UO_SaleShop_Member parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_Member.Columns, TokenTypes> extTokens)
{
return(parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens)));
}
///<summary>
///Get records count.
///</summary>
public static int GetRecordsCount(DO_SaleShop_Member.UO_SaleShop_Member parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_Member.Columns, TokenTypes> extTokens)
{
DO_SaleShop_Member da = new DO_SaleShop_Member();
return(da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens)));
}
///<summary>
///Get records count.
///</summary>
public static int GetRecordsCount(DO_SaleShop_Member.UO_SaleShop_Member parameterObj)
{
return(GetRecordsCount(parameterObj, true, TokenTypes.Equal, null));
}
///<summary>
///Get conditions by object with Multi-TokenType.
///</summary>
public static ParameterCollection GetConditionsByObject(DO_SaleShop_Member.UO_SaleShop_Member parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary <DO_SaleShop_Member.Columns, TokenTypes> extTokens)
{
ParameterCollection objectConditions = new ParameterCollection();
TokenTypes tt = tokenTypes;
ParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;
if (parameterObj.UId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.UId)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.UId, extTokens), DO_SaleShop_Member.Columns.UId, parameterObj.UId);
}
if (!string.IsNullOrEmpty(parameterObj.UserName))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.UserName, extTokens), DO_SaleShop_Member.Columns.UserName, parameterObj.UserName);
}
if (!string.IsNullOrEmpty(parameterObj.RealName))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.RealName, extTokens), DO_SaleShop_Member.Columns.RealName, parameterObj.RealName);
}
if (!string.IsNullOrEmpty(parameterObj.ICON))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.ICON, extTokens), DO_SaleShop_Member.Columns.ICON, parameterObj.ICON);
}
if (!string.IsNullOrEmpty(parameterObj.Password))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Password, extTokens), DO_SaleShop_Member.Columns.Password, parameterObj.Password);
}
if (parameterObj.Gender != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Gender)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Gender, extTokens), DO_SaleShop_Member.Columns.Gender, parameterObj.Gender);
}
if (parameterObj.GroupId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.GroupId)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.GroupId, extTokens), DO_SaleShop_Member.Columns.GroupId, parameterObj.GroupId);
}
if (!string.IsNullOrEmpty(parameterObj.Email))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Email, extTokens), DO_SaleShop_Member.Columns.Email, parameterObj.Email);
}
if (!string.IsNullOrEmpty(parameterObj.Mobile))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Mobile, extTokens), DO_SaleShop_Member.Columns.Mobile, parameterObj.Mobile);
}
if (parameterObj.District != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.District)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.District, extTokens), DO_SaleShop_Member.Columns.District, parameterObj.District);
}
if (!string.IsNullOrEmpty(parameterObj.OtherContact))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.OtherContact, extTokens), DO_SaleShop_Member.Columns.OtherContact, parameterObj.OtherContact);
}
if (parameterObj.Funds != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Funds)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Funds, extTokens), DO_SaleShop_Member.Columns.Funds, parameterObj.Funds);
}
if (parameterObj.frostFunds != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.frostFunds)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.frostFunds, extTokens), DO_SaleShop_Member.Columns.frostFunds, parameterObj.frostFunds);
}
if (parameterObj.Referee != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.Referee)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Referee, extTokens), DO_SaleShop_Member.Columns.Referee, parameterObj.Referee);
}
if (!string.IsNullOrEmpty(parameterObj.LastIP))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.LastIP, extTokens), DO_SaleShop_Member.Columns.LastIP, parameterObj.LastIP);
}
if (!string.IsNullOrEmpty(parameterObj.PrevIP))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.PrevIP, extTokens), DO_SaleShop_Member.Columns.PrevIP, parameterObj.PrevIP);
}
if (!string.IsNullOrEmpty(parameterObj.RegIP))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.RegIP, extTokens), DO_SaleShop_Member.Columns.RegIP, parameterObj.RegIP);
}
if (parameterObj.State != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.State)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.State, extTokens), DO_SaleShop_Member.Columns.State, parameterObj.State);
}
if (parameterObj.IsReceiveSms != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.IsReceiveSms)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.IsReceiveSms, extTokens), DO_SaleShop_Member.Columns.IsReceiveSms, parameterObj.IsReceiveSms);
}
if (!string.IsNullOrEmpty(parameterObj.Friends))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.Friends, extTokens), DO_SaleShop_Member.Columns.Friends, parameterObj.Friends);
}
if (!string.IsNullOrEmpty(parameterObj.loginappid))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.loginappid, extTokens), DO_SaleShop_Member.Columns.loginappid, parameterObj.loginappid);
}
if (!string.IsNullOrEmpty(parameterObj.idcard))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.idcard, extTokens), DO_SaleShop_Member.Columns.idcard, parameterObj.idcard);
}
if (!string.IsNullOrEmpty(parameterObj.linkaddress))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.linkaddress, extTokens), DO_SaleShop_Member.Columns.linkaddress, parameterObj.linkaddress);
}
if (!string.IsNullOrEmpty(parameterObj.industry))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.industry, extTokens), DO_SaleShop_Member.Columns.industry, parameterObj.industry);
}
if (parameterObj.mshopid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.mshopid)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.mshopid, extTokens), DO_SaleShop_Member.Columns.mshopid, parameterObj.mshopid);
}
if (parameterObj.headuid != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.headuid)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.headuid, extTokens), DO_SaleShop_Member.Columns.headuid, parameterObj.headuid);
}
if (parameterObj.areaid1 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid1)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid1, extTokens), DO_SaleShop_Member.Columns.areaid1, parameterObj.areaid1);
}
if (parameterObj.areaid2 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid2)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid2, extTokens), DO_SaleShop_Member.Columns.areaid2, parameterObj.areaid2);
}
if (parameterObj.areaid3 != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.areaid3)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.areaid3, extTokens), DO_SaleShop_Member.Columns.areaid3, parameterObj.areaid3);
}
if (!string.IsNullOrEmpty(parameterObj.paypwd))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.paypwd, extTokens), DO_SaleShop_Member.Columns.paypwd, parameterObj.paypwd);
}
if (!string.IsNullOrEmpty(parameterObj.icon_old))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.icon_old, extTokens), DO_SaleShop_Member.Columns.icon_old, parameterObj.icon_old);
}
if (parameterObj.experience != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.experience)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.experience, extTokens), DO_SaleShop_Member.Columns.experience, parameterObj.experience);
}
if (!string.IsNullOrEmpty(parameterObj.question))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.question, extTokens), DO_SaleShop_Member.Columns.question, parameterObj.question);
}
if (!string.IsNullOrEmpty(parameterObj.answer))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.answer, extTokens), DO_SaleShop_Member.Columns.answer, parameterObj.answer);
}
if (!string.IsNullOrEmpty(parameterObj.bankNum))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.bankNum, extTokens), DO_SaleShop_Member.Columns.bankNum, parameterObj.bankNum);
}
if (!string.IsNullOrEmpty(parameterObj.honourId))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.honourId, extTokens), DO_SaleShop_Member.Columns.honourId, parameterObj.honourId);
}
if (parameterObj.gradeId != 0 || (extTokens != null && extTokens.ContainsKey(DO_SaleShop_Member.Columns.gradeId)))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.gradeId, extTokens), DO_SaleShop_Member.Columns.gradeId, parameterObj.gradeId);
}
if (!string.IsNullOrEmpty(parameterObj.weixin_openid))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.weixin_openid, extTokens), DO_SaleShop_Member.Columns.weixin_openid, parameterObj.weixin_openid);
}
if (!string.IsNullOrEmpty(parameterObj.qq_openid))
{
objectConditions.AddCondition(pt, GetColumnTokenType(tt, DO_SaleShop_Member.Columns.qq_openid, extTokens), DO_SaleShop_Member.Columns.qq_openid, parameterObj.qq_openid);
}
return(objectConditions);
}