/// <summary>
/// 添加延期数据
/// </summary>
private void AddExtension(MemberInfoModel memberInfoModel)
{
ExtensionCard extensionCard = new ExtensionCard();
extensionCard.CreateTime = DateTime.Now;
extensionCard.ExtensionEndTm = this.dtp_ExtensionEndTime.Value;
extensionCard.ExtensionStartTm = this.dtp_ExtensionStartTime.Value;
extensionCard.MemberId = memberInfoModel.MemberID;
int result = extensionCardManager.Add(extensionCard);
if (result > 0) AdddLog(extensionCard);
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="swipingInfoModel"></param>
public void DetialModel(MemberInfoModel memberInfoModel)
{
this.dtp_AddTime.Text = memberInfoModel.AddTime;
List<Control> filter = new List<Control>();
// filter.Add(this.cardTypeCbx);
DisableControls(filter);
//this.addTimeTp.Enabled = false;
this.txt_Unit.Text = memberInfoModel.Unit;
//this.addressTxt.Enabled = false;
this.dtp_Birthday.Text = memberInfoModel.Birthday;
//this.birthdayDp.Enabled = false;
this.label1.Text = "查看会员信息";
this.Text = "查看会员信息";
this.btn_OK.Visible = false;
this.btn_Abolish.Text = "关闭";
this.btn_Abolish.Location = new Point(this.Width / 2 - this.btn_Abolish.Size.Width / 2, this.btn_Abolish.Location.Y);
this.cmb_CardType.Items.Add(memberInfoModel.CardType);
this.cmb_CardType.SelectedItem = memberInfoModel.CardType;
// this.cardTypeCbx.Text = memberInfoModel.CardType;
//this.cardTypeCbx.Enabled = false;
this.txt_Mail.Text = memberInfoModel.Mail;
//this.emailTxt.Enabled = false;
this.dtp_EndTime.Text = memberInfoModel.EndTime;
//this.endTimeTp.Enabled = false;
this.txt_IDCard.Text = memberInfoModel.IDCard;
// this.idNoTxt.Enabled = false;
this.cmb_IDType.Text = memberInfoModel.IDCardType;
//this.idTypeCbx.Enabled = false;
this.txt_Count.Text = memberInfoModel.Count;
//this.leftCountTxt.Enabled = false;
this.txt_CardNumber.Text = memberInfoModel.CardID;
// this.memberCardNoTxt.Enabled = false;
this.txt_Name.Text = memberInfoModel.Name;
//this.memberNameTxt.Enabled = false;
this.cmb_Sex.Text = memberInfoModel.Sex;
// this.memberSexCbx.Enabled = false;
this.txt_Phone.Text = memberInfoModel.Phone;
// this.phoneTxt.Enabled = false;
if (memberInfoModel.Photo != null && memberInfoModel.Photo.Length > 0)
{
this.pictureBox1.Image = CommTools.ByteToImg(memberInfoModel.Photo);
}
// this.pictureBox1.Enabled = false;
this.dtp_StartTime.Text = memberInfoModel.StartTime;
// this.startTimeTp.Enabled = false;
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="swipingInfoModel"></param>
public void DetialModel(MemberInfoModel memberInfoModel)
{
this.addTimeTp.Text = memberInfoModel.AddTime;
List<Control> filter=new List<Control>();
filter.Add(this.cardTypeCbx);
DisableControls(filter);
//this.addTimeTp.Enabled = false;
this.addressTxt.Text = memberInfoModel.Unit;
//this.addressTxt.Enabled = false;
this.birthdayDp.Text = memberInfoModel.Birthday;
//this.birthdayDp.Enabled = false;
this.bsTitleLb.Text = "查看会员信息";
this.btn_OK.Visible = false;
this.cardTypeCbx.Items.Add(memberInfoModel.CardType);
this.cardTypeCbx.SelectedItem = memberInfoModel.CardType;
// this.cardTypeCbx.Text = memberInfoModel.CardType;
//this.cardTypeCbx.Enabled = false;
this.emailTxt.Text = memberInfoModel.Mail;
//this.emailTxt.Enabled = false;
this.endTimeTp.Text = memberInfoModel.EndTime;
//this.endTimeTp.Enabled = false;
this.idNoTxt.Text = memberInfoModel.IDCard;
// this.idNoTxt.Enabled = false;
this.idTypeCbx.Text = memberInfoModel.IDCardType;
//this.idTypeCbx.Enabled = false;
this.leftCountTxt.Text = memberInfoModel.Count;
//this.leftCountTxt.Enabled = false;
this.memberCardNoTxt.Text = memberInfoModel.CardID;
// this.memberCardNoTxt.Enabled = false;
this.memberNameTxt.Text = memberInfoModel.Name;
//this.memberNameTxt.Enabled = false;
this.memberSexCbx.Text = memberInfoModel.Sex;
// this.memberSexCbx.Enabled = false;
this.phoneTxt.Text = memberInfoModel.Phone;
// this.phoneTxt.Enabled = false;
if (memberInfoModel.Photo != null && memberInfoModel.Photo.Length > 0)
{
this.pictureBox1.Image = ByteToImg(memberInfoModel.Photo);
}
// this.pictureBox1.Enabled = false;
this.startTimeTp.Text = memberInfoModel.StartTime;
// this.startTimeTp.Enabled = false;
}
public SellCardCastFrm(MemberInfoModel memberModel)
{
InitializeComponent();
addMemberModel = memberModel;
this.txt_CardType.Enabled = false;
this.dtp_StartTime.Enabled = false;
this.dtp_EndTime.Enabled = false;
this.txt_PriceAmount.Enabled = false;
this.txt_ChangeAmount.Enabled = false;
if (addMemberModel != null)
{
txt_CardType.Text = addMemberModel.CardType;
dtp_StartTime.Text = addMemberModel.StartTime;
dtp_EndTime.Text = addMemberModel.EndTime;
txt_LeftCount.Text = addMemberModel.Count;
List<CardTypeInfoModel> cardtypeModelList = cardTypeManager.GetModelList(" CardTypeName='" + addMemberModel.CardType + "'");
if (cardtypeModelList.Count > 0)
{
txt_PriceAmount.Text = cardtypeModelList[0].MonthsPrice;
}
}
}
/// <summary>
/// 提交售卡
/// </summary>
private void SubmitForSellCard()
{
errorProvider1.Clear();
if (txt_CardNumber.Text.Trim() == "")
{
errorProvider1.SetError(txt_CardNumber, "卡号不能为空！");
return;
}
List<MemberInfoModel> modelList = manager.GetModelList(" CardID='" + txt_CardNumber.Text + "'");
if (modelList.Count > 0)
{
errorProvider1.SetError(txt_CardNumber, "卡号已经存在，请更换！");
return;
}
//if (txt_Mail.Text.Trim() == "")
//{
// errorProvider1.SetError(txt_Mail, "邮箱不能为空！");
// return;
//}
if (cmb_CardType.Text.Trim() == "")
{
errorProvider1.SetError(cmb_CardType, "卡类别不能为空！");
return;
}
if (cmb_IDType.Text.Trim() == "")
{
errorProvider1.SetError(cmb_IDType, "证件类型不能为空！");
return;
}
if (txt_Name.Text.Trim() == "")
{
errorProvider1.SetError(txt_Name, "姓名不能为空！");
return;
}
if (txt_IDCard.Text.Trim() == "")
{
errorProvider1.SetError(txt_IDCard, "证件号不能为空！");
return;
}
if (cmb_Sex.Text.Trim() == "")
{
errorProvider1.SetError(cmb_Sex, "性别不能为空！");
return;
}
if (cmb_CardType.SelectedValue is Int32)
{
CardTypeInfoModel cardtypeModel = cardTypeManager.GetModel(Convert.ToInt32(cmb_CardType.SelectedValue));
if (cardtypeModel.TypeName.Equals("计时产品"))
{
if (dtp_StartTime.Text.Trim() == "")
{
errorProvider1.SetError(dtp_StartTime, "生效日期不能为空！");
return;
}
if (dtp_EndTime.Text.Trim() == "")
{
errorProvider1.SetError(dtp_EndTime, "失效日期不能为空！");
return;
}
}
if (cardtypeModel.TypeName.Equals("计次产品"))
{
if (txt_Count.Text.Trim() == "")
{
errorProvider1.SetError(txt_Count, "剩余次数不能为空！");
return;
}
}
}
if (dtp_Birthday.Text.Trim() == "")
{
errorProvider1.SetError(dtp_Birthday, "生日不能为空！");
return;
}
//if (txt_Phone.Text.Trim() == "")
//{
// errorProvider1.SetError(txt_Phone, "电话不能为空！");
// return;
//}
if (dtp_AddTime.Text.Trim() == "")
{
errorProvider1.SetError(dtp_AddTime, "办理日期不能为空！");
return;
}
//添加
if (FormName.Equals("ADD") || FormName.Equals("CONTINUED"))
{
MemberInfoModel model = new MemberInfoModel();
model.MemberID = manager.GetMaxId();
model.CardID = txt_CardNumber.Text.Trim();
model.Mail = txt_Mail.Text.Trim();
model.CardType = cmb_CardType.Text.Trim();
model.IDCardType = cmb_IDType.Text.Trim();
model.Name = txt_Name.Text.Trim();
model.IDCard = txt_IDCard.Text.Trim();
model.Sex = cmb_Sex.Text.Trim();
model.StartTime = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_StartTime.Text.Trim()));
model.Birthday = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_Birthday.Text.Trim()));
model.EndTime = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_EndTime.Text.Trim()));
model.Phone = txt_Phone.Text.Trim();
model.Count = txt_Count.Text.Trim();
model.Unit = txt_Unit.Text.Trim();
model.AddTime = CommTools.GetDateFormatStrot2(DateTime.Now);
if (buffer != null || this.pictureBox1.Image!=null)
{
Image image = this.pictureBox1.Image;
model.Photo = CommTools.GetByteFromImage(this.pictureBox1);
}
model.InfoType = "正常";
MainForm mf = (MainForm)this.Owner;
model.AddUserName = mf.lbl_login_name.Text.Trim().Split(':')[1];
int isAdd = 0;
switch (memberBusinessType)
{
case MemberBusinessType.SellCardType:
isAdd= manager.Add(model);
//MessageBox.Show("会员：" + txt_Name.Text.Trim() + " 添加" + (isAdd > 0 ? "成功！" : "失败！"));
CommTools.AddSystemLog("添加", "会员：" + txt_Name.Text.Trim() + " 添加" + (isAdd > 0 ? "成功！" : "失败！"));
break;
case MemberBusinessType.ContinuedCardType:
List<MemberInfoModel> memberInfoModels = manager.GetModelList("CardID='" + model.CardID + "'");
if (memberInfoModels != null && memberInfoModels.Count > 0)
{
model.MemberID = memberInfoModels[0].MemberID;
bool isFlag = manager.Update(model);
if (isFlag) isAdd = 1;
// MessageBox.Show("会员：" + txt_Name.Text.Trim() + " 续卡" + (isAdd > 0 ? "成功！" : "失败！"));
CommTools.AddSystemLog("续卡", "会员：" + txt_Name.Text.Trim() + " 续卡" + (isAdd > 0 ? "成功！" : "失败！"));
}
break;
}
//添加历史记录
MemberHistoryInfoModel hisModel = new MemberHistoryInfoModel();
hisModel.MemberID = manager.GetMaxId();
hisModel.CardID = txt_CardNumber.Text.Trim();
hisModel.Mail = txt_Mail.Text.Trim();
hisModel.CardType = cmb_CardType.Text.Trim();
hisModel.IDCardType = cmb_IDType.Text.Trim();
hisModel.Name = txt_Name.Text.Trim();
hisModel.IDCard = txt_IDCard.Text.Trim();
hisModel.Sex = cmb_Sex.Text.Trim();
hisModel.Photo = model.Photo;
hisModel.InfoType = model.InfoType;
hisModel.StartTime = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_StartTime.Text.Trim()));
hisModel.Birthday = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_Birthday.Text.Trim()));
hisModel.EndTime = CommTools.GetDateFormatStrot2(Convert.ToDateTime(dtp_EndTime.Text.Trim()));
hisModel.Phone = txt_Phone.Text.Trim();
hisModel.Count = txt_Count.Text.Trim();
hisModel.Unit = txt_Unit.Text.Trim();
hisModel.AddTime = CommTools.GetDateFormatStrot2(DateTime.Now);
hisModel.AddUserName = mf.lbl_login_name.Text.Trim().Split(':')[1];
hisModel.InfoType = "添加";
int isAddHis = hisManager.Add(hisModel);
this.Close();
//显示费用
SellCardCastFrm sellCardCastForm = new SellCardCastFrm(model);
sellCardCastForm.Owner = this.Owner;
sellCardCastForm.Show();
}
}
/// <summary>
/// 获取会员数据通过ID
/// </summary>
/// <returns></returns>
private MemberInfoModel GetMemberInfoByID()
{
List<MemberInfoModel> memberInfoModels =
memberInfoManager.GetModelList("IDCardType='" + this.cmb_IDType.Text + "' and IDCard='" + this.txt_IDCard.Text + "' and InfoType='正常'");
if (memberInfoModels != null && memberInfoModels.Count > 0)
{
toupdateMemberInfo = memberInfoModels[0];
return memberInfoModels[0];
}
return null;
}
/// <summary>
/// 获取会员信息
/// </summary>
/// <returns></returns>
private MemberInfoModel GetMemberInfo()
{
List<MemberInfoModel> memberInfoModels =
memberInfoManager.GetModelList("CardID='" + this.txt_CardNumber.Text + "' and InfoType='正常'");
if (memberInfoModels != null && memberInfoModels.Count > 0)
{
toupdateMemberInfo = memberInfoModels[0];
return memberInfoModels[0];
}
return null;
}
/// <summary>
/// 设置控件数据
/// </summary>
private void SetControlValue(MemberInfoModel memberInfoModel)
{
if (memberInfoModel == null) return;
List<CardTypeInfoModel> cardTypeInfoModels =
cardTypeInfoManager.GetModelList("CardTypeName='" + memberInfoModel.CardType + "'");
if (cardTypeInfoModels != null && cardTypeInfoModels.Count > 0)
{
this.cmb_CardType.Items.Add(memberInfoModel.CardType);
this.cmb_CardType.SelectedItem = memberInfoModel.CardType;
this.txt_Name.Text = memberInfoModel.Name;
if (backCardType == BackCardType.HasCard)
{
this.cmb_IDType.Items.Add(memberInfoModel.IDCardType);
this.cmb_IDType.SelectedItem = memberInfoModel.IDCardType;
this.txt_IDCard.Text = memberInfoModel.IDCard;
}
else if(backCardType==BackCardType.NoCard)
{
this.txt_CardNumber.Text = memberInfoModel.CardID;
this.cmb_CardType.Items.Add(memberInfoModel.CardType);
this.cmb_CardType.SelectedItem = memberInfoModel.CardType;
}
this.txt_Phone.Text = memberInfoModel.Phone;
this.dtp_AddTime.Text = memberInfoModel.AddTime;
this.dtp_StartTime.Text = memberInfoModel.StartTime;
this.dtp_EndTime.Text = memberInfoModel.EndTime;
if (memberInfoModel.Photo != null && memberInfoModel.Photo.Length > 0)
{
this.pictureBox1.Image = CommTools.ByteToImg(memberInfoModel.Photo);
}
if (cardTypeInfoModels[0].TypeName.Equals("计时产品"))
{
this.txt_TotalTimes.Enabled = false;
this.txt_LeftTimes.Text = "0";
this.txt_LeftTimes.Enabled = false;
this.txt_TotalTimes.Text = "0";
// 计算剩余天数
DateTime startTime=DateTime.Parse(memberInfoModel.StartTime);
DateTime endTime = DateTime.Parse(memberInfoModel.EndTime);
TimeSpan totalDate = endTime - startTime;
this.txt_TotalDays.Text = Convert.ToString((int)totalDate.TotalDays);
TimeSpan leftDate = endTime - DateTime.Now;
this.txt_LeftDays.Text = Convert.ToString((int)leftDate.TotalDays);
// 计算金额
this.txt_PaidAmount.Text = cardTypeInfoModels[0].MonthsPrice;
this.txt_ChangeAmount.Text = Convert.ToString(Convert.ToSingle(cardTypeInfoModels[0].MonthsPrice
)*(float)(leftDate.TotalDays/totalDate.TotalDays));
}
else if (cardTypeInfoModels[0].TypeName.Equals("计次产品"))
{
this.txt_TotalDays.Enabled = false;
this.txt_LeftDays.Enabled = false;
this.txt_TotalDays.Text = "0";
this.txt_LeftDays.Text = "0";
this.txt_TotalTimes.Text = cardTypeInfoModels[0].CardCount;
this.txt_LeftTimes.Text =
Convert.ToString(Convert.ToInt32(cardTypeInfoModels[0].CardCount) -
Convert.ToInt32(memberInfoModel.Count));
this.txt_PaidAmount.Text = cardTypeInfoModels[0].MonthsPrice;
this.txt_ChangeAmount.Text =
Convert.ToString(Convert.ToSingle(cardTypeInfoModels[0].MonthsPrice) *
(double)Convert.ToInt32(this.txt_LeftTimes) / Convert.ToUInt32(this.txt_TotalTimes));
}
}
}
/// <summary>
/// 会员刷卡
/// 如果是会员卡，那么操作人员用会员卡刷卡，照片、卡号和卡类型自动录入。如果是时段卡，那么失效日期会自动显示，剩余次数和消费人数变为灰色，不能操作。如果是次卡，那么剩余次数会自动显示当前剩余次数，点进场以后，剩余次数自动减1，然后显示新的剩余次数；此时，失效日期和消费人数变为灰色，不能操作
/// </summary>
private void MemberSwipeCaseInit()
{
ValidateFlag = true;
String cardNumber = this.txt_CardNumber.Text;
List<MemberInfoModel> memberInfoModels =
this.memberInfoManager.GetModelList("CardID='"+this.txt_CardNumber.Text + "' and InfoType='正常'");
if (memberInfoModels != null && memberInfoModels.Count > 0)
{
memberInfoModel = memberInfoModels[0];
if (memberInfoModels[0].Photo != null && memberInfoModels[0].Photo.Length > 0)
{
this.pictureBox1.Image = CommTools.ByteToImg(memberInfoModels[0].Photo);
txt_UserName.Text = memberInfoModels[0].Name;
}
this.cmb_CardType.Items.Add(memberInfoModels[0].CardType);
this.cmb_CardType.SelectedItem = memberInfoModels[0].CardType;
List<CardTypeInfoModel> cardTypeInfoModels = this.cardTypeInfoManager.GetModelList("CardTypeName='"+memberInfoModels[0].CardType+"'");
if (cardTypeInfoModels != null && cardTypeInfoModels.Count > 0)
{
switch (cardTypeInfoModels[0].TypeName)
{
case "计时产品":
this.dtp_EndTime.Text=memberInfoModels[0].EndTime;
this.txt_LeftCount.Enabled = false;
this.txt_CunsumeCount.Enabled = false;
break;
case "计次产品":
this.txt_LeftCount.Text = memberInfoModels[0].Count;
this.txt_LeftCount.Enabled = false;
this.dtp_EndTime.Enabled = false;
if (Convert.ToInt32(memberInfoModels[0].Count) <= 0)
{
this.ValidateFlag = false;
this.errorProvider1.Clear();
this.errorProvider1.SetError(this.txt_LeftCount, "剩余次数为0");
MessageBox.Show("剩余次数为0");
}
break;
}
}
}
else
{
MessageBox.Show("此卡号不存在");
return;
}
}
/// <summary>
/// 条件变化时获取数据
/// </summary>
/// <returns></returns>
private MemberInfoModel GetMemberInfo()
{
List<MemberInfoModel> memberInfoModels = memberInfoManager.GetModelList("IDCardType='" +this.cmb_IDCardType.Text+ "' and IDCard='"+this.txt_IDNumber.Text+"'");
if (memberInfoModels != null && memberInfoModels.Count > 0)
{
toupdateMemberInfo = memberInfoModels[0];
return memberInfoModels[0];
}
else
{
MessageBox.Show("未找到此身份信息");
return null;
}
}
/// <summary>
/// 设置窗体控件值
/// </summary>
/// <param name="memberInfoModel"></param>
private void SetControlValue(MemberInfoModel memberInfoModel)
{
if (memberInfoModel == null) return;
this.txt_CardNumber.Text = memberInfoModel.CardID;
this.cmb_CardType.Items.Add(memberInfoModel.CardType);
this.cmb_CardType.SelectedItem = memberInfoModel.CardType;
this.txt_Name.Text = memberInfoModel.Name;
this.cmb_Sex.Items.Add(memberInfoModel.Sex);
this.cmb_Sex.SelectedItem = memberInfoModel.Sex;
this.dtp_Birthday.Text = memberInfoModel.Birthday;
this.dtp_StartTime.Text = memberInfoModel.StartTime;
this.txt_Phone.Text = memberInfoModel.Phone;
this.dtp_EndTime.Text = memberInfoModel.EndTime;
this.txt_Mail.Text = memberInfoModel.Mail;
this.txt_Count.Text = memberInfoModel.Count;
this.txt_Unit.Text = memberInfoModel.Unit;
this.dtp_AddTime.Text = memberInfoModel.AddTime;
this.memberId = memberInfoModel.MemberID;
if (memberInfoModel.Photo != null && memberInfoModel.Photo.Length > 0)
{
this.pictureBox1.Image = CommTools.ByteToImg(memberInfoModel.Photo);
}
}
