private void button2_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { Worklog worklog = new Worklog(); worklog.ID = ((Product)comboBox1.SelectedItem).ID; worklog.销售 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null; worklog.日期 = DateTime.Parse(textBox3.Text.Trim()); worklog.客户 = textBox1.Text.Trim(); worklog.电话 = textBox2.Text.Trim(); worklog.是否自访 = checkBox1.Checked; worklog.是否老会员 = checkBox2.Checked; worklog.是否电话拜访 = checkBox3.Checked; worklog.性别 = (性别)Enum.ToObject(typeof(性别), comboBox2.SelectedIndex); worklog.意向 = textBox4.Text.Trim(); worklog.住址 = textBox5.Text.Trim(); worklog.备注 = textBox6.Text; WorklogLogic rl = WorklogLogic.GetInstance(); if (rl.UpdateWorklog(worklog)) { LoadWorklogs(); MessageBox.Show("修改成功!"); } } else { MessageBox.Show("先选定要修改的工作日报!"); } }
private DataTable Search(string name, int sex = 0, CardType cardType = null, string cardNo = null, string mobile = null) { string nm = ""; if (!string.IsNullOrEmpty(name) && name.Trim() != "") { nm = " and TF_Member.姓名 like '%" + name + "%'"; } string sx = ""; if (sex > 0) { sx = " and TF_Member.性别=" + sex; } string ct = ""; if (cardType != null) { ct = " and TF_Member.卡种=" + cardType.ID; } string cn = ""; if (!string.IsNullOrEmpty(cardNo) && cardNo.Trim() != "") { cn = " and TF_Member.卡号 like '%" + cardNo.Trim() + "%'"; } string mb = ""; if (!string.IsNullOrEmpty(mobile) && mobile.Trim() != "") { mb = " and TF_Member.电话 like '%" + mobile.Trim() + "%'"; } string where = nm + sx + ct + cn + mb + " order by TF_Worklog.ID desc"; return(WorklogLogic.GetInstance().GetWorklogs(where)); }
private void button1_Click(object sender, EventArgs e) { Worklog worklog = new Worklog(); worklog.销售 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null; worklog.日期 = DateTime.Parse(textBox3.Text.Trim()); worklog.客户 = textBox1.Text.Trim(); worklog.电话 = textBox2.Text.Trim(); worklog.是否自访 = checkBox1.Checked; worklog.是否老会员 = checkBox2.Checked; worklog.是否电话拜访 = checkBox3.Checked; worklog.性别 = (性别)Enum.ToObject(typeof(性别), comboBox2.SelectedIndex); worklog.意向 = textBox4.Text.Trim(); worklog.住址 = textBox5.Text.Trim(); worklog.备注 = textBox6.Text; WorklogLogic rl = WorklogLogic.GetInstance(); int id = rl.AddWorklog(worklog); if (id > 0) { worklog.ID = id; LoadWorklogs(); MessageBox.Show("添加成功!"); } }
public static WorklogLogic GetInstance() { if (instance == null) { instance = new WorklogLogic(); } return(instance); }
private void LoadWorklogs() { List <Worklog> elements = WorklogLogic.GetInstance().GetAllWorklogs(); comboBox1.Items.Clear(); foreach (Worklog element in elements) { comboBox1.Items.Add(element); } }
private void LoadWorklogs() { List <Worklog> elements = WorklogLogic.GetInstance().GetAllWorklogs(); comboBox1.Items.Clear(); foreach (Worklog element in elements) { comboBox1.Items.Add(element); } dataGridView1.DataSource = WorklogLogic.GetInstance().GetWorklogs(string.Empty); }
private DataTable Search(Staff staff, string start, string end) { string nm = ""; if (staff != null) { nm = " and 销售='" + staff.姓名 + "'"; } string where = "(1=1)" + nm + " and 日期 between '" + start + "' and '" + end + "'"; return(WorklogLogic.GetInstance().GetWorklogs(where)); }
private void button3_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { if (MessageBox.Show("确定要删除该工作日报?", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK) { Worklog worklog = (Worklog)comboBox1.SelectedItem; if (WorklogLogic.GetInstance().DeleteWorklog(worklog)) { LoadWorklogs(); } } } else { MessageBox.Show("先选定要删除的工作日报!"); } }