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