protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { coll = cardDal.getCard(" User_Id= 1"); if (coll.Count > 0) { } } }
private void BindDataGrid(List<QueryElement> list) { cardColl = CardMethods.GetCard(list); this.CardListDataGrid.DataSource = cardColl; this.CardListDataGrid.DataBind(); for (int i = 0; i < cardColl.Count; i++) { this.CardListDataGrid.Items[i].Cells[2].Text = StaticRescourse.DisplayAccountType(cardColl[i].AccountType); this.CardListDataGrid.Items[i].Cells[3].Text = StaticRescourse.DisplayBank(cardColl[i].BankId); } }
/// <summary> /// 动态条件查询卡号 /// </summary> /// <param name="strFields">条件字段</param> /// <param name="strValues">条件值</param> /// <returns></returns> public static CardCollection GetCard(List<QueryElement> list) { CardCollection coll = new CardCollection(); StringBuilder sb = new StringBuilder(); sb.Append(" select card.*,a.name as ownerName,b.name as userName from card left join user a on card.ownerId=a.id left join user b on card.userId = b.id where 1=1 "); if (list.Count > 0) { MySqlParameter[] pars = new MySqlParameter[list.Count]; for (int i = 0; i < list.Count; i++) { QueryElement query = list[i]; if (query.QueryElementType == MySqlDbType.DateTime) { sb.AppendFormat(" {0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname + i); pars[i] = new MySqlParameter("@" + query.Queryname + i, query.QueryElementType); } else { sb.AppendFormat(" {0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname); pars[i] = new MySqlParameter("@" + query.Queryname, query.QueryElementType); } if (query.QueryOperation.Equals("like")) { pars[i].Value = "%" + query.Queryvalue + "%"; } else { pars[i].Value = query.Queryvalue; } } using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), pars)) { while (reader.Read()) { coll.Add(new CardInfo(reader)); } } } else { using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString())) { while (reader.Read()) { coll.Add(new CardInfo(reader)); } } } return coll; }
public static CardCollection GetCardByUserId(int userId) { CardCollection coll = new CardCollection(); StringBuilder sb = new StringBuilder(); sb.Append(" select card.*,a.name as ownerName,b.name as userName from card left join user a on card.ownerId=a.id left join user b on card.userId = b.id where card.UserId=@UserId "); MySqlParameter par = new MySqlParameter("@UserId", MySqlDbType.Int32); par.Value = userId; using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), par)) { while (reader.Read()) { coll .Add(new CardInfo(reader)); } } return coll; }
public CardCollection Pagination(int pageIndex, int pageSize) { if (InnerList.Count == 0) { return(null); } int start = pageSize * (pageIndex - 1); int end = start + pageSize - 1; if (end > InnerList.Count - 1) { end = InnerList.Count - 1; } CardCollection pages = new CardCollection(); for (int i = start; i <= end; i++) { pages.Add(InnerList[i] as CardInfo); } return(pages); }
public CardCollectionEnumerator(CardCollection mappings) { enumerator = ((IEnumerable)mappings).GetEnumerator(); }
public CardCollection Pagination(int pageIndex, int pageSize) { if (InnerList.Count == 0) return null; int start = pageSize * (pageIndex - 1); int end = start + pageSize - 1; if (end > InnerList.Count - 1) end = InnerList.Count - 1; CardCollection pages = new CardCollection(); for (int i = start; i <= end; i++) { pages.Add(InnerList[i] as CardInfo); } return pages; }
public void AddRange(CardCollection value) { for (int i = 0; (i < value.Count); i++) { this.Add(value.List[i] as CardInfo); } }
/// <summary> /// 初始化卡号(新增) /// </summary> private void InitializeDropIncomeCardNumber() { CardCollection cardcoll = new CardCollection(); List<QueryElement> list = new List<QueryElement>(); cardcoll = CardMethods.GetCard(list); List<DropItem> card = new List<DropItem>(); card.Add(new DropItem { ValueField = "", DisplayField = " " }); for (int i = 0; i < cardcoll.Count; i++) { CardInfo cardInfo = cardcoll[i]; string bank = StaticRescourse.DisplayBank(cardInfo.BankId); card.Add(new DropItem { ValueField = cardInfo.Id.ToString(), DisplayField = cardInfo.CardNumber+" "+bank});// +" "+bank } this.dropIncomeAddCardNumber.DataSource = card; Helper.SetDropDownList(this.dropIncomeAddCardNumber); this.dropIncomeAddCardNumber.SelectedValue = string.Empty; }
/// <summary> /// 初始化卡号(新增) /// </summary> private void InitializeDropExpensesDropControl() { List<CardHelper> cardNumberList = new List<CardHelper>(); List<CardHelper> cxList = new List<CardHelper>(); CardCollection cardcoll = new CardCollection(); //返回的卡的collection cardcoll = CardMethods.GetCard(new List<QueryElement>()); List<DropItem> card = new List<DropItem>(); card.Add(new DropItem { ValueField = "", DisplayField = " " }); for (int i = 0; i < cardcoll.Count; i++) { CardInfo info = cardcoll[i]; cardNumberList.Add(new CardHelper { CardId = info.Id, BankId = info.BankId, CardNumber = info.CardNumber }); } cxList.AddRange(cardNumberList.OrderBy(x=>x.CardNumber)); cardNumberList.Clear(); for (int i = 0; i < cxList.Count;i++ ) { if (i == 0 || cxList[i].CardNumber != cxList[i - 1].CardNumber) { cardNumberList.Add(new CardHelper { CardId = cxList[i].CardId, BankId = cxList[i].BankId, CardNumber = cxList[i].CardNumber }); } } for (int i = 0; i < cardNumberList.Count; i++) { var cardInfo = cardNumberList[i]; string bank = StaticRescourse.DisplayBank(cardInfo.BankId); card.Add(new DropItem { ValueField = cardInfo.CardId.ToString(), DisplayField = cardInfo.CardNumber + " " + bank });// +" "+bank } this.dropExpensesAddCardNumber.DataSource = card; Helper.SetDropDownList(this.dropExpensesAddCardNumber); this.dropExpensesAddSpendMode.DataSource = StaticRescourse.GetSpendMode(); Helper.SetDropDownList(this.dropExpensesAddSpendMode); this.dropExpensesAddSpendType.DataSource = StaticRescourse.GetSpendType(); Helper.SetDropDownList(this.dropExpensesAddSpendType); }