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("先选定要删除的工作日报！");
}
}
