public bool UpdateMemberMoney(MemberMoney element)
{
string sql = "update TF_MemberMoney set 会员姓名='" + element.会员姓名 + "', 会员电话='" + element.会员电话 + "', 账户余额=" + element.账户余额 + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool DeleteMemberMoney(MemberMoney element)
{
string sql = "delete from TF_MemberMoney where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public List <MemberMoney> GetMemberMoneys(string name, string mobile, decimal lessThan = 0)
{
List <MemberMoney> elements = new List <MemberMoney>();
string sql = "select * from TF_MemberMoney where (1=1)";
if (!string.IsNullOrEmpty(name))
{
sql += " and 会员姓名 like '%" + name.Trim() + "%'";
}
if (!string.IsNullOrEmpty(mobile))
{
sql += " and 会员电话 like '%" + mobile.Trim() + "%'";
}
if (lessThan > 0)
{
sql += " and 账户余额<" + lessThan;
}
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MemberMoney element = new MemberMoney();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.会员姓名 = dt.Rows[i]["会员姓名"].ToString();
element.会员电话 = dt.Rows[i]["会员电话"].ToString();
element.账户余额 = Convert.ToDecimal(dt.Rows[i]["账户余额"]);
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
private void button1_Click(object sender, EventArgs e)
{
if (selectMemberControl1.SelectedMembers.Count == 0)
{
MessageBox.Show("请先指定一个会员！");
selectMemberControl1.Focus();
return;
}
Member member = selectMemberControl1.SelectedMembers[0];
MemberMoneyLogic mml = MemberMoneyLogic.GetInstance();
string name = member.姓名;
string mobile = member.电话;
MemberMoney mm = null;
if (!mml.ExistsName(name, mobile))
{
mm = new MemberMoney();
mm.会员姓名 = name;
mm.会员电话 = mobile;
mm.备注 = "账户创建于" + DateTime.Now.ToString();
int id = mml.AddMemberMoney(mm);
if (id > 0)
{
mm.ID = id;
}
}
else
{
mm = mml.GetMemberMoney(name, mobile);
}
if (mm != null)
{
MoneyRecord mr = new MoneyRecord();
mr.会员账户 = mm;
mr.发生金额 = numericUpDown1.Value;
mr.是否充值 = true;
mr.操作人 = textBox3.Text;
if (MoneyRecordLogic.GetInstance().AddMoneyRecord(mr) > 0)
{
LoadMoneyRecords();
MessageBox.Show("保存会员消费记录以及扣款成功！");
}
else
{
MessageBox.Show("保存会员消费记录失败或者扣款失败！");
}
}
else
{
MessageBox.Show("无法创建会员账户！");
}
}
public int AddMemberMoney(MemberMoney element)
{
string sql = "insert into TF_MemberMoney (会员姓名, 会员电话, 账户余额, 备注) values ('" + element.会员姓名 + "', '" + element.会员电话 + "', " + element.账户余额 + ", '" + element.备注 + "'); select SCOPE_IDENTITY()";
object obj = sqlHelper.ExecuteSqlReturn(sql);
int R;
if (obj != null && obj != DBNull.Value && int.TryParse(obj.ToString(), out R))
{
return(R);
}
else
{
return(0);
}
}
public MemberMoney GetMemberMoney(int id)
{
string sql = "select * from TF_MemberMoney where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
MemberMoney element = new MemberMoney();
element.ID = id;
element.会员姓名 = dt.Rows[0]["会员姓名"].ToString();
element.会员电话 = dt.Rows[0]["会员电话"].ToString();
element.账户余额 = Convert.ToDecimal(dt.Rows[0]["账户余额"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public MemberMoney GetMemberMoney(string name, string mobile)
{
MemberMoney element = null;
string sql = "select * from TF_MemberMoney where 会员姓名='" + name + "' and 会员电话='" + mobile + "'";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
element = new MemberMoney();
element.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
element.会员姓名 = dt.Rows[0]["会员姓名"].ToString();
element.会员电话 = dt.Rows[0]["会员电话"].ToString();
element.账户余额 = Convert.ToDecimal(dt.Rows[0]["账户余额"]);
element.备注 = dt.Rows[0]["备注"].ToString();
}
return(element);
}
public List <MemberMoney> GetMemberMoneysByMobile(string mobile)
{
List <MemberMoney> elements = new List <MemberMoney>();
string sql = "select * from TF_MemberMoney where 会员电话 like '%" + mobile.Trim() + "%'";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MemberMoney element = new MemberMoney();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.会员姓名 = dt.Rows[i]["会员姓名"].ToString();
element.会员电话 = dt.Rows[i]["会员电话"].ToString();
element.账户余额 = Convert.ToDecimal(dt.Rows[i]["账户余额"]);
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
public Member GetMember(MemberMoney mm)
{
return(MemberLogic.GetInstance().GetMember(mm.会员姓名, mm.会员电话));
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请先选择要出库的产品！");
comboBox1.Focus();
return;
}
int num = 0;
int R;
if (int.TryParse(textBox1.Text.Trim(), out R))
{
num = R;
}
else
{
MessageBox.Show("数量必须为整数！");
textBox1.Focus();
textBox1.SelectAll();
return;
}
decimal price = 0;
decimal r;
if (decimal.TryParse(textBox2.Text.Trim(), out r))
{
price = r;
}
else
{
MessageBox.Show("实价必须为整数！");
textBox2.Focus();
textBox2.SelectAll();
return;
}
if (checkBox1.Checked)
{
if (selectMemberControl1.SelectedMembers.Count == 0)
{
MessageBox.Show("请选择当前消费的会员！");
selectMemberControl1.Focus();
return;
}
}
Income element = new Income();
element.PID = ((Product)comboBox1.SelectedItem).ID;
element.IsProduct = true;
element.IsIncome = false;
element.数量 = num;
element.实价 = price;
element.经手人 = textBox3.Text.Trim();
element.备注 = textBox4.Text.Trim();
if (IncomeLogic.GetInstance().AddIncome(element) > 0)
{
MessageBox.Show("登记成功！");
if (checkBox1.Checked)
{
Member member = selectMemberControl1.SelectedMembers[0];
decimal sum = num * price;
if (sum > 0)
{
MemberMoneyLogic mml = MemberMoneyLogic.GetInstance();
string name = member.姓名;
string mobile = member.电话;
MemberMoney mm = null;
if (!mml.ExistsName(name, mobile))
{
mm = new MemberMoney();
mm.会员姓名 = name;
mm.会员电话 = mobile;
mm.备注 = "账户创建于" + DateTime.Now.ToString();
mml.AddMemberMoney(mm);
}
else
{
mm = mml.GetMemberMoney(name, mobile);
}
if (mm != null)
{
MoneyRecord mr = new MoneyRecord();
mr.会员账户 = mm;
mr.发生金额 = sum;
mr.是否充值 = false;
mr.操作人 = element.经手人;
if (MoneyRecordLogic.GetInstance().AddMoneyRecord(mr) > 0)
{
MessageBox.Show("保存会员消费记录以及扣款成功！");
}
else
{
MessageBox.Show("保存会员消费记录失败或者扣款失败！");
}
}
else
{
MessageBox.Show("无法创建会员账户！");
}
}
else
{
MessageBox.Show("消费额不能为负！");
}
}
}
else
{
MessageBox.Show("登记失败！");
}
}