void BindList() { this.dgvPoinList.Rows.Clear(); DataTable dt = new VipSoft.BLL.ExchangeLog().GetReportList(QueryCondition()).Tables[0]; foreach (DataRow dr in dt.Rows) { this.dgvPoinList.Rows.Add(dr["CardID"], dr["Name"], dr["GiftCode"], dr["GiftName"], dr["Point"], dr["Number"], dr["CreateTime"]); } }
private void searchMember1_EventMemberSelected(Model.MemCard selectedMemInfo) { this.dataGridView_List.Rows.Clear(); VipSoft.BLL.ExchangeLog log = new VipSoft.BLL.ExchangeLog(); DataTable dt = log.GetReportList("ExchangeLog.CardID='" + this.searchMember1.CardID + "' or MemCard.CardmianID='" + this.searchMember1.CardID + "' or MemCard.Mobile='" + this.searchMember1.CardID + "'").Tables[0]; if (dt.Rows.Count != 0) { foreach (DataRow dr in dt.Rows) { this.dataGridView_List.Rows.Add(dr["ID"].ToString(), dr["GiftName"].ToString(), dr["Point"].ToString(), dr["Number"].ToString(), dr["CreateTime"].ToString()); } this.label_Result.Visible = false; } else { this.label_Result.Text = "暂无兑换记录!"; this.label_Result.Visible = true; } }
private void BindLiPingHistoryThread() { Thread.Sleep(50); VipSoft.BLL.ExchangeLog ex = new VipSoft.BLL.ExchangeLog(); DataTable dt = ex.GetList(" MemCardID='" + memInfo.CardID + "'").Tables[0]; if (dt.Rows.Count == 0) { this.label_Loading_History2.Text = "暂无兑换记录!"; this.label_Loading_History2.Visible = true; this.dataGridView_List.Visible = false; return; } this.label_Loading_History2.Visible = false; this.dataGridView_List.Visible = true; foreach (DataRow dr in dt.Rows) { this.dataGridView_List.Rows.Add(dr["GoodsName"].ToString(), dr["Point"].ToString(), dr["Number"].ToString(), dr["CreateTime"].ToString()); } }