public List <FinanceDetail> GetFinanceDetailList(string where)
{
List <FinanceDetail> elements = new List <FinanceDetail>();
if (!string.IsNullOrEmpty(where))
{
string w = where.Trim().ToLower();
if (!w.StartsWith("where "))
{
w = "where " + w;
}
string sql = "select * from TF_FinanceDetail " + w;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
FinanceDetail element = new FinanceDetail();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.项目 = dt.Rows[i]["项目"].ToString();
element.金额 = Convert.ToDecimal(dt.Rows[i]["金额"]);
element.是否进账 = Convert.ToBoolean(dt.Rows[i]["是否进账"]);
element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["责任人"]));
element.备注 = dt.Rows[i]["备注"].ToString();
element.提交时间 = Convert.ToDateTime(dt.Rows[i]["提交时间"]);
element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]);
elements.Add(element);
}
}
}
return(elements);
}
public List <FinanceDetail> GetFinanceDetailsByIds(string ids)
{
List <FinanceDetail> elements = new List <FinanceDetail>();
string Ids = "";
if (!string.IsNullOrEmpty(ids))
{
Ids = " where ID in (" + ids + ")";
}
string sql = "select * from TF_FinanceDetail" + Ids;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
FinanceDetail element = new FinanceDetail();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.项目 = dt.Rows[i]["项目"].ToString();
element.金额 = Convert.ToDecimal(dt.Rows[i]["金额"]);
element.是否进账 = Convert.ToBoolean(dt.Rows[i]["是否进账"]);
element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["责任人"]));
element.备注 = dt.Rows[i]["备注"].ToString();
element.提交时间 = Convert.ToDateTime(dt.Rows[i]["提交时间"]);
element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]);
elements.Add(element);
}
}
return(elements);
}
public List <Dairy> GetAllDairys()
{
List <Dairy> elements = new List <Dairy>();
string sql = "select * from TF_Dairy";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Dairy element = new Dairy();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.Pos机会籍 = Convert.ToDecimal(dt.Rows[i]["Pos机会籍"]);
element.Pos机私教 = Convert.ToDecimal(dt.Rows[i]["Pos机私教"]);
element.现金会籍 = Convert.ToDecimal(dt.Rows[i]["现金会籍"]);
element.现金私教 = Convert.ToDecimal(dt.Rows[i]["现金私教"]);
element.微信会籍 = Convert.ToDecimal(dt.Rows[i]["微信会籍"]);
element.微信私教 = Convert.ToDecimal(dt.Rows[i]["微信私教"]);
element.现金存水 = Convert.ToDecimal(dt.Rows[i]["现金存水"]);
element.微信存水 = Convert.ToDecimal(dt.Rows[i]["微信存水"]);
element.水吧余 = Convert.ToDecimal(dt.Rows[i]["水吧余"]);
element.总金额 = Convert.ToDecimal(dt.Rows[i]["总金额"]);
element.备注 = dt.Rows[i]["备注"].ToString();
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["经手人"]));
element.日期 = Convert.ToDateTime(dt.Rows[i]["日期"]);
elements.Add(element);
}
}
return(elements);
}
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);
}
public Dairy GetDairy(int id)
{
string sql = "select * from TF_Dairy where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Dairy element = new Dairy();
element.ID = id;
element.Pos机会籍 = Convert.ToDecimal(dt.Rows[0]["Pos机会籍"]);
element.Pos机私教 = Convert.ToDecimal(dt.Rows[0]["Pos机私教"]);
element.现金会籍 = Convert.ToDecimal(dt.Rows[0]["现金会籍"]);
element.现金私教 = Convert.ToDecimal(dt.Rows[0]["现金私教"]);
element.微信会籍 = Convert.ToDecimal(dt.Rows[0]["微信会籍"]);
element.微信私教 = Convert.ToDecimal(dt.Rows[0]["微信私教"]);
element.现金存水 = Convert.ToDecimal(dt.Rows[0]["现金存水"]);
element.微信存水 = Convert.ToDecimal(dt.Rows[0]["微信存水"]);
element.水吧余 = Convert.ToDecimal(dt.Rows[0]["水吧余"]);
element.总金额 = Convert.ToDecimal(dt.Rows[0]["总金额"]);
element.备注 = dt.Rows[0]["备注"].ToString();
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["经手人"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
return(element);
}
return(null);
}
private DataTable Search(string name, int sex = 0, Department dep = null, StaffCondition condition = null, string mobile = null)
{
string nm = "";
if (!string.IsNullOrEmpty(name))
{
nm = " and 姓名 like '%" + name + "%'";
}
string sx = "";
if (sex > 0)
{
sx = " and 性别='" + (性别)Enum.ToObject(typeof(性别), (sex - 1)) + "'";
}
string dp = "";
if (dep != null)
{
dp = " and 部门='" + dep.Name + "'";
}
string cd = "";
if (condition != null)
{
cd = " and 状态='" + condition.状态 + "'";
}
string mb = "";
if (!string.IsNullOrEmpty(mb) && mb.Trim() != "")
{
mb = " and 电话 like '%" + mb.Trim() + "%'";
}
string where = "(1=1)" + nm + sx + dp + cd + mb;
return(StaffLogic.GetInstance().GetStaffs(where));
}
private DataTable Search(string name, int sex = 0, Department dep = null, StaffCondition condition = null, string mobile = null)
{
string nm = "";
if (!string.IsNullOrEmpty(name))
{
nm = " and 姓名 like '%" + name + "%'";
}
string sx = "";
if (sex > 0)
{
sx = " and 性别=" + sex;
}
string dp = "";
if (dep != null)
{
dp = " and Depart=" + dep.ID;
}
string cd = "";
if (condition != null)
{
cd = " and Condition=" + condition.ID;
}
string mb = "";
if (!string.IsNullOrEmpty(mb) && mb.Trim() != "")
{
mb = " and 电话 like '%" + mb.Trim() + "%'";
}
string where = "(1=1)" + nm + sx + dp + cd + mb + " order by ID desc";
return(StaffLogic.GetInstance().GetStaffs(where));
}
public List <Worklog> GetAllWorklogs()
{
List <Worklog> elements = new List <Worklog>();
string sql = "select * from TF_Worklog";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Worklog element = new Worklog();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[i]["日期"]);
element.客户 = dt.Rows[i]["客户"].ToString();
element.电话 = dt.Rows[i]["电话"].ToString();
element.是否自访 = Convert.ToBoolean(dt.Rows[i]["是否自访"]);
element.是否老会员 = Convert.ToBoolean(dt.Rows[i]["是否老会员"]);
element.是否电话拜访 = Convert.ToBoolean(dt.Rows[i]["是否电话拜访"]);
element.性别 = (性别)Enum.ToObject(typeof(性别), Convert.ToInt32(dt.Rows[i]["性别"]));
element.意向 = dt.Rows[i]["意向"].ToString();
element.住址 = dt.Rows[i]["住址"].ToString();
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
private void label1_Click(object sender, EventArgs e)
{
List <Department> allDeps = DepartmentLogic.GetInstance().GetAllDepartments();
List <Staff> allStaffs = StaffLogic.GetInstance().GetAllStaffs();
SelectStaffForm f = new SelectStaffForm(selectOnlyOne, this.SelectedStaffs, allDeps, allStaffs);
if (f.ShowDialog() == DialogResult.OK)
{
this.label1.Tag = f.SelectedStaffs;
if (f.SelectedStaffs != null && f.SelectedStaffs.Count > 0)
{
StringBuilder sb = new StringBuilder();
foreach (Staff staff in f.SelectedStaffs)
{
if (sb.Length == 0)
{
sb.Append(staff.姓名);
}
else
{
sb.Append("," + staff.姓名);
}
}
this.label1.Text = sb.ToString();
}
else
{
this.label1.Text = "选择员工...";
}
}
}
public static StaffLogic GetInstance()
{
if (instance == null)
{
instance = new StaffLogic();
}
return(instance);
}
private void LoadStaffs()
{
List <Staff> elements = StaffLogic.GetInstance().GetAllStaffs();
comboBox1.Items.Clear();
foreach (Staff element in elements)
{
comboBox1.Items.Add(element);
}
}
private void LoadStaffs()
{
List <Staff> elements = StaffLogic.GetInstance().GetAllStaffs();
comboBox1.Items.Clear();
foreach (Staff element in elements)
{
comboBox1.Items.Add(element);
}
dataGridView1.DataSource = StaffLogic.GetInstance().GetStaffs(string.Empty);
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
Staff staff = new Staff();
staff.ID = ((Product)comboBox1.SelectedItem).ID;
staff.姓名 = textBox1.Text.Trim();
staff.性别 = (性别)Enum.ToObject(typeof(性别), comboBox2.SelectedIndex);
staff.Depart = comboBox3.SelectedItem as Department;
staff.Condition = comboBox3.SelectedItem as StaffCondition;
staff.生日 = DateTime.Parse(textBox3.Text.Trim());
staff.电话 = textBox5.Text.Trim();
staff.宿舍 = textBox4.Text.Trim();
staff.备注 = textBox6.Text.Trim();
staff.钥匙数 = (int)numericUpDown1.Value;
staff.工衣数 = (int)numericUpDown2.Value;
staff.工牌数 = (int)numericUpDown3.Value;
staff.是否全部回收 = checkBox1.Checked;
StaffLogic ml = StaffLogic.GetInstance();
if (ml.ExistsNameOther(staff.姓名, staff.ID))
{
if (MessageBox.Show("系统中已经存在该员工，确定还要继续保存么？", "重名提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
if (ml.UpdateStaff(staff))
{
LoadStaffs();
MessageBox.Show("修改成功！");
}
}
else
{
textBox1.Focus();
textBox1.SelectAll();
}
}
else
{
if (ml.UpdateStaff(staff))
{
LoadStaffs();
MessageBox.Show("修改成功！");
}
}
}
else
{
MessageBox.Show("先选定要修改的员工！");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
if (MessageBox.Show("确定要删除该员工？", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
Staff staff = (Staff)comboBox1.SelectedItem;
if (StaffLogic.GetInstance().DeleteStaff(staff))
{
LoadStaffs();
}
}
}
else
{
MessageBox.Show("先选定要删除的员工！");
}
}
public Renew GetRenew(int id)
{
string sql = "select * from TF_Renew where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Renew element = new Renew();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.卡种 = CardTypeLogic.GetInstance().GetCardType(Convert.ToInt32(dt.Rows[0]["CardType"]));
element.卡号 = dt.Rows[0]["卡号"].ToString();
element.续卡时间 = Convert.ToDateTime(dt.Rows[0]["续卡时间"]);
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["经手人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Followup GetFollowup(int id)
{
string sql = "select * from TF_Followup where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Followup element = new Followup();
element.ID = id;
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[0]["MemberID"]));
element.回访方式 = FollowupTypeLogic.GetInstance().GetFollowupType(Convert.ToInt32(dt.Rows[0]["跟进方式"]));
element.跟进结果 = FollowupResultLogic.GetInstance().GetFollowupResult(Convert.ToInt32(dt.Rows[0]["跟进结果"]));
element.跟进时间 = Convert.ToDateTime(dt.Rows[0]["跟进时间"]);
element.跟进人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["跟进人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public Workplan GetWorkplan(int id)
{
string sql = "select * from TF_Workplan where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Workplan element = new Workplan();
element.ID = id;
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
element.带人数 = Convert.ToInt32(dt.Rows[0]["带人数"]);
element.号码数 = Convert.ToInt32(dt.Rows[0]["号码数"]);
element.成单数 = Convert.ToInt32(dt.Rows[0]["成单数"]);
element.回访数 = Convert.ToInt32(dt.Rows[0]["回访数"]);
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public FinanceDetail GetFinanceDetail(int id)
{
string sql = "select * from TF_FinanceDetail where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
FinanceDetail element = new FinanceDetail();
element.ID = id;
element.项目 = dt.Rows[0]["项目"].ToString();
element.金额 = Convert.ToDecimal(dt.Rows[0]["金额"]);
element.是否进账 = Convert.ToBoolean(dt.Rows[0]["是否进账"]);
element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["责任人"]));
element.备注 = dt.Rows[0]["备注"].ToString();
element.提交时间 = Convert.ToDateTime(dt.Rows[0]["提交时间"]);
element.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
return(element);
}
return(null);
}
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);
}
private DataTable Search(string name, object alertType, string subject)
{
string nm = "";
if (!string.IsNullOrEmpty(name) && name.Trim() != "")
{
nm = " and 提醒项目 like '%" + name.Trim() + "%'";
}
string at = "";
string sb = "";
if (alertType is 提醒方式)
{
提醒方式 type = (提醒方式)alertType;
at = " and 提醒方式='" + type.ToString();
if (!string.IsNullOrEmpty(subject) && subject.Trim() != "")
{
int id = 0;
if (type == 提醒方式.系统提示 || type == 提醒方式.员工短信)
{
Staff staff = StaffLogic.GetInstance().GetStaffByName(subject.Trim());
if (staff != null)
{
id = staff.ID;
}
}
else if (type == 提醒方式.会员短信)
{
Member member = MemberLogic.GetInstance().GetMemberByName(subject.Trim());
if (member != null)
{
id = member.ID;
}
}
sb = " and ','+提醒对象+',' like '%," + id + ",%'";
}
}
string where = "(1=1)" + nm + sb + at;
return(AlertLogic.GetInstance().GetAlerts(where));
}
public List <Renew> GetAllRenews()
{
List <Renew> elements = new List <Renew>();
string sql = "select * from TF_Renew";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Renew element = new Renew();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[i]["MemberID"]));
element.卡种 = CardTypeLogic.GetInstance().GetCardType(Convert.ToInt32(dt.Rows[i]["卡种"]));
element.卡号 = dt.Rows[i]["卡号"].ToString();
element.续卡时间 = Convert.ToDateTime(dt.Rows[i]["续卡时间"]);
element.经手人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["经手人"]));
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
public List <Followup> GetAllFollowups()
{
List <Followup> elements = new List <Followup>();
string sql = "select * from TF_Followup";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Followup element = new Followup();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.Member = MemberLogic.GetInstance().GetMember(Convert.ToInt32(dt.Rows[i]["MemberID"]));
element.回访方式 = FollowupTypeLogic.GetInstance().GetFollowupType(Convert.ToInt32(dt.Rows[i]["跟进方式"]));
element.跟进结果 = FollowupResultLogic.GetInstance().GetFollowupResult(Convert.ToInt32(dt.Rows[i]["跟进结果"]));
element.跟进时间 = Convert.ToDateTime(dt.Rows[i]["跟进时间"]);
element.跟进人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["跟进人"]));
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
public static List <Staff> GetStaffByIdStr(string ids)
{
List <Staff> staffs = new List <Staff>();
if (!string.IsNullOrEmpty(ids))
{
StaffLogic sl = StaffLogic.GetInstance();
string[] Ids = ids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (string id in Ids)
{
int ID;
if (int.TryParse(id, out ID))
{
Staff staff = sl.GetStaff(ID);
if (staff != null)
{
staffs.Add(staff);
}
}
}
}
return(staffs);
}
public List <Workplan> GetAllWorkplans()
{
List <Workplan> elements = new List <Workplan>();
string sql = "select * from TF_Workplan";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Workplan element = new Workplan();
element.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[i]["日期"]);
element.带人数 = Convert.ToInt32(dt.Rows[i]["带人数"]);
element.号码数 = Convert.ToInt32(dt.Rows[i]["号码数"]);
element.成单数 = Convert.ToInt32(dt.Rows[i]["成单数"]);
element.回访数 = Convert.ToInt32(dt.Rows[i]["回访数"]);
element.备注 = dt.Rows[i]["备注"].ToString();
elements.Add(element);
}
}
return(elements);
}
private string BackupData(string type)
{
DataTable data = null;
if (type == "会员")
{
data = MemberLogic.GetInstance().GetMemberData();
}
else if (type == "员工")
{
data = StaffLogic.GetInstance().GetStaffData();
}
string filename = Directory.GetCurrentDirectory() + "\\" + type + "资料.xls";
bool f = Common.ExportData(data, filename);
if (f)
{
return(filename);
}
else
{
return("");
}
}
public Worklog GetWorklog(int id)
{
string sql = "select * from TF_Worklog where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
Worklog element = new Worklog();
element.ID = id;
element.销售 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["销售"]));
element.日期 = Convert.ToDateTime(dt.Rows[0]["日期"]);
element.客户 = dt.Rows[0]["客户"].ToString();
element.电话 = dt.Rows[0]["电话"].ToString();
element.是否自访 = Convert.ToBoolean(dt.Rows[0]["是否自访"]);
element.是否老会员 = Convert.ToBoolean(dt.Rows[0]["是否老会员"]);
element.是否电话拜访 = Convert.ToBoolean(dt.Rows[0]["是否电话拜访"]);
element.性别 = (性别)Enum.ToObject(typeof(性别), Convert.ToInt32(dt.Rows[0]["性别"]));
element.意向 = dt.Rows[0]["意向"].ToString();
element.住址 = dt.Rows[0]["住址"].ToString();
element.备注 = dt.Rows[0]["备注"].ToString();
return(element);
}
return(null);
}
public static bool ImportData(string elementType, bool clearOldData, DataTable data, FieldMap <string, string> map, ImportDataProcessHandler process)
{
if (data == null && data.Rows.Count == 0)
{
return(false);
}
if (map.Count == 0)
{
return(false);
}
try
{
Assembly ass = null;
Type t = null;
string typeName = null;
//清空数据库中的原有数据
switch (elementType)
{
case "会员":
ass = Assembly.Load("Model");
t = ass.GetType("TopFashion.Member", false, true);
typeName = t.FullName;
if (clearOldData)
{
MemberLogic.GetInstance().ClearMembers();
}
break;
case "员工":
ass = Assembly.Load("Model");
t = ass.GetType("TopFashion.Staff", false, true);
typeName = t.FullName;
if (clearOldData)
{
StaffLogic.GetInstance().ClearStaffs();
}
break;
default:
break;
}
if (!string.IsNullOrEmpty(typeName))
{
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow row = data.Rows[i];//FormatData(data.Rows[i]);
//保存数据到数据库
switch (elementType)
{
case "会员":
Member elementM = ass.CreateInstance(typeName, true) as Member;
Member member = GetData <Member>(row, map, elementM, t);
MemberLogic.GetInstance().AddMember(member);
break;
case "员工":
Staff elementS = ass.CreateInstance(typeName, true) as Staff;
Staff staff = GetData <Staff>(row, map, elementS, t);
StaffLogic.GetInstance().AddStaff(staff);
break;
default:
break;
}
//反馈进度给外部程序
if (process != null)
{
process(i + 1);
}
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
