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("会员余额不足以支付当前应收金额！");
}
}
}
}
}
