protected override void Loading() { var obj = BaseInfoMember.FindById(MemberId); FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1); ctRechargeDate.Value = DateTime.Now; remainingSum = ctRemainingSum.Value; }
public static void ImportToAccess(string tableName) { OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { DataSet ds = new DataSet(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + ofd.FileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; strExcel = string.Format("select * from [{0}$]", "Sheet1"); //Sheet1为excel中工作薄 myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, "Sheet1"); DataTable dt = ds.Tables["Sheet1"]; for (int iRow = 1; iRow < dt.Rows.Count; iRow++) { BaseInfoMember bifm = BaseInfoMember.New; bifm.CardNumber = dt.Rows[iRow][0].ToString(); bifm.MemberName = dt.Rows[iRow][1].ToString(); bifm.PinYin = AutoPinYin.GetPinYin(bifm.MemberName); bifm.Password = dt.Rows[iRow][3].ToString(); bifm.Birth = (DateTime)dt.Rows[iRow][4]; bifm.Mobile = dt.Rows[iRow][5].ToString(); bifm.Phone = dt.Rows[iRow][6].ToString(); bifm.DiscountRate = (decimal)dt.Rows[iRow][7]; bifm.RemainingSum = (decimal)dt.Rows[iRow][8]; bifm.TotalBonusPoint = (decimal)dt.Rows[iRow][9]; bifm.Frequency = (decimal)dt.Rows[iRow][10]; bifm.TotalSpending = (decimal)dt.Rows[iRow][11]; bifm.Description = dt.Rows[iRow][12].ToString(); bifm.SavedOn = (DateTime)dt.Rows[iRow][13]; bifm.OptrType = UserStatics.OptrType; bifm.Save(); } //DbEntry.Context.UsingConnection(delegate() //{ // IDbBulkCopy c = DbEntry.Context.GetDbBulkCopy(); // c.BatchSize = 10; // c.DestinationTableName = tableName; // c.NotifyAfter = 10; // //c.SqlRowsCopied += new SqlRowsCopiedEventHandler( // // delegate(object sender, SqlRowsCopiedEventArgs e) // // { // // Console.WriteLine("{0} rows copied.", e.RowsCopied); // // }); // c.WriteToServer(dt); //}); } }
private void PerformClick() { FrmBaseInfoMember fbim = new FrmBaseInfoMember(); fbim.IsSelect = true; fbim.ShowDialog(); //返回的SelectedValue,取出SelectedValue的相应数据 BaseInfoMember bim = BaseInfoMember.FindById(fbim.SelectedValue); ctMemberCardNumber.Text = bim.CardNumber; MemberId = fbim.SelectedValue; fbim.Dispose(); }
protected override void Loading() { if (!IsAdd) { var obj = BaseInfoMember.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1); } else { ctDiscountRate.Value = 100; ctJoinedDate.Value = DateTime.Now.Date; } }
protected override void Saving() { if (IsAdd) { var obj = BaseInfoMember.FindById(MemberId); var objRecharge = BaseInfoMemberRecharge.New; FrmAddEditBindComboBoxText.BindControlsToObject(objRecharge, tabPage1); objRecharge.OptrType = UserStatics.OptrType; objRecharge.PayType = "现金"; objRecharge.Save(); obj.RemainingSum = ctRemainingSum.Value; obj.BaseInfoMemberRecharges.Add(objRecharge); obj.Save(); } }
protected override void Saving() { if (IsAdd) { var obj = BaseInfoMember.New; FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.Save(); } else { var obj = BaseInfoMember.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.Save(); } }
public void ImportToAccess() { OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { DataSet ds = new DataSet(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + ofd.FileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; strExcel = string.Format("select * from [{0}$]", "Sheet1"); //Sheet1为excel中工作薄 myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, "Sheet1"); DataTable dt = ds.Tables["Sheet1"]; Encoding gb2312 = Encoding.GetEncoding("GB2312"); for (int iRow = 1; iRow < dt.Rows.Count; iRow++) { BaseInfoMember bifm = BaseInfoMember.New; bifm.JoinedDate = (DateTime)dt.Rows[iRow][0]; bifm.CardNumber = dt.Rows[iRow][1].ToString(); bifm.MemberName = dt.Rows[iRow][2].ToString(); bifm.PinYin = PinYinTransfer.GetInitials(bifm.MemberName, gb2312); bifm.Password = dt.Rows[iRow][4].ToString(); bifm.Birth = (DateTime)dt.Rows[iRow][5]; bifm.Mobile = dt.Rows[iRow][6].ToString(); bifm.Phone = dt.Rows[iRow][7].ToString(); bifm.DiscountRate = decimal.Parse(dt.Rows[iRow][8].ToString()); bifm.RemainingSum = decimal.Parse(dt.Rows[iRow][9].ToString()); bifm.TotalBonusPoint = decimal.Parse(dt.Rows[iRow][10].ToString()); bifm.Frequency = decimal.Parse(dt.Rows[iRow][11].ToString()); bifm.TotalSpending = decimal.Parse(dt.Rows[iRow][12].ToString()); bifm.Description = dt.Rows[iRow][13].ToString(); bifm.SavedOn = DateTime.Now; bifm.OptrType = UserStatics.OptrType; bifm.Save(); } } }
private void RaiseMemberSearchWindow() { FrmBaseInfoMember fim = new FrmBaseInfoMember();; fim.IsSelect = true; fim.Text = "请选择会员"; fim.ShowDialog(); MemberId = fim.SelectedValue; //返回的SelectedValue,取出SelectedValue的EquipmentInformation if (MemberId != 0) { BaseInfoMember bim = BaseInfoMember.FindById(MemberId); //绑定各个控件 FrmAddEditBindComboBoxText.BindObjectToControls(bim, panelTop); if (bim.RemainingSum > 0) { ctRemainingSum.Text = bim.RemainingSum.ToString(); lbRemainingSum.Visible = true; ctRemainingSum.Visible = true; } } fim.Dispose(); }
internal static void DelCell(long id) { BaseInfoMember.DeleteAll(CK.K["Id"] == id); }
private void btnFullPay_Click(object sender, EventArgs e) { BaseInfoMember bim = BaseInfoMember.FindById(MemberId); if (ctCardNumber.Text == "" && ctMemberName.Text.Trim() != "") { MessageBox.Show("本单据看到会员名称,却看不到会员号,请确认会员号不能为空!"); } else { //判断是否存在会员ID //1.如果会员ID不存在 //1a.实收<应收,则提示实收款不足 //2b.实收>=应收,则完成正常结算 if (MemberId == 0) { if (ctRealPay.Value < decimal.Parse(ctUnderPay.Text)) { MessageBox.Show("实收不足以支付当前应收金额!"); } else { PayAllDue(); //3.弹出支付完成提示窗口 //todo 需要初始化POS数据,增加单号 MessageBox.Show("已经完成结算!"); } } //2.会员ID存在 //1a.会员存款>应收,直接扣除会员存款,完成结算 //1b.会员存款<应收, //1ba.如果存款+实付 > 应收,完成结算,会员存款清零,并提示 else { if (decimal.Parse(ctRemainingSum.Text) >= decimal.Parse(ctUnderPay.Text)) { PayAllDue(); bim.Frequency += 1; bim.RemainingSum -= decimal.Parse(ctUnderPay.Text); bim.TotalSpending += decimal.Parse(ctUnderPay.Text); bim.Save(); MessageBox.Show("已经完成结算!"); InitialPos(); } else { if (bim.RemainingSum + ctRealPay.Value >= decimal.Parse(ctUnderPay.Text)) { PayAllDue(); bim.RemainingSum = 0; bim.Save(); //todo 在这里提示会员是否充值 MessageBox.Show("会员余额已经为零,是否要充值?"); } else { MessageBox.Show("会员余额不足以支付当前应收金额!"); } } } } }