public MODEL.DataTableModel.DataTableGrid GetWeChatUserForGrid(MODEL.DataTableModel.DataTableRequest request)
{
try
{
var predicate = PredicateBuilder.True <YX_weiUser>();
DateTime time = TypeParser.ToDateTime("1975-1-1");
int total = 0;
//string strSql = "select * from FW_GEO_NODE";
//SqlParameter[] parameters = {
// new SqlParameter("@id", "")
// };
var list = IDBSession.ISYS_USERLOGIN_REPOSITORY.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
predicate = predicate.And(p => list.Contains(p.TREE_NODE_ID));
var data = base.LoadPagedList(request.PageNumber, request.PageSize, ref total, predicate, request.Model, p => true, request.SortOrder, request.SortName);
//var list = ViewModelProduct.ToListViewModel(data);
return(new MODEL.DataTableModel.DataTableGrid()
{
draw = request.Draw,
data = VIEW_YX_weiUser.ToListViewModel(data),
total = total
});
}
catch (Exception)
{
throw;
}
}
public ActionResult OrderDetail(string ordernum)
{
VIEW_TG_order order = new VIEW_TG_order()
{
orderNum = CommonMethod.GetOrderNum(), trade_type = "ONLINE", orderTime = DateTime.Now, ThingNum = CommonMethod.GetCode(18)
};
ViewBag.ReturnUrl = Request["returnurl"];
ViewBag.TYPE = "Update";
if (string.IsNullOrEmpty(ordernum))
{
ViewBag.TYPE = "Add";
var list = sys_userlogin.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
ViewBag.MEMBERS = DataSelect.ToListViewModel(VIEW_YX_weiUser.ToListViewModel(userB.GetListBy(u => list.Contains(u.TREE_NODE_ID) && u.isfenxiao != 0, u => u.userRelname)));
ViewBag.COMPANYS = DataSelect.ToListViewModel(VIEW_MST_SUPPLIER.ToListViewModel(supplierB.GetListBy(u => list.Contains(u.TREE_NODE_ID) && u.SYNCOPERATION != "D", u => u.SUPPLIER_ID)));
}
var model = orderB.Get(o => o.orderNum == ordernum);
if (model != null)
{
order = VIEW_TG_order.ToViewModel(model);
ViewBag.Things = VIEW_TG_Thing.ToListViewModel(thingB.GetListBy(t => t.orderNum == ordernum, t => t.createTim, false));
}
return(View(order));
}
public ActionResult ProductDetail(string id)
{
ViewBag.Appid = WeChatConfig.GetKeyValue("appid");
ViewBag.Uri = WeChatConfig.GetKeyValue("shareurl");
noncestr = CommonMethod.GetCode(16);
string jsapi_ticket = Js_sdk_Signature.IsExistjsapi_ticket(token.IsExistAccess_Token());
timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10);;
string url = Request.Url.ToString().Replace("#", "");
JssdkSignature = Js_sdk_Signature.GetjsSDK_Signature(noncestr, jsapi_ticket, timestamp, url);
ViewBag.noncestr = noncestr;
ViewBag.jsapi_ticket = jsapi_ticket;
ViewBag.timestamp = timestamp;
ViewBag.JssdkSignature = JssdkSignature;
var userid = CommonMethod.getCookie("userid");
var openid = CommonMethod.getCookie("openid");
ViewBag.userName = "";
ViewBag.userTel = "";
if (!string.IsNullOrEmpty(userid) && !string.IsNullOrEmpty(openid))
{
var user = VIEW_YX_weiUser.ToViewModel(weiUserM.GetModelWithOutTrace(u => u.openid == openid));
if (user != null)
{
ViewBag.userName = user.userRelname;
ViewBag.userTel = user.userTel;
}
}
var sid = TypeParser.ToInt32(Request["sid"]);
if (sid <= 0)
{
sid = 2;
}
ViewBag.SupplierID = sid;
var supplier = supplierB.Get(s => s.SUPPLIER_ID == sid);
ViewBag.SupplierName = supplier.SUPPLIER_NAME;
ViewBag.Address = supplier.ADDRESS;
ViewBag.Tel = supplier.TEL;
var model = VIEW_MST_PRD.ToViewModel(prdB.Get(p => p.PRD_CD == id));
ViewBag.ImgList = VIEW_MST_PRD_IMG.ToListViewModel(prdimgB.GetListBy(pm => pm.PRD_CD == id));
ViewBag.AM = sysrefB.GetListBy(s => s.REF_TYPE == model.CATE_ID && s.REF_PARAM.Contains("AM_"), s => s.REF_SEQ);
ViewBag.PM = sysrefB.GetListBy(s => s.REF_TYPE == model.CATE_ID && s.REF_PARAM.Contains("PM_"), s => s.REF_SEQ);
ViewBag.PageFlag = model.CATE_ID;
return(View(model));
}
public ActionResult Update(VIEW_YX_weiUser user)
{
bool status = false;
try
{
user.RegTim1 = DateTime.Now;
if (!string.IsNullOrEmpty(user.btnChargeMoney))
{
var model = wechatUserB.GetModelWithOutTrace(u => u.userNum == user.userNum);
if (model != null && user.ReChargeMoney > 0)
{
MODEL.TG_transactionLog log = new MODEL.TG_transactionLog();
log.userId = model.userNum;
log.openid = model.openid;
log.tranCate = 1;
log.remark4 = "1000";
log.CateName = "会员充值";
log.tranMoney = user.ReChargeMoney;
log.tranContent = "会员充值(会员充值金额：" + user.ReChargeMoney + ";充值前金额为：" + model.userYongJin + ";充值后金额为：" + (model.userYongJin + user.ReChargeMoney) + ")";
log.orderNum = "UserReCharge";
log.AddTime = DateTime.Now; model.userMoney = model.userMoney + user.ReChargeMoney;
model.userYongJin = model.userYongJin + user.ReChargeMoney;
wechatUserB.ChargeMoney(log, model, "userMoney", "userYongJin", "RegTim1");
}
else
{
ModelState.AddModelError("ReChargeMoney_Msg", "金额必须大于0元");
return(this.JsonFormat(ModelState, status, "ERROR"));
}
// wechatUserB.Modify(model, "userRelname", "userTel", "userWXnum", "userQQ", "remark1", "isfenxiao", "userMoney", "RegTim1");
}
else
{
wechatUserB.Modify(VIEW_YX_weiUser.ToEntity(user), "userRelname", "userTel", "userWXnum", "userQQ", "remark1", "remark2", "RegTim1", "isfenxiao", "TREE_NODE_ID");
}
status = true;
}
catch (Exception e)
{
return(this.JsonFormat(status, status, SysOperate.Update));
}
return(this.JsonFormat("/Admin/WeChatUser/WeChatUserInfo", status, SysOperate.Update.ToMessage(status), status));
}
public ActionResult Add(VIEW_YX_weiUser user)
{
var currUser = VIEW_YX_weiUser.ToEntity(user);
bool status = false;
try
{
currUser.openid = currUser.userNum;
currUser.subscribe_time = DateTime.Now;
currUser.TREE_NODE_ID = currUser.TREE_NODE_ID;
wechatUserB.Add(currUser);
status = true;
}
catch (Exception e)
{
return(this.JsonFormat(status, status, SysOperate.Add));
}
return(this.JsonFormat("/Admin/WeChatUser/WeChatUserInfo", status, SysOperate.Add.ToMessage(status), status));
}
public ActionResult WeChatDetail(string userNum)
{
ViewBag.UserType = DataSelect.ToListViewModel(ConfigSettings.GetSysConfigList("USERTYPE"));
ViewBag.ReturnUrl = Request["returnurl"];
ViewDetailPage page = new ViewDetailPage(HttpContext);
ViewBag.IsView = page.IsView;
//ViewBag.CurrentID = id;
ViewBag.TYPE = "Update";
var list = sys_userlogin.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
ViewBag.COMPANYS = DataSelect.ToListViewModel(VIEW_MST_SUPPLIER.ToListViewModel(supplierB.GetListBy(u => list.Contains(u.TREE_NODE_ID), u => u.SUPPLIER_ID)), true);
var model = wechatUserB.Get(u => u.userNum == userNum);
if (model == null)
{
ViewBag.TYPE = "Add";
return(View(new VIEW_YX_weiUser()
{
}));
}
return(View(VIEW_YX_weiUser.ToViewModel(model)));
}
public ActionResult CarDetail(string car_cd)
{
VIEW_MST_CAR car = new VIEW_MST_CAR()
{
CAR_CD = "CAR" + Common.Tools.Get8Digits(), AddTime = DateTime.Now
};
var usernum = Request.QueryString["userNum"];
if (!string.IsNullOrEmpty(usernum))
{
car.UserId = usernum;
}
var list = sys_UsurLogin.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
var memberlist = DataSelect.ToListViewModel(VIEW_YX_weiUser.ToListViewModel(userB.GetListBy(u => list.Contains(u.TREE_NODE_ID), u => u.userRelname)));
ViewBag.MEMBERS = memberlist;
ViewBag.ReturnUrl = Request["returnurl"];
ViewDetailPage page = new ViewDetailPage(HttpContext);
ViewBag.IsView = page.IsView;
//ViewBag.CurrentID = id;
ViewBag.IsUpdate = "N";
ViewBag.TYPE = "Update";
var model = carB.Get(u => u.CAR_CD == car_cd);
if (model == null)
{
ViewBag.TYPE = "Add"; ViewBag.IsUpdate = "Y";
return(View(car));
}
if (memberlist.Select(m => m.Value).Contains(model.UserId))
{
ViewBag.IsUpdate = "Y";
}
return(View(VIEW_MST_CAR.ToViewModel(model)));
}
public ActionResult UserMain()
{
ViewBag.PageFlag = "UserMain";
ViewBag.isok = "OK";
ViewBag.Appid = WeChatConfig.GetKeyValue("appid");
ViewBag.Uri = WeChatConfig.GetKeyValue("shareurl");
noncestr = CommonMethod.GetCode(16);
string jsapi_ticket = Js_sdk_Signature.IsExistjsapi_ticket(token.IsExistAccess_Token());
timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10);;
string url = Request.Url.ToString().Replace("#", "");
JssdkSignature = Js_sdk_Signature.GetjsSDK_Signature(noncestr, jsapi_ticket, timestamp, url);
ViewBag.noncestr = noncestr;
ViewBag.jsapi_ticket = jsapi_ticket;
ViewBag.timestamp = timestamp;
openid = CommonMethod.getCookie("openid");
userid = CommonMethod.getCookie("userid");
if (string.IsNullOrEmpty(openid))
{
//根据授权 获取openid //根据授权 获取用户的openid
string code = Request.QueryString["code"];//获取授权code
LogHelper.WriteLog("//////////////////////////////////////////////////////////////////////////////////");
LogHelper.WriteLog("code：" + code);
if (string.IsNullOrEmpty(code))
{
string codeurl = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx242aa47391c159f6&redirect_uri=http://www.aoshacar.com/AoShaCar/userMain&response_type=code&scope=snsapi_userinfo&state=STATE&connect_redirect=1#wechat_redirect";
Response.Redirect(codeurl);
}
else
{
string openIdUrl = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + WeChatConfig.GetKeyValue("appid") + "&secret=" + WeChatConfig.GetKeyValue("appsecret") + "&code=" + code + "&grant_type=authorization_code";
string content = Tools.GetPage(openIdUrl, "");
openid = Tools.GetJsonValue(content, "openid");//根据授权 获取当前人的openid
}
}
var model = VIEW_YX_weiUser.ToViewModel(weiUserM.GetModelWithOutTrace(u => u.openid == openid));
if (model != null)
{
CommonMethod.delCookie("openid");
CommonMethod.delCookie("userid");
CommonMethod.setCookie("openid", openid, 1);
CommonMethod.setCookie("userid", model.userNum, 1);
ViewBag.nickname = model.nickname;
ViewBag.headimgurl = model.headimgurl;
}
else
{
Senparc.Weixin.MP.AdvancedAPIs.User.UserInfoJson dic = Senparc.Weixin.MP.AdvancedAPIs.UserApi.Info(token.IsExistAccess_Token(), openid);
//LogHelper.WriteLog("XXXXXXXXXXX：" + openid);
if (dic != null)
{
ViewBag.nickname = dic.nickname;
ViewBag.headimgurl = dic.headimgurl;
}
model = new MODEL.ViewModel.VIEW_YX_weiUser();
model.subscribe = dic.subscribe;
model.openid = dic.openid;
model.nickname = dic.nickname;
model.sex = dic.sex;
model.U_language = dic.language;
model.city = dic.city;
model.province = dic.province;
model.country = dic.country;
model.headimgurl = dic.headimgurl;
model.subscribe_time = DateTime.Now;
model.userSex = dic.sex == 2 ? "女" : "男";
model.userNum = Common.Tools.Get8Digits();
model.F_id = 0;
model.isfenxiao = 0;
model.userMoney = 0;
model.userYongJin = 0;
weiUserM.Add(VIEW_YX_weiUser.ToEntity(model));
}
ViewBag.UserType = ConfigSettings.GetSysConfigValue("USERTYPE", model.isfenxiao.ToString());
return(View(model));
}
