//发送模板消息
private JsonSMsg TemplateSend(Template1 text)
{
JsonSMsg rMsg = new JsonSMsg();
OAauth_Log oa = mss.GetOA(text.Openid);
WeiPage w = new WeiPage();
string token = w.Token(AppConfig.FWHOriginalID);
rMsg.Data += "," + token;
var temp = new
{
first = new { value = text.first, color = "#173177" },
ADA_number = new { value = text.ADA_number, color = "#173177" },
ADA_name = new { value = text.ADA_name, color = "#173177" },
ADA_date = new { value = text.ADA_date, color = "#173177" },
remark = new { value = "\n" + text.remark, color = "#000000" }
};
string message = SendTemplateMessage(token, text.Openid, text.TemplateID, "#FF0000", temp, "http://www.censh.com", text.first);
result data = JsonConvert.DeserializeObject <result>(message);
if (data != null)
{
rMsg.Status = data.errcode;
rMsg.Message = data.errmsg;
}
else
{
rMsg.Status = -1;
rMsg.Message = "出现异常";
}
return(rMsg);
}
public ActionResult CreateEwm(int id)
{
WeiPage wp = new WeiPage();
string mpToken = wp.Token(AppConfig.FWHOriginalID);
string url = "";
QRCodeResponse qrCodeResponse = WXMPClientServiceApi.Create().CreateQRCode(mpToken, id);
if (qrCodeResponse != null)
{
url = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + qrCodeResponse.Ticket;
}
return(Content(string.Format("EwmId：{0}，EwmUrl：{1}", id, url)));
}
public ActionResult SyncQrCode()
{
WeiPage wp = new WeiPage();
string mpToken = wp.Token(AppConfig.FWHOriginalID);
var list = EmployeeService.QueryAllEmpWithNoQrCode(mpToken);
if (list != null && list.Count > 0)
{
return(Content("更新二维码成功"));
}
else
{
return(Content("没有数据需要同步"));
}
}
public ActionResult SaveEmployee(EMPLOYEE_MODEL model, FormCollection form)
{
JsonSMsg rMsg = new JsonSMsg();
string accessToken = HmjClientServiceApi.Create().GetAccessToken();
if (model.ID == 0)
{
WeiPage wp = new WeiPage();
string mpToken = wp.Token(AppConfig.FWHOriginalID);
int ewmId = SystemService.GetEwmId() + 1;
model.EwmId = ewmId;
QRCodeResponse qrCodeResponse = WXMPClientServiceApi.Create().CreateQRCode(mpToken, ewmId);
if (qrCodeResponse != null && qrCodeResponse.ErrorCode == 0)
{
model.EwmUrl = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + qrCodeResponse.Ticket;
}
else
{
rMsg.Message = "获取服务号access_token失败，请重试。";
return(Json(rMsg));
}
}
DeptInfo dept = new DeptInfo();
dept.ID = model.EmpGroupId;
string errMsg = null;
int rows = EmployeeService.SaveEmployee(accessToken, model, dept, ref errMsg);
if (rows > 0)
{
rMsg.Status = 1;
}
else
{
if (string.IsNullOrEmpty(errMsg))
{
errMsg = "保存失败。";
}
rMsg.Message = errMsg;
}
return(Json(rMsg));
}
public ActionResult SaveEmp(EMPLOYEE CuObj, FormCollection form)
{
JsonSMsg rMsg = new JsonSMsg();
try
{
//CuObj.NAME = CuObj.NAME.ToString();
//CuObj.MOBILE = CuObj.MOBILE.ToString();
CuObj.USERID = CuObj.MOBILE.ToString();
CuObj.EwmId = _service.GetEwmId() + 1;
string deptId = form["DeptId"];
string parentDeptId = form["ParentDeptId"];
//设置StoreName(所属部门)，AreaName(部门所属区域) 的值
if (deptJArray == null)
{
setDeptJArray();
}
foreach (JObject dept in deptJArray)
{
if (dept["id"].ToString() == deptId)
{
CuObj.StoreName = dept["name"].ToString();
}
if (dept["id"].ToString() == parentDeptId)
{
CuObj.AreaName = dept["name"].ToString();
}
}
WeiPage wp = new WeiPage();
string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID);
//这里需要修改
string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}}
}";
d = d.Replace("{0}", CuObj.EwmId.ToString());
string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8);
//Response.Write(mes);
string[] b = mes.Split('\"');
string ticket = Server.UrlEncode(b[3]);
//CuObj.Id = num;
CuObj.EwmUrl = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket;
//CuObj.MdSel = "qrscene_" + num.ToString();
int num = _service.SaveEMPLOYEE(CuObj);
if (num > 0)
{
rMsg.Status = 0;
rMsg.Message = "保存成功";
}
else
{
rMsg.Status = -1;
rMsg.Message = "保存失败";
}
}
catch (Exception ex)
{
rMsg.Status = -1;
rMsg.Message = ex.Message;
}
return(Json(rMsg));
}
public ActionResult SaveEWM(QMActivity CuObj, FormCollection form)
{
JsonSMsg rMsg = new JsonSMsg();
try
{
CuObj.MdName = CuObj.MdName.ToString();
//double x = 0;
//double y = 0;
//bd_decrypt(CuObj.Lat.Value, CuObj.Lng.Value, ref y, ref x);
//CuObj.Lat = y;
//CuObj.Lng = x;
//CuObj.MIMAGE_ID = form["MIMAGE_ID"];
int num = _service.SaveQMActivity(CuObj);
WeiPage wp = new WeiPage();
string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID);
//这里需要修改
string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}}
}";
d = d.Replace("{0}", num.ToString());
string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8);
//Response.Write(mes);
string[] b = mes.Split('\"');
string ticket = Server.UrlEncode(b[3]);
CuObj.Id = num;
CuObj.Ticket = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket;
CuObj.MdSel = "qrscene_" + num.ToString();
num = _service.SaveQMActivity(CuObj);
if (num > 0)
{
rMsg.Status = 0;
rMsg.Message = "保存成功";
}
else
{
rMsg.Status = -1;
rMsg.Message = "保存失败";
}
}
catch (Exception ex)
{
rMsg.Status = -1;
rMsg.Message = ex.Message;
}
return(Json(rMsg));
}
public void Get()
{
DataTable dt_base = ImportExcelFile(@"C:\Users\Administrator\Desktop\test2016.xls");
DataTable dt = Distinct(dt_base);//自身去重
List <EMPLOYEE> emplist = sbo.QueryAllEmp();
DataTable dtNew1 = dt.Clone();
foreach (var item in emplist)
{
DataRow[] drArr1 = dt.Select(" B ='" + item.MOBILE + "'");
for (int i = 0; i < drArr1.Length; i++)
{
// dtNew1.ImportRow(drArr1[i]);
dt.Rows.Remove(drArr1[i]);//删除重复数据
}
}
WeiPage wp = new WeiPage();
string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID);
//这里需要修改
int ewmid_max = sbo.GetMaxEwmId();//获取最大的二维码id
string Ticket = "";
int j = 0;
for (int i = (ewmid_max + 1); i < (ewmid_max + dt.Rows.Count + 1); i++)
{
string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}}
}";
d = d.Replace("{0}", i.ToString());
string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8);
JsonData info = JsonMapper.ToObject(mes);
string[] b = mes.Split('\"');
string ticket = info["ticket"].ToString();
Ticket += "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket + "\r\n";
EMPLOYEE emp = new EMPLOYEE();
emp.USERID = dt.Rows[j]["B"].ToString();
emp.NAME = dt.Rows[j]["A"].ToString();
emp.MOBILE = dt.Rows[j]["B"].ToString();
emp.StoreName = dt.Rows[j]["C"].ToString();
emp.AreaName = dt.Rows[j]["D"].ToString();
emp.EwmId = i;
emp.EwmUrl = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket;
sbo.SaveEMPLOYEE(emp);
j++;
}
string ti = Ticket;
}
public void opEwmId()
{
WeiPage wp = new WeiPage();
string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token("gh_b43dad5de37a");
//这里需要修改
string Ticket = "";
for (int i = 1; i <= 10; i++)
{
string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}}
}";
d = d.Replace("{0}", i.ToString());
string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8);
JsonData info = JsonMapper.ToObject(mes);
string[] b = mes.Split('\"');
string ticket = info["ticket"].ToString();
Ticket += i + "|https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket + "\r\n";
}
}