private void button1_Click(object sender, EventArgs e)
{
if (selectMemberControl1.SelectedMembers.Count == 0)
{
MessageBox.Show("请选择会员！");
selectMemberControl1.Focus();
return;
}
PersonalTrain personalTrain = new PersonalTrain();
personalTrain.Member = selectMemberControl1.SelectedMembers[0];//comboBox2.SelectedItem as Member;
personalTrain.私教项目 = textBox1.Text.Trim();
personalTrain.次数 = (int)numericUpDown1.Value;
personalTrain.开始日期 = DateTime.Parse(textBox3.Text.Trim());
personalTrain.结束日期 = DateTime.Parse(textBox4.Text.Trim());
personalTrain.教练 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null;
personalTrain.备注 = textBox6.Text;
PersonalTrainLogic rl = PersonalTrainLogic.GetInstance();
int id = rl.AddPersonalTrain(personalTrain);
if (id > 0)
{
personalTrain.ID = id;
LoadPersonalTrains();
MessageBox.Show("添加成功！");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
if (selectMemberControl1.SelectedMembers.Count == 0)
{
MessageBox.Show("请选择会员！");
selectMemberControl1.Focus();
return;
}
PersonalTrain personalTrain = (PersonalTrain)comboBox1.SelectedItem;
personalTrain.Member = selectMemberControl1.SelectedMembers[0];//comboBox2.SelectedItem as Member;
personalTrain.私教项目 = textBox1.Text.Trim();
personalTrain.次数 = (int)numericUpDown1.Value;
personalTrain.开始日期 = DateTime.Parse(textBox3.Text.Trim());
personalTrain.结束日期 = DateTime.Parse(textBox4.Text.Trim());
personalTrain.教练 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null;
personalTrain.备注 = textBox6.Text;
PersonalTrainLogic rl = PersonalTrainLogic.GetInstance();
if (rl.UpdatePersonalTrain(personalTrain))
{
LoadPersonalTrains();
MessageBox.Show("修改成功！");
}
}
else
{
MessageBox.Show("先选定要修改的私教！");
}
}
private DataTable Search(string name, int sex = 0, string personalTr = null, Staff trainer = null)
{
string nm = "";
if (!string.IsNullOrEmpty(name))
{
nm = " and 会员 like '%" + name + "%'";
}
string sx = "";
if (sex > 0)
{
sx = " and 性别='" + (性别)Enum.ToObject(typeof(性别), (sex - 1)) + "'";
}
string cn = "";
if (!string.IsNullOrEmpty(personalTr) && personalTr.Trim() != "")
{
cn = " and 私教项目 like '%" + personalTr.Trim() + "%'";
}
string mb = "";
if (trainer != null)
{
mb = " and 教练='" + trainer.姓名 + "'";
}
string where = "(1=1)" + nm + sx + cn + mb;
return(PersonalTrainLogic.GetInstance().GetPersonalTrains(where));
}
private DataTable Search(string name, int sex = 0, string personalTr = null, Staff trainer = null)
{
string nm = "";
if (!string.IsNullOrEmpty(name))
{
nm = " and TF_Member.姓名 like '%" + name + "%'";
}
string sx = "";
if (sex > 0)
{
sx = " and TF_Member.性别=" + sex;
}
string cn = "";
if (!string.IsNullOrEmpty(personalTr) && personalTr.Trim() != "")
{
cn = " and TF_PersonalTrain.私教项目 like '%" + personalTr.Trim() + "%'";
}
string mb = "";
if (trainer != null)
{
mb = " and TF_PersonalTrain.教练=" + trainer.ID;
}
string where = nm + sx + cn + mb + " order by TF_PersonalTrain.ID desc";
return(PersonalTrainLogic.GetInstance().GetPersonalTrains(where));
}
public static PersonalTrainLogic GetInstance()
{
if (instance == null)
{
instance = new PersonalTrainLogic();
}
return(instance);
}
private void LoadPersonalTrains()
{
List <PersonalTrain> elements = PersonalTrainLogic.GetInstance().GetAllPersonalTrains();
comboBox1.Items.Clear();
foreach (PersonalTrain element in elements)
{
comboBox1.Items.Add(element);
}
}
private void LoadPersonalTrains()
{
List <PersonalTrain> elements = PersonalTrainLogic.GetInstance().GetAllPersonalTrains();
comboBox1.Items.Clear();
foreach (PersonalTrain element in elements)
{
comboBox1.Items.Add(element);
}
dataGridView1.DataSource = PersonalTrainLogic.GetInstance().GetPersonalTrains(string.Empty);
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
if (MessageBox.Show("确定要删除该私教？", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
PersonalTrain personalTrain = (PersonalTrain)comboBox1.SelectedItem;
if (PersonalTrainLogic.GetInstance().DeletePersonalTrain(personalTrain))
{
LoadPersonalTrains();
}
}
}
else
{
MessageBox.Show("先选定要删除的私教！");
}
}