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); }