public bool DeleteRenew(Renew element) { string sql = "delete from TF_Renew where ID=" + element.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
private void button1_Click(object sender, EventArgs e) { if (selectMemberControl1.SelectedMembers.Count == 0) { MessageBox.Show("请选择会员!"); selectMemberControl1.Focus(); return; } Renew renew = new Renew(); renew.Member = selectMemberControl1.SelectedMembers[0];//comboBox2.SelectedItem as Member; renew.卡种 = comboBox3.SelectedItem as CardType; renew.卡号 = textBox2.Text.Trim(); renew.续卡时间 = DateTime.Parse(textBox3.Text.Trim()); renew.经手人 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null; renew.备注 = textBox6.Text; RenewLogic rl = RenewLogic.GetInstance(); int id = rl.AddRenew(renew); if (id > 0) { renew.ID = id; LoadRenews(); MessageBox.Show("添加成功!"); } }
public bool UpdateRenew(Renew element) { string sql = "update TF_Renew set MemberID=" + element.Member.ID + ", 卡种=" + element.卡种.ID + ", 卡号='" + element.卡号 + "', 续卡时间='" + element.续卡时间 + "', 备注='" + element.备注 + "', 经手人=" + element.经手人.ID + " where ID=" + element.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
private void button2_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { if (selectMemberControl1.SelectedMembers.Count == 0) { MessageBox.Show("请选择会员!"); selectMemberControl1.Focus(); return; } Renew renew = (Renew)comboBox1.SelectedItem; renew.Member = selectMemberControl1.SelectedMembers[0];//comboBox2.SelectedItem as Member; renew.卡种 = comboBox3.SelectedItem as CardType; renew.卡号 = textBox2.Text.Trim(); renew.续卡时间 = DateTime.Parse(textBox3.Text.Trim()); renew.经手人 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null; renew.备注 = textBox6.Text; RenewLogic rl = RenewLogic.GetInstance(); if (rl.UpdateRenew(renew)) { LoadRenews(); MessageBox.Show("修改成功!"); } } else { MessageBox.Show("先选定要修改的续卡记录!"); } }
public int AddRenew(Renew element) { string sql = "insert into TF_Renew (MemberID, 卡种, 卡号, 续卡时间, 备注, 经手人) values (" + element.Member.ID + ", " + element.卡种.ID + ", '" + element.卡号 + "', '" + element.续卡时间 + "', '" + element.备注 + "', " + element.经手人.ID + "); 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); } }
private void button3_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { if (MessageBox.Show("确定要删除该续卡记录?", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK) { Renew renew = (Renew)comboBox1.SelectedItem; if (RenewLogic.GetInstance().DeleteRenew(renew)) { LoadRenews(); } } } else { MessageBox.Show("先选定要删除的续卡记录!"); } }
public Renew GetRenew(int id) { string sql = "select * from TF_Renew where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { Renew element = new Renew(); element.ID = id; element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"])); element.卡种 = CardTypeLogic.GetInstance().GetCardType(Convert.ToInt32(dt.Rows[0]["CardType"])); element.卡号 = dt.Rows[0]["卡号"].ToString(); element.续卡时间 = Convert.ToDateTime(dt.Rows[0]["续卡时间"]); element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["经手人"])); element.备注 = dt.Rows[0]["备注"].ToString(); return(element); } return(null); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { Renew renew = comboBox1.SelectedItem as Renew; if (renew != null) { comboBox2.SelectedIndex = GetIndexByMember(renew.Member, comboBox2); comboBox3.SelectedIndex = GetIndexByCardType(renew.卡种, comboBox3); textBox2.Text = renew.卡号; textBox3.Text = renew.续卡时间.ToString("yyyy-MM-dd"); monthCalendar1.SelectionStart = renew.续卡时间; selectStaffControl1.SelectedStaffs = new List <Staff>() { renew.经手人 }; textBox6.Text = renew.备注; } } }
public List <Renew> GetAllRenews() { List <Renew> elements = new List <Renew>(); string sql = "select * from TF_Renew"; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Renew element = new Renew(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[i]["MemberID"])); element.卡种 = CardTypeLogic.GetInstance().GetCardType(Convert.ToInt32(dt.Rows[i]["卡种"])); element.卡号 = dt.Rows[i]["卡号"].ToString(); element.续卡时间 = Convert.ToDateTime(dt.Rows[i]["续卡时间"]); element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["经手人"])); element.备注 = dt.Rows[i]["备注"].ToString(); elements.Add(element); } } return(elements); }
private void button2_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { Renew renew = new Renew(); renew.ID = ((Product)comboBox1.SelectedItem).ID; renew.Member = comboBox2.SelectedItem as Member; renew.卡种 = renew.Member.卡种; renew.卡号 = textBox2.Text.Trim(); renew.续卡时间 = DateTime.Parse(textBox3.Text.Trim()); renew.经手人 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null; renew.备注 = textBox6.Text; RenewLogic rl = RenewLogic.GetInstance(); if (rl.UpdateRenew(renew)) { LoadRenews(); MessageBox.Show("修改成功!"); } } else { MessageBox.Show("先选定要修改的续卡记录!"); } }