public int Add(CustomerConnectRecordInfo entity)
{
int id = CommonDataProvider.Instance().AddCustomerConnectRecord(entity);
if (id > 0)
{
RefreshCustomerConnectRecordCache(entity);
}
return id;
}
public int Add(CustomerConnectRecordInfo entity)
{
int id = CommonDataProvider.Instance().AddCustomerConnectRecord(entity);
if (id > 0)
{
RefreshCustomerConnectRecordCache(entity);
}
return(id);
}
/// <summary>
/// 更新客户线索流转记录缓存
/// </summary>
/// <param name="entity"></param>
public void RefreshCustomerConnectRecordCache(CustomerConnectRecordInfo entity)
{
string key = GlobalKey.CUSTOMERCONNECTRECORD_LIST + "_c" + entity.CustomerID;
List<CustomerConnectRecordInfo> list = MangaCache.Get(key) as List<CustomerConnectRecordInfo>;
entity = GetCustomerConnectRecordByID(entity.ID);
if (list != null && list.Exists(c => c.ID == entity.ID))
{
list[list.FindIndex(c => c.ID == entity.ID)] = entity;
}
else if (list == null)
{
GetListByCustomerID(entity.CustomerID,true);
}
else
list.Add(entity);
}
public static CustomerConnectRecordInfo PopulateCustomerConnectRecordInfo(IDataReader reader)
{
CustomerConnectRecordInfo entity = new CustomerConnectRecordInfo()
{
ID = (int)reader["ID"],
CustomerID = (int)reader["CustomerID"],
CustomerName = reader["CustomerName"] as string,
CustomerPhone = reader["CustomerPhone"] as string,
ConnectUserID = (int)reader["ConnectUserID"],
ConnectUser = reader["ConnectUser"] as string,
FollowTime = reader["FollowTime"] as string,
ConnectwayID = (int)reader["ConnectwayID"],
CustomerLevelID = (int)reader["CustomerLevelID"],
ConnectDetail = reader["ConnectDetail"] as string,
CreateTime = reader["CreateTime"] as string
};
return(entity);
}
/// <summary>
/// 更新客户线索流转记录缓存
/// </summary>
/// <param name="entity"></param>
public void RefreshCustomerConnectRecordCache(CustomerConnectRecordInfo entity)
{
string key = GlobalKey.CUSTOMERCONNECTRECORD_LIST + "_c" + entity.CustomerID;
List <CustomerConnectRecordInfo> list = MangaCache.Get(key) as List <CustomerConnectRecordInfo>;
entity = GetCustomerConnectRecordByID(entity.ID);
if (list != null && list.Exists(c => c.ID == entity.ID))
{
list[list.FindIndex(c => c.ID == entity.ID)] = entity;
}
else if (list == null)
{
GetListByCustomerID(entity.CustomerID, true);
}
else
{
list.Add(entity);
}
}
public abstract int AddCustomerConnectRecord(CustomerConnectRecordInfo entity);
public override int AddCustomerConnectRecord(CustomerConnectRecordInfo entity)
{
string sql = @"
INSERT INTO ComOpp_CustomerConnectRecord(
[CustomerID],[CustomerName],[CustomerPhone],[ConnectUserID],[ConnectUser],[FollowTime],[ConnectwayID],[CustomerLevelID],[ConnectDetail],[CreateTime],[CorporationID]
)VALUES(
@CustomerID,@CustomerName,@CustomerPhone,@ConnectUserID,@ConnectUser,@FollowTime,@ConnectwayID,@CustomerLevelID,@ConnectDetail,@CreateTime,@CorporationID
);
SELECT @@IDENTITY;
";
SqlParameter[] p =
{
new SqlParameter("@CustomerID",entity.CustomerID),
new SqlParameter("@CustomerName",entity.CustomerName),
new SqlParameter("@CustomerPhone",entity.CustomerPhone),
new SqlParameter("@ConnectUserID",entity.ConnectUserID),
new SqlParameter("@ConnectUser",entity.ConnectUser),
new SqlParameter("@FollowTime",entity.FollowTime),
new SqlParameter("@ConnectwayID",entity.ConnectwayID),
new SqlParameter("@CustomerLevelID",entity.CustomerLevelID),
new SqlParameter("@ConnectDetail",entity.ConnectDetail),
new SqlParameter("@CreateTime",entity.CreateTime),
new SqlParameter("@CorporationID",entity.CorporationID)
};
entity.ID = DataConvert.SafeInt(SqlHelper.ExecuteScalar(_con, CommandType.Text, sql, p));
return entity.ID;
}
private void FillData(CustomerConnectRecordInfo entity)
{
entity.CorporationID = CurrentCustomerInfo.CorporationID;
entity.CustomerID = GetInt("id");
entity.CustomerName = CurrentCustomerInfo.Name;
entity.CustomerPhone = CurrentCustomerInfo.Phone;
entity.ConnectUserID = DataConvert.SafeInt(Request["form[uid]"]);
entity.ConnectUser = Request["form[uname]"];
entity.FollowTime = Request["form[followtime]"];
entity.ConnectwayID = DataConvert.SafeInt(Request["form[connectway]"]);
entity.CustomerLevelID = DataConvert.SafeInt(Request["form[customerlevel]"]);
entity.ConnectDetail = Request["form[followinfo]"];
entity.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
private void CommitData()
{
int result = 0;
int id = GetInt("id");
if (id > 0)
CurrentCustomerInfo = Customers.Instance.GetCustomerByID(id);
CustomerConnectRecordInfo entity = new CustomerConnectRecordInfo();
FillData(entity);
result = CustomerConnectRecords.Instance.Add(entity);
if (result > 0)
{
CurrentCustomerInfo.LastConnectTime = entity.FollowTime;
CurrentCustomerInfo.LastConnectDetail = entity.ConnectDetail;
CurrentCustomerInfo.LastConnectUserID = entity.ConnectUserID;
CurrentCustomerInfo.LastConnectUser = entity.ConnectUser;
CurrentCustomerInfo.LastConnectwayID = entity.ConnectwayID;
CurrentCustomerInfo.LastCustomerLevelID = entity.CustomerLevelID;
CurrentCustomerInfo.LastUpdateTime = entity.CreateTime;
CurrentCustomerInfo.LastUpdateUserID = AdminID;
CurrentCustomerInfo.LastUpdateUser = Admin.Realname;
CurrentCustomerInfo.ConnectTimes = CurrentCustomerInfo.ConnectTimes + 1;
Customers.Instance.UpdateCustomerLastConnect(CurrentCustomerInfo);
}
Response.Clear();
Response.Write(result == 0 ? "n" : "y");
Response.End();
}
public abstract int AddCustomerConnectRecord(CustomerConnectRecordInfo entity);
public static CustomerConnectRecordInfo PopulateCustomerConnectRecordInfo(IDataReader reader)
{
CustomerConnectRecordInfo entity = new CustomerConnectRecordInfo()
{
ID = (int)reader["ID"],
CustomerID = (int)reader["CustomerID"],
CustomerName = reader["CustomerName"] as string,
CustomerPhone = reader["CustomerPhone"] as string,
ConnectUserID = (int)reader["ConnectUserID"],
ConnectUser = reader["ConnectUser"] as string,
FollowTime = reader["FollowTime"] as string,
ConnectwayID = (int)reader["ConnectwayID"],
CustomerLevelID = (int)reader["CustomerLevelID"],
ConnectDetail = reader["ConnectDetail"] as string,
CreateTime = reader["CreateTime"] as string
};
return entity;
}
