public bool UpdatePersonalTrain(PersonalTrain element)
{
string sql = "update TF_PersonalTrain set MemberID=" + element.Member.ID + ", 私教项目='" + element.私教项目 + "', 次数=" + element.次数 + ", 开始日期='" + element.开始日期 + "', 结束日期='" + element.结束日期 + "', 教练=" + element.教练.ID + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool DeletePersonalTrain(PersonalTrain element)
{
string sql = "delete from TF_PersonalTrain where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public List <PersonalTrain> GetAllPersonalTrains()
{
List <PersonalTrain> elements = new List <PersonalTrain>();
string sql = "select * from TF_PersonalTrain";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
PersonalTrain element = new PersonalTrain();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[i]["MemberID"]));
element.私教项目 = dt.Rows[i]["私教项目"].ToString();
element.次数 = Convert.ToInt32(dt.Rows[i]["次数"]);
element.开始日期 = Convert.ToDateTime(dt.Rows[i]["开始日期"]);
element.结束日期 = Convert.ToDateTime(dt.Rows[i]["结束日期"]);
element.教练 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["教练"]));
element.备注 = dt.Rows[i]["备注"].ToString();
element.SaleTime = Convert.ToDateTime(dt.Rows[i]["SaleTime"]);
elements.Add(element);
}
}
return(elements);
}
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 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 comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
PersonalTrain personalTrain = comboBox1.SelectedItem as PersonalTrain;
if (personalTrain != null)
{
//comboBox2.SelectedIndex = GetIndexByMember(personalTrain.Member, comboBox2);
selectMemberControl1.SelectedMembers = new List <Member>()
{
personalTrain.Member
};
textBox1.Text = personalTrain.私教项目;
numericUpDown1.Value = personalTrain.次数;
textBox3.Text = personalTrain.开始日期.ToString("yyyy-MM-dd");
textBox4.Text = personalTrain.结束日期.ToString("yyyy-MM-dd");
monthCalendar1.SelectionStart = personalTrain.开始日期;
monthCalendar2.SelectionStart = personalTrain.结束日期;
selectStaffControl1.SelectedStaffs = new List <Staff>()
{
personalTrain.教练
};
textBox6.Text = personalTrain.备注;
}
}
}
public int AddPersonalTrain(PersonalTrain element)
{
string sql = "insert into TF_PersonalTrain (MemberID, 私教项目, 次数, 开始日期, 结束日期, 教练, 备注) values (" + element.Member.ID + ", '" + element.私教项目 + "', " + element.次数 + ", '" + element.开始日期 + "', '" + element.结束日期 + "', " + element.教练.ID + ", '" + 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);
}
}
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("先选定要删除的私教！");
}
}
public PersonalTrain GetPersonalTrain(int id)
{
string sql = "select * from TF_PersonalTrain where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
PersonalTrain element = new PersonalTrain();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.私教项目 = dt.Rows[0]["私教项目"].ToString();
element.次数 = Convert.ToInt32(dt.Rows[0]["次数"]);
element.开始日期 = Convert.ToDateTime(dt.Rows[0]["开始日期"]);
element.结束日期 = Convert.ToDateTime(dt.Rows[0]["结束日期"]);
element.教练 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["教练"]));
element.备注 = dt.Rows[0]["备注"].ToString();
element.SaleTime = Convert.ToDateTime(dt.Rows[0]["SaleTime"]);
return(element);
}
return(null);
}
