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("先选定要修改的续卡记录！");
}
}
