private static void updateWorkPlan()
{
WorkPlanProider _Provider = new WorkPlanProider();
WorkPlan _WorkPlan = new WorkPlan();
_WorkPlan.id = 5;
_WorkPlan.address = "sd";
_WorkPlan.addressCity = "sdsd";
_WorkPlan.addressCityID = 1;
_WorkPlan.addressProvince = "sddd";
_WorkPlan.addressProvinceID = 1;
_WorkPlan.content = "sddd";
_WorkPlan.scale = 10;
_WorkPlan.startTime = DateTime.Now;
_WorkPlan.endTime = DateTime.Now;
_WorkPlan.workPlanTypeID = 1;
_WorkPlan.year = "2017";
_WorkPlan.name = "工作计划3";
WorkPlanContacts _WorkPlanContacts = new WorkPlanContacts();
_WorkPlanContacts.id = 2;
_WorkPlanContacts.phone = "13811961223";
_WorkPlanContacts.statue = "edit";
_WorkPlanContacts.contactsName = "test2ee";
_WorkPlan.Contacts.Add(_WorkPlanContacts);
_Provider.UpdateWorkPlan(_WorkPlan);
}
/// <summary>
/// 修改工作计划联系人
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
private bool UpdateWorkPlanContacts(WorkPlanContacts Data)
{
try
{
string sql = "update de2_workplancontacts set contactsID=@contactsID,contactsName=@contactsName,phone=@phone where id=@id";
MySqlClient _Client = new MySqlClient();
_Client.ExecuteNonQuery(sql,
new MySqlParameter("@contactsID", Data.contactsID)
, new MySqlParameter("@contactsName", Data.contactsName)
, new MySqlParameter("@phone", Data.phone)
, new MySqlParameter("@id", Data.id));
return(true);
}
catch (Exception ex)
{
LogFactory _LogFactory = new LogFactory(this.GetType());
_LogFactory.CreateLog(LogType.Error, "修改工作计划联系人", "UpdateWorkPlanContacts", ex);
return(false);
}
}
/// <summary>
/// 新建工作计划联系人
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
private bool AddWorkPlanContacts(WorkPlanContacts Data, int wid)
{
try
{
string sql = "insert into de2_workplancontacts(contactsID,contactsName,phone,wid) values (@contactsID,@contactsName,@phone,@wid)";
MySqlClient _Client = new MySqlClient();
_Client.ExecuteNonQuery(sql,
new MySqlParameter("@contactsID", Data.contactsID)
, new MySqlParameter("@contactsName", Data.contactsName)
, new MySqlParameter("@phone", Data.phone)
, new MySqlParameter("@wid", wid));
return(true);
}
catch (Exception ex)
{
LogFactory _LogFactory = new LogFactory(this.GetType());
_LogFactory.CreateLog(LogType.Error, "新建工作计划联系人", "AddWorkPlanContacts", ex);
return(false);
}
}
