/// <summary>
/// 添加跟进记录
/// </summary>
/// <param name="guid"></param>
/// <param name="newfollow_up"></param>
/// <param name="_pictures"></param>
private void add_follow(string guid, follow_up newfollow_up, string _pictures)
{
try
{
//通知领导进行添加
admin_add_follow(guid, newfollow_up);
//添加跟进记录
jsonModel = Constant.bbc.add_follow_up(newfollow_up, _pictures);
newfollow_up.id = Convert.ToInt64(jsonModel.retData);
//缓存添加图片
AddPicture_helper(newfollow_up, _pictures);
//客户列表,当前用户【更改拜访记录】
List <cust_customer> cust_customer_selfs = cust_customer_handle.dic_Self[guid];
cust_customer customer_follow = cust_customer_selfs.FirstOrDefault(item => item.id == newfollow_up.follow_cust_id);
if (customer_follow != null)
{
customer_follow.cust_followdate = DateTime.Now;
Constant.cust_customer_S.Update(customer_follow);
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
}
/// <summary>
/// 获取客户和联系人姓名
/// </summary>
/// <param name="guid"></param>
/// <param name="fp"></param>
/// <param name="follow"></param>
private static void get_customer_linkman(string guid, follow_up fp, follow follow)
{
try
{
#region 获取客户信息\联系人
//联系人列表,当前用户
List <cust_linkman> cust_linkman_selfs = cust_linkman_handle.list_All;
//获取联系人信息
string link_id = fp.follow_link_id.ToString();
long link_id_long = Convert.ToInt64(link_id);
//获取指定的客户【在自己的客户列表里获取】
cust_linkman cust_linkman = (from t in cust_linkman_selfs
where t.id == link_id_long
select t).FirstOrDefault(); if (cust_linkman != null)
{
follow.follow_up_info.follow_cust_name = cust_linkman.link_cust_name;
follow.follow_up_info.follow_link_name = cust_linkman.link_name;
}
#endregion
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
finally
{
}
}
///// <summary>
///// 新增签到
///// </summary>
///// <param name="model"></param>
///// <returns></returns>
//public static int edit_sign_in(sign_in model)
//{
// int result = 0;
// SqlParameter[] param = {
// new SqlParameter("@id", model.id),
// new SqlParameter("@sign_userid", model.sign_userid),
// new SqlParameter("@sign_username", model.sign_username),
// new SqlParameter("@sign_date", model.sign_date),
// new SqlParameter("@sign_cust_id", model.sign_cust_id),
// new SqlParameter("@sign_location", model.sign_location),
// new SqlParameter("@sign_address", model.sign_address),
// new SqlParameter("@sign_offset", model.sign_offset)
// };
// param[0].Direction = ParameterDirection.Output;
// object obj = SQLHelp.ExecuteNonQuery("edit_sign_in", CommandType.StoredProcedure, param);
// result = Convert.ToInt32(param[0].Value.ToString());
// return result;
//}
/// <summary>
/// 新增跟进记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int add_follow_up(follow_up model, string picture)
{
int result = 0;
SqlParameter[] param =
{
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@follow_userid", model.follow_userid == null?"":model.follow_userid),
new SqlParameter("@follow_username", model.follow_username == null?"":model.follow_username),
new SqlParameter("@follow_cust_id", model.follow_cust_id == null?0:model.follow_cust_id),
new SqlParameter("@follow_link_id", model.follow_link_id == null?0:model.follow_link_id),
new SqlParameter("@follow_date", model.follow_date == null?DateTime.Now:model.follow_date),
new SqlParameter("@follow_content", model.follow_content == null?"":model.follow_content),
new SqlParameter("@follow_type", model.follow_type == null?0:model.follow_type),
new SqlParameter("@follow_status", model.follow_status == null?"":model.follow_status),
new SqlParameter("@follow_remaindate", model.follow_remaindate == null?DateTime.Now:model.follow_remaindate),
new SqlParameter("@follow_address", model.follow_address == null?"":model.follow_address),
new SqlParameter("@picture", picture == null?"":picture)
};
param[0].Direction = ParameterDirection.Output;
object obj = SQLHelp.ExecuteNonQuery("add_follow_up", CommandType.StoredProcedure, param);
result = Convert.ToInt32(param[0].Value.ToString());
return(result);
}
public JsonModel edit_follow_up(follow_up model, string picture)
{
JsonModel jsonModel = new JsonModel();
try
{
int result = DALBaseCommon.edit_follow_up(model, picture);
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = result
};
return(jsonModel);
}
catch (Exception ex)
{
jsonModel = new JsonModel()
{
errNum = 400,
errMsg = ex.Message,
retData = ""
};
return(jsonModel);
}
}
/// <summary>
/// 获取根据记录【指定ID】
/// </summary>
/// <param name="context"></param>
public void get_follow_up(HttpContext context, string guid)
{
HttpRequest Request = context.Request;
try
{
long id = RequestHelper.long_transfer(Request, "id");
long follow_cust_id = RequestHelper.long_transfer(Request, "follow_cust_id");
long follow_link_id = RequestHelper.long_transfer(Request, "follow_link_id");
string follow_type = RequestHelper.string_transfer(Request, "follow_type");
//跟进列表
List <follow_up> follow_selfs = dic_Self[guid];
//指定的一个客户
follow_up follow_up = (from t in follow_selfs
where t.id == id
select t).FirstOrDefault();
Dictionary <string, object> dic_follow_up = ConverList <follow_up> .T_ToDic(follow_up);
//联系人列表,当前用户
List <cust_linkman> cust_linkman_selfs = cust_linkman_handle.dic_Self[guid];
//联系人名称和客户名称
cust_linkman cust_linkman = (from t in cust_linkman_selfs
where t.id == follow_up.follow_link_id
select t).FirstOrDefault();
if (cust_linkman != null)
{
dic_follow_up["follow_link_name"] = cust_linkman.link_name;
dic_follow_up["follow_cust_name"] = cust_linkman.link_cust_name;
}
//跟进类型
dic_follow_up["follow_type_name"] = LevelHelper.Getfollow_level(follow_up.follow_type.ToString());
if (Constant.list_picture_All != null)
{
//获取指定的图片【类型 和ID】
List <picture> listp = (from t in Constant.list_picture_All
where t.pic_en_table == "follow_up" && t.pic_table_id == id
select t).ToList();
string pic = "";
foreach (picture p in listp)
{
pic += p.pic_url + ',';
}
dic_follow_up["pic"] = pic.Trim(',');
}
jsonModel = Constant.get_jsonmodel(0, "success", dic_follow_up);
}
catch (Exception ex)
{
jsonModel = Constant.ErrorGetData(ex);
}
finally
{
string jsonString = Constant.jss.Serialize(jsonModel);
context.Response.Write("{\"result\":" + jsonString + "}");
}
}
/// <summary>
/// 获取图片评论和点赞
/// </summary>
/// <param name="fp"></param>
/// <param name="follow"></param>
private static void get_picture_praise_comment(follow_up fp, follow follow)
{
try
{
#region 获取图片
if (Constant.list_picture_All != null)
{
//获取指定的图片【类型 和ID】
List <picture> list_picture = (from t in Constant.list_picture_All
where t.pic_en_table == "follow_up" && t.pic_table_id == (int)fp.id
select t).ToList();
follow.picture = ConverList <picture> .ListToDic(list_picture);
}
#endregion
#region 获取评论
//获取指定的评论
List <comment> list_comment = (from t in comment_handle.list_All
where t.com_table_id == (int)fp.id && t.com_isdelete == "0" && t.com_type == "1"
select t).ToList();
follow.comment = ConverList <comment> .ListToDic(list_comment);
#endregion
#region 获取点赞人
List <praise> list_praise = (from t in praise_handle.list_All
where t.praise_table_id == (int)fp.id && t.praise_type == "1"
select t).ToList();
follow.praise = ConverList <praise> .ListToDic(list_praise);
#endregion
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
finally
{
}
}
/// <summary>
/// 编辑跟进记录
/// </summary>
/// <param name="guid"></param>
/// <param name="Request"></param>
/// <param name="id"></param>
/// <param name="follow_up"></param>
private void edit_follow(string guid, long id, follow_up follow_up, string _pictures)
{
try
{
//跟进列表
List <follow_up> follow_selfs = dic_Self[guid];
follow_up edit_follow_up = follow_selfs.FirstOrDefault(item => item.id == id);
if (edit_follow_up != null)
{
edit_follow_up.follow_cust_id = follow_up.follow_cust_id;
edit_follow_up.follow_link_id = follow_up.follow_link_id;
edit_follow_up.follow_content = follow_up.follow_content;
edit_follow_up.follow_status = follow_up.follow_status;
edit_follow_up.follow_remaindate = follow_up.follow_remaindate;
edit_follow_up.follow_isdelete = follow_up.follow_isdelete;
edit_follow_up.follow_address = follow_up.follow_address;
//成功提示
jsonModel = Constant.get_jsonmodel(0, "success", 1);
//开启线程操作数据库
new Thread(() =>
{
try
{
editpicture_helper(id, _pictures, edit_follow_up);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
})
{
IsBackground = true
}.Start();
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
}
public static int edit_follow_up(follow_up model, string picture)
{
int result = 0;
SqlParameter[] param =
{
new SqlParameter("@id", model.id),
new SqlParameter("@follow_userid", model.follow_userid == null?"":model.follow_userid),
new SqlParameter("@follow_username", model.follow_username == null?"":model.follow_username),
new SqlParameter("@follow_cust_id", model.follow_cust_id == null?0:model.follow_cust_id),
new SqlParameter("@follow_link_id", model.follow_link_id == null?0:model.follow_link_id),
new SqlParameter("@follow_date", model.follow_date == null?DateTime.Now:model.follow_date),
new SqlParameter("@follow_content", model.follow_content == null?"":model.follow_content),
new SqlParameter("@follow_type", model.follow_type == null?0:model.follow_type),
new SqlParameter("@follow_status", model.follow_status == null?"":model.follow_status),
new SqlParameter("@follow_remaindate", model.follow_remaindate == null?DateTime.Now:model.follow_remaindate),
new SqlParameter("@follow_address", model.follow_address == null?"":model.follow_address),
new SqlParameter("@picture", picture == null?"":picture)
};
result = Convert.ToInt32(SQLHelp.ExecuteScalar("edit_cust_customer", System.Data.CommandType.StoredProcedure, param.ToArray()));
return(result);
}
/// <summary>
/// 通知领导我已添加跟进
/// </summary>
/// <param name="guid"></param>
/// <param name="follow_up"></param>
private static void admin_add_follow(string guid, follow_up follow_up)
{
try
{
//通知领导我已添加跟进
if (Constant.dic_custs_users.ContainsKey(guid))
{
if (!list_All.Contains(follow_up))
{
//当前添加跟进
list_All.Add(follow_up);
}
//获取上级的guid
List <string> commonAdmin_CustursID = Constant.dic_custs_users[guid];
//上级列表
foreach (var item in commonAdmin_CustursID)
{
//若领导在线，添加当前添加的跟进
if (dic_Self.ContainsKey(item))
{
//跟进列表,当前跟进
List <follow_up> follow_up_admins = dic_Self[item];
if (!follow_up_admins.Contains(follow_up))
{
follow_up_admins.Add(follow_up);
}
}
}
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
}
/// <summary>
/// 缓存添加图片
/// </summary>
/// <param name="newfollow_up"></param>
/// <param name="_pictures"></param>
private static picture AddPicture_helper(follow_up newfollow_up, string _pictures)
{
picture picturemodel = null;
try
{
//图片之前已经用存储过程和跟进记录一起插入
if (!string.IsNullOrEmpty(_pictures))
{
string[] _pics = _pictures.Split(',');
for (int i = 0; i < _pics.Length; i++)
{
picturemodel = new picture()
{
pic_en_table = "follow_up",
pic_cn_table = "跟进记录",
pic_table_id = Convert.ToInt32(newfollow_up.id),
pic_url = _pics[i],
pic_createdate = DateTime.Now,
pic_creator = 1,
pic_updatedate = DateTime.Now,
pic_updateuser = 1,
pic_isdelete = "0",
pic_remark = "新增跟进记录",
};
Constant.list_picture_All.Add(picturemodel);
}
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(picturemodel);
}
/// <summary>
/// 编辑图片，若没有则添加
/// </summary>
/// <param name="id"></param>
/// <param name="_pictures"></param>
/// <param name="edit_follow_up"></param>
private static void editpicture_helper(long id, string _pictures, follow_up edit_follow_up)
{
try
{
picture edit_picture = Constant.list_picture_All.FirstOrDefault(item => item.id == id);
if (edit_picture != null)
{
edit_picture.pic_updatedate = DateTime.Now;
edit_picture.pic_url = _pictures;
Constant.follow_up_S.Update(edit_follow_up);
Constant.picture_S.Update(edit_picture);
}
else
{
picture pictureModel = AddPicture_helper(edit_follow_up, _pictures);
Constant.picture_S.Add(pictureModel);
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
}
/// <summary>
/// 新增跟进记录
/// </summary>
/// <param name="context"></param>
public void add_follow_up(HttpContext context, string guid)
{
HttpRequest Request = context.Request;
HttpResponse response = context.Response;
try
{
long id = RequestHelper.long_transfer(Request, "id");
follow_up newfollow_up = new follow_up();
newfollow_up.follow_cust_id = RequestHelper.int_transfer(Request, "follow_cust_id");
newfollow_up.follow_link_id = RequestHelper.int_transfer(Request, "follow_link_id");
newfollow_up.follow_type = int.Parse(RequestHelper.string_transfer(Request, "follow_type"));
newfollow_up.follow_content = RequestHelper.string_transfer(Request, "follow_content");
newfollow_up.follow_status = RequestHelper.string_transfer(Request, "follow_status");
newfollow_up.follow_remaindate = RequestHelper.DateTime_transfer(Request, "follow_remaindate");
newfollow_up.follow_address = RequestHelper.string_transfer(Request, "follow_address");
string _pictures = RequestHelper.string_transfer(Request, "picture");
//修改《暂时修改功能》
if (id > 0)
{
//编辑跟进记录
edit_follow(guid, id, newfollow_up, _pictures);
}
else if (id == 0)
{
newfollow_up.follow_userid = RequestHelper.string_transfer(Request, "follow_userid"); //用户编号
newfollow_up.follow_username = RequestHelper.string_transfer(Request, "follow_username"); //用户姓名
newfollow_up.follow_createdate = DateTime.Now;
newfollow_up.follow_date = RequestHelper.DateTime_transfer(Request, "follow_date");
newfollow_up.follow_date = newfollow_up.follow_date == RequestHelper.default_DateTime ? DateTime.Now : newfollow_up.follow_date;
newfollow_up.follow_isdelete = "0";
if (!dic_Self[guid].Contains(newfollow_up))
{
//缓存添加客户
dic_Self[guid].Add(newfollow_up);
jsonModel = Constant.get_jsonmodel(0, "success", 1);
new Thread(() =>
{
try
{
//添加跟进
add_follow(guid, newfollow_up, _pictures);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
})
{
IsBackground = true
}.Start();
}
}
}
catch (Exception ex)
{
jsonModel = Constant.ErrorGetData(ex);
}
finally
{
response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}");
}
}
