/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public MarketingChance Get(int IdmarketingChance)
{
MarketingChance returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetMarketingChance = cmdGetMarketingChance.Clone() as MySqlCommand;
_cmdGetMarketingChance.Connection = oc;
try
{
_cmdGetMarketingChance.Parameters["@IdmarketingChance"].Value = IdmarketingChance;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdGetMarketingChance.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new MarketingChance().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetMarketingChance.Dispose();
_cmdGetMarketingChance = null;
GC.Collect();
}
return(returnValue);
}
//编辑销售机会详情（机会ID，机会类型，客户类型，机会描述，联系人，联系方式，token） 返回（true/false）
public JsonResult EditMarketingInfo(int cid, int chanceType, int customerType,
string username, string chanceDetail, string tel,
string phone, string email, string qq)
{
var Res = new JsonResult();
RespResult result = new RespResult();
try
{
if (CacheManagerFactory.GetMemoryManager().Contains(token))
{
if (!CheckUserFunction("1202"))
{
result.Error = AppError.ERROR_PERMISSION_FORBID;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
MarketingChance chance = new MarketingChance();
chance = MarketingChanceAccessor.Instance.Get(cid);
chance.ChanceType = chanceType;
chance.ContactName = username;
chance.CustomerType = customerType;
chance.Email = email;
chance.Phone = phone;
chance.Qq = qq;
chance.Remark = chanceDetail;
chance.Tel = tel;
MarketingChanceAccessor.Instance.Update(chance);
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);
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(MarketingChance e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateMarketingChance = cmdUpdateMarketingChance.Clone() as MySqlCommand;
_cmdUpdateMarketingChance.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateMarketingChance.Parameters["@IdmarketingChance"].Value = e.IdmarketingChance;
_cmdUpdateMarketingChance.Parameters["@ChanceType"].Value = e.ChanceType;
_cmdUpdateMarketingChance.Parameters["@CustomerType"].Value = e.CustomerType;
_cmdUpdateMarketingChance.Parameters["@ContactName"].Value = e.ContactName;
_cmdUpdateMarketingChance.Parameters["@Remark"].Value = e.Remark;
_cmdUpdateMarketingChance.Parameters["@AddTime"].Value = e.AddTime;
_cmdUpdateMarketingChance.Parameters["@Qq"].Value = e.Qq;
_cmdUpdateMarketingChance.Parameters["@Email"].Value = e.Email;
_cmdUpdateMarketingChance.Parameters["@Tel"].Value = e.Tel;
_cmdUpdateMarketingChance.Parameters["@Phone"].Value = e.Phone;
_cmdUpdateMarketingChance.Parameters["@Rate"].Value = e.Rate;
_cmdUpdateMarketingChance.Parameters["@EntId"].Value = e.EntId;
_cmdUpdateMarketingChance.Parameters["@UserId"].Value = e.UserId;
_cmdUpdateMarketingChance.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateMarketingChance.Dispose();
_cmdUpdateMarketingChance = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public int Insert(MarketingChance e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertMarketingChance = cmdInsertMarketingChance.Clone() as MySqlCommand;
int returnValue = 0;
_cmdInsertMarketingChance.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertMarketingChance.Parameters["@ChanceType"].Value = e.ChanceType;
_cmdInsertMarketingChance.Parameters["@CustomerType"].Value = e.CustomerType;
_cmdInsertMarketingChance.Parameters["@ContactName"].Value = e.ContactName;
_cmdInsertMarketingChance.Parameters["@Remark"].Value = e.Remark;
_cmdInsertMarketingChance.Parameters["@AddTime"].Value = e.AddTime;
_cmdInsertMarketingChance.Parameters["@Qq"].Value = e.Qq;
_cmdInsertMarketingChance.Parameters["@Email"].Value = e.Email;
_cmdInsertMarketingChance.Parameters["@Tel"].Value = e.Tel;
_cmdInsertMarketingChance.Parameters["@Phone"].Value = e.Phone;
_cmdInsertMarketingChance.Parameters["@Rate"].Value = e.Rate;
_cmdInsertMarketingChance.Parameters["@EntId"].Value = e.EntId;
_cmdInsertMarketingChance.Parameters["@UserId"].Value = e.UserId;
_cmdInsertMarketingChance.ExecuteNonQuery();
returnValue = Convert.ToInt32(_cmdInsertMarketingChance.LastInsertedId);
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertMarketingChance.Dispose();
_cmdInsertMarketingChance = null;
}
}
//获取单个销售机会详情（销售机会ID，token） 返回 （机会类型，客户类型，机会描述，联系人，联系方式，录入时间）
public JsonResult GetMarketingInfo(int cid)
{
var Res = new JsonResult();
AdvancedResult <MarketingChance> result = new AdvancedResult <MarketingChance>();
try
{
if (CacheManagerFactory.GetMemoryManager().Contains(token))
{
if (!CheckUserFunction("1205"))
{
result.Error = AppError.ERROR_PERMISSION_FORBID;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
MarketingChance chance = new MarketingChance();
chance = MarketingChanceAccessor.Instance.Get(cid);
result.Error = AppError.ERROR_SUCCESS;
result.Data = chance;
}
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);
}
//
// GET: /MarketingManagement/Marketing/
/// <summary>
/// 销售机会即企业客户以及个人客户信息，此处都是调用客户信息
/// </summary>
/// <returns></returns>
/// <summary>
/// 添加销售机会（机会类型，客户类型，联系人，机会描述，联系方式{}，是否同步，token）返回（true/false）
/// 客户类型分为：1:企业客户2:个人客户；默认为企业客户
/// </summary>
public JsonResult AddMarketingChance(int chanceType, int customerType,
string username, string chanceDetail, string tel,
string phone, string email, string qq, bool Isasyn)
{
var Res = new JsonResult();
RespResult result = new RespResult();
try
{
if (CacheManagerFactory.GetMemoryManager().Contains(token))
{
if (!CheckUserFunction("1202"))
{
result.Error = AppError.ERROR_PERMISSION_FORBID;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
MarketingChance chance = new MarketingChance();
chance.AddTime = DateTime.Now;
chance.ChanceType = chanceType;
chance.ContactName = username;
chance.CustomerType = customerType;
chance.Email = email;
chance.EntId = CurrentUser.EntId;
chance.Phone = phone;
chance.Qq = qq;
chance.Remark = chanceDetail;
chance.Tel = tel;
chance.UserId = CurrentUser.UserId;
if (Isasyn)
{
switch (customerType)
{
case 1:
//添加企业客户
CustomerEnt ce = new CustomerEnt();
ce.EntName = username;
ce.ContactUsername = username;
ce.ContactMobile = phone;
ce.ContactPhone = phone;
ce.ContactEmail = email;
ce.ContactQq = qq;
ce.Detail = chanceDetail;
ce.OwnerId = CurrentUser.UserId;
ce.EntId = CurrentUser.EntId;
CustomerEntAccessor.Instance.Insert(ce);
break;
case 2:
//添加个人客户
CustomerPrivate cp = new CustomerPrivate();
cp.Name = username;
cp.Mobile = phone;
cp.Phone = phone;
cp.Email = email;
cp.Qq = qq;
cp.Detail = chanceDetail;
cp.OwnerId = CurrentUser.UserId;
cp.EntId = CurrentUser.EntId; CustomerPrivateAccessor.Instance.Insert(cp);
break;
}
}
int i = MarketingChanceAccessor.Instance.Insert(chance);
if (i > 0)
{
result.Id = i;
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，机会类型，客户类型，机会描述，联系人，联系方式，token） 返回（true/false）
public JsonResult EditMarketingInfo(int cid, int chanceType, int customerType,
string username, string chanceDetail, string tel,
string phone, string email, string qq, int customerId)
{
var Res = new JsonResult();
RespResult result = new RespResult();
try
{
if (CacheManagerFactory.GetMemoryManager().Contains(token))
{
if (!CheckUserFunction(19))
{
result.Error = AppError.ERROR_PERMISSION_FORBID;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
MarketingChance chance = new MarketingChance();
chance = MarketingChanceAccessor.Instance.Get(cid);
chance.ChanceType = chanceType;
chance.ContactName = username;
chance.CustomerType = customerType;
chance.Email = email;
chance.Phone = phone;
chance.Qq = qq;
chance.Remark = chanceDetail;
chance.Tel = tel;
MarketingChanceAccessor.Instance.Update(chance);
switch (customerType)
{
case 1:
//编辑企业客户
CustomerEnt ce = CustomerEntAccessor.Instance.Get(customerId);
ce.EntName = username;
ce.ContactUsername = username;
ce.ContactMobile = phone;
ce.ContactPhone = phone;
ce.ContactEmail = email;
ce.ContactQq = qq;
ce.Detail = chanceDetail;
CustomerEntAccessor.Instance.Update(ce);
break;
case 2:
//编辑个人客户
CustomerPrivate cp = CustomerPrivateAccessor.Instance.Get(customerId);
cp.Name = username;
cp.Mobile = phone;
cp.Phone = phone;
cp.Email = email;
cp.Qq = qq;
cp.Detail = chanceDetail;
CustomerPrivateAccessor.Instance.Update(cp);
break;
}
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);
}
