/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public MarketingVisit Get(int IdmarketingVisit) { MarketingVisit returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetMarketingVisit = cmdGetMarketingVisit.Clone() as MySqlCommand; _cmdGetMarketingVisit.Connection = oc; try { _cmdGetMarketingVisit.Parameters["@IdmarketingVisit"].Value = IdmarketingVisit; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetMarketingVisit.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new MarketingVisit().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetMarketingVisit.Dispose(); _cmdGetMarketingVisit = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 修改指定的数据 /// <param name="e">修改后的数据实体对象</param> /// <para>数据对应的主键必须在实例中设置</para> /// </summary> public void Update(MarketingVisit e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdUpdateMarketingVisit = cmdUpdateMarketingVisit.Clone() as MySqlCommand; _cmdUpdateMarketingVisit.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdUpdateMarketingVisit.Parameters["@IdmarketingVisit"].Value = e.IdmarketingVisit; _cmdUpdateMarketingVisit.Parameters["@VisitType"].Value = e.VisitType; _cmdUpdateMarketingVisit.Parameters["@Amount"].Value = e.Amount; _cmdUpdateMarketingVisit.Parameters["@Address"].Value = e.Address; _cmdUpdateMarketingVisit.Parameters["@Remark"].Value = e.Remark; _cmdUpdateMarketingVisit.Parameters["@VisitTime"].Value = e.VisitTime; _cmdUpdateMarketingVisit.Parameters["@ChanceId"].Value = e.ChanceId; _cmdUpdateMarketingVisit.Parameters["@EntId"].Value = e.EntId; _cmdUpdateMarketingVisit.ExecuteNonQuery(); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdUpdateMarketingVisit.Dispose(); _cmdUpdateMarketingVisit = null; GC.Collect(); } }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public int Insert(MarketingVisit e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertMarketingVisit = cmdInsertMarketingVisit.Clone() as MySqlCommand; int returnValue = 0; _cmdInsertMarketingVisit.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdInsertMarketingVisit.Parameters["@VisitType"].Value = e.VisitType; _cmdInsertMarketingVisit.Parameters["@Amount"].Value = e.Amount; _cmdInsertMarketingVisit.Parameters["@Address"].Value = e.Address; _cmdInsertMarketingVisit.Parameters["@Remark"].Value = e.Remark; _cmdInsertMarketingVisit.Parameters["@VisitTime"].Value = e.VisitTime; _cmdInsertMarketingVisit.Parameters["@ChanceId"].Value = e.ChanceId; _cmdInsertMarketingVisit.Parameters["@EntId"].Value = e.EntId; _cmdInsertMarketingVisit.ExecuteNonQuery(); returnValue = Convert.ToInt32(_cmdInsertMarketingVisit.LastInsertedId); return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertMarketingVisit.Dispose(); _cmdInsertMarketingVisit = null; } }
//针对单个销售机会拜访客户(销售机会ID,拜访方式,拜访描述,报价,地点,token) //返回(True/false)注:如果是第一次则需修改机会表字段为已拜访 public JsonResult ToVisit(int cid, int visitType, string remark, Double amount, String address) { var Res = new JsonResult(); RespResult result = new RespResult(); try { if (CacheManagerFactory.GetMemoryManager().Contains(token)) { if (!CheckUserFunction(21)) { result.Error = AppError.ERROR_PERMISSION_FORBID; Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); } MarketingVisit mv = new MarketingVisit(); mv.Address = address; mv.Amount = amount; mv.ChanceId = cid; mv.Remark = remark; mv.VisitTime = DateTime.Now; mv.VisitType = visitType; mv.EntId = CurrentUser.EntId; int i = MarketingVisitAccessor.Instance.Insert(mv); if (i > 0) { MarketingChanceAccessor.Instance.UpdateisVisit(cid, 2); result.Error = AppError.ERROR_SUCCESS; } else { result.Error = AppError.ERROR_FAILED; } } else { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); }
//编辑拜访记录(拜访记录ID,拜访方式,拜访描述,报价,地点)返回(true/false) public JsonResult EditVisitInfo(int vid, int visitType, string remark, Double amount, String address) { var Res = new JsonResult(); RespResult result = new RespResult(); try { if (CacheManagerFactory.GetMemoryManager().Contains(token)) { if (!CheckUserFunction("1204")) { result.Error = AppError.ERROR_PERMISSION_FORBID; Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); } MarketingVisit mv = MarketingVisitAccessor.Instance.Get(vid); mv.Address = address; mv.Amount = amount; mv.IdmarketingVisit = vid; mv.Remark = remark; mv.VisitType = visitType; MarketingVisitAccessor.Instance.Update(mv); result.Error = AppError.ERROR_SUCCESS; } else { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); }