/// <summary>
/// 通过manager id 获取操作员的姓名与角色名
/// </summary>
/// <param name="db">数据库连接实例</param>
/// <param name="id">manager id</param>
public static NewBase <string, string> getManagerNameAndRole(EFContext db, string id)
{
var name = string.Empty;
var roleName = string.Empty;
if (id.IsNotNull())
{
var manager = db.selmanager.FirstOrDefault(a => a.ID == id);
if (manager != null)
{
name = manager.NickName;
var role = (from a in db.selrole
join b in db.selmanager_role.Where(t => t.SelManagerID == manager.ID) on a.ID equals b.SelRoleID
select a.Title
).FirstOrDefault();
if (role != null)
{
roleName = role;
}
}
}
var ba = new NewBase <string, string>();
ba.Data = name;
ba.Data2 = roleName;
ba.setSuccess("获取数据成功");
return(ba);
}
/// <summary>
/// 添加充值记录
/// </summary>
/// <param name="uguid"></param>
/// <param name="data"></param>
/// <param name="paymode">支付方式</param>
/// <param name="origin"></param>
/// <returns></returns>
public NewBase <ExAddRecharge> AddRecharge(string shopid, string managerid, decimal data, int paymode, int origin)
{
NewBase <ExAddRecharge> b = new NewBase <ExAddRecharge>();
b.Data = new ExAddRecharge();
try
{
DateTime now = DateTime.Now;
using (var db = new EFContext())
{
selshopjinbirecharge recharge = new selshopjinbirecharge();
recharge.ID = WebTools.getGUID();
recharge.ShopID = shopid;
recharge.ManagerID = managerid;
recharge.Data = data;
recharge.DT = now;
recharge.Status = 0;
recharge.Mode = paymode;
recharge.Origin = origin;
recharge.IsAvailable = true;
recharge.BatchId = BatchHelper.GetBatchId;
recharge.Contents = data.ToString();
db.selshopjinbirecharge.Add(recharge);
syspayhistory payhistory = new syspayhistory()
{
OrderMode = 1,
OrderNumber = recharge.ID,
CreateTime = now,
Status = 0,
BatchId = recharge.BatchId,
Price = data
};
db.syspayhistory.Add(payhistory);
db.SaveChanges();
b.Code = 1;
b.Message = "充值订单已提交，请确认后进行付款操作";
b.Data.Id = recharge.ID;
b.Data.BatchId = recharge.BatchId;
}
}
catch (Exception Exc)
{
b.Code = 0;
b.Message = ConstantHelper.Failure;
b.Description = Exc.ToString();
}
return(b);
}
private NewBase <ExOrderLossRateAll> getOrderBase(PaID pa, bool?isCheck = null)
{
var ba = new NewBase <ExOrderLossRateAll>();
try
{
Tools.PrintPa <PaID>(pa);
using (var db = new EFContext())
{
var model = db.swhorderlossrate.FirstOrDefault(a => a.ID == pa.ID);
ba.Data = new ExOrderLossRateAll
{
ID = model.ID,
ApproveContents = model.ApproveContents,
ApproveTime = model.ApproveTime,
OrderState = model.OrderState,
PriceReal = model.PriceReal,
ApproveSellerID = model.ApproveSellerID,
ApplySellerID = model.ApplySellerID,
CreateDate = model.CreateDate,
CreateTime = model.CreateTime,
Introduction = model.Introduction,
ShopID = model.ShopID,
Title = model.Title,
WareHouseID = model.WareHouseID,
WareHouseName = Tools.getWareHouseName(db, model.WareHouseID)
};
var n = Tools.getManagerNameAndRole(db, model.ApplySellerID);
ba.Data.ApplySellerName = n.Data;
ba.Data.ApplySellerRole = n.Data2;
if (model.ApproveSellerID.IsNotNull()) //这里都查出来吧
{
var n2 = Tools.getManagerNameAndRole(db, model.ApproveSellerID);
ba.Data.ApplySellerName = n2.Data;
ba.Data.ApplySellerRole = n2.Data2;
ba.Data.ApproveContents = model.ApproveContents;
ba.Data.ApproveTime = model.ApproveTime;
}
ba.setSuccess("获取数据成功");
return(ba);
}
}
catch (Exception e)
{
var m = WebTools.getFinalException(e);
ba.setFail("获取数据失败", m);
LogHelper.Error("获取数据失败：" + m);
}
return(ba);
}
IEnumerator createBase()
{
WWW request = RequestService.makeRequest("world/bases/create", b);
yield return(request);
Debug.Log(request.text);
NewBase newBase = JsonMapper.ToObject <NewBase> (request.text);
GenerateWorld.instance.addBase(newBase.b);
EventManager.positionText();
PortalHandler.instance.addPortal(newBase.p);
GenerateWorld.instance.message.text = request.text;
UpdateGold.instance.syncGold();
//GenerateWorld.instance.resetWorldView ();
}
public NewBase <decimal> getMoneySumBudget(string id)
{
var ba = new NewBase <decimal>();
try
{
using (var db = new EFContext())
{
//通过材料ID获得材料信息
var model = db.swhorderlossratedetail.Where(m => m.OrderApplyID == id)
.Select(a => new { a.PriceReal, a.CountLoss })
.Sum(a => a.PriceReal * a.CountLoss);
ba.Data = model;
ba.setSuccess("获取数据成功");
}
}
catch (Exception e)
{
var m = WebTools.getFinalException(e);
ba.setFail("操作失败", m);
LogHelper.Error("getMoneySumBudget：" + m);
}
return(ba);
}
/// <summary>
/// Sends a push notification request
/// </summary>
/// <returns>Sends a push notification request</returns>
public async Task PushRequestAsync(PushRequest req)
{
var request = $"{{\"title\":\"{req.Title}\",\"body\":\"{req.Content}\",\"target_device_iden\":\"{req.TargetDeviceIdentity}\",\"type\":\"note\"}}";
await NewBase.PostRequestAsync(Token, "https://api.pushbullet.com/v2/pushes", request).ConfigureAwait(false);
}
/// <summary>
/// Finds your past pushes
/// </summary>
/// <returns>Your PushBullet pushes</returns>
public async Task GetPushesAsync()
{
var cl = await NewBase.GetRequestAsync <ClientPushes>(Token, "/pushes").ConfigureAwait(false);
Pushes = cl.Pushes;
}
public JsonResult UserReg(FormCollection form)
{
#region field
ViewUserReg b = new ViewUserReg();
DateTime dt1 = DateTime.Now;
var iLog = log4net.LogManager.GetLogger("LogToTXT");
//仿照sso添加登录信息模型
string msg = string.Empty;
bool flag = false;
string tg = form.Get("tg");
string userName = form.Get("userName");
string password = form.Get("password");
string cpassword = form.Get("cpassword");
string email = form.Get("email");
string phone = form.Get("phone");
string validatecode = form.Get("validatecode");
string validateid = form.Get("validateid");
#endregion
#region 开始验证
#region 判断用户密码是否为空
if (string.IsNullOrEmpty(validateid))
{
flag = true;
msg = string.Format("验证码不能为空！");
}
if (string.IsNullOrEmpty(validatecode))
{
flag = true;
msg = string.Format("验证码不能为空！");
}
if (password != cpassword)
{
flag = true;
msg = string.Format("两次输入的密码不相同！");
}
if (string.IsNullOrEmpty(cpassword))
{
flag = true;
msg = string.Format("确认密码不能为空！");
}
if (string.IsNullOrEmpty(password))
{
flag = true;
msg = string.Format("密码不能为空！");
}
if (string.IsNullOrEmpty(email))
{
flag = true;
msg = string.Format("邮箱不能为空！");
}
if (string.IsNullOrEmpty(userName))
{
flag = true;
msg = string.Format("用户名不能为空！");
}
#endregion
#region 开始校验
if (Session["ValidateCode"] == null || validatecode != Session["ValidateCode"].ToString())
{
flag = true;
msg = string.Format("验证码输入不正确！");
}
if (Session["ValidateId"] == null || validateid != Session["ValidateId"].ToString())
{
flag = true;
msg = string.Format("验证码输入不正确！");
}
if (Session["Email"] == null || email != Session["Email"].ToString())
{
flag = true;
msg = string.Format("验证码输入不正确！");
}
#endregion
#region 开始判断
if (flag)
{
ViewBag.Email = email;
ViewBag.UserName = userName;
ViewBag.Phone = phone;
b.Code = 0;
b.Message = msg;
return(Json(b));
}
var bbb = RegexHelper.CheckPassword(password);
if (bbb.Code == 0)
{
b.Code = 0;
b.Message = bbb.Message;
return(Json(b));
}
var bbbb = RegexHelper.CheckUserName(userName);
if (bbbb.Code == 0)
{
b.Code = 0;
b.Message = bbbb.Message;
return(Json(b));
}
#endregion
#endregion
#region 用户注册
try
{
#region httpclient
var apiUrl = ConfigHelper.GetApiUrl;
var url = string.Format(apiUrl + "/api/so/postRegister");
using (var http = new HttpClient())
{
var content = new FormUrlEncodedContent(new Dictionary <string, string>()
{
{ "safecode", SafeCodeHelper.GetSafeCode },
{ "username", userName },
{ "password", password },
{ "email", email },
{ "tg", tg }
});
var response = http.PostAsync(url, content).Result;
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
NewBase <ExRegUser> bb = JsonConvert.DeserializeObject <NewBase <ExRegUser> >(response.Content.ReadAsStringAsync().Result);
if (bb.Code == 1)
{
b.Code = 1;
//采用服务端的返回提示
// b.Message = "注册成功！";
b.Url = ConfigHelper.GetHomeUrl;
b.Message = bb.Message;
//清理注册Session
Session["ValidateCode"] = null;
Session["ValidateId"] = null;
Session["Email"] = null;
//登录成功之后 默认用户登录 然后跳转到用户后台
SoUser sm = new SoUser();
sm.UserName = userName;
sm.NickName = userName;
sm.IP = SM.Current.IPManager.GetIP();
sm.ManagerId = bb.Data.UGUID;
bool isLogin = SoLogin.Login(sm);
return(Json(b));
}
else
{
b.Code = 0;
//采用服务端的返回提示
//b.Message = "注册失败！";
b.Message = bb.Message;
return(Json(b));
}
}
else
{
b.Code = 0;
b.Message = response.ReasonPhrase;
return(Json(b));
}
}
#endregion
}
catch (Exception Exc)
{
b.Code = 0;
b.Message = "注册异常！";
return(Json(b));
}
#endregion
}
public JsonResult GetValidateCode(FormCollection form)
{
#region field
NewBase <string> b = new NewBase <string>();
bool flag = false;
string userName = form.Get("userName");
string email = form.Get("email");
#endregion
#region 开始验证
#region 判断用户密码是否为空
if (string.IsNullOrEmpty(email))
{
flag = true;
b.Message = string.Format("邮箱不能为空！");
}
if (string.IsNullOrEmpty(userName))
{
flag = true;
b.Message = string.Format("用户名不能为空！");
}
#endregion
#region 开始判断
if (flag)
{
b.Code = 0;
return(Json(b));
}
#endregion
#endregion
string vaildatecode = RandomHelper.GetRandom(6);
Session["ValidateCode"] = vaildatecode;
var ValidateId = WebTools.getGUID();
Session["ValidateId"] = ValidateId;
Session["Email"] = email;
#region 获取验证码
try
{
//var p = new Dictionary<string, string>() { { "username", userName }, { "email", email }, { "vaildatecode", vaildatecode } };
//var result = PostAsync<Base>("postValidateCode", p);
//if (result.Code == 1)
//{
// b.Code = 1;
// b.Message = result.Message;
// b.Data = ValidateId;
//}
//else
//{
// b.Code = 0;
// b.Message = result.Message;
// b.Data = ValidateId;
//}
}
catch (Exception Exc)
{
b.Code = 0;
b.Message = "验证码获取失败！";
b.Description = Exc.ToString();
var iLog = log4net.LogManager.GetLogger("LogToTXT");
iLog.Info(Exc.ToString());
}
#endregion
return(Json(b));
}