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