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