private void BindList()
{
VipSoft.BLL.MemCard card = new VipSoft.BLL.MemCard();
DataSet ds = card.GetList(20, "ID", false, condition);
this.dataGridView_List.Rows.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
this.dataGridView_List.Rows.Add(dr["ID"].ToString(),dr["CardID"].ToString(),dr["Name"].ToString(),
decimal.Parse(dr["TotalMoney"].ToString() == "" ? "0" : dr["TotalMoney"].ToString()).ToString("￥0.00"),
Function.LevelIDToName(int.Parse(dr["LevelID"].ToString())));
}
}
private void memRegister_Load(object sender, EventArgs e)
{
LoadCardLevel();
loadDicData();
if (memId != 0)
{
VipSoft.BLL.MemCard mCard = new VipSoft.BLL.MemCard();
VipSoft.Model.MemCard memModel = mCard.GetModel(memId);
if (memModel != null)
{
this.continue_add.Visible = false;
this.cardid.Text = memModel.CardID;
this.cardmianid.Text = memModel.CardMianID;
this.CardTypeID.SelectedValue= int.Parse(memModel.CardTypeID.ToString());
this.Name.Text = memModel.Name;
this.LevelID.Text = memModel.LevelID.ToString();
this.id.Text = memModel.ID.ToString();
this.Sex.SelectedValue = int.Parse(memModel.Sex.ToString());
this.State.SelectedValue= int.Parse(memModel.State.ToString());
this.IsPast.Checked = memModel.IsPast;
this.IsPointAuto.Checked= memModel.IsPointAuto;
this.Email.Text = memModel.Email;
this.createtime.Text = memModel.CreateTime.ToString();
this.Mobile.Text = memModel.Mobile;
this.Money.Text = memModel.Money.ToString();
this.PayMoney.Text = memModel.PayMoney.ToString();
this.Remark.Text = memModel.Remark.ToString();
this.Point.Text = memModel.Point.ToString();
}
}
}
//删除会员操作
private void delMem()
{
//那个选择的条数不是1条时返回
if (this.dataGridView_List.SelectedRows.Count != 1)
return;
//得到所选记录的主键
int memId = int.Parse(this.dataGridView_List.SelectedRows[0].Cells["ID"].Value.ToString());
string memCardId = this.dataGridView_List.SelectedRows[0].Cells["cardId"].Value.ToString();
string memName = this.dataGridView_List.SelectedRows[0].Cells["MemName"].Value.ToString();
DialogResult dRes = MessageBox.Show("您确定要删除此会员么？此操作不可恢复。", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (dRes == DialogResult.No)
return;
VipSoft.BLL.MemCard mCard = new VipSoft.BLL.MemCard();
//查询该会员的记录，用于记录操作日志
VipSoft.Model.MemCard memModel = mCard.GetModel(memId);
if (mCard.Delete(memId))
{
// 记录日志
VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
log.Add(new VipSoft.Model.SysLog(PublicState.Master, "会员管理",
string.Format("删除会员，ID：{0}会员卡号：{1} 名称：{2}", memId.ToString(), memModel.CardID, memModel.Name),
DateTime.Now));
// 提示
MessageBox.Show("会员已被删除。");
// 重新绑定
BindList();
}
}
/// <summary>
/// 当选择用户时，调用委托，关闭窗口
/// </summary>
/// <param name="row"></param>
private void MemSelected(DataGridViewRow row)
{
int id = int.Parse(row.Cells["Column_ID"].Value.ToString());
string cardID = row.Cells["Column_CardID"].Value.ToString();
this.Close();
if (SearchMemSelected != null)
{
VipSoft.Model.MemCard info = new VipSoft.BLL.MemCard().GetModel(id);
SearchMemSelected(info);
}
else if (SearchMemSelectedCard != null)
{
SearchMemSelectedCard(cardID);
}
}
private void btnBlackQuery_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (this.dateTimePicker_B_Start.Checked)
{
DateTime time1;
string t1 = this.dateTimePicker_B_Start.Value.ToShortDateString() + " " + this.maskedTextBox_B_Start.Text;
if (!DateTime.TryParse(t1, out time1))
{
MessageBox.Show("开始时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime >= '" + time1.ToString() + "'");
}
if (this.dateTimePicker_B_End.Checked)
{
DateTime time2;
string t2 = this.dateTimePicker_B_End.Value.ToShortDateString() + " " + this.maskedTextBox_B_End.Text;
if (!DateTime.TryParse(t2, out time2))
{
MessageBox.Show("结束时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime <= '" + time2.ToString() + "'");
}
sb.Append(" and OrderLog.OrderType=2") ;//
if (this.comboBox_B_CardLevel.SelectedIndex != -1 && this.comboBox_B_CardLevel.SelectedIndex != 0)
{
int level = int.Parse(((DictionaryEntry)this.comboBox_B_CardLevel.SelectedItem).Value.ToString());
string ids = new VipSoft.BLL.MemCard().GetMemIDs(level);
if (ids != "")
sb.Append(" and OrderLog.MemID in (" + ids + ")");
else
{
sb.Append( " and MemID in (-1)");
}
}
if (this.searchMember5.CardID != "")
{
searchMember5.GetSearchMember();
sb.Append(" and OrderLog.MemID=" + this.searchMember5.MemID);
}
if (this.textBox_B_Money.Text != "￥0.00" && this.textBox_B_Money.Text != "")
sb.Append(" and abs(OrderLog.DiscountMoney)" + this.comboBox_B_Sign.Text + this.textBox_B_Money.Text.Replace("￥", ""));
if (this.TextBox_B_OrderCode.Text != "")
sb.Append(" and OrderLog.OrderCode='" + this.TextBox_B_OrderCode.Text + "'");
this.dgvBlackWater.Rows.Clear();
this.dgvBlackCollect.Rows.Clear();
decimal balckMoney = 0; //退货总金额
decimal balckNumber = 0; //退货总数量
////流水表
DataTable dt = new VipSoft.BLL.OrderLog().GetOrderGoodsList(sb.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
this.load_B_ing.Visible = false;
}
else
{
this.load_B_ing.Visible = true;
}
foreach (DataRow dr in dt.Rows)
{
balckMoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2);
balckNumber += decimal.Parse(dr["TotalNumber"].ToString());
this.dgvBlackWater.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["CreateDateTime"]);
}
this.label70.Text = balckNumber.ToString();
this.label68.Text = balckMoney.ToString("￥0.00");
}
private void button_Query_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (this.dateTimePicker_Start.Checked)
{
DateTime time1;
string t1 = this.dateTimePicker_Start.Value.ToShortDateString() + " " + this.maskedTextBox5.Text;
if (!DateTime.TryParse(t1, out time1))
{
MessageBox.Show("开始时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime>='" + t1 + "'");
}
if (this.dateTimePicker_End.Checked)
{
DateTime time2;
string t2 = this.dateTimePicker_End.Value.ToShortDateString() + " " + this.maskedTextBox_End.Text;
if (!DateTime.TryParse(t2, out time2))
{
MessageBox.Show("结束时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime<='" + t2 + "'");
}
sb.Append(" and OrderLog.OrderType=0");
if (this.comboBox_CardLevel.SelectedIndex != -1 && this.comboBox_CardLevel.SelectedIndex != 0)
{
int level = int.Parse(((DictionaryEntry)this.comboBox_CardLevel.SelectedItem).Value.ToString());
string ids = new VipSoft.BLL.MemCard().GetMemIDs(level);
}
if (this.searchMember1.CardID != "")
{
searchMember1.GetSearchMember();
sb.Append(" and OrderLog.MemID=" + this.searchMember1.MemID);
}
if (this.textBox_Money.Text != "￥0.00" && this.textBox_Money.Text != "")
sb.Append(" and OrderLog.DiscountMoney" + this.comboBox_Sign.Text + this.textBox_Money.Text.Replace("￥", ""));
if (this.TextBox_OrderCode.Text != "")
sb.Append(" and orderLog.OrderCode='" + this.TextBox_OrderCode.Text + "'");
this.dgvSellWater.Rows.Clear();
decimal totalmoney = 0;
decimal totalNumber = 0;
DataTable dt = new VipSoft.BLL.OrderLog().GetOrderGoodsList(sb.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
this.loading.Visible = false;
}
else
{
this.loading.Visible = true;
}
foreach (DataRow dr in dt.Rows)
{
totalmoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2);
totalNumber += decimal.Parse(dr["TotalNumber"].ToString());
this.dgvSellWater.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["CreateDateTime"], Function.GetPayTypeName(int.Parse(dr["PayType"].ToString())), dr["OrderType"].ToString() == "0" ? "储值消费" : (dr["OrderType"].ToString() == "1" ? "记次消费" : (dr["OrderType"].ToString() == "2" ? "退货" : "累计积分")), dr["Remark"]);
}
this.lbl_summoney.Text = totalmoney.ToString("#0.00");
this.label66.Text = totalNumber.ToString();
}
private void btn_P_Query_Click(object sender, EventArgs e)
{
this.dgvPointList.Rows.Clear();
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (this.dateTimePicker_P_Start.Checked)
{
DateTime time1;
string t1 = this.dateTimePicker_P_Start.Value.ToShortDateString() + " " + this.maskedTextBox_P_Start.Text;
if (!DateTime.TryParse(t1, out time1))
{
MessageBox.Show("开始时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime >= '" + time1.ToString() + "'");
}
if (this.dateTimePicker_P_End.Checked)
{
DateTime time2;
string t2 = this.dateTimePicker_P_End.Value.ToShortDateString() + " " + this.maskedTextBox_P_End.Text;
if (!DateTime.TryParse(t2, out time2))
{
MessageBox.Show("结束时间输入错误！");
return;
}
sb.Append(" and OrderLog.CreateDateTime <= '" + time2.ToString() + "'");
}
sb.Append(" and OrderLog.OrderType=3");
if (this.comboBox_P_CardLevel.SelectedIndex != -1 && this.comboBox_P_CardLevel.SelectedIndex != 0)
{
int level = int.Parse(((DictionaryEntry)this.comboBox_P_CardLevel.SelectedItem).Value.ToString());
string ids = new VipSoft.BLL.MemCard().GetMemIDs(level);
if (ids != "")
sb.Append("OrderLog.MemID in (" + ids + ")");
else
{
sb.Append(" and OrderLog.MemID in (-1)");
}
}
if (this.searchMember2.CardID != "")
{
searchMember2.GetSearchMember();
sb.Append(" OrderLog.MemID=" + this.searchMember2.MemID);
}
if (this.textBox_P_Money.Text != "￥0.00" && this.textBox_P_Money.Text != "")
sb.Append(" OrderLog.DiscountMoney" + this.comboBox_P_Sign.Text + this.textBox_P_Money.Text.Replace("￥", ""));
if (this.TextBox_P_OrderCode.Text != "")
sb.Append(" OrderLog.OrderCode='" + this.TextBox_P_OrderCode.Text + "'");
if (this.txtRemark.Text != "")
sb.Append(" OrderLog.Remark like '%" + this.txtRemark.Text + "%'");
decimal pmoney = 0;
int point = 0;
DataSet ds = new VipSoft.BLL.OrderLog().GetOrderPointList(sb.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
pmoney += Math.Round(decimal.Parse(dr["DiscountMoney"].ToString()), 2);
point += int.Parse(dr["Point"].ToString());
this.dgvPointList.Rows.Add(dr["OrderCode"], dr["CardID"], dr["MemName"], dr["DiscountMoney"], dr["Point"], dr["CreateDateTime"], Function.GetPayTypeName(int.Parse(dr["PayType"].ToString())), dr["Remark"]);
}
this.lbl_pnum.Text = point.ToString();
this.lbl_p.Text = pmoney.ToString("#0.00");
}
public void GetSearchMember()
{
if (this.textBox_CardID.Text.Trim() != "")
{
VipSoft.BLL.MemCard card = new VipSoft.BLL.MemCard();
VipSoft.Model.MemCard memInfo = card.GetModel(this.textBox_CardID.Text);
if (memInfo != null)
{
MemID = memInfo.ID;
}
else
{
MemID = -1;
}
}
}
/// <summary>
/// 按下回车时的处理方法
/// </summary>
public void CardIDKeyDown()
{
// 卡号
string reg_cardid = @"^[A-Za-z0-9]{0,30}$";
if (this.textBox_CardID.Text == "")
{
if (ShanKeSelected != null)
ShanKeSelected();
return;
}
else if (!Regex.IsMatch(this.textBox_CardID.Text, reg_cardid))
{
MessageBox.Show("卡号输入错误。");
this.textBox_CardID.Focus();
this.textBox_CardID.SelectAll();
return;
}
VipSoft.BLL.MemCard card = new VipSoft.BLL.MemCard();
VipSoft.Model.MemCard memInfo = card.GetModel(this.textBox_CardID.Text);
if (memInfo == null)
{
MessageBox.Show("未找到此会员。");
this.textBox_CardID.Focus();
this.textBox_CardID.SelectAll();
return;
}
if (EventMemberSelected != null)
EventMemberSelected(memInfo);
}
private void recharge_Click(object sender, EventArgs e)
{
if (this.v_cardid.Text == null || this.v_cardid.Text == "")
{
MessageBox.Show("请先选择需要充值的会员!");
this.search_box.Focus();
return;
}
if (this.total.Text == "" || this.total.Text == null || decimal.Parse(this.total.Text) <= 0)
{
MessageBox.Show("请输入充值金额!");
return;
}
int id = int.Parse(this.id.Text);
decimal rechargeMoney = decimal.Parse(this.total.Text);
VipSoft.BLL.MemCard mCard = new VipSoft.BLL.MemCard();
VipSoft.Model.MemCard memModel = mCard.GetModel(id);
//更新会员表的卡余额
memModel.Money += rechargeMoney;
mCard.Update(memModel);
//往充值记录表插入充值记录
VipSoft.BLL.RechargeLog chargeBll = new VipSoft.BLL.RechargeLog();
VipSoft.Model.RechargeLog charge = new Model.RechargeLog();
charge.MemID = id;
charge.MemName = memModel.Name;
charge.Money = decimal.Parse(this.rechargeAmount.Text);
charge.CardID = memModel.CardID;
charge.GiveMoney = decimal.Parse(this.giftAmount.Text);
charge.MasterID = PublicState.Master.ID;
charge.MasterName = PublicState.Master.Name;
charge.ShopID = PublicState.Master.ShopID;
charge.ShopName = PublicState.Master.ShopName;
charge.Type = 0;
if (chargeBll.Add(charge) > 0)
{
MessageBox.Show("充值成功!");
this.Close();
}
else
{
MessageBox.Show("充值失败!");
}
}
private void Expense_Load(object sender, EventArgs e)
{
ClearFormText();
if (CurrentCardID != "")
{
VipSoft.BLL.MemCard card = new VipSoft.BLL.MemCard();
memInfo = card.GetModel(CurrentCardID);
if (memInfo != null)
BindMemberMsg();
this.textBox_GoodsCode.Select();
}
else
this.searchMember1.Select();
BindGoodsTree();
}
