public string LabelSql_API()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Success);
string action = Request.Query["action"];
try
{
switch (action)
{
case "tables": //根据数据库获取表信息
{
}
break;
case "fields": //根据当前选中的表,获取字段信息
{
string dsname = RequestEx["dsname"];
string tbname = RequestEx["tbname"];
SqlBase db = B_DataSource.GetDSByType(dsname);
DataTable dt = db.Field_List(tbname);
dt.DefaultView.Sort = "Name";
retMod.result = JsonConvert.SerializeObject(dt);
}
break;
}
}
catch (Exception ex) { retMod.retmsg = ex.Message; retMod.retcode = M_APIResult.Failed; }
return(retMod.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (function.isAjax())
{
M_APIResult retMod = new M_APIResult();
retMod.retcode = M_APIResult.Failed;
DataTable dt = JsonConvert.DeserializeObject <DataTable>(Request["list"]);
foreach (DataRow dr in dt.Rows)
{
string uname = dr["uname"].ToString();
if (string.IsNullOrEmpty(uname))
{
continue;
}
if (buser.IsExist("ume", uname))
{
retMod.retmsg = "用户名[" + uname + "]已存在,请修改名称"; RepToClient(retMod);
}
}
retMod.retcode = M_APIResult.Success;
RepToClient(retMod);
}
if (!IsPostBack)
{
MyBind();
PreFix_Hid.Value = function.GetRandomString(6, 3).ToLower();
Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='CompList.aspx'>能力中心</a></li><li><a href='PlatInfoManage.aspx'>信息管理</a></li><li><a href='" + Request.RawUrl + "'>创建企业</a></li>");
}
}
//自有账号登录(跳转页面)
public string Login_Ajax(string uname, string upwd, string vcode, int regid)
{
string err = "";
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
if (SiteConfig.UserConfig.EnableCheckCodeOfLogin || UserLoginCount >= 3)
{
if (!ZoomlaSecurityCenter.VCodeCheck(Request.Form["VCode_hid"], vcode.Trim()))
{
retMod.retmsg = "验证码不正确";
return(retMod.ToString());
}
}
M_UserInfo mu = LoginByRegID(ref err, uname, upwd, regid);
if (mu.IsNull)
{
UserLoginCount++; retMod.retmsg = err; if (UserLoginCount >= 3)
{
retMod.addon = "showvcode";
}
}
else if (mu.Status != 0)
{
retMod.retmsg = "你的帐户未通过验证或被锁定，请与网站管理员联系";
}
else
{
UserLoginCount = 0;
retMod.retcode = M_APIResult.Success;
buser.SetLoginState(mu, "Month");
}
return(retMod.ToString());
}
public void RepToClient(M_APIResult result)
{
result.action = Action;
HttpResponse rep = HttpContext.Current.Response;
rep.Clear(); rep.Write(result.ToString()); rep.Flush(); rep.End();
}
public IActionResult DBScript()
{
//type source name uname passwd
M_APIResult retMod = new M_APIResult(Failed);
try
{
string connStr = GetConnstr();
DBCenter.DB = SqlBase.CreateHelper("mssql");
DBCenter.DB.ConnectionString = SiteConfig.SiteInfo.ConnectionString = connStr;
if (!DataConvert.CBool(GetParam("ignoreSql")))
{
string sqlPath = function.VToP("/App_Data/Data.sql");
DBHelper.ExecuteSqlScript(GetConnstr(), sqlPath);
}
SiteConfig.Update();
retMod.retcode = M_APIResult.Success;
}
catch (Exception ex)
{
retMod.retmsg = ex.Message;
ZLLog.L("安装时出错,原因:" + ex.Message);
}
return(Content(retMod.ToString()));
}
public string Register_API()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Success);
string action = Request["action"];
string value = (Request.Form["value"] ?? "").Replace(" ", "");
string result = "";
switch (action)
{
case "uname":
if (!CheckUserName(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "puser": //推荐人为空则不检测
if (!string.IsNullOrEmpty(value) && CheckParentUser(value).IsNull)
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = "推荐人不存在";
}
break;
case "email":
if (!CheckEmail(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "invite":
if (!CheckInvitCode(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "birth":
if (!CheckBirthDay(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
//case "GetModelFied":
// result = GetUserGorupModel(value);
// break;
default:
retMod.retmsg = "[" + action + "]接口不存在";
break;
}
return(retMod.ToString());
}
//------------------------------官方示例,用于验证签名
//string appid = "wx2421b1c4370ec43b";
//string secret = "";
//static string nonceStr = "1add1a30ac87aa2db72f57a2375d8fec";
//string partnerid = "10000100";//商户号
//string timestr = "1415659990";
//string ip = "14.23.150.211";
//string notifyUrl = "http://wxpay.weixin.qq.com/pub_v2/pay/notify.v2.php";
protected void Page_Load(object sender, EventArgs e)
{
M_APIResult retMod = new M_APIResult();
retMod.retcode = M_APIResult.Failed;
retMod.callback = Request["callback"];
TimeSpan ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0);
timestr = Convert.ToInt64(ts.TotalSeconds).ToString();
//------------统一下单,获取预付单号
WxPayData wxdata = new WxPayData(PlatConfig.WXPay_Key);
wxdata.SetValue("appid", PlatConfig.WXPay_APPID);
wxdata.SetValue("attach", "attach"); //test
wxdata.SetValue("body", "pay"); //不允许为空,中文需要单独处理
wxdata.SetValue("mch_id", PlatConfig.WXPay_MCHID);
wxdata.SetValue("nonce_str", nonceStr);
wxdata.SetValue("notify_url", notifyUrl);
wxdata.SetValue("out_trade_no", timestr); //支付单号
wxdata.SetValue("spbill_create_ip", ip); //Can be empty
wxdata.SetValue("total_fee", 1); //(payMod.MoneyReal * 100).ToString("f0")
wxdata.SetValue("trade_type", "APP");
WxPayData result = UnifiedOrder(wxdata);
//if (result.GetValue("return_code") != "SUCCESS") { retMod.retmsg = result.GetValue("return_msg").ToString(); RepToClient(retMod); }
//------------生成返回给APP端的数据
timestr = Convert.ToInt64(ts.TotalSeconds).ToString();
WxPayData appdata = new WxPayData(PlatConfig.WXPay_Key);
appdata.SetValue("appid", PlatConfig.WXPay_APPID);
appdata.SetValue("partnerid", PlatConfig.WXPay_MCHID);
appdata.SetValue("package", "Sign=WXPay");
appdata.SetValue("noncestr", nonceStr);
appdata.SetValue("timestamp", timestr);
appdata.SetValue("prepayid", result.GetValue("prepay_id").ToString());
appdata.SetValue("sign", appdata.MakeSign());
retMod.result = "{\"appid\":\"" + PlatConfig.WXPay_APPID + "\",\"partnerid\":\"" + PlatConfig.WXPay_MCHID + "\",\"package\":\"Sign=WXPay\",\"noncestr\":\"" + nonceStr + "\",\"timestamp\":" + timestr + ",\"prepayid\":\"" + result.GetValue("prepay_id").ToString() + "\",\"sign\":\"" + appdata.GetValue("sign") + "\"}";
retMod.retcode = M_APIResult.Success;
ZLLog.L("生成微信预付单完成" + retMod.result);
RepToClient(retMod);
//正确返回
//<xml><return_code><![CDATA[SUCCESS]]></return_code>
//<return_msg><![CDATA[OK]]></return_msg>
//<appid><![CDATA[wxe4703a7618738bed]]></appid>
//<mch_id><![CDATA[1342097701]]></mch_id>
//<nonce_str><![CDATA[LYJFMZbGIaa2LezS]]></nonce_str>
//<sign><![CDATA[440C7616B9658FD7102805895E6808CC]]></sign>
//<result_code><![CDATA[SUCCESS]]></result_code>
//<prepay_id><![CDATA[wx201605160903248f02bc5ab10976835276]]></prepay_id>
//<trade_type><![CDATA[APP]]></trade_type>
//</xml>
//转成Json回发给APP
//{"appid":"wxb4ba3c02aa476ea1","partnerid":"1305176001","package":"Sign=WXPay","noncestr":"717cbf90679a1f26d6b8211efaed3ffb","timestamp":1463394698,"prepayid":"wx20160516183138c3ac06576e0471509227","sign":"414C383FA311DAC74DC882BA89A5E296"}
}
protected void Page_Load(object sender, EventArgs e)
{
if (function.isAjax())
{
M_APIResult result = new M_APIResult();
result.retcode = M_APIResult.Failed;
WxAPI api = WxAPI.Code_Get(AppId);
string action = Request["action"];
//result.result = api.AccessToken;
//RepToClient(result);
try
{
switch (action)
{
case "create":
string jsondata = "{\"button\":" + Request.Form["menus"] + "}";
result.result = api.CreateWxMenu(jsondata);
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
case "get":
result.result = api.GetWxMenu();
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
default:
result.retmsg = "接口[" + action + "]不存在";
break;
}
}
catch (Exception ex) { result.retmsg = ex.Message; }
RepToClient(result);
}
if (!IsPostBack)
{
M_WX_APPID appmod = appbll.SelReturnModel(AppId);
string alias = " [公众号:" + appmod.Alias + "]";
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='" + CustomerPageAction.customPath2 + "WeiXin/WxAppManage.aspx'>公众号管理</a></li><li class='active'>自定义菜单" + alias + "</li>");
}
}
public string ShopNode_API()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Success);
int nid = DataConvert.CLng(Request["nid"]);
//DataTable dt = DBCenter.SelWithField("ZL_Node", "NodeID,NodeName", "ParentID=" + nid);
DataTable dt = nodeBll.GetNodeListUserShop(nid);
dt = dt.DefaultView.ToTable(false, "NodeID", "NodeName");
retMod.result = JsonConvert.SerializeObject(dt);
return(retMod.ToString());
}
public IActionResult Default()
{
if (!adminMod.IsSuperAdmin())
{
return(WriteErr("无权访问该功能"));
}
if (Request.IsAjax())
{
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
string action = GetParam("action");
string tbname = GetParam("tbname").Trim();
string fdname = GetParam("fdname").Trim();
try
{
switch (action)
{
case "field_update":
{
int len = DataConvert.CLng(GetParam("len"));
string type = GetParam("type").Replace(" ", "").ToLower();
if (string.IsNullOrEmpty(type) || len < 1)
{
retMod.retmsg = "字段类型或数值不正确";
}
else
{
string sql = "ALTER TABLE [" + tbname + "] ALTER Column [" + fdname + "][" + type + "]";
string[] ignore = new string[] { "int", "money", "decimal", "float", "datetime", "date", "timestamp" };
if (!ignore.Contains(type))
{
sql += "(" + len + ")";
}
DBCenter.DB.ExecuteNonQuery(new SqlModel(sql, null));
retMod.retcode = M_APIResult.Success;
}
}
break;
default:
{
retMod.retmsg = "[" + action + "]未命中";
}
break;
}
}
catch (Exception ex) { retMod.retmsg = ex.Message; }
return(Content(retMod.ToString()));
}
else
{
return(View());
}
}
public IActionResult EditWxMenu()
{
try { api = WxAPI.Code_Get(AppId); } catch (Exception ex) { return(WriteErr("微信公众号配置不正确," + ex.Message)); }
if (Request.IsAjax())
{
M_APIResult result = new M_APIResult();
result.retcode = M_APIResult.Failed;
WxAPI api = WxAPI.Code_Get(AppId);
string action = GetParam("action");
//result.result = api.AccessToken;
//RepToClient(result);
try
{
switch (action)
{
case "create":
string jsondata = "{\"button\":" + Request.Form["menus"] + "}";
result.result = api.CreateWxMenu(jsondata);
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
case "get":
result.result = api.GetWxMenu();
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
default:
result.retmsg = "接口[" + action + "]不存在";
break;
}
}
catch (Exception ex) { result.retmsg = ex.Message; }
return(Content(result.ToString()));
}
else
{
return(View(viewDir + "EditWxMenu.cshtml"));
}
}
public string Content_WordApi(int gid, string op)
{
M_CommonData conMod = contentBll.SelReturnModel(gid);
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
if (conMod == null || conMod.GeneralID < 1)
{
retMod.result = "内容[" + gid + "]不存在"; return(retMod.ToString());
}
switch (op)
{
case "create":
{
string pdfdir = "";
if (string.IsNullOrEmpty(conMod.Rtype))
{
conMod.Rtype = ZLHelper.GetUploadDir_System("Content", "Word") + conMod.GeneralID + ".docx";
}
pdfdir = Path.GetDirectoryName(Server.MapPath(conMod.Rtype));
if (!Directory.Exists(pdfdir))
{
Directory.CreateDirectory(pdfdir);
}
//------------------------
string html = GetContentHtml(conMod);
OfficeHelper.W_HtmlToWord(html, conMod.Rtype);
contentBll.UpdateByID(conMod);
retMod.result = conMod.Rtype;
retMod.retcode = M_APIResult.Success;
}
break;
case "del":
if (!string.IsNullOrEmpty(conMod.Rtype))
{
if (System.IO.File.Exists(Server.MapPath(conMod.Rtype)))
{
System.IO.File.Delete(Server.MapPath(conMod.Rtype));
}
conMod.Rtype = "";
contentBll.UpdateByID(conMod);
retMod.retcode = M_APIResult.Success;
}
break;
default:
retMod.retmsg = "[" + op + "]不存在";
break;
}
return(retMod.ToString());
}
public IActionResult CSSManage()
{
if (Request.IsAjax())
{
M_APIResult ret = new M_APIResult(M_APIResult.Failed);
B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.system, "tlp");
try
{
string action = GetParam("action");
string vpath = Request.Form["vpath"];
if (string.IsNullOrEmpty(vpath))
{
throw new Exception("未指定文件");
}
switch (action)
{
case "del":
{
SafeSC.DelFile(CSSBaseDir + vpath);
ret.retcode = M_APIResult.Success;
}
break;
case "copy":
{
string src = function.VToP(CSSBaseDir + vpath);
string tar = function.VToP((CSSBaseDir + vpath).Replace(".", "_" + function.GetRandomString(3) + "."));
IOHelper.File_Copy(src, tar);
ret.retcode = M_APIResult.Success;
}
break;
case "down":
{
}
break;
default:
ret.retmsg = "[" + action + "]不存在";
break;
}
}
catch (Exception ex) { ret.retmsg = ex.Message; }
return(Content(ret.ToString()));
}
ViewBag.BaseDir = CSSBaseDir;
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
B_Admin.CheckIsLogged(Request.RawUrl);
if (!IsPostBack)
{
if (function.isAjax())
{
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
string action = (Request["action"] ?? "").ToLower();
switch (Request["action"])
{
case "save":
{
string layouts = Request.Form["layouts"];
pageMod = pageBll.SelReturnModel(Mid);
pageMod.Layouts = layouts;
pageBll.UpdateByID(pageMod);
retMod.retcode = M_APIResult.Success;
}
break;
default:
retMod.retmsg = "[" + action + "]不存在";
break;
}
Response.Clear(); Response.Write(retMod.ToString()); Response.Flush(); Response.End();
}
switch (Request["action"])
{
case "new":
{
pageMod = new M_SPage_Page();
pageMod.PageName = "新页面";
pageMod.ID = pageBll.Insert(pageMod);
Response.Redirect("default.aspx?ID=" + pageMod.ID);
}
break;
default:
break;
}
pageMod = pageBll.SelReturnModel(Mid);
if (pageMod == null)
{
function.WriteErrMsg("页面不存在");
}
}
}
public string Register_MobileCheck()
{
M_APIResult retMod = new M_APIResult(Failed);
string mobile = RequestEx["mobile"];
string code = RequestEx["code"];
CommonReturn ret = B_Safe_Mobile.CheckVaildCode(mobile, code, "register");
if (ret.isok)
{
RegisterMobile = mobile;
retMod.retcode = M_APIResult.Success;
}
else
{
retMod.retmsg = ret.err;
}
return(retMod.ToString());
}
public string UserSign_Add()
{
M_APIResult retMod = new M_APIResult(Failed);
M_User_Signin sinMod = new M_User_Signin();
if (!sinBll.IsSignToday(mu.UserID))
{
sinMod.CreateTime = DateTime.Now;
sinMod.UserID = mu.UserID;
sinMod.Status = 1;
sinMod.Remind = mu.UserName + "签到";
sinBll.Insert(sinMod);
retMod.retcode = M_APIResult.Success;
}
else
{
retMod.retmsg = "你已经签过到了";
}
return(retMod.ToString());
}
//保存字段排序
public string Order_Submit()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
string[] ordervalues = DataConvert.CStr(RequestEx["Order_Hid"]).Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string value in ordervalues)
{
if (string.IsNullOrWhiteSpace(value.Split('|')[0]))
{
continue;
}
int fid = Convert.ToInt32(value.Split('|')[0]);
int orderid = Convert.ToInt32(value.Split('|')[1]);
M_ModelField modfield = fieldBll.GetModelByID(Mid.ToString(), fid);
modfield.OrderID = orderid;
fieldBll.UpdateOrder(modfield);
}
retMod.retcode = M_APIResult.Success;
return(retMod.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (function.isAjax())
{
string action = Request["action"];
M_APIResult retMod = new M_APIResult();
retMod.retcode = M_APIResult.Failed;
switch (action)
{
case "del":
regionMod = regionBll.SelModelByGuid(Guid);
regionBll.P_Remove(regionMod, Region);
retMod.retcode = regionBll.UpdateByID(regionMod) ? M_APIResult.Success : M_APIResult.Failed;
break;
}
Response.Write(retMod.ToString()); Response.Flush(); Response.End();
}
if (!IsPostBack)
{
MyBind();
Call.HideBread(Master);
}
}
//自有账号登录(跳转页面)
public string Login_Ajax(string uname, string upwd, string vcode, int regid)
{
string id = HttpContext.Session.Id;
string err = "";
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
string openVCode = SiteConfig.UserConfig.EnableCheckCodeOfLogin;
if ((openVCode == "0" && UserLoginCount >= 3) || openVCode == "1")
{
if (!VerifyHelper.Check(RequestEx["VCode_hid"]))
{
retMod.retmsg = "验证码不正确";
return(retMod.ToString());
}
}
//upwd = RSAHelper.RsaDecrypt(upwd, SafeSC.ReadFileStr("/config/safe/PrivateKey.config"));
M_UserInfo mu = LoginByRegID(ref err, uname, upwd, regid);
if (mu.IsNull)
{
UserLoginCount++; retMod.retmsg = err; if (openVCode == "0" && UserLoginCount >= 3)
{
retMod.addon = "showvcode";
}
}
else if (mu.Status != 0)
{
retMod.retmsg = "你的帐户未通过验证或被锁定，请与网站管理员联系";
}
else
{
UserLoginCount = 0;
retMod.retcode = M_APIResult.Success;
buser.SetLoginState(mu, "Month");
}
return(retMod.ToString());
}
private void RepToClient(M_APIResult result)
{
Response.Write(result.ToString()); Response.Flush(); Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
M_APIResult retMod = new M_APIResult();
retMod.retcode = M_APIResult.Failed;
retMod.callback = Request["callback"];
if (string.IsNullOrEmpty(PayNo) || string.IsNullOrEmpty(OpenID))
{
retMod.retmsg = "0x53,支付单号或OpenID为空"; RepToClient(retMod);
}
try
{
M_UserInfo mu = B_User_API.GetLogin(OpenID);
M_Payment payMod = payBll.SelModelByPayNo(PayNo);
if (mu == null)
{
retMod.retmsg = "0x59,用户未登录,或登录已失效";
}
else if (payMod == null)
{
retMod.retmsg = "0x82,支付单号不存在";
}
else if (payMod.Status != (int)M_Payment.PayStatus.NoPay)
{
retMod.retmsg = "0x14,支付单已付过款,不能重复支付";
}
else if (payMod.MoneyReal <= 0)
{
retMod.retmsg = "0x56,支付单金额异常";
}
//else if (payMod.UserID != mu.UserID) { retMod.retmsg = "x058,该支付单并非你所有"; }
else
{
//*不要看程序内部的报错,直接看Repsonse返回,其才是真正的报错
TimeSpan ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0);
timestr = Convert.ToInt64(ts.TotalSeconds).ToString();
//------------统一下单,获取预付单号
WxPayData wxdata = new WxPayData(PlatConfig.WXPay_Key);
wxdata.SetValue("appid", PlatConfig.WXPay_APPID);
wxdata.SetValue("attach", "attach"); //test
wxdata.SetValue("body", "pay"); //不允许为空,中文需要单独处理
wxdata.SetValue("mch_id", PlatConfig.WXPay_MCHID);
wxdata.SetValue("nonce_str", nonceStr);
wxdata.SetValue("notify_url", notifyUrl);
wxdata.SetValue("out_trade_no", PayNo); //支付单号
wxdata.SetValue("spbill_create_ip", ip); //Can be empty
wxdata.SetValue("total_fee", (payMod.MoneyReal * 100).ToString("f0")); //(payMod.MoneyReal * 100).ToString("f0")
wxdata.SetValue("trade_type", "APP");
WxPayData result = UnifiedOrder(wxdata);
//if (result.GetValue("return_code") != "SUCCESS") { retMod.retmsg = result.GetValue("return_msg").ToString(); RepToClient(retMod); }
//------------生成返回给APP端的数据
timestr = Convert.ToInt64(ts.TotalSeconds).ToString();
WxPayData appdata = new WxPayData(PlatConfig.WXPay_Key);
appdata.SetValue("appid", PlatConfig.WXPay_APPID);
appdata.SetValue("partnerid", PlatConfig.WXPay_MCHID);
appdata.SetValue("package", "Sign=WXPay");
appdata.SetValue("noncestr", nonceStr);
appdata.SetValue("timestamp", timestr);
appdata.SetValue("prepayid", result.GetValue("prepay_id").ToString());
appdata.SetValue("sign", appdata.MakeSign());
retMod.result = "{\"appid\":\"" + PlatConfig.WXPay_APPID + "\",\"partnerid\":\"" + PlatConfig.WXPay_MCHID + "\",\"package\":\"Sign=WXPay\",\"noncestr\":\"" + nonceStr + "\",\"timestamp\":" + timestr + ",\"prepayid\":\"" + result.GetValue("prepay_id").ToString() + "\",\"sign\":\"" + appdata.GetValue("sign") + "\"}";
retMod.retcode = M_APIResult.Success;
ZLLog.L("生成微信预付单完成" + retMod.result);
payBll.UpdatePlat(payMod.PaymentID, M_PayPlat.Plat.WXPay, appMod.ID.ToString());
}
}
catch (Exception ex) { retMod.retcode = M_APIResult.Failed; retMod.retmsg = "server exception:" + ex.Message; ZLLog.L("微信预付单报错" + retMod.retmsg); }
RepToClient(retMod);
//正确返回
//<xml><return_code><![CDATA[SUCCESS]]></return_code>
//<return_msg><![CDATA[OK]]></return_msg>
//<appid><![CDATA[wxe4703a7618738bed]]></appid>
//<mch_id><![CDATA[1342097701]]></mch_id>
//<nonce_str><![CDATA[LYJFMZbGIaa2LezS]]></nonce_str>
//<sign><![CDATA[440C7616B9658FD7102805895E6808CC]]></sign>
//<result_code><![CDATA[SUCCESS]]></result_code>
//<prepay_id><![CDATA[wx201605160903248f02bc5ab10976835276]]></prepay_id>
//<trade_type><![CDATA[APP]]></trade_type>
//</xml>
//转成Json回发给APP
//{"appid":"wxb4ba3c02aa476ea1","partnerid":"1305176001","package":"Sign=WXPay","noncestr":"717cbf90679a1f26d6b8211efaed3ffb","timestamp":1463394698,"prepayid":"wx20160516183138c3ac06576e0471509227","sign":"414C383FA311DAC74DC882BA89A5E296"}
}
public ContentResult OrderCom()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Failed);
switch (action)
{
case "cart_del":
{
cartBll.DelByIDS(CartCookID, buser.GetLogin().UserName, ids);
retMod.retcode = M_APIResult.Success;
}
break;
case "setnum": //兼容
case "cart_setnum": //ID,数量,Cookies,可不登录,数量不能小于1
{
int id = DataConverter.CLng(GetParam("id"));
int pronum = DataConverter.CLng(GetParam("pronum"));
if (id < 1 || pronum < 1)
{
retMod.retmsg = "商品ID与数量不能小于1";
}
else if (string.IsNullOrEmpty(CartCookID))
{
retMod.retmsg = "CartCookID不存在";
}
else
{
cartBll.UpdateProNum(CartCookID, mu.UserID, id, pronum);
retMod.retcode = M_APIResult.Success;
}
}
break;
case "deladdress":
{
int id = DataConverter.CLng(GetParam("id"));
if (mu == null || mu.UserID == 0 || id < 1)
{
return(Content(Failed.ToString()));
}
else
{
receBll.U_DelByID(id, mu.UserID); return(Content(Success.ToString()));
}
}
case "arrive":
{
string flow = GetParam("flow");
double money = double.Parse(GetParam("money"));
DataTable cartdt = cartBll.SelByCartID(CartCookID, mu.UserID, -100, ids);
if (cartdt.Rows.Count < 1)
{
retMod.retmsg = "购物车为空"; return(Content(retMod.ToString()));
}
M_Arrive avMod = avBll.SelModelByFlow(flow, mu.UserID);
M_Arrive_Result arrMod = avBll.U_CheckArrive(avMod, mu.UserID, cartdt, money);
if (arrMod.enabled)
{
retMod.retcode = M_APIResult.Success;
//已优惠金额,优惠后金额
retMod.result = Newtonsoft.Json.JsonConvert.SerializeObject(arrMod);
}
else
{
retMod.retmsg = arrMod.err;
}
}
break;
default:
retMod.retmsg = "[" + action + "]接口不存在";
break;
}
return(Content(retMod.ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
try { api = WxAPI.Code_Get(AppId); } catch (Exception ex) { function.WriteErrMsg("微信公众号配置不正确," + ex.Message); }
if (function.isAjax())
{
M_APIResult result = new M_APIResult();
result.retcode = M_APIResult.Failed;
WxAPI api = WxAPI.Code_Get(AppId);
string action = Request["action"];
//result.result = api.AccessToken;
//RepToClient(result);
try
{
switch (action)
{
case "create":
string jsondata = "{\"button\":" + Request.Form["menus"] + "}";
result.result = api.CreateWxMenu(jsondata);
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
case "get":
result.result = api.GetWxMenu();
if (!result.result.Contains("errmsg"))
{
result.retcode = M_APIResult.Success;
}
else
{
result.retmsg = result.result;
}
break;
default:
result.retmsg = "接口[" + action + "]不存在";
break;
}
}
catch (Exception ex) { result.retmsg = ex.Message; }
RepToClient(result);
}
if (!IsPostBack)
{
B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.portable, "wechat");
M_WX_APPID appmod = appbll.SelReturnModel(AppId);
string alias = " [公众号:" + appmod.Alias + "]";
string bread = "";
//检测是否关联了店铺
DataTable dt = DBCenter.Sel("ZL_CommonModel", "SpecialID IS NOT NULL AND SpecialID='" + appmod.ID + "'");
if (dt.Rows.Count < 1)
{
bread += "<span style='color:orange;'>(尚未绑定店铺)</span>";
}
else if (dt.Rows.Count == 1)
{
StoreId = DataConvert.CLng(dt.Rows[0]["GeneralID"]);
bread += "<span><a href='javascript:;' onclick='wxmenu.initMenu();' class='btn btn-info btn-xs'>初始化菜单(" + dt.Rows[0]["Title"] + ")</a></span>";
}
else if (dt.Rows.Count > 1)
{
StoreId = DataConvert.CLng(dt.Rows[0]["GeneralID"]);
bread += "<span><a href='javascript:;' onclick='wxmenu.initMenu();' class='btn btn-info btn-xs'>初始化菜单<span class='color:orange;'>(绑定了多个店铺)</span></a></span>";
}
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='" + CustomerPageAction.customPath2 + "WeiXin/WxAppManage.aspx'>公众号管理</a></li><li class='active'>自定义菜单" + alias + " " + bread + "</li>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request["action"];
M_APIResult result = new M_APIResult()
{
retcode = M_APIResult.Success,
action = action
};
M_UserInfo mu = buser.GetLogin();
switch (action)
{
case "msg_list":
{
int stepid = DataConvert.CLng(Request["ID"]);
int psize = DataConvert.CLng(Request["psize"]); if (psize < 1)
{
psize = 10;
}
PageSetting setting = SelPage(PageCommon.GetCPage(), psize, stepid, 0);
result.result = JsonConvert.SerializeObject(setting.dt);
result.addon = setting.itemCount.ToString();
}
break;
case "msg_add":
{
M_Pro_Msg msgMod = new M_Pro_Msg();
msgMod.CUser = mu.UserID;
msgMod.CUName = mu.UserName;
msgMod.Content = Request["Content"];
msgMod.StepID = DataConvert.CLng(Request["ID"]);
msgMod.ReplyMsgID = DataConvert.CLng(Request["rid"]);
if (msgMod.ReplyMsgID > 0)
{
M_Pro_Msg rpyMod = msgBll.SelReturnModel(msgMod.ReplyMsgID);
msgMod.RCUser = rpyMod.CUser;
msgMod.RCUName = rpyMod.CUName;
}
msgMod.ID = msgBll.Insert(msgMod);
PageSetting setting = SelPage(1, 1, 0, msgMod.ID);
result.result = JsonConvert.SerializeObject(setting.dt);
}
break;
case "msg_del":
{
}
break;
case "complete": //获取完成度
{
int proid = DataConvert.CLng(Request["proid"]);
result.result = progBll.GetComplete(proid).ToString();
}
break;
default:
throw new Exception(action + ",不在请求列表");
}
RepToClient(result);
}
public void RepToClient(M_APIResult result)
{
Response.Clear(); Response.Write(JsonConvert.SerializeObject(result)); Response.Flush(); Response.End();
}
public string Register_API()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Success);
string action = GetParam("action");
string value = GetParam("value").Replace(" ", "");
string result = "";
switch (action)
{
case "uname":
if (!CheckUserName(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "mobile": //手机号不可重复
{
string mobile = GetParam("mobile");
if (string.IsNullOrEmpty(mobile))
{
retMod.retmsg = "手机号码不能为空";
}
else if (!RegexHelper.IsMobilPhone(mobile))
{
retMod.retmsg = "手机号码格式不正确";
}
else
{
bool flag = DBCenter.IsExist("ZL_UserBase", "Mobile=@mobile",
new List <SqlParameter>()
{
new SqlParameter("mobile", mobile)
});
if (flag)
{
retMod.retmsg = "手机号码已存在";
}
else
{
retMod.retcode = M_APIResult.Success;
}
}
}
break;
case "puser": //推荐人为空则不检测
if (!string.IsNullOrEmpty(value) && CheckParentUser(value).IsNull)
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = "推荐人不存在";
}
break;
case "email":
if (!CheckEmail(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "birth":
if (!CheckBirthDay(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "GetModelFied":
return(GetUserGorupModel(value));
default:
retMod.retmsg = "[" + action + "]接口不存在";
break;
}
return(retMod.ToString());
}
//统一状态码 -1:失败,99:成功
//以下都限制为只能获取用户所在的公司
public void ProcessRequest(HttpContext context)
{
M_APIResult retMod = new M_APIResult();
retMod.retcode = M_APIResult.Failed;
M_User_Plat upMod = null;
string value = context.Request.Form["value"];
string result = "";
switch (Action)
{
case "plat_compuser": //获取公司中成员,用于@功能
{
upMod = B_User_Plat.GetLogin();
DataTable dt = upBll.SelByCompWithAT(upMod.CompID);
result = JsonHelper.JsonSerialDataTable(dt);
OldRep(result);
}
break;
case "getuinfo": //获取单个用户信息(只允许获取本公司),返回的信息存入Json,避免重复检测,后期将服务端也缓存化
{
upMod = B_User_Plat.GetLogin();
int uid = Convert.ToInt32(value);
M_User_Plat model = upBll.SelReturnModel(uid, upMod.CompID);
if (model != null)
{
result = "{\"id\":\"" + model.UserID + "\",\"UserID\":\"" + model.UserID + "\",\"UserName\":\"" + model.TrueName + "\",\"Mobile\":\"" + model.Mobile + "\",\"GroupName\":\"" + model.GroupName.Trim(',') + "\",\"UserFace\":\"" + model.UserFace + "\"}";
}
OldRep(result);
}
break;
case "getnotify": //获取提醒
{
B_Notify notBll = new B_Notify();
if (B_Notify.NotifyList.Count < 1)
{
retMod.retmsg = "none";
}
else
{
notBll.RemoveExpire(); //去除超时的
M_UserInfo mu = new B_User().GetLogin();
List <M_Notify> list = notBll.GetNotfiyByUid(mu.UserID);
DataTable retdt = new DataTable();
retdt.Columns.Add(new DataColumn("title", typeof(string)));
retdt.Columns.Add(new DataColumn("content", typeof(string)));
retdt.Columns.Add(new DataColumn("cuname", typeof(string)));
if (list.Count > 0)
{
foreach (M_Notify model in list) //有多个就发多条
{
notBll.AddReader(model, mu.UserID);
DataRow dr = retdt.NewRow();
dr["title"] = model.Title;
dr["content"] = model.Content;
dr["cuname"] = model.CUName;
retdt.Rows.Add(dr);
}
}
retMod.retcode = M_APIResult.Success;
retMod.result = JsonConvert.SerializeObject(retdt);
}
RepToClient(retMod);
}
break;
case "newblog": //自己公司有无新的信息
{
upMod = B_User_Plat.GetLogin();
result = msgBll.SelByDateForNotify(Req("date"), upMod).ToString();
OldRep(result);
}
break;
case "privatesend": //私信功能,走邮件模块
{
upMod = B_User_Plat.GetLogin();
if (upMod != null)
{
string msg = context.Request.Form["msg"];
string receuser = context.Request.Form["receuser"];
if (!string.IsNullOrWhiteSpace(msg) && !string.IsNullOrWhiteSpace(receuser) && SafeSC.CheckIDS(receuser))
{
//过滤非用户公司的同事,后期处理
M_Message msgMod = new M_Message();
B_Message msgBll = new B_Message();
msgMod.Incept = receuser;
msgMod.Sender = upMod.UserID.ToString();
msgMod.Title = upMod.TrueName + "的私信";
msgMod.PostDate = DateTime.Now;
msgMod.Content = msg;
msgMod.Savedata = 0;
msgMod.Receipt = "";
msgMod.CCUser = "";
msgMod.Attachment = "";
msgBll.GetInsert(msgMod);
result = "99";
//添加一条新提醒
B_Notify.AddNotify(upMod.UserName, "你收到一封私信", msgMod.Title, msgMod.Incept);
}
else
{
result = "-1";
}
}
else
{
result = "0";
} //未登录
OldRep(result);
break;
}
case "addread": //阅读量统计
{
string ids = context.Request.Form["ids"];
msgBll.AddRead(ids.Trim(','));
OldRep("1");
}
break;
}
}
private void RepToClient(M_APIResult retMod)
{
Response.Clear(); Response.Write(retMod.ToString()); Response.Flush(); Response.End();
}
public IActionResult Final()
{
M_APIResult retMod = new M_APIResult(Failed);
B_User buser = new B_User();
try
{
string adminPwd = GetParam("adminPwd").Replace(" ", "");
string adminPwd2 = GetParam("adminPwd2").Replace(" ", "");
if (string.IsNullOrEmpty(adminPwd))
{
throw new Exception("管理员密码不能为空");
}
if (!adminPwd.Equals(adminPwd2))
{
throw new Exception("管理员确认密码不匹配");
}
if (adminPwd.Length < 6)
{
throw new Exception("管理员密码过短");
}
SiteConfig.SiteInfo.SiteTitle = GetParam("siteTitle");
SiteConfig.SiteInfo.SiteName = GetParam("siteName");
SiteConfig.SiteInfo.SiteUrl = GetParam("siteUrl");
SiteConfig.SiteInfo.WebmasterEmail = GetParam("email");
SiteConfig.SiteOption.SiteManageCode = "888888";
SiteConfig.SiteInfo.IsInstalled = true;
SiteConfig.Update();
//----------------------------------------------------
M_AdminInfo adminMod = new M_AdminInfo()
{
AdminName = "admin",
AdminPassword = adminPwd
};
//---添加用户
M_UserInfo muser = buser.GetUserByName("admin");
if (muser.IsNull)
{
muser = new M_UserInfo()
{
UserName = "******"
};
muser.UserPwd = StringHelper.MD5(adminMod.AdminPassword);
muser.RegTime = DateTime.Now;
muser.RegTime = DateTime.Now;
muser.LastLockTime = DateTime.Now;
muser.LastLoginTimes = DateTime.Now;
muser.LastPwdChangeTime = DateTime.Now;
muser.Email = GetParam("email");
muser.Question = "admin";
muser.Answer = function.GetRandomString(8);
muser.GroupID = 1;
muser.UserRole = ",1,";
muser.SiteID = 1;
muser.VIP = 0;
muser.LastLoginIP = IPScaner.GetUserIP(HttpContext);
muser.CheckNum = function.GetRandomString(6);
muser.UserID = buser.Add(muser);
}
adminMod.AddUserID = muser.UserID;
//存在则更新
ZoomLa.BLL.Install.Add(adminMod);
retMod.retcode = M_APIResult.Success;
}
catch (Exception ex) { retMod.retmsg = ex.Message; }
return(Content(retMod.ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Pid <= 0)
{
function.WriteErrMsg("参数错误!不存在此信息!");
}
M_Pub mpub = pubBll.GetSelect(Pid);
mu = buser.GetLogin();
if (mpub == null || mpub.Pubid < 1)
{
function.WriteErrMsg("互动信息不存在");
}
M_APIResult retMod = new M_APIResult();
int spid = DataConvert.CLng(Request.Form["spfbrid"]);
if (mu.UserID < 1)
{
retMod.retmsg = "未登录不可提交订单"; RepToClient(retMod.ToString()); return;
}
if (spid < 1)
{
retMod.retmsg = "未指定教师信息"; RepToClient(retMod.ToString()); return;
}
{
//如果存在与该老师的进行中订单,则忽略
string where = "xsrid=" + mu.UserID + " AND spfbrid=" + spid;
where += " AND status_order>=0 AND status_order<100";
if (DBCenter.IsExist("ZL_Pub_dsmx", where))
{
retMod.retmsg = "已存在生效中的订单";
RepToClient(retMod.ToString());
return;
}
}
M_UserInfo spmu = buser.SelReturnModel(spid);
if (spmu.IsNull)
{
retMod.retmsg = "老师信息不存在"; RepToClient(retMod.ToString()); return;
}
//-----------------------获取用户提交的数据
//隐藏字段值
int PubContentid = DataConverter.CLng(Request.Form["PubContentid"]);
int Parentid = DataConvert.CLng(Request.Form["Parentid"]);
//用户提交
string pbtitle = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubTitle"]));
string pbcontent = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubContent"]));
if (!pbtitle.Contains("的"))//xxx的课程
{
pbtitle = B_User.GetUserName(spmu.HoneyName, spmu.UserName) + "的课程";
}
//-----------------------可提交判断
List <SqlParameter> sp = new List <SqlParameter>();
//-----------------------初始化参数
//删除超过保留期限的值
//pubBll.DeleteModel(mpub.PubTableName, "DateDiff(d,PubAddTime,getdate())>" + mpub.Pubkeep);
//ModelField表中仅存了自定义的字段
B_CodeModel codeBll = new B_CodeModel(mpub.PubTableName);
DataRow dr = codeBll.NewModel();
DataTable mfDT = mfBll.DB_SelByModel(mpub.PubModelID);
mfDT.DefaultView.RowFilter = "sys_type=0";
mfDT = mfDT.DefaultView.ToTable();
//-----固定的系统字段
dr["Pubnum"] = 1;
dr["PubIP"] = EnviorHelper.GetUserIP();
dr["PubUserID"] = mu.UserID;
dr["PubUserName"] = mu.UserName;
dr["Pubupid"] = mpub.Pubid;
dr["PubAddTime"] = DateTime.Now;
dr["Parentid"] = Parentid;
dr["PubTitle"] = pbtitle;
dr["PubContent"] = pbcontent;
dr["Pubstart"] = mpub.PubIsTrue == 1 ? 0 : 1;//取反
dr["PubInputer"] = B_User.GetUserName(mu.HoneyName, mu.UserName);
dr["PubContentid"] = PubContentid;
//dr["cookflag"] = CookFlag;
//=========订单初始化
dr["status_order"] = 0;
dr["status_user"] = 0;
dr["status_teacher"] = 0;
dr["status_money"] = 0;
dr["edate"] = "";
dr["fcAmount"] = 0;
dr["fcDate"] = "";
//int djid = DataConvert.CLng(mu.ParentUserID);
//if (djid < 1) { djid = DataConvert.CLng(Request["djid"]); }
dr["djid"] = DataConvert.CLng(Request["djid"]);
//------非系统字段
for (int i = 0; i < mfDT.Rows.Count; i++)
{
M_ModelField mfMod = new M_ModelField().GetModelFromReader(mfDT.Rows[i]);
string value = Server.HtmlEncode(Request.Form[mfMod.FieldName] ?? "");
Parentid = DataConvert.CLng(Request.Form["Parentid"]);
if (mfMod.IsNotNull && string.IsNullOrEmpty(value))
{
RepToClient(mfMod.FieldName + "不能为空");
}
dr[mfMod.FieldName] = value;
switch (mpub.PubType)
{
#region 根据互动类型,进行空值判断
case 0:
if (string.IsNullOrEmpty(pbcontent))
{
RepToClient("评论内容不能为空!");
}
break;
case 1:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
break;
case 2:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
if (string.IsNullOrEmpty(pbcontent))
{
RepToClient("活动信息不能为空!");
}
break;
case 3:
if (string.IsNullOrEmpty(pbtitle) || string.IsNullOrEmpty(pbcontent))
{
RepToClient("标题与内容不能为空!");
}
break;
case 4:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
break;
case 5:
break;
case 7: //将评星控件的数据写入数据表中
dr["PubContent"] = Request.Params["scoreVal"];
break;
case 8: //互动表单
break;
#endregion
}
}
codeBll.Insert(dr);
retMod.retcode = M_APIResult.Success;
RepToClient(retMod.ToString());
//Upaddnums(mpub); //更新总参与人数
}
