//通过读卡获取会员卡
private void get_member_by_card()
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
var cardType = MemberForm.memberSetting.cardType;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
if (!st)
{
return;
}
m_member = dao.get_CardInfo("CI_CardNo='" + card_data + "'");
//m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == card_data);
if (m_member == null)
{
return;
}
set_member();
}
//通过读数据库获取会员卡
private bool get_member_by_db()
{
if (phone.Text != "")
{
m_Member = dao.get_CardInfo("CI_Telephone='" + phone.Text + "'");
}
//m_Member = db.CardInfo.FirstOrDefault(x => x.CI_Telephone == phone.Text);
else if (name.Text != "")
{
var members = dao.get_CardInfos("CI_Telephone='" + phone.Text + "'");
//var members = db.CardInfo.Where(x => x.CI_Name == name.Text);
if (members.Count != 1)
{
BathClass.printErrorMsg("名称不唯一或者不存在!");
return(false);
}
m_Member = members.FirstOrDefault();
}
else if (memberId.Text != "")
{
m_Member = dao.get_CardInfo("CI_CardNo='" + memberId.Text + "'");
}
//m_Member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == memberId.Text);
if (m_Member == null)
{
BathClass.printErrorMsg("该会员卡不在本店登记!");
return(false);
}
return(true);
}
//获取会员卡
private void get_member()
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
else if (cardType == "CT")
{
card_data = id.Text;
st = true;
}
if (!st)
{
return;
}
//card_data = "000000";
m_member = dao.get_CardInfo("CI_CardNo='" + card_data + "'");
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
id.Text = m_member.CI_CardNo;
name.Text = m_member.CI_Name;
phone.Text = m_member.CI_Telephone;
cmemberType = dao.get_MemberType("id='" + m_member.CI_CardTypeNo + "'");
if (memberType != null)
{
memberType.Text = cmemberType.name;
}
var cc = dao.get_CardCharges("CC_CardNo='" + m_member.CI_CardNo + "'");
double debit = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_DebitSum), 0);
double lend = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_LenderSum), 0);
balance.Text = (debit - lend).ToString();
var c = MConvert <int> .ToTypeOrDefault(m_member.CI_CreditsUsed, 0);
var cu = MConvert <int> .ToTypeOrDefault(memberSetting.money, 0);
int cs = (int)(lend / cu - c);
credits.Text = cs.ToString();
btnOk.Text = "会员打折";
}
//获取会员卡
private void get_member()
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
else if (cardType == "CT")
{
card_data = id.Text;
st = true;
}
if (!st)
{
return;
}
//card_data = "103051";
id.Text = card_data;
m_member = dao.get_CardInfo("CI_CardNo='" + id.Text + "'");
//m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == id.Text);
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
var t = dao.get_MemberType("id=" + m_member.CI_CardTypeNo);
//var t = db.MemberType.FirstOrDefault(x => x.id == m_member.CI_CardTypeNo);
if (t != null)
{
type.Text = t.name;
}
balance.Text = dao.get_member_balance(id.Text).ToString();
//balance.Text = BathClass.get_member_balance(db, card_data).ToString();
if (m_member.state == "入库")
{
btnOk.Text = "激活";
}
if (m_member.state == "在用")
{
btnOk.Text = "退卡";
}
}
//会员打折
private void btnDiscount_Click(object sender, EventArgs e)
{
//BathClass.sendMessageToCamera(db, m_Seats[0].systemId);
var id = string.Join("|", m_Seats.Select(x => x.systemId).ToArray());
MemberPromotionForm memberPromotionForm = new MemberPromotionForm(m_Seats, id);
memberPromotionForm.ShowDialog();
m_Member = memberPromotionForm.m_member;
this.Close();
}
//构造函数
public MemberFingerForm(CCardInfo member)
{
InitializeComponent();
try
{
dao = new DAO(LogIn.connectionString);
m_member = member;
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
}
//构造函数
public PayForm(List <CSeat> _seats, Dictionary <Int64, bool> orders,
CCardInfo member, double discount_money, double money)
{
//seat_keeps = seats;
m_orders = orders;
m_wipe_limit = MConvert <int> .ToTypeOrDefault(LogIn.options.抹零限制, 0);
m_Seats = _seats;
//m_Seats.AddRange(db.Seat.Where(x => seats.Keys.Contains(x.text)));
m_promotion_Member = member;
m_discount_money = discount_money;
m_money = money;
InitializeComponent();
}
//读会员卡
private void btnOk_Click(object sender, EventArgs e)
{
if (btnOk.Text == "读卡")
{
m_member = null;
get_member();
//if (m_member == null)
//{
// BathClass.printErrorMsg("输入卡不存在");
//}
}
else if (btnOk.Text == "重置")
{
reset_form();
}
}
//添加储值卡
private void btnAdd_Click(object sender, EventArgs e)
{
double paid_money = get_paid_money();
if (paid_money >= m_money)
{
BathClass.printErrorMsg("刷卡金额已经足够！");
return;
}
if (id.Text != "")
{
m_member = dao.get_CardInfo("CI_CardNo='" + id.Text + "'");
}
else
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
var cardType = memberSetting.cardType;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
if (!st)
{
return;
}
m_member = dao.get_CardInfo("CI_CardNo='" + card_data + "'");
}
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
if (m_member.state == "挂失")
{
BathClass.printErrorMsg("卡已挂失，无法使用！");
return;
}
if (m_member.state == "入库")
{
BathClass.printErrorMsg("卡已入库，但未激活，无法使用！");
return;
}
if (m_member.state == "停用")
{
BathClass.printErrorMsg("卡已停用，无法使用！，新卡卡号为:" + m_member.CI_Special1 + "，补卡时间为：" +
m_member.CI_SpecialDate1.Value.ToString("yyyy-MM-dd HH:mm"));
return;
}
string memberType = "";
var t = dao.get_MemberType("id=" + m_member.CI_CardTypeNo);
if (t != null)
{
memberType = t.name;
}
if (t != null && MConvert <bool> .ToTypeOrDefault(t.userOneTimeOneDay, false) &&
dao.exist_instance("CardCharge", "datediff(day,CC_InputDate,getdate())=0 and cc_itemExplain!='售卡收' and cc_cardno='" + m_member.CI_CardNo + "'"))
{
BathClass.printErrorMsg("此卡被限定一天只能使用一次，今天已经使用过!");
return;
}
if (t != null && MConvert <bool> .ToTypeOrDefault(t.LimitedTimesPerMonth, false) &&
dao.get_memberCard_useTimes_this_month(m_member.CI_CardNo) >= t.TimesPerMonth)
{
BathClass.printErrorMsg("此卡被限定每月只能使用" + t.TimesPerMonth + "次，本月已达额度!");
return;
}
if (m_memberList.Keys.Contains(m_member.CI_CardNo))
{
BathClass.printErrorMsg("已经添加卡号为" + m_member.CI_CardNo + "的会员卡，不能重复添加！");
return;
}
if (m_use_finger_pwd)
{
var form = new MemberFingerForm(m_member);
form.ShowDialog();
if (!form.verified)
{
BathClass.printErrorMsg("验证指纹失败!");
return;
}
}
var cc = dao.get_CardCharges("CC_CardNo='" + m_member.CI_CardNo + "'");
double debit = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_DebitSum), 0);
double lend = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_LenderSum), 0);
double balance = debit - lend;
var c = MConvert <int> .ToTypeOrDefault(m_member.CI_CreditsUsed, 0);
var cu = memberSetting.money.Value;
int cs = (int)(lend / cu - c);
double hasto_money = 0;
if (balance <= m_money - paid_money)
{
hasto_money = balance;
}
else
{
hasto_money = m_money - paid_money;
}
m_memberList[m_member.CI_CardNo] = hasto_money;
dgv.Rows.Add(m_member.CI_CardNo, m_member.CI_Name, m_member.CI_Telephone, memberType, balance, cs, hasto_money);
id.Text = "";
}
//确定
private void btnOk_Click(object sender, EventArgs e)
{
//前台发卡
//if (db.CardInfo.FirstOrDefault(x => x.CI_CardNo == id.Text) != null)
//{
// BathClass.printErrorMsg("已经发行卡号为" + id.Text + "的卡");
// return;
//}
//if (!ICCard.destribute_card(company_code, id.Text))
//{
// return;
//}
//前台发卡
//CardInfo m_Element = new CardInfo();//前台发卡
CCardInfo m_Element = dao.get_CardInfo("CI_CardNo='" + id.Text + "'");
//CardInfo m_Element = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == id.Text);//后台发卡
if (m_Element == null)
{
BathClass.printErrorMsg("卡未入库！");
return;
}
if (m_Element.CI_Name != null && BathClass.printAskMsg("您确定需要修改卡号" + m_Element.CI_CardNo + "姓名：" +
m_Element.CI_Name + "的信息？") != DialogResult.Yes)
{
return;
}
//m_Element.CI_CardNo = id.Text;//前台发卡
//m_Element.CI_CardTypeNo = db.MemberType.FirstOrDefault(x => x.name == memberType.Text).id;
string cmd_str = @"update [CardInfo] set CI_Name='" + name.Text + "',"
+ @"CI_Sexno='" + gender.Text + "',"
+ @"CI_SendCardDate=getdate(),"
+ @"CI_SendCardOperator='" + LogIn.m_User.id + "',"
+ @"state='在用'";
if (birthday.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
cmd_str += ",birthday='" + birthday.Value.ToString() + "'";
//m_Element.birthday = birthday.Value;
}
if (mobile.Text != "")
{
cmd_str += ",CI_Telephone='" + mobile.Text + "'";
}
//m_Element.CI_Telephone = mobile.Text;
if (address.Text != "")
{
cmd_str += ",CI_Address='" + address.Text + "'";
}
//m_Element.CI_Address = address.Text;
cmd_str += " where CI_CardNo='" + m_Element.CI_CardNo + "'";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("会员资料录入失败，请重试!");
return;
}
//前台发卡
//db.CardInfo.InsertOnSubmit(m_Element);
//CardCharge cardCharge = new CardCharge();
//cardCharge.CC_CardNo = m_Element.CI_CardNo;
//cardCharge.CC_ItemExplain = "售卡收";
//if (money.Text != "")
// cardCharge.CC_DebitSum = Convert.ToDouble(money.Text);
//cardCharge.CC_LenderSum = 0;
//cardCharge.CC_InputOperator = LogIn.m_User.id.ToString();
//cardCharge.CC_InputDate = GeneralClass.Now;
//cardCharge.systemId = m_Seat.systemId;
//db.CardCharge.InsertOnSubmit(cardCharge);
//if (money.Text != "")
//{
//int sale_money = find_card_sale();//前台发卡
//if (sale_money != 0)
//{
//CardCharge cardChargeSale = new CardCharge();
//cardChargeSale.CC_CardNo = m_Element.CI_CardNo;
//cardChargeSale.CC_ItemExplain = "优惠送";
//cardChargeSale.CC_DebitSum = sale_money;
//cardChargeSale.CC_LenderSum = 0;
//cardChargeSale.CC_InputOperator = LogIn.m_User.id.ToString();
//cardChargeSale.CC_InputDate = GeneralClass.Now;
//cardChargeSale.systemId = m_Seat.systemId;
//db.CardCharge.InsertOnSubmit(cardChargeSale);
// BathClass.printInformation("送" + sale_money + "元");
//}
// var menu = db.Menu.FirstOrDefault(x => x.name == memberType.Text);
// Orders order = new Orders();
// order.menu = menu.name;
// order.text = m_Seat.text;
// order.systemId = m_Seat.systemId;
// order.number = 1;
// order.inputTime = BathClass.Now(LogIn.connectionString);
// order.inputEmployee = LogIn.m_User.id.ToString();
// order.paid = false;
// if (money.Text == "")
// order.money = menu.price;
// else
// order.money = Convert.ToDouble(money.Text);
// db.Orders.InsertOnSubmit(order);
//}
//前台发卡结束
//db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
//获取会员卡
private void get_member()
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
//var cardType = db.MemberSetting.FirstOrDefault().cardType;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
else if (cardType == "CT")
{
card_data = id.Text;
st = true;
}
if (!st)
{
return;
}
//card_data = "0000117";
id.Text = card_data;
m_member = dao.get_CardInfo("CI_CardNo='" + id.Text + "'");
//m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == id.Text);
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
name.Text = m_member.CI_Name;
var t = dao.get_MemberType("id=" + m_member.CI_CardTypeNo);
//var t = db.MemberType.FirstOrDefault(x => x.id == m_member.CI_CardTypeNo);
if (t != null)
{
type.Text = t.name;
}
var cc = dao.get_CardCharges("CC_CardNo='" + m_member.CI_CardNo + "'");
//var cc = db.CardCharge.Where(x => x.CC_CardNo == m_member.CI_CardNo);
int debit = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_DebitSum), 0);
int lend = MConvert <int> .ToTypeOrDefault(cc.Sum(x => x.CC_LenderSum), 0);
balance.Text = (debit - lend).ToString();
var c = MConvert <int> .ToTypeOrDefault(m_member.CI_CreditsUsed, 0);
var cu = MConvert <int> .ToTypeOrDefault(MemberForm.memberSetting.money, 0);
int cs = (int)(lend / cu - c);
credits.Text = cs.ToString();
btnOk.Text = "充值";
}
