void LoadChargeAccountTypeToText() { List <ChargeAccountType> chargeAccountTypeSet = SQLChargeAccountType.GetChargeAccountType(p => p.ChargeAccountTypeID != null); this.CmbAccountType.DataSource = chargeAccountTypeSet; this.CmbAccountType.DisplayMember = "Description"; this.CmbAccountType.ValueMember = "ChargeAccountTypeID"; }
void SetCardStoreDataSouce(List <Cards> cardSet) { List <CardStore> cardStoreSet = new List <CardStore>(); try { List <IGrouping <int, Cards> > cardType = cardSet.GroupBy(p => p.ChargeAccountTypeID).ToList(); foreach (IGrouping <int, Cards> group in cardType) { List <Cards> cardValue = group.ToList(); var result = cardValue.GroupBy(a => a.Price) .Select(g => (new { value = g.Key, count = g.Count(), ageUntreated = g.Count(item => item.ReChargeStatus == 0), ageProcessing = g.Count(item => item.ReChargeStatus == 1), ageSuccessful = g.Count(item => item.ReChargeStatus == 2), ageFailure = g.Count(item => item.ReChargeStatus == 3), ageSuspicious = g.Count(item => item.ReChargeStatus == 4) })); foreach (var item in result) { CardStore cardStore = new CardStore(); cardStore.CardTypeID = cardValue[0].ChargeAccountTypeID; cardStore.CardTypeDescription = SQLChargeAccountType.GetChargeAccountType(p => p.ChargeAccountTypeID == cardValue[0].ChargeAccountTypeID).FirstOrDefault().Description; cardStore.CardValue = Convert.ToInt16(item.value); cardStore.TotalCount = item.count; cardStore.UntreatedCount = Convert.ToInt16(item.ageUntreated); cardStore.ProcessingCount = Convert.ToInt16(item.ageProcessing); cardStore.SuccessfulCount = Convert.ToInt16(item.ageSuccessful); cardStore.FailureCount = Convert.ToInt16(item.ageFailure); cardStore.SuspiciousCount = Convert.ToInt16(item.ageSuspicious); cardStoreSet.Add(cardStore); } } } catch (Exception) { throw; } BindingSource bs = new BindingSource(); bs.DataSource = cardStoreSet; dgvCardStore.DataSource = bs; bdnCardStore.BindingSource = bs; }
void LoadType(System.Windows.Forms.ComboBox cmb, bool isCard = false, bool isQuery = false) { List <ChargeAccountType> chargeAccountTypeSet = SQLChargeAccountType.GetChargeAccountType(p => p.IsCard == isCard); if (isQuery) { ChargeAccountType type = new ChargeAccountType() { Description = "全部", ChargeAccountTypeID = 000000 }; chargeAccountTypeSet.Add(type); } cmb.DataSource = chargeAccountTypeSet; cmb.DisplayMember = "Description"; cmb.ValueMember = "ChargeAccountTypeID"; }
void BindingQueryCardsDataGridColumns() { dgvQueryCards.AllowUserToAddRows = false; dgvQueryCards.AllowUserToDeleteRows = false; dgvQueryCards.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; dgvQueryCards.AutoGenerateColumns = false; //关闭自动产生列 DataGridViewColumn cCardsID = new DataGridViewTextBoxColumn() { Name = "CardsID", DataPropertyName = "CardsID", HeaderText = "卡密编号", Width = 100, ReadOnly = true }; DataGridViewComboBoxColumn cmbChargeAccountTypeID = new DataGridViewComboBoxColumn() { Name = "ChargeAccountTypeID", DataPropertyName = "ChargeAccountTypeID", HeaderText = "类型名称", Width = 100, ReadOnly = true }; List <ChargeAccountType> chargeAccountTypeSet = SQLChargeAccountType.GetChargeAccountType(p => p.ChargeAccountTypeID != null); cmbChargeAccountTypeID.DataSource = chargeAccountTypeSet; cmbChargeAccountTypeID.DisplayMember = "Description"; cmbChargeAccountTypeID.ValueMember = "ChargeAccountTypeID"; DataGridViewColumn cCardNumber = new DataGridViewTextBoxColumn() { Name = "CardNumber", DataPropertyName = "CardNumber", HeaderText = "卡号", Width = 100 }; DataGridViewColumn cCardPassWord = new DataGridViewTextBoxColumn() { Name = "CardPassWord", DataPropertyName = "CardPassWord", HeaderText = "密码", Width = 100 }; DataGridViewColumn cPrice = new DataGridViewTextBoxColumn() { Name = "Price", DataPropertyName = "Price", HeaderText = "卡密面值", Width = 100 }; DataGridViewComboBoxColumn cmbRechargeStatus = new DataGridViewComboBoxColumn { Name = "RechargeStatus", DataPropertyName = "RechargeStatus", HeaderText = "充值状态" }; List <RechargeStatusSet> ss = SetValues(); cmbRechargeStatus.DataSource = ss; cmbRechargeStatus.DisplayMember = "description"; cmbRechargeStatus.ValueMember = "RechargeStatus"; DataGridViewColumn cReChargeMsg = new DataGridViewTextBoxColumn() { Name = "ReChargeMsg", DataPropertyName = "ReChargeMsg", HeaderText = "充值描述", Width = 100, ReadOnly = true }; DataGridViewCheckBoxColumn cIsAvailable = new DataGridViewCheckBoxColumn() { Name = "IsAvailable", DataPropertyName = "IsAvailable", HeaderText = "是否可用", Width = 100 }; DataGridViewColumn cCreatTime = new DataGridViewTextBoxColumn() { Name = "CreatTime", DataPropertyName = "CreatTime", HeaderText = "导入时间", Width = 100, ReadOnly = true } ; DataGridViewColumn cUseTime = new DataGridViewTextBoxColumn() { Name = "UseTime", DataPropertyName = "UseTime", HeaderText = "使用时间", Width = 100, ReadOnly = true }; DataGridViewButtonColumn bUpdateCards = new DataGridViewButtonColumn() { Name = "UpdateCards", HeaderText = "操作", Text = "保存", UseColumnTextForButtonValue = true }; DataGridViewButtonColumn bDeleteCards = new DataGridViewButtonColumn() { Name = "DeleteCards", HeaderText = "操作", Text = "删除", UseColumnTextForButtonValue = true }; dgvQueryCards.Columns.Add(cCardsID); dgvQueryCards.Columns.Add(cmbChargeAccountTypeID); dgvQueryCards.Columns.Add(cCardNumber); dgvQueryCards.Columns.Add(cCardPassWord); dgvQueryCards.Columns.Add(cPrice); dgvQueryCards.Columns.Add(cmbRechargeStatus); dgvQueryCards.Columns.Add(cReChargeMsg); dgvQueryCards.Columns.Add(cIsAvailable); dgvQueryCards.Columns.Add(cCreatTime); dgvQueryCards.Columns.Add(cUseTime); dgvQueryCards.Columns.Add(bUpdateCards); dgvQueryCards.Columns.Add(bDeleteCards); }
void BindingQueryAccountDataGridColumns() { dgvQueryAccount.AllowUserToAddRows = false; dgvQueryAccount.AllowUserToDeleteRows = false; dgvQueryAccount.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; dgvQueryAccount.AutoGenerateColumns = false; //关闭自动产生列 DataGridViewColumn cOrderChargeAccountID = new DataGridViewTextBoxColumn() { Name = "OrderChargeAccountID", DataPropertyName = "OrderChargeAccountID", HeaderText = "帐号编号", Width = 100, ReadOnly = true }; DataGridViewComboBoxColumn cmbChargeAccountTypeID = new DataGridViewComboBoxColumn() { Name = "ChargeAccountTypeID", DataPropertyName = "ChargeAccountTypeID", HeaderText = "类型名称", Width = 100, }; List <ChargeAccountType> chargeAccountTypeSet = SQLChargeAccountType.GetChargeAccountType(p => p.ChargeAccountTypeID != null); cmbChargeAccountTypeID.DataSource = chargeAccountTypeSet; cmbChargeAccountTypeID.DisplayMember = "Description"; cmbChargeAccountTypeID.ValueMember = "ChargeAccountTypeID"; DataGridViewColumn cChargeAccount = new DataGridViewTextBoxColumn() { Name = "ChargeAccount", DataPropertyName = "ChargeAccount", HeaderText = "帐号名字", Width = 100, Frozen = false }; DataGridViewColumn cChargePassword = new DataGridViewTextBoxColumn() { Name = "ChargePassword", DataPropertyName = "ChargePassword", HeaderText = "登录密码", Width = 100, Frozen = false }; DataGridViewColumn cPayPassword = new DataGridViewTextBoxColumn() { Name = "PayPassword", DataPropertyName = "PayPassword", HeaderText = "支付密码", Width = 100, Frozen = false }; DataGridViewColumn cBalance = new DataGridViewTextBoxColumn() { Name = "Balance", DataPropertyName = "Balance", HeaderText = "帐号余额", Width = 100, Frozen = false }; DataGridViewColumn cUseTimes = new DataGridViewTextBoxColumn() { Name = "UseTimes", DataPropertyName = "UseTimes", HeaderText = "使用次数", Width = 100, ReadOnly = true }; DataGridViewCheckBoxColumn cIsAvailable = new DataGridViewCheckBoxColumn() { Name = "IsAvailable", DataPropertyName = "IsAvailable", HeaderText = "是否启用", Width = 100, Frozen = false }; DataGridViewColumn cCreateTime = new DataGridViewTextBoxColumn() { Name = "CreateTime", DataPropertyName = "CreateTime", HeaderText = "导入时间", Width = 100, Frozen = false, ReadOnly = true } ; DataGridViewColumn cLastUseTime = new DataGridViewTextBoxColumn() { Name = "LastUseTime", DataPropertyName = "LastUseTime", HeaderText = "最后使用时间", Width = 100, Frozen = false, ReadOnly = true }; DataGridViewButtonColumn bUpdate = new DataGridViewButtonColumn() { Name = "Update", HeaderText = "操作", Text = "保存", UseColumnTextForButtonValue = true }; DataGridViewButtonColumn bDelete = new DataGridViewButtonColumn() { Name = "Delete", HeaderText = "操作", Text = "删除", UseColumnTextForButtonValue = true }; dgvQueryAccount.Columns.Add(cOrderChargeAccountID); dgvQueryAccount.Columns.Add(cmbChargeAccountTypeID); dgvQueryAccount.Columns.Add(cChargeAccount); dgvQueryAccount.Columns.Add(cChargePassword); dgvQueryAccount.Columns.Add(cPayPassword); dgvQueryAccount.Columns.Add(cBalance); dgvQueryAccount.Columns.Add(cUseTimes); dgvQueryAccount.Columns.Add(cIsAvailable); dgvQueryAccount.Columns.Add(cCreateTime); dgvQueryAccount.Columns.Add(cLastUseTime); dgvQueryAccount.Columns.Add(bUpdate); dgvQueryAccount.Columns.Add(bDelete); }