public static string GetAllGroups()
{
var totalcount = 0;
try
{
var list = new Sys_GroupData().GetAllGroups(out totalcount);
IEnumerable result = "";
if (list != null)
{
result = from model in list
select new
{
Groupid = model.Groupid,
Groupname = model.Groupname,
Groupinfo = model.Groupinfo,
}
}
;
return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string GetGroupById(int groupid)
{
try
{
var pro = new Sys_GroupData().GetGroupById(groupid);
return(JsonConvert.SerializeObject(new { type = 100, msg = pro }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
/// <summary>
/// //如果是门市 ，则显示门市经理 权限内的管理组列表
///如果是合作单位 ，则显示合作单位负责人 权限内的管理组列表
///如果是公司 ，根据登录账户角色判断其可以显示的管理组列表
/// </summary>
/// <param name="channelsource"></param>
/// <returns></returns>
public static string GetGroupBychannelsource(string channelsource, int userid = 0)
{
try
{
var pro = new Sys_GroupData().GetGroupBychannelsource(channelsource, userid);
return(JsonConvert.SerializeObject(new { type = 100, msg = pro }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string EditGroup(Sys_Group sysgroup)
{
try
{
var pro = new Sys_GroupData().EditGroup(sysgroup);
return(JsonConvert.SerializeObject(new { type = 100, msg = pro }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
internal static string GetCompanyIdByUserId(string userid)
{
string companyid = "0";
//判断用户是否是管理员，如是管理员，不对用户渠道公司限制
Sys_Group sysgroup = new Sys_GroupData().GetGroupByUserId(int.Parse(userid));
if (sysgroup.Groupid != 1)//不是管理员
{
//根据userid得到用户信息，如果用户没有渠道公司的分配，则显示全部门市
B2b_company_manageuser muser = B2bCompanyManagerUserData.GetUser(int.Parse(userid));
companyid = muser.Channelcompanyid.ToString();
}
return(companyid);
}
public int iscanbindprint = 0;//是否可以绑定打印机:0不可以；1可以
protected void Page_Load(object sender, EventArgs e)
{
if (UserHelper.ValidateLogin())
{
comid = UserHelper.CurrentCompany.ID;
userid = UserHelper.CurrentUserId();
//根据用户获得所属分组
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
if (group != null)
{
if (group.Groupname == "管理员" || group.Groupname == "商户负责人（含实体卡）" || group.Groupname == "商户负责人" || group.Groupname == "景区负责人（含分销系统）")
{
iscanbindprint = 1;
}
}
}
}
//设定员工所在分组
public static bool SetMasterGroup(string masterid, string groupname, out string msg)
{
B2b_company_manageuser user = B2bCompanyManagerUserData.GetUser(int.Parse(masterid));
if (user == null)
{
msg = "账户信息获取为空";
return(false);
}
else
{
string mastername = user.Employeename;
Sys_Group group = new Sys_GroupData().GetGroupByName(groupname.Trim());
if (group == null)
{
msg = "管理组获取为空";
return(false);
}
else
{
string grouparr = group.Groupid.ToString();
int createmasterid = 0;
string createmastername = "开户后系统自动创建";
DateTime createdate = DateTime.Now;
int count = new Sys_MasterGroupData().EditMasterGroup(masterid, mastername, grouparr, createmasterid, createmastername, createdate);
if (count > 0)
{
msg = "";
return(true);
}
else
{
msg = "设定账户权限失败";
return(false);
}
}
}
}
public int promotetypeid = 1000000; //默认是显示全部
protected void Page_Load(object sender, EventArgs e)
{
promotetypeid = Request["promotetypeid"].ConvertTo <int>(1000000);
if (UserHelper.ValidateLogin())
{
comid = UserHelper.CurrentCompany.ID;
userid = UserHelper.CurrentUserId();
//根据用户获得所属分组
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
if (group != null)
{
if (group.Groupname == "管理员" || group.Groupname == "商户负责人（含实体卡）" || group.Groupname == "商户负责人" || group.Groupname == "景区负责人（含分销系统）")
{
iscandelmaterialtype = 1;
}
else
{
iscandelmaterialtype = 0;
}
}
}
}
public static string DelGroupById(int groupid)
{
try
{
var dataa = new Sys_GroupData().DelGroupById(groupid);
if (dataa > 0)
{
return(JsonConvert.SerializeObject(new { type = 100, msg = dataa }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = dataa }));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
private void GetUser()
{
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "004");
B2b_company_manageuser user = UserHelper.CurrentUser();
B2b_company company = UserHelper.CurrentCompany;
atypee = user.Atype;
userid = user.Id;
comid = company.ID;
comname = company.Com_name;
//根据comid得到公司logo信息
B2b_company_saleset logoset = B2bCompanySaleSetData.GetDirectSellByComid(comid.ToString());
if (logoset != null)
{
int logo_temp = 0;
if (logoset.Logo != "")
{
logo_temp = int.Parse(logoset.Logo);
}
FileUploadModel identityFileUpload = new FileUploadData().GetFileById(logo_temp);
if (identityFileUpload != null)
{
comlogo = fileUrl + identityFileUpload.Relativepath;
}
}
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "005");
username = user.Accounts;
B2b_company companyinfo = B2bCompanyData.GetAllComMsg(comid);
if (companyinfo.B2bcompanyinfo.Domainname != "")
{
companydo = "http://" + companyinfo.B2bcompanyinfo.Domainname;
}
else
{
companydo = "http://shop" + company.ID + ".etown.cn";
}
//根据userid得到用户信息，如果用户没有渠道公司的分配，则显示全部门市
B2b_company_manageuser muser = B2bCompanyManagerUserData.GetUser(UserHelper.CurrentUserId());
if (muser != null)
{
//TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\Log.txt", "006");
Sys_Group gg = new Sys_GroupData().GetGroupByUserId(muser.Id);
if (gg == null)
{
//Response.Write("<script>alert('用户尚未分配角色，请联系管理员！');location.href='/Manage/index1.html'</script>");
}
else
{
iscanverify = gg.Iscanverify;
groupname = gg.Groupname;
groupid = gg.Groupid;
}
}
}
private void GetUser()
{
B2b_company_manageuser user = UserHelper.CurrentUser();
B2b_company company = UserHelper.CurrentCompany;
atypee = user.Atype;
userid = user.Id;
comid = company.ID;
comname = company.Com_name;
//判断页面是否在权限页面链接中：没有，不做处理；有，判断角色是否可以访问此页面
bool isactionurl = new Sys_ActionData().Isactionurl(Requestfile);
if (isactionurl)
{
bool iscanvisit = new Sys_ActionData().Iscanvisit(Requestfile, userid);
if (iscanvisit == false)
{
//Response.Redirect("/manage.aspx");
Response.Write("<script>window.location.href='/manage.aspx'</script>");
}
}
//根据comid得到公司logo信息
B2b_company_saleset logoset = B2bCompanySaleSetData.GetDirectSellByComid(comid.ToString());
if (logoset != null)
{
int logo_temp = 0;
if (logoset.Logo != "")
{
logo_temp = int.Parse(logoset.Logo);
}
FileUploadModel identityFileUpload = new FileUploadData().GetFileById(logo_temp);
if (identityFileUpload != null)
{
comlogo = fileUrl + identityFileUpload.Relativepath;
}
}
username = user.Accounts;
B2b_company companyinfo = B2bCompanyData.GetAllComMsg(comid);
if (companyinfo.B2bcompanyinfo.Domainname != "")
{
companydo = "http://" + companyinfo.B2bcompanyinfo.Domainname;
}
else
{
companydo = "http://shop" + company.ID + ".etown.cn";
}
//根据userid得到用户信息，如果用户没有渠道公司的分配，则显示全部门市
B2b_company_manageuser muser = B2bCompanyManagerUserData.GetUser(UserHelper.CurrentUserId());
if (muser != null)
{
//控制只有平台总账户才可以进入/ui/permissionui目录
if (Requestfile.Contains("/ui/permissionui"))
{
if (muser.Id != 1035)
{
Response.Redirect("http://shop.etown.cn");
}
}
Sys_Group gg = new Sys_GroupData().GetGroupByUserId(muser.Id);
if (gg == null)
{
//Response.Write("<script>alert('用户尚未分配角色，请联系管理员！');location.href='/Manage/index1.html'</script>");
}
else
{
iscanverify = gg.Iscanverify;
groupname = gg.Groupname;
groupid = gg.Groupid;
}
}
//根据不同用户显示不同的左侧栏
int totalcount = 0;
List <Sys_ActionColumn> topList = new Sys_ActionColumnData().GetActionColumnByUser(UserHelper.CurrentUserId(), out totalcount);
rptTopMenuList.DataSource = topList;
rptTopMenuList.DataBind();
foreach (RepeaterItem item in rptTopMenuList.Items)
{
int funcId = (item.FindControl("HideFuncId") as HiddenField).Value.ConvertTo <int>();
int totalaction = 0;
var menuList = new Sys_ActionData().GetActionsByColumnId(UserHelper.CurrentUserId(), funcId, out totalaction);
Repeater rptMenuList = item.FindControl("rptMenuList") as Repeater;
rptMenuList.DataSource = menuList;
rptMenuList.DataBind();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string oper = context.Request["oper"].ConvertTo <string>("");
if (oper != "")
{
if (oper == "ValidateEticket")
{
var pno = context.Request["pno"].ToString();
if (pno != null && pno != "")
{
pno = EncryptionHelper.EticketPnoDES(pno, 1);//对码进行解密
}
var comid = context.Request["comid"];
string data = "";//获取电子票详细信息
int isget = 0;//判断获取详情是否成功
data = EticketJsonData.GetEticketDetail(pno, comid, out isget);
if (isget == 1)//如果获取成功，附session值，防止确认使用操作后重复刷新页面造成电子票重复打印的操作
{
context.Session[pno] = "1";
}
else
{
context.Session[pno] = "0";
}
context.Response.Write(data);
}
if (oper == "getagentsearchlist")
{
var pno = context.Request["key"].ConvertTo <string>("");
var comid = context.Request["comid"].ConvertTo <int>(0);
var agentid = context.Request["agentid"].ConvertTo <int>(0);
var data = EticketJsonData.GetEticketSearch(pno, comid, agentid);
context.Response.Write(data);
}
if (oper == "getagentbacklist")
{
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
var comid = context.Request["comid"].ConvertTo <int>(0);
var agentid = context.Request["agentid"].ConvertTo <int>(0);
var data = EticketJsonData.GetBackEticketlist(comid, agentid, pageindex, pagesize);
context.Response.Write(data);
}
//退票
if (oper == "backagentticket")
{
var pno = context.Request["pno"].ConvertTo <string>("");
var comid = context.Request["comid"].ConvertTo <int>(0);
var agentid = context.Request["agentid"].ConvertTo <int>(0);
var id = context.Request["id"].ConvertTo <int>(0);
var data = EticketJsonData.BackAgentEticket_interface(id, pno);
context.Response.Write(data);
}
if (oper == "GetPnoDetail")//得到电子票详细信息（包括厂家信息，产品信息，电子票信息）
{
var pno = context.Request["pno"];
string data = EticketJsonData.GetPnoDetail(pno);
context.Response.Write(data);
}
if (oper == "getedetail")//得到此次后台验证票的详细情况
{
var pno = context.Request["pno"];
if (pno != null && pno != "")
{
pno = EncryptionHelper.EticketPnoDES(pno, 1);//对码进行解密
}
var comid = context.Request["comid"];
var validateticketlogid = context.Request["validateticketlogid"];
string data = "";//获取电子票详细信息
data = EticketJsonData.GetEticketDetailNotValidate(pno, comid, validateticketlogid);
context.Response.Write(data);
}
if (oper == "econfirm")
{
var pno = context.Request["pno"];
if (pno != null && pno != "")
{
pno = EncryptionHelper.EticketPnoDES(pno, 1);//对码进行解密
}
var usenum = context.Request["usenum"];
var comid = context.Request["comid"];
if (context.Session[pno].ToString() == "1")//防止点击后退键重复使用
{
//获取PC验证登陆账户
B2b_company_manageuser user = UserHelper.CurrentUser();
var username = user.Accounts;
//得到登录用户角色 验证电子票的类型
int validateservertype = 0;
Sys_Group mgroup = new Sys_GroupData().GetGroupByUserId(user.Id);
if (mgroup != null)
{
validateservertype = mgroup.validateservertype;
}
if (validateservertype > 0)
{
//根据电子码 得到产品的服务类型，如果和用户角色所能验证的服务类型不符，则不可验证电子票
int pnoservertype = new B2bComProData().GetServertypeByPno(pno);
if (pnoservertype == 0)
{
context.Response.Write("{\"type\":1,\"msg\":\"根据电子码得到产品服务类型失败\"}");
return;
}
else
{
if (pnoservertype != validateservertype)
{
context.Response.Write("{\"type\":1,\"msg\":\"登录用户角色只可以验证" + EnumUtils.GetName((ProductServer_Type)validateservertype) + "\"}");
return;
}
}
}
string data = EticketJsonData.EConfirm(pno, usenum, comid, 999999999, "", username);//返回数据
context.Session[pno] = "0";
context.Response.Write(data);
}
else
{
context.Response.Redirect("/ui/pmui/eticket/eticketindex.aspx");
}
}
if (oper == "zizhueconfirm")
{
var pno = context.Request["pno"];
if (pno != null && pno != "")
{
pno = EncryptionHelper.EticketPnoDES(pno, 1);//对码进行解密
}
var usenum = context.Request["usenum"];
var comid = context.Request["comid"];
string data = EticketJsonData.EConfirm(pno, usenum, comid, 999999999, "", "自助验证");//返回数据
context.Response.Write(data);
}
if (oper == "pagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
var eclass = context.Request["eclass"].ConvertTo <int>(0);
var proid = context.Request["proid"].ConvertTo <string>("0");
var jsid = context.Request["jsid"].ConvertTo <string>("0");
var posid = context.Request["posid"].ConvertTo <int>(0);
var key = context.Request["key"].ConvertTo <string>("");
var startime = context.Request["startime"].ConvertTo <string>("");
var endtime = context.Request["endtime"].ConvertTo <string>("");
var projectid = context.Request["projectid"].ConvertTo <int>(0);
var saleagentid = context.Request["agentid"].ConvertTo <int>(0);
string data = EticketJsonData.EPageList(comid, pageindex, pagesize, eclass, int.Parse(proid), int.Parse(jsid), posid, key, startime, endtime, 0, projectid, saleagentid);
context.Response.Write(data);
}
if (oper == "interfaceuselogpagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
var key = context.Request["key"].ConvertTo <string>("");
var startime = context.Request["startime"].ConvertTo <string>("");
var endtime = context.Request["endtime"].ConvertTo <string>("");
string data = EticketJsonData.InterfaceUsePageList(comid, pageindex, pagesize, key, startime, endtime);
context.Response.Write(data);
}
if (oper == "dayjslist")
{
var comid = context.Request["comid"];
string data = EticketJsonData.DayJSList(comid);
context.Response.Write(data);
}
if (oper == "dayjsresult")
{
var comid = context.Request["comid"];
var jsid = context.Request["jsid"];
string data = EticketJsonData.DayJSResult(comid, jsid);
context.Response.Write(data);
}
if (oper == "GetPnoConsumeLogList")
{
string pno = context.Request["pno"];
string data = EticketJsonData.GetPnoConsumeLogList(pno);
context.Response.Write(data);
}
if (oper == "agentEticketlog")
{
int Pageindex = context.Request["Pageindex"].ConvertTo <int>(1);
int Pagesize = context.Request["Pagesize"].ConvertTo <int>(10);
int agentid = context.Request["agentid"].ConvertTo <int>(0);
int comid = context.Request["comid"].ConvertTo <int>(0);
string key = context.Request["key"].ConvertTo <string>("");
string startime = context.Request["startime"].ConvertTo <string>("");
string endtime = context.Request["endtime"].ConvertTo <string>("");
var data = EticketJsonData.AgentEticketlog(comid, agentid, Pageindex, Pagesize, key, startime, endtime);
context.Response.Write(data);
}
//安订单，已验票列表
if (oper == "VagentEticketlog")
{
int Pageindex = context.Request["Pageindex"].ConvertTo <int>(1);
int Pagesize = context.Request["Pagesize"].ConvertTo <int>(10);
int agentid = context.Request["agentid"].ConvertTo <int>(0);
int orderid = context.Request["orderid"].ConvertTo <int>(0);
int comid = context.Request["comid"].ConvertTo <int>(0);
var data = EticketJsonData.VAgentEticketlog(comid, agentid, orderid, Pageindex, Pagesize);
context.Response.Write(data);
}
//安全码
if (oper == "eticketsafety")
{
int comid = context.Request["comid"].ConvertTo <int>(0);
DateTime startime = context.Request["startime"].ConvertTo <DateTime>(DateTime.Now);
var data = EticketJsonData.GetComDayRandomlist(comid, startime);
context.Response.Write(data);
}
//生成安全码
if (oper == "createeticketsafety")
{
int comid = context.Request["comid"].ConvertTo <int>(0);
DateTime startime = context.Request["startime"].ConvertTo <DateTime>(DateTime.Now);
var data = EticketJsonData.CreateComDayRandom(comid, startime);
context.Response.Write(data);
}
}
}
public string groupname = ""; //管理组名称
protected void Page_Load(object sender, EventArgs e)
{
groupid = Request["groupid"].ConvertTo <string>("0");
Sys_Group group = new Sys_GroupData().GetGroupById(groupid.ConvertTo <int>(0));
groupname = group.Groupname;
//根据groupid得到管理组所拥有的权限
int listcount = 0;
IList <Sys_Action> actionlist = new Sys_ActionData().GetActionsByGroupdId(groupid, out listcount);
var ListSelectedActionId = new List <int>();
foreach (Sys_Action a in actionlist)
{
ListSelectedActionId.Add(a.Actionid);
}
treestr += "[";
//得到权限分栏表
int columncount = 0;
IList <Sys_ActionColumn> columns = new Sys_ActionColumnData().GetColumns(out columncount);
foreach (Sys_ActionColumn column in columns)
{
//判断权限分栏下如果没有权限，则不显示
int actionnum = new Sys_ActionData().GetActionNumByColumn(column.Actioncolumnid);
if (actionnum > 0)
{
int columnid = column.Actioncolumnid;
string columnname = column.Actioncolumnname;
treestr += "{id:" + columnid + ",pId:0,name:\"" + columnname + "\",open:true,nocheck:true},";
//得到权限分栏表下的权限列表
int actioncount = 0;
IList <Sys_Action> actions = new Sys_ActionData().GetActionsByColumnId(columnid, out actioncount);
foreach (Sys_Action action in actions)
{
int actionid = action.Actionid;
string actionname = action.Actionname;
string actionurl = action.Actionurl;
if (ListSelectedActionId.Contains(actionid))
{
treestr += "{id:" + actionid + ",pId:" + columnid + ",name:\"" + actionname + "\", checked: true},";
}
else
{
treestr += "{id:" + actionid + ",pId:" + columnid + ",name:\"" + actionname + "\"},";
}
//根据管理组、权限 得到右侧子导航(显示)--选中项
var ListSelectedsubnavId = new List <int>();
IList <Sys_groupactionsubnav> checked_slist = new Sys_groupactionsubnavData().GetSys_groupactionsubnav(action.Actionid, groupid);
if (checked_slist.Count > 0)
{
foreach (Sys_groupactionsubnav a in checked_slist)
{
ListSelectedsubnavId.Add(a.subnavid);
}
}
//根据权限 得到右侧子导航(显示)
int viewcode = 1;
IList <Sys_subnav> slist = new Sys_subnavData().GetSys_subnavbyactionid(action.Actionid, viewcode);
if (slist.Count > 0)
{
foreach (Sys_subnav m in slist)
{
int subnavid = m.id;
string subnavname = m.subnav_name;
if (ListSelectedsubnavId.Count > 0)
{
if (ListSelectedsubnavId.Contains(m.id))
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\", checked: true},";
}
else
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\"},";
}
}
else
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\"},";
}
}
}
}
}
}
treestr = treestr.Substring(0, treestr.Length - 1);
treestr += "]";
// treestr = @"[
// { id: 1, pId: 0, name: '随意勾选 1', open: true, nocheck:true },
// { id: 11, pId: 1, name: '随意勾选 1-1', open: true },
// { id: 111, pId: 11, name: '随意勾选 1-1-1' },
// { id: 112, pId: 11, name: '随意勾选 1-1-2' },
// { id: 12, pId: 1, name: '随意勾选 1-2', open: true },
// { id: 121, pId: 12, name: '随意勾选 1-2-1' },
// { id: 122, pId: 12, name: '随意勾选 1-2-2' },
// { id: 2, pId: 0, name: '随意勾选 2', checked: true, open: true },
// { id: 21, pId: 2, name: '随意勾选 2-1' },
// { id: 22, pId: 2, name: '随意勾选 2-2', open: true },
// { id: 221, pId: 22, name: '随意勾选 2-2-1', checked: true },
// { id: 222, pId: 22, name: '随意勾选 2-2-2' },
// { id: 23, pId: 2, name: '随意勾选 2-3' }
// ]";
}
protected void Page_Load(object sender, EventArgs e)
{
string oper = Request["oper"].ConvertTo <string>("");
#region 导出卡号
if (oper == "outcardno")//导出卡号
{
int crid = Request["crid"].ConvertTo <int>(0);
int comid = Request["comid"].ConvertTo <int>(0);
if (crid > 0 && comid > 0)
{
DataTable table = ExcelSqlHelper.ExecuteDataTable("select cardcode from member_card where crid=" + crid + " and com_id=" + comid);
ExcelRender.RenderToExcel(table, Context, "卡号列表.xls");
}
}
#endregion
#region 导出旅游大巴产品结单名单
if (oper == "outlvyoubusorderlistbyorderstate")//导出旅游大巴产品结单名单
{
int proid = Request["proid"].ConvertTo <int>(0);
string gooutdate = Request["gooutdate"].ConvertTo <string>("");
int orderstate = Request["orderstate"].ConvertTo <int>(0);
object o = ExcelSqlHelper.ExecuteScalar("select pro_name from b2b_com_pro where id=" + proid);
//DataTable table = ExcelSqlHelper.ExecuteDataTable("select id as 订单号,u_name as 预订人,u_num as 预订人数,CONVERT(varchar(10),u_traveldate,120) as 出行时间,u_subdate as 预订时间 FROM b2b_order where u_traveldate='" + gooutdate + "' and pro_id=" + proid + " and order_state=" + orderstate);
//DataTable table = ExcelSqlHelper.ExecuteDataTable("SELECT [orderid] as 订单号,[name] as 乘车人姓名,[IdCard] as 乘车人身份证,[Nation] as 乘车人民族,CONVERT(varchar(10),[travel_time],120) as 乘车日期,[yuding_name] as 预订人姓名,[yuding_phone] as 预订人电话,[yuding_time] as 预订时间,pickuppoint as 上车地点,dropoffpoint as 下车地点 FROM [b2b_order_busNamelist] where orderid in (select id FROM b2b_order where u_traveldate='" + gooutdate + "' and pro_id=" + proid + " and order_state=" + orderstate + ")");
DataTable table = ExcelSqlHelper.ExecuteDataTable("SELECT a.[orderid] as 订单号,a.[name] as 乘车人姓名,a.[contactphone] as 乘车人电话,a.[IdCard] as 乘车人身份证,a.[Nation] as 乘车人民族,CONVERT(varchar(10),a.[travel_time],120) as 乘车日期,a.[yuding_name] as 预订人姓名,a.[yuding_phone] as 预订人电话,a.[yuding_time] as 预订时间,a.pickuppoint as 上车地点,a.dropoffpoint as 下车地点,b.company as 购票地点,a.contactremark as 备注 FROM agent_company as b right join [b2b_order_busNamelist] as a on a.agentid=b.id left join b2b_order as c on a.orderid=c.id where a.orderid in (select id FROM b2b_order where u_traveldate='" + gooutdate + "' and pro_id=" + proid + " and order_state=" + orderstate + ")");
ExcelRender.RenderToExcel(table, Context, gooutdate + o.ToString() + "结单名单.xls");
}
#endregion
#region 分销订单导入到excel
if (oper == "agentordertoexcel")
{
var comid = Request["comid"].ConvertTo <int>(0);
int agentid = Request["agentid"].ConvertTo <int>(0);
var key = Request["key"].ConvertTo <string>("");
var account = Request["account"].ConvertTo <string>("");
var order_state = Request["order_state"].ConvertTo <int>(0);
var begindate = Request["beginDate"].ConvertTo <string>("");
var enddate = Request["endDate"].ConvertTo <string>("");
var servertype = Request["servertype"].ConvertTo <int>(0);
object o1 = ExcelSqlHelper.ExecuteScalar("select company from agent_company where id=" + agentid);
object o2 = ExcelSqlHelper.ExecuteScalar("select com_name from b2b_company where id=" + comid);
List <B2b_order> agentorderlist = new B2bOrderData().GetAgentOrderList(comid, agentid, key, order_state, begindate, enddate, servertype);
if (agentorderlist.Count > 0)
{
DataTable tblDatas = new DataTable("Datas");
DataColumn dc = null;
dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true; //自动增加
dc.AutoIncrementSeed = 1; //起始为1
dc.AutoIncrementStep = 1; //步长为1
dc.AllowDBNull = false;
dc = tblDatas.Columns.Add("订单号", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单时间", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("产品名称", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单人", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("单价", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("数量", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("实收", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("状态", Type.GetType("System.String"));
DataRow newRow;
foreach (B2b_order morder in agentorderlist)
{
if (morder != null)
{
newRow = tblDatas.NewRow();
newRow["订单号"] = morder.Id;
newRow["提单时间"] = morder.U_subdate;
newRow["产品名称"] = morder.Order_type == 2 ? "预付款充值" : new B2bComProData().GetProById(morder.Pro_id.ToString(), morder.Speciid).Pro_name;
newRow["提单人"] = morder.U_name + "(" + morder.U_phone + ")";
newRow["单价"] = morder.Pay_price;
newRow["数量"] = morder.U_num;
newRow["实收"] = (morder.Pay_price) * (morder.U_num) + morder.Express - morder.Integral1 - morder.Imprest1;
newRow["状态"] = EnumUtils.GetName((OrderStatus)morder.Order_state);
tblDatas.Rows.Add(newRow);
}
}
ExcelRender.RenderToExcel(tblDatas, Context, o1.ToString() + "-" + o2.ToString() + "-订单列表.xls");
}
}
#endregion
#region 商户产品分销销售订单导入到excel
if (oper == "agentsalescodetoexcel")
{
var comid = Request["comid"].ConvertTo <int>(0);
var order_state = Request["order_state"].ConvertTo <int>(0);
var servertype = Request["servertype"].ConvertTo <int>(0);
var begindate = Request["beginDate"].ConvertTo <string>("");
var enddate = Request["endDate"].ConvertTo <string>("");
var key = Request["key"].ConvertTo <string>("");
var ordertype = Request["ordertype"].ConvertTo <int>(0);
var userid = Request["userid"].ConvertTo <int>(0);
int orderIsAccurateToPerson = 0;
int channelcompanyid = 0;
if (userid > 0)
{
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
if (group != null)
{
//判断订单是否要求精确到渠道人
orderIsAccurateToPerson = group.OrderIsAccurateToPerson;
Member_Channel_company channelcom = new MemberChannelcompanyData().GetChannelCompanyByUserId(userid);
if (channelcom != null)
{
channelcompanyid = channelcom.Id;
}
}
}
object o2 = ExcelSqlHelper.ExecuteScalar("select com_name from b2b_company where id=" + comid);
List <B2b_order> directorderlist = new B2bOrderData().GetOrderList(comid, order_state, servertype, begindate, enddate, key, userid, orderIsAccurateToPerson, channelcompanyid, ordertype);
if (directorderlist.Count > 0)
{
DataTable tblDatas = new DataTable("Datas");
DataColumn dc = null;
dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true; //自动增加
dc.AutoIncrementSeed = 1; //起始为1
dc.AutoIncrementStep = 1; //步长为1
dc.AllowDBNull = false;
dc = tblDatas.Columns.Add("订单号", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单时间", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("产品名称", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单人", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("单价", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("数量", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("实收", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("收货地址", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("状态", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("分销商", Type.GetType("System.String"));
DataRow newRow;
foreach (B2b_order morder in directorderlist)
{
if (morder != null)
{
newRow = tblDatas.NewRow();
newRow["订单号"] = morder.Id;
newRow["提单时间"] = morder.U_subdate;
newRow["产品名称"] = morder.Order_type == 2 ? "预付款充值" : new B2bComProData().GetProById(morder.Pro_id.ToString(), morder.Speciid).Pro_name;
newRow["提单人"] = morder.U_name + "(" + morder.U_phone + ")";
newRow["单价"] = morder.Pay_price;
newRow["数量"] = morder.U_num;
newRow["实收"] = (morder.Pay_price) * (morder.U_num) + morder.Express - morder.Integral1 - morder.Imprest1;
newRow["收货地址"] = morder.Province + "-" + morder.City + "-" + morder.Address;
newRow["状态"] = EnumUtils.GetName((OrderStatus)morder.Order_state);
newRow["分销商"] = new Agent_companyData().GetAgentName(morder.Agentid);
tblDatas.Rows.Add(newRow);
}
}
ExcelRender.RenderToExcel(tblDatas, Context, o2.ToString() + "-后台销售订单列表.xls");
}
}
#endregion
#region 商户产品分销倒码订单导入到excel
if (oper == "agentbackcodetoexcel")
{
var comid = Request["comid"].ConvertTo <int>(0);
var order_state = Request["order_state"].ConvertTo <int>(0);
var servertype = Request["servertype"].ConvertTo <int>(0);
var begindate = Request["beginDate"].ConvertTo <string>("");
var enddate = Request["endDate"].ConvertTo <string>("");
var key = Request["key"].ConvertTo <string>("");
var ordertype = Request["ordertype"].ConvertTo <int>(0);
var userid = Request["userid"].ConvertTo <int>(0);
int orderIsAccurateToPerson = 0;
int channelcompanyid = 0;
if (userid > 0)
{
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
if (group != null)
{
//判断订单是否要求精确到渠道人
orderIsAccurateToPerson = group.OrderIsAccurateToPerson;
Member_Channel_company channelcom = new MemberChannelcompanyData().GetChannelCompanyByUserId(userid);
if (channelcom != null)
{
channelcompanyid = channelcom.Id;
}
}
}
object o2 = ExcelSqlHelper.ExecuteScalar("select com_name from b2b_company where id=" + comid);
List <B2b_order> directorderlist = new B2bOrderData().GetOrderList(comid, order_state, servertype, begindate, enddate, key, userid, orderIsAccurateToPerson, channelcompanyid, ordertype);
if (directorderlist.Count > 0)
{
DataTable tblDatas = new DataTable("Datas");
DataColumn dc = null;
dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true; //自动增加
dc.AutoIncrementSeed = 1; //起始为1
dc.AutoIncrementStep = 1; //步长为1
dc.AllowDBNull = false;
dc = tblDatas.Columns.Add("订单号", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单时间", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("产品名称", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单人", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("单价", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("数量", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("实收", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("收货地址", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("状态", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("分销商", Type.GetType("System.String"));
DataRow newRow;
foreach (B2b_order morder in directorderlist)
{
if (morder != null)
{
newRow = tblDatas.NewRow();
newRow["订单号"] = morder.Id;
newRow["提单时间"] = morder.U_subdate;
newRow["产品名称"] = morder.Order_type == 2 ? "预付款充值" : new B2bComProData().GetProById(morder.Pro_id.ToString(), morder.Speciid).Pro_name;
newRow["提单人"] = morder.U_name + "(" + morder.U_phone + ")";
newRow["单价"] = morder.Pay_price;
newRow["数量"] = morder.U_num;
newRow["实收"] = (morder.Pay_price) * (morder.U_num) + morder.Express - morder.Integral1 - morder.Imprest1;
newRow["收货地址"] = morder.Province + "-" + morder.City + "-" + morder.Address;
newRow["状态"] = EnumUtils.GetName((OrderStatus)morder.Order_state);
newRow["分销商"] = new Agent_companyData().GetAgentName(morder.Agentid);
tblDatas.Rows.Add(newRow);
}
}
ExcelRender.RenderToExcel(tblDatas, Context, o2.ToString() + "-倒码订单列表.xls");
}
}
#endregion
#region 直销订单导入到excel
if (oper == "directordertoexcel")
{
var comid = Request["comid"].ConvertTo <int>(0);
var order_state = Request["order_state"].ConvertTo <int>(0);
var servertype = Request["servertype"].ConvertTo <int>(0);
var begindate = Request["beginDate"].ConvertTo <string>("");
var enddate = Request["endDate"].ConvertTo <string>("");
var key = Request["key"].ConvertTo <string>("");
var ordertype = Request["ordertype"].ConvertTo <int>(0);
var userid = Request["userid"].ConvertTo <int>(0);
int orderIsAccurateToPerson = 0;
int channelcompanyid = 0;
if (userid > 0)
{
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
if (group != null)
{
//判断订单是否要求精确到渠道人
orderIsAccurateToPerson = group.OrderIsAccurateToPerson;
Member_Channel_company channelcom = new MemberChannelcompanyData().GetChannelCompanyByUserId(userid);
if (channelcom != null)
{
channelcompanyid = channelcom.Id;
}
}
}
object o2 = ExcelSqlHelper.ExecuteScalar("select com_name from b2b_company where id=" + comid);
List <B2b_order> directorderlist = new B2bOrderData().GetOrderList(comid, order_state, servertype, begindate, enddate, key, userid, orderIsAccurateToPerson, channelcompanyid, ordertype);
if (directorderlist.Count > 0)
{
DataTable tblDatas = new DataTable("Datas");
DataColumn dc = null;
dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true; //自动增加
dc.AutoIncrementSeed = 1; //起始为1
dc.AutoIncrementStep = 1; //步长为1
dc.AllowDBNull = false;
dc = tblDatas.Columns.Add("订单号", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单时间", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("产品名称", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("提单人", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("身份证", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("手机", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("单价", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("数量", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("实收", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("收货地址", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("状态", Type.GetType("System.String"));
DataRow newRow;
foreach (B2b_order morder in directorderlist)
{
if (morder != null)
{
newRow = tblDatas.NewRow();
newRow["订单号"] = morder.Id;
newRow["提单时间"] = morder.U_subdate;
newRow["产品名称"] = morder.Order_type == 2 ? "预付款充值" : new B2bComProData().GetProById(morder.Pro_id.ToString(), morder.Speciid).Pro_name;
newRow["提单人"] = morder.U_name;
newRow["身份证"] = morder.U_idcard;
newRow["手机"] = morder.U_phone;
newRow["单价"] = morder.Pay_price;
newRow["数量"] = morder.U_num;
newRow["实收"] = (morder.Pay_price) * (morder.U_num) + morder.Express - morder.Integral1 - morder.Imprest1;
newRow["收货地址"] = morder.Province + "-" + morder.City + "-" + morder.Address;
newRow["状态"] = EnumUtils.GetName((OrderStatus)morder.Order_state);
tblDatas.Rows.Add(newRow);
}
}
ExcelRender.RenderToExcel(tblDatas, Context, o2.ToString() + "-直销订单列表.xls");
}
}
#endregion
#region 订房信息导入到excel
if (oper == "hotelordertoexcel")
{
int comid = Request["comid"].ConvertTo <int>(0);
string begindate = Request["begindate"].ConvertTo <string>("");
string enddate = Request["enddate"].ConvertTo <string>("");
int productid = Request["productid"].ConvertTo <int>(0);
string orderstate = Request["orderstate"].ConvertTo <string>("");
try
{
object o1 = ExcelSqlHelper.ExecuteScalar("select com_name from b2b_company where id=" + comid);
object o2 = ExcelSqlHelper.ExecuteScalar("select pro_name from b2b_com_pro where id=" + productid);
object o3 = ExcelSqlHelper.ExecuteScalar("select projectname from b2b_com_project where id=(select projectid from b2b_com_pro where id=" + productid + ")");
DataTable tblDatas = new B2bOrderData().HotelOrderlist(comid, begindate, enddate, productid, orderstate, 1);
if (begindate == "" || enddate == "")
{
ExcelRender.RenderToExcel(tblDatas, Context, o1.ToString() + "-" + o2.ToString() + "-" + o3.ToString() + "-订房订单列表.xls");
}
else
{
ExcelRender.RenderToExcel(tblDatas, Context, o1.ToString() + "-" + o2.ToString() + "-" + o3.ToString() + "(" + DateTime.Parse(begindate).ToString("yyyy-MM-dd") + "到" + DateTime.Parse(enddate).ToString("yyyy-MM-dd") + ")" + "-订房订单列表.xls");
}
}
catch { }
}
#endregion
#region 载分销特定项目下的验票记录
if (oper == "downagentpro_yplist")
{
int proid = Request["proid"].ConvertTo <int>(0);
string startime = Request["startime"].ConvertTo <string>("");
string endtime = Request["endtime"].ConvertTo <string>("");
int agentid = 0;
if (Session["Agentid"] != null)
{
agentid = Int32.Parse(Session["Agentid"].ToString());
}
object o1 = ExcelSqlHelper.ExecuteScalar("select company from agent_company where id=" + agentid);
object o2 = ExcelSqlHelper.ExecuteScalar("select pro_name from b2b_com_pro where id=" + proid);
int comid = new B2bComProData().GetComidByProid(proid);
var condition = " a.action=1 and a.com_id=" + comid + " and a.a_state=" + (int)ECodeOperStatus.OperSuc + " and a.pno in (select pno from b2b_eticket where 1=1 ";
if (proid != 0)
{
condition += " and pro_id=" + proid;
}
if (agentid != 0)
{
condition += " and pro_id in (select id from b2b_com_pro where projectid in (select projectid from b2b_project_agent where agentid=" + agentid + ") )";
}
condition += ")";
if (startime != "")
{
condition += " and a.actiondate>='" + startime + "'";
}
if (endtime != "")
{
endtime = DateTime.Parse(endtime).AddDays(1).ToString();
condition += " and a.actiondate<'" + endtime + "'";
}
ExcelRender.RenderToExcel(
ExcelSqlHelper.ExecuteDataTable(CommandType.Text, "select b.e_proname [产品名称],a.pno [电子码],b.pnum [订购数量],a.use_pnum [本次使用数量],a.actiondate [验证时间],a.posid [验证pos],b.e_face_price [门市价],b.e_sale_price [结算价],c.company[出票方] from b2b_etcket_log as a left join b2b_eticket as b on a.com_id=b.com_id and a.pno=b.pno and a.eticket_id=b.id left join agent_company as c on b.agent_id=c.id where " + condition + " order by a.id desc"),
Context, "分销:" + o1.ToString() + "-" + "产品:" + o2.ToString() + "-验证电子票列表(" + startime + "--" + endtime + ")" + ".xls");
}
#endregion
#region 财务导出到excel
if (oper == "Financelisttoexcel")
{
var comid = Request["comid"].ConvertTo <int>(0);
var begindate = Request["beginDate"].ConvertTo <string>("");
var enddate = Request["endDate"].ConvertTo <string>("");
var financedata = new B2bFinanceData();
var directorderlist = financedata.FinanceallList(comid, begindate, enddate);
if (directorderlist.Count > 0)
{
DataTable tblDatas = new DataTable("Datas");
DataColumn dc = null;
dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true; //自动增加
dc.AutoIncrementSeed = 1; //起始为1
dc.AutoIncrementStep = 1; //步长为1
dc.AllowDBNull = false;
dc = tblDatas.Columns.Add("订单号", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("时间", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("产品名称", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("类型", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("金额", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("余额", Type.GetType("System.String"));
dc = tblDatas.Columns.Add("渠道", Type.GetType("System.String"));
DataRow newRow;
foreach (B2b_Finance morder in directorderlist)
{
if (morder != null)
{
newRow = tblDatas.NewRow();
newRow["订单号"] = morder.Order_id;
newRow["时间"] = morder.Subdate;
newRow["产品名称"] = morder.Servicesname;
newRow["类型"] = morder.Payment_type;
newRow["金额"] = morder.Money;
newRow["余额"] = morder.Over_money;
newRow["渠道"] = morder.Money_come == "wx"?"微信支付":morder.Money_come;
tblDatas.Rows.Add(newRow);
}
}
ExcelRender.RenderToExcel(tblDatas, Context, comid.ToString() + DateTime.Now.ToString("yyyyMMddHHmmss") + "-财务明细列表.xls");
}
}
#endregion
#region 注释内容
//int splitid = Request["splitid"].ConvertTo<int>(0);//微信拆分表id
//if (splitid == 0)//下载excel导入样例操作,暂时没有用到
//{
// DataTable table = new DataTable();
// table.Columns.Add("姓名", typeof(string));
// table.Columns.Add("手机", typeof(string));
// table.Columns.Add("邮箱", typeof(string));
// table.Columns.Add("微信号", typeof(string));
// table.Columns.Add("预付款", typeof(string));
// table.Columns.Add("积分", typeof(string));
// table.Columns.Add("目的地", typeof(string));
// table.Columns.Add("年龄段", typeof(string));
// table.Columns.Add("会员级别", typeof(string));
// for (int i = 0; i < 10; i++)
// {
// string name = "张三" + i.ToString();
// Thread.Sleep(1);
// string phone = "手机号" + i.ToString();
// Thread.Sleep(1);
// string email = "邮箱地址" + i.ToString();
// Thread.Sleep(1);
// string weixin = "微信" + i.ToString();
// Thread.Sleep(1);
// string imprest = i.ToString();
// Thread.Sleep(1);
// string integral = i.ToString();
// Thread.Sleep(1);
// string destination = "目的地" + i.ToString();
// Thread.Sleep(1);
// string agegroup = "年龄段" + i.ToString();
// Thread.Sleep(1);
// string crmlevel = "1";
// Thread.Sleep(1);
// table.Rows.Add(name, phone, email, weixin, imprest, integral, destination, agegroup, crmlevel);
// }
// ExcelRender.RenderToExcel(table, Context, "Excel导入样例.xls");
//}
//else//下载获取的微信关注用户表 的拆分用户列表,暂时没有到
//{
// ObtainGzListSplit model = new ObtainGzListSplitData().GetObtainGzListSplit(splitid);
// if (model != null)
// {
// string openidstr = model.Splitopenid;
// string[] str = openidstr.Split(',');
// DataTable table = new DataTable();
// table.Columns.Add("姓名", typeof(string));
// table.Columns.Add("手机", typeof(string));
// table.Columns.Add("邮箱", typeof(string));
// table.Columns.Add("微信号", typeof(string));
// for (int i = 0; i < str.Length; i++)
// {
// string name = "";
// Thread.Sleep(1);
// string phone = "";
// Thread.Sleep(1);
// string email = "";
// Thread.Sleep(1);
// string weixin = str[i];
// Thread.Sleep(1);
// table.Rows.Add(name, phone, email, weixin);
// }
// ExcelRender.RenderToExcel(table, Context, model.Comid + "-" + splitid + ".xls");
// }
// else
// {
// Label1.Text = "获取拆分用户列表为空";
// }
//}
#endregion
}
public static string SearchPageList(int userid, string comid, int pageindex, int pagesize, string key, string isactivate = "1", string iswxfocus = "0,1", string ishasweixin = "0,1", string ishasphone = "0,1")
{
var totalcount = 0;
try
{
var list = new List <B2b_crm>();
#region
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
//判断会员是否要求精确到渠道人
bool crmIsAccurateToPerson = group.CrmIsAccurateToPerson;
Member_Channel_company channelcom = new MemberChannelcompanyData().GetChannelCompanyByUserId(userid);
if (channelcom == null)//总公司账户
{
list = new B2bCrmData().SearchPageList(comid, pageindex, pagesize, key, out totalcount, isactivate, iswxfocus, ishasweixin, ishasphone);
}
else
{
string channelcompanytype = "0"; //渠道类型：0内部门店；1合作公司
if (channelcom.Issuetype == 0) //内部门市
{
list = new B2bCrmData().SearchPageList1(comid, pageindex, pagesize, key, channelcom.Id, out totalcount, isactivate, iswxfocus, ishasweixin, channelcompanytype, crmIsAccurateToPerson, userid, ishasphone);
}
else //合作公司
{
channelcompanytype = "1";
list = new B2bCrmData().SearchPageList1(comid, pageindex, pagesize, key, channelcom.Id, out totalcount, isactivate, iswxfocus, ishasweixin, channelcompanytype, crmIsAccurateToPerson, userid, ishasphone);
}
}
IEnumerable result = "";
if (list != null)
{
result = from pro in list
select new
{
id = pro.Id,
comid = pro.Com_id,
phone = pro.Phone,
registerdate = pro.Regidate,
customername = pro.Name,
imprest = pro.Imprest,
integral = pro.Integral,
idcard = pro.Idcard,
email = pro.Email,
serverid = pro.Servercard,
isfocuswinxin = pro.Weixin == "" ? "" : pro.Whetherwxfocus == false ? "已取消" : "已关注",
weixin = pro.Weixin,
channel = new MemberChannelcompanyData().UpCompanyById(pro.Idcard.ToString()),
referrer = MemberChannelData.SearchNamestring(pro.Idcard.ToString()),
WxHeadimgurl = pro.WxHeadimgurl,
WxNickname = pro.WxNickname.Replace("?", ""),
WxProvince = pro.WxProvince,
WxCity = pro.WxCity,
WxSex = pro.WxSex == 0 ? "未知" : pro.WxSex == 1 ? "男" : "女",
GroupId = pro.Groupid,
GroupName = new B2b_groupData().GetB2bgroupName(pro.Groupid),
IsCanReplyWx = IsIn48h(pro.Wxlastinteracttime),
whetherwxfocus = pro.Whetherwxfocus
}
}
;
return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result }));
#endregion
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
