//添加员工分组
public ActionResult AddGroup(string groupName, string desc)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
try
{
TStaffGroup group = new TStaffGroup();
group.CreateTime = DateTime.Now;
group.GroupName = groupName;
group.Descriptions = desc;
db.TStaffGroup.InsertOnSubmit(group);
db.SubmitChanges();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
OLog.UpdateValue = ObjectToJson.ModelToJson(group);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "新增员工分组";
Converter.InsertOperationLog(OLog);
return Json(group.ID);//添加成功
}
catch (Exception)
{
return Json(0);//添加失败
}
}
}
public ActionResult PostCurrency()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
try
{
int id = Converter.ToInt(Request["id"], 0);
double curr = Convert.ToDouble(Converter.ToFloat(Request["currency"], 0).ToString("f5"));
APIDataDataContext db = APIDataContextProxy.APIDB;
var currency = (from c in db.TProductName where c.ID == id select c).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(currency);
if (currency != null)
{
currency.CurrencyNum = curr;
db.SubmitChanges();
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改汇率成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
OLog.UpdateValue = ObjectToJson.ModelToJson(currency);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改汇率";
Converter.InsertOperationLog(OLog);
return Content("true");
}
else
{
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改汇率失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("false");
}
}
catch
{
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改汇率失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("false");
}
}
public ActionResult Edit()
{
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
int ID = Converter.ToInt(Request.Form["id"], 0);//主键id
string Name = Converter.ToString(Request.Form["Name"], "", null);//帐号名称
string Phone = Converter.ToString(Request.Form["Phone"], "", null);//联系方式
string Email = Converter.ToString(Request.Form["Email"], "", null);//联系邮箱
string CityCode = Converter.ToString(Request.Form["CityCode"], "", null);//地区
string Address = Converter.ToString(Request.Form["Address"], "", null);//地址
int AllowTrade = Converter.ToInt(Request.Form["AllowTrade"], 0);//交易操作
int AllowFinance = Converter.ToInt(Request.Form["AllowFinance"], 0);//资金操作
int GroupID = Converter.ToInt(Request.Form["GroupID"], 0);//用户分组
string password = Converter.ToString(Request["password"], ""); //密码
double AccountMoney = (double)Converter.ToFloat(Request.Form["AccountMoney"], 0); //帐户余额
int agentid = Converter.ToInt(Request.Form["agentid"], 0);
string IDCardNo = Converter.ToString(Request.Form["IDCardNo"], "", null);
string SavingsAccount = Converter.ToString(Request.Form["SavingsAccount"], "", null);
int Bankid = Converter.ToInt(Request.Form["Bankid"], 0);
string Branch = Converter.ToString(Request["Branch"], "");
if (ID == 0)
Json(new { result = "fail", msg = "用户不存在！" });
#region 数据校验
bool isValid = true;
int i = 0;
if (string.IsNullOrEmpty(Name))
{
msg += (++i).ToString() + "、客户名称不能为空！<br />";
isValid = false;
}
APIDataDataContext db = APIDataContextProxy.APIDB;
{
TRealAccounts account = null;
if (!string.IsNullOrEmpty(Phone))
{
account = db.TRealAccounts.Where(t => t.Phone == Phone).FirstOrDefault();
if (account != null)
{
if (account.ID != ID)
{
msg += (++i).ToString() + "、该联系方式已经存在！<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(Email))
{
account = db.TRealAccounts.Where(t => t.Email == Email).FirstOrDefault();
if (account != null)
{
if (account.ID != ID)
{
msg += (++i).ToString() + "、该联系邮箱已经存在！<br />";
isValid = false;
}
}
}
}
if (string.IsNullOrEmpty(password))
{
msg += (++i).ToString() + "、密码不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(IDCardNo))
{
msg += (++i).ToString() + "、身份证号不能为空！<br />";
isValid = false;
}
if (Bankid <= 0)
{
msg += (++i).ToString() + "、开户银行不能为空！<br />";
}
if (string.IsNullOrEmpty(SavingsAccount))
{
msg += (++i).ToString() + "、储蓄卡号不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(CityCode))
{
msg += (++i).ToString() + "、开户行所在地不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(Branch))
{
msg += (++i).ToString() + "、开户支行不能为空！<br />";
isValid = false;
}
//if (AccountMoney <= 0)
//{
// msg += (++i).ToString()+"、账户余额必须大于0！<br />";
// isValid = false;
//}
if (!isValid)
{
return Json(new { result = "fail", msg = msg });
}
#endregion
try
{
TOperationLog OLog = new TOperationLog();
var cityid = (from c in db.TCities where c.CityCode == CityCode select c.ID).FirstOrDefault();
TRealAccounts accounts = (from c in db.TRealAccounts where c.ID == ID select c).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(accounts);//修改前数据
accounts.Name = Name;
accounts.Phone = Phone;
accounts.Email = Email;
accounts.CityID = cityid;
accounts.Address = Address;
accounts.AllowTrade = (AllowTrade == 1);
accounts.AllowFinance = (AllowFinance == 1);
accounts.GroupID = GroupID;
if (agentid>0)
accounts.AgendID = agentid;
accounts.IDCardNo = IDCardNo;
accounts.BankID = Bankid;
accounts.SavingsAccount = SavingsAccount;
accounts.Branch = Branch;
if (!string.IsNullOrEmpty(password))
{
if (password != "******")
{
accounts.PassWord = password;
}
}
accounts.AccountMoney = AccountMoney;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(accounts);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改用户";
Converter.InsertOperationLog(OLog);
//存入日志
ID = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改用户成功";
fruit = true;
Converter.InsertLog(ID, name, Type, msg, fruit);
return Json(new { result = "success", msg = msg });
}
catch
{
//存入日志
ID = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改用户失败";
fruit = false;
Converter.InsertLog(ID, name, Type, msg, fruit);
return Json(new { result = "fail", msg = msg });
}
}
public ActionResult PostEditPosition()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'非法请求！'}");
int orderid = Converter.ToInt(Request.Form["orderid"], 0);
if (orderid <= 0)
return Content("{result:'fail',msg:'订单号错误！'}");
string type = Request.Form["type"];
TOperationLog OLog = new TOperationLog();
if (type == "1")//删除
{
try
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
var res = (from p in db.TOrders where p.ID == orderid select p).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(res);
if (res == null)
return Content("{result:'fail',msg:'订单不存在！'}");
else
db.TOrders.DeleteOnSubmit(res);
db.SubmitChanges();
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除委托订单";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除订单成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'删除成功！'}");
}
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除订单失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'服务器出错，删除失败！'}");
}
}
int enType = Converter.ToInt(Request.Form["enType"], -1);
if (!(enType >= 0 && enType <= 3))
return Content("{result:'fail',msg:'订单类型错误！'}");
bool deal = false;
int entrust = 1;
if (enType == 0)
{
deal = false;
entrust = 1;
}
else if (enType == 1)
{
deal = true;
entrust = 1;
}
else if (enType == 2)
{
deal = false;
entrust = 0;
}
else
{
deal = true;
entrust = 0;
}
double ordercount = Converter.ToFloat(Request.Form["ordercount"], 0);
if (ordercount <= 0)
return Content("{result:'fail',msg:'交易数量错误！'}");
DateTime dt = DateTime.Now;
if (!DateTime.TryParse(Request.Form["opentime"], out dt))
return Content("{result:'fail',msg:'截止日期错误！'}");
if (dt <= DateTime.Now)
return Content("{result:'fail',msg:'截止日期不能小于当前时间！'}");
double price = Converter.ToFloat(Request.Form["openprice"], 0);
if (price <= 0)
return Content("{result:'fail',msg:'价格错误！'}");
string pro = (Request.Form["profit"] + "").Trim();
float profit = 0f;
if (pro != "" && !float.TryParse(pro, out profit))
return Content("{result:'fail',msg:'止盈距离必须为数值类型！'}");
string los = (Request.Form["profit"] + "").Trim();
float loss = 0f;
if (pro != "" && !float.TryParse(los, out loss))
return Content("{result:'fail',msg:'止损距离必须为数值类型！'}");
if (type == "0")
{
try
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
var res = (from p in db.TOrders where p.ID == orderid select p).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(res);
if (res == null)
return Content("{result:'fail',msg:'订单不存在！'}");
else
{
res.Deal = deal;
res.EntrustType = entrust;
res.OrderCount = (double)ordercount;
res.OpenTime = dt;
res.OpenPrice = (double)price;
res.Profit = (double)profit;
res.Loss = (double)loss;
}
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(res);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改委托订单";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改订单成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'修改成功！'}");
}
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改订单失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'服务器出错，修改失败！'}");
}
}
//委托单转开仓单，待做
else if (type == "2")
{
return Content("{result:'fail',msg:'功能待做！'}");
}
return Content("{result:'fail',msg:'操作类型有误！'}");
}
public ActionResult PostStaffInfo()
{
int Id = 0; //Id
string Name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
int uid = 1;
try
{
if (!Request.IsAjaxRequest())
return Content("{result:'success',msg:'非法提交数据，信息修改失败！'}");
int id = Converter.ToInt(Request.Form["ID"], 0);
if (id == 0)
return Content("{result:'fail',msg:'员工不存在！'}");
string staffName = Converter.ToString(Request.Form["StaffName"]).Trim();
string telePhone = Converter.ToString(Request.Form["TelePhone"]).Trim();
int groupid = Converter.ToInt(Request.Form["GroupID"], 0);
string Account = Converter.ToString(Request.Form["Account"], "");
string email = Converter.ToString(Request.Form["Email"]).Trim().ToLower();
string password = Converter.ToString(Request["Password"]);
string errMsg = "";
#region 数据校验
int i = 0;
bool isValid = true;
if (staffName == "")
{
errMsg += (++i).ToString() + "、员工姓名不能为空;<br />";
isValid = false;
}
if (Account == "")
{
errMsg += (++i).ToString() + "、员工帐号不能为空;<br />";
isValid = false;
}
if (string.IsNullOrEmpty(password))
{
errMsg += (++i).ToString() + "、员工密码不能为空;<br />";
isValid = false;
}
APIDataDataContext db = APIDataContextProxy.APIDB;
{
if (!string.IsNullOrEmpty(Account))
{
TStaffs staff = db.TStaffs.Where(t => t.Account == Account).FirstOrDefault();
if (staff != null)
{
if (staff.ID != id)
{
errMsg += (++i).ToString() + "、员工帐号已经存在;<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(telePhone))
{
TStaffs staff = db.TStaffs.Where(t => t.TelePhone == telePhone).FirstOrDefault();
if (staff != null)
{
if (staff.ID != id)
{
errMsg += (++i).ToString() + "、联系电话已经存在;<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(email))
{
TStaffs staff = db.TStaffs.Where(t => t.Email == email).FirstOrDefault();
if (staff != null)
{
if (staff.ID != id)
{
errMsg += (++i).ToString() + "、联系邮箱已经存在;<br />";
isValid = false;
}
}
}
}
#endregion
if (!isValid)
{
return Content("{result:'fail',msg:'" + errMsg + "'}");
}
else
{
var staff = (from p in db.TStaffs where p.ID == id select p).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(staff);
if (staff == null)
{
return Content("{result:'fail',msg:'员工不存在！'}");
}
else
{
staff.StaffName = staffName;
staff.GroupID = groupid;
staff.TelePhone = telePhone;
staff.Email = email;
//staff.DepartmentID = depid;
staff.LastModifyerID = uid;
staff.LastUpdateTime = DateTime.Now;
staff.Password = password;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(staff);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改员工账户";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改员工成功";
fruit = true;
Converter.InsertLog(Id, Name, Type, msg, fruit);
return Content("{result:'success',msg:'信息修改成功！'}");
}
}
}
catch (Exception ex)
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改员工失败";
fruit = false;
Converter.InsertLog(Id, Name, Type, msg, fruit);
return Content("{result:'fail',msg:'修改失败，出现未知异常！'}");
}
}
/// <summary>
/// 处理提款申请结果
/// </summary>
/// <returns></returns>
public ActionResult ApplyforResult(int orderId, int bankStatus, int? platformStatus, int? examine)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
var res = "1";
try
{
TAccountMoney ta = db.TAccountMoney.Where(s => s.Id == orderId).FirstOrDefault();
TOperationLog OLog = new TOperationLog();
bool isTrue = false;
OLog.BeforeValue = ObjectToJson.ModelToJson(ta);
if (bankStatus == -1 || bankStatus == -2)
{
OLog.PageName = bankStatus == -1 ? "确认出金成功" : "确认出金失败";
}
string payType = System.Configuration.ConfigurationManager.AppSettings["payType"];//支付接口类型
if (ta.AgentId == null)
{
TRealAccounts tr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
#region 用户出金
switch (bankStatus)
{
case -1://确认出金成功
if (ta.Status > 1)
{
res = "订单状态错误！";
}
else
{
#region 调用出金接口
if (!string.IsNullOrEmpty(payType))
{
if (tr != null)
{
RequestResult result = CashOutAPI.CachOut(payType, tr, null, ta);
if (!result.IsSuccess)
{
return Json(result.ErrMsg);
}
}
else
{
return Json("用户不存在！");//用户不存在
}
}
#endregion
ta.BankState = 1;
ta.PlatformState = 1;
ta.Examine = 1;
ta.Status = 2;
//tr.AccountMoney = tr.AccountMoney - ta.CreateMoney;
}
break;
case -2://确认出金失败
ta.BankState = 2;
ta.PlatformState = 2;
ta.Examine = 2;
ta.Status = 3;
tr.AccountMoney = tr.AccountMoney + ta.CreateMoney;
break;
default://提交处理其他
ta.BankState = bankStatus;
ta.PlatformState = platformStatus;
ta.Examine = examine;
if (examine == 0)
{
TRealAccounts trr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
TBanks tb = db.TBanks.Where(b => b.Id == trr.BankID).FirstOrDefault();
res = Converter.SetMoneyOrder(orderId.ToString(), trr.Name, ta.AccountNo, Converter.ToInt(ta.CreateMoney), ta.BankName, tb.Code);
}
break;
}
#endregion
}
else
{
#region 会员出金
TAgents tg = db.TAgents.Where(t => t.ID == ta.AgentId).FirstOrDefault();
switch (bankStatus)
{
case -1://确认出金成功
if (ta.Status > 1)
{
res = "订单状态错误！";
}
else
{
#region 调用出金接口
if (!string.IsNullOrEmpty(payType))
{
if (tg != null)
{
RequestResult result = CashOutAPI.CachOut(payType, null, tg, ta);
if (!result.IsSuccess)
{
return Json(result.ErrMsg);
}
}
else
{
return Json("会员不存在！");//会员不存在
}
}
#endregion
isTrue = true;
ta.BankState = 1;
ta.PlatformState = 1;
ta.Examine = 1;
ta.Status = 2;
//tg.AccountMoney = ((double)tg.AccountMoney - (double)ta.CreateMoney);
}
break;
case -2://确认出金失败
ta.BankState = 2;
ta.PlatformState = 2;
ta.Examine = 2;
ta.Status = 3;
tg.AccountMoney = (tg.AccountMoney + (double)ta.CreateMoney);
break;
default://提交处理其他
ta.BankState = bankStatus;
ta.PlatformState = platformStatus;
ta.Examine = examine;
if (examine == 0)
{
TRealAccounts trr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
TBanks tb = db.TBanks.Where(b => b.Id == trr.BankID).FirstOrDefault();
res = Converter.SetMoneyOrder(orderId.ToString(), trr.Name, ta.AccountNo, Converter.ToInt(ta.CreateMoney), ta.BankName, tb.Code);
}
break;
}
#endregion
}
db.SubmitChanges();
if (isTrue)
{
OLog.UpdateValue = ObjectToJson.ModelToJson(ta);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
}
}
catch
{
res = "出金出现错误，请核实出金用户信息！";
}
return Json(res);
}
public ActionResult RemoveTAnalysis()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'非法请求'}");
string str = Converter.ToString(Request.QueryString["ids"]).Trim();
if (str == "")
return Content("{result:'fail',msg:'参数错误，删除失败！'}");
try
{
string sql = "delete from TAnalysis where Id in (" + str + ")";
int count = APIDataContextProxy.ExecuteNonQuery(null, sql, CommandType.Text);
if (count > 0)
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除分析成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
string[] arr = str.Split(',');
StringBuilder sb = new StringBuilder();
sb.Append("{\"IDList\"：[");
foreach (string i in arr)
{
sb.Append("{").AppendFormat("\"id\"：\"{0}\"", i).Append("},");
}
sb.Remove(sb.Length - 1, 1).Append("]}");
OLog.BeforeValue = sb.ToString();
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除分析";
Converter.InsertOperationLog(OLog);
return Content("{result:'success',msg:'删除成功！'}");
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除分析失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'删除失败！'}");
}
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除分析失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'删除失败，未知错误！'}");
}
}
public ActionResult PostAgentInfo()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
try
{
if (!Request.IsAjaxRequest())
return Content("{result:'success',msg:'非法提交数据，信息修改失败！'}");
int id = Converter.ToInt(Request.Form["id"], 0);
if (id == 0)
return Content("{result:'fail',msg:'非法提交数据，信息修改失败！'}");
string agentName = Converter.ToString(Request.Form["agentname"]).Trim();
string phone = Converter.ToString(Request.Form["phone"]).Trim();
string email = Converter.ToString(Request.Form["email"]).Trim();
string citycode = Converter.ToString(Request.Form["citycode"], "");
string address = Converter.ToString(Request.Form["address"]).Trim();
int dirid = Converter.ToInt(Request.Form["dirid"], 0);
string idno = Converter.ToString(Request.Form["idno"]).Trim();
int bankid = Converter.ToInt(Request.Form["bankid"], 0);
string savings = Converter.ToString(Request.Form["savings"]).Trim();
int allowcus = Converter.ToInt(Request.Form["allowcus"], -1);
int allowagent = Converter.ToInt(Request.Form["allowagent"], -1);
int groupid = Converter.ToInt(Request.Form["groupid"], 0);
string password = Converter.ToString(Request.Form["password"], "");
string branch = Converter.ToString(Request["Branch"], "");
string savingsName = Converter.ToString(Request["SavingsName"], "");
#region 返佣信息
var hr1 = Converter.ToFloat(Request["HeadRate1"]);
var pr1 = Converter.ToFloat(Request["ProcessRate1"]);
var ir1 = Converter.ToFloat(Request["InterestRate1"]);
var hr2 = Converter.ToFloat(Request["HeadRate2"]);
var pr2 = Converter.ToFloat(Request["ProcessRate2"]);
var ir2 = Converter.ToFloat(Request["InterestRate2"]);
var hr3 = Converter.ToFloat(Request["HeadRate3"]);
var pr3 = Converter.ToFloat(Request["ProcessRate3"]);
var ir3 = Converter.ToFloat(Request["InterestRate3"]);
var hr4 = Converter.ToFloat(Request["HeadRate4"]);
var pr4 = Converter.ToFloat(Request["ProcessRate4"]);
var ir4 = Converter.ToFloat(Request["InterestRate4"]);
var hr5 = Converter.ToFloat(Request["HeadRate5"]);
var pr5 = Converter.ToFloat(Request["ProcessRate5"]);
var ir5 = Converter.ToFloat(Request["InterestRate5"]);
#endregion
#region 数据校验
string errMsg = "";
bool isValid = true;
int i = 0;
if (agentName == "")
{
errMsg += (++i).ToString() + "、会员姓名不能为空；<br />";
isValid = false;
}
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
TAgents agent = null;
if (!string.IsNullOrEmpty(phone))
{
agent = db.TAgents.Where(t => t.TelePhone == phone).FirstOrDefault();
if (agent != null)
{
if (agent.ID != id)
{
errMsg += (++i).ToString() + "、联系方式已经存在！<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(email))
{
agent = db.TAgents.Where(t => t.Email == email).FirstOrDefault();
if (agent != null)
{
if (agent.ID != id)
{
errMsg += (++i).ToString() + "、联系邮箱已经存在！<br />";
isValid = false;
}
}
}
}
if (password == "")
{
errMsg += (++i).ToString() + "、密码不能为空；<br />";
isValid = false;
}
if (id == dirid)
{
errMsg += (++i).ToString() + "、所属上级不能为会员自己；<br />";
isValid = false;
}
if (string.IsNullOrEmpty(idno))
{
errMsg += (++i).ToString() + "、身份证号不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(savings))
{
errMsg += (++i).ToString() + "、银行卡号不能为空！<br />";
isValid = false;
}
if (bankid <= 0)
{
errMsg += (++i).ToString() + "、开户银行不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(citycode))
{
errMsg += (++i).ToString() + "、开户行所在地不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(branch))
{
errMsg += (++i).ToString() + "、银行支行名不能为空！<br />";
isValid = false;
}
if (bankid <= 0)
{
errMsg += (++i).ToString() + "、开户银行不能为空！<br />";
isValid = false;
}
#endregion
if (!isValid)
{
return Content("{result:'fail',msg:'" + errMsg + "'}");
}
else
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
TOperationLog OLog = new TOperationLog();
var agent = (from p in db.TAgents where p.ID == id select p).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(agent);
if (agent == null)
return Content("{result:'fail',msg:'会员不存在！'}");
int cityID = (from p in db.TCities where p.CityCode == citycode select p.ID).FirstOrDefault();
agent.CityID = cityID;
agent.AgentName = agentName;
agent.TelePhone = phone;
agent.Email = email;
agent.Address = address;
//agent.DirectAgentID = dirid;
agent.IdCardNo = idno;
agent.BankID = bankid;
agent.SavingsAccount = savings;
agent.PassWord = password;
agent.AllowDevelopAgents = Convert.ToBoolean(allowagent);
agent.AllowDevelopCustomers = Convert.ToBoolean(allowcus);
agent.GroupID = groupid;
agent.LastLoginTime = DateTime.Now;
agent.Branch = branch;
agent.SavingsName = savingsName;
agent.HeadRate1 = hr1;
agent.ProcessRate1 = pr1;
agent.InterestRate1 = ir1;
agent.HeadRate2 = hr2;
agent.ProcessRate2 = pr2;
agent.InterestRate2 = ir2;
agent.HeadRate3 = hr3;
agent.ProcessRate3 = pr3;
agent.InterestRate3 = ir3;
agent.HeadRate4 = hr4;
agent.ProcessRate4 = pr4;
agent.InterestRate4 = ir4;
agent.HeadRate5 = hr5;
agent.ProcessRate5 = pr5;
agent.InterestRate5 = ir5;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(agent);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改会员会员";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改会员信息成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'success',msg:'信息修改成功！'}");
}
}
}
catch (Exception ex)
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改会员信息失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'修改失败，出现未知异常！'}");
}
}
public ActionResult PostCommission()
{
APIDataDataContext db = APIDataContextProxy.APIDB;
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
OLog.PageName = "会员资金审核";
try
{
var agentid = Request["agentid"];
var createdate = Request["createdate"];
var Yjtc = Convert.ToDouble(Converter.ToFloat(Request["Yjtc"], 0).ToString("f4"));
var Yjjgf = Convert.ToDouble(Converter.ToFloat(Request["Yjjgf"], 0).ToString("f4"));
var Yjcx = Convert.ToDouble(Converter.ToFloat(Request["Yjcx"], 0).ToString("f4"));
var Yjxj = Convert.ToDouble(Converter.ToFloat(Request["Yjxj"], 0).ToString("f4"));
var allrate = Convert.ToDouble(Converter.ToFloat(Request["allrate"], 0).ToString("f4"));
TAgentCommission tac = new TAgentCommission();
tac.agentid = Convert.ToInt32(agentid);
tac.createdate = Convert.ToDateTime(createdate);
db.TAgentCommission.InsertOnSubmit(tac);
var ag = (from c in db.TAgents where c.ID == Convert.ToInt32(agentid) select c).FirstOrDefault();
#region 资金记录
TAccountMoney tam = new TAccountMoney();
tam.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tam.AgentId = ag.ID;
tam.TypeId = 4;
tam.OriginalMoney = ag.AccountMoney;
tam.CreateMoney = Yjtc;
tam.NowMoney = ag.AccountMoney + Yjtc;
if (tam.NowMoney < 0)
{
tam.NowMoney = 0;
}
tam.CreateTime = Convert.ToDateTime(createdate);
tam.UpDateTime = Convert.ToDateTime(createdate);
tam.Status = 2;
tam.TOrderId = 0;
db.TAccountMoney.InsertOnSubmit(tam);
TAccountMoney tams = new TAccountMoney();
tams.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tams.AgentId = ag.ID;
tams.TypeId = 5;
tams.OriginalMoney = tam.NowMoney;
tams.CreateMoney = Yjjgf;
tams.NowMoney = tam.NowMoney + Yjjgf;
if (tams.NowMoney < 0)
{
tams.NowMoney = 0;
}
tams.CreateTime = Convert.ToDateTime(createdate);
tams.UpDateTime = Convert.ToDateTime(createdate);
tams.Status = 2;
tams.TOrderId = 0;
db.TAccountMoney.InsertOnSubmit(tams);
TAccountMoney tams1 = new TAccountMoney();
tams1.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tams1.AgentId = ag.ID;
tams1.TypeId = 6;
tams1.OriginalMoney = tams.NowMoney;
tams1.CreateMoney = Yjcx;
tams1.NowMoney = tams.NowMoney + Yjcx;
if (tams1.NowMoney < 0)
{
tams1.NowMoney = 0;
}
tams1.CreateTime = Convert.ToDateTime(createdate);
tams1.UpDateTime = Convert.ToDateTime(createdate);
tams1.Status = 2;
tams1.TOrderId = 0;
db.TAccountMoney.InsertOnSubmit(tams1);
TAccountMoney tams2 = new TAccountMoney();
tams2.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tams2.AgentId = ag.ID;
tams2.TypeId = 7;
tams2.OriginalMoney = tams1.NowMoney;
tams2.CreateMoney = Yjxj;
tams2.NowMoney = tams1.NowMoney + Yjxj;
if (tams2.NowMoney < 0)
{
tams2.NowMoney = 0;
}
tams2.CreateTime = Convert.ToDateTime(createdate);
tams2.UpDateTime = Convert.ToDateTime(createdate);
tams2.Status = 2;
tams2.TOrderId = 0;
db.TAccountMoney.InsertOnSubmit(tams2);
#endregion
ag.AccountMoney = ag.AccountMoney + Yjtc + Yjjgf + Yjcx + Yjxj;
db.SubmitChanges();
var total = allrate + Yjxj;
StringBuilder sb = new StringBuilder();
sb.Append("{")
.AppendFormat(
"\"会员金额\"：\"{0}\",\"分红\"：\"{1}\",\"加工费\"：\"{2}\",\"仓息\"：\"{3}\",\"本级汇总\"：\"{4}\",\"下级汇总\"：\"{5}\",\"总计\"：\"{6}\"" +
"", ag.AccountMoney, Yjtc, Yjjgf, Yjcx, allrate, Yjxj, total).Append("}");
OLog.UpdateValue = sb.ToString();
OLog.BeforeValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改会员账户金额";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("true");
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改会员账户金额";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("false");
}
}
public ActionResult PostClosingEdit()
{
APIDataDataContext db = APIDataContextProxy.APIDB;
int TRealAccountsID = Converter.ToInt(Request["TRealAccountsID"], 0);
var password = Request["password"];
TOperationLog OLog = new TOperationLog();
TRealAccounts realAccount = new TRealAccounts();
if (!Request.IsAjaxRequest())
return Json(new { code = 0, msg = "非法请求！" });
int orderid = Converter.ToInt(Request["orderid"], 0);
if (orderid == 0)
return Json(new { code = 0, msg = "订单号错误！" });
int type = Converter.ToInt(Request["type"], 0);
if (!(type >= 1 && type <= 3))
return Json(new { code = 0, msg = "操作类型错误！" });
try
{
var user2 = (from c in db.TRealAccounts where c.ID == TRealAccountsID && c.PassWord == password select c).FirstOrDefault();
if (user2 == null)
{
return Json(new { code = 0, msg = "客户密码不正确！" });
}
var order = (from c in db.TOrders
where c.ID == orderid && c.OrderType == 2 && c.OrderState == 2
select c).FirstOrDefault();
if (order == null)
return Json(new { code = 0, msg = "订单不存在！" });
OLog.BeforeValue = ObjectToJson.ModelToJson(order);
if (type == 1 || type == 2)
{
OLog.PageName = "重新平仓";
OLog.UpdateValue = "";
bool orderType = Converter.ToInt(Request["OrderType"], 1) == 1 ? true : false;
double orderCount = Converter.ToFloat(Request["OrderCount"], order.OrderCount != null ? (float)order.OrderCount.Value : 0f);
double openPrice = Converter.ToFloat(Request["OpenPrice"], order.OpenPrice != null ? (float)order.OpenPrice.Value : 0f);
double loss = Converter.ToFloat(Request["Loss"], order.Loss != null ? (float)order.Loss.Value : 0f);
double profit = Converter.ToFloat(Request["Profit"], order.Profit != null ? (float)order.Profit.Value : 0f);
DateTime dtOpen = DateTime.Now;
if (!(DateTime.TryParse(Request["OpenTime"] + "", out dtOpen) && order.OpenTime != null))
dtOpen = order.OpenTime.Value;
DateTime dtClose = DateTime.Now;
if (!(DateTime.TryParse(Request["UpdateTime"] + "", out dtOpen) && order.UpdateTime != null))
dtClose = order.UpdateTime.Value;
double nowPrice = Converter.ToFloat(Request["NowPrice"], order.NowPrice != null ? (float)order.NowPrice.Value : 0f);
double deposit = Converter.ToFloat(Request["Deposit"], order.Deposit != null ? (float)order.Deposit.Value : 0f);
double interest = Converter.ToFloat(Request["Interest"], order.Interest != null ? (float)order.Interest.Value : 0f);
double proloss = Converter.ToFloat(Request["ProfitAndLoss"], order.ProfitAndLoss != null ? (float)order.ProfitAndLoss.Value : 0f);
order.Deal = orderType;
order.OrderCount = orderCount;
order.OpenPrice = openPrice;
order.Loss = loss;
order.OpenTime = dtOpen;
order.Profit = profit;
order.NowPrice = nowPrice;
order.Deposit = deposit;
order.UpdateTime = dtClose;
order.Interest = interest;
order.ProfitAndLoss = proloss;
if (type == 2)
{
OLog.PageName = "撤销平仓";
order.OrderType = 1;
order.OrderState = 1;
//撤销平仓要改余额
List<TAccountMoney> orders = db.TAccountMoney.Where(a => a.TOrderId == orderid).ToList();
double? yingkui = 0.0;
double? fee = 0.0;
foreach (TAccountMoney item in orders)
{
if (item.TypeId == 4)
{
yingkui -= item.CreateMoney;
}
if (item.TypeId == 5)
{
fee += item.CreateMoney;
}
db.TAccountMoney.DeleteOnSubmit(item);
}
realAccount = db.TRealAccounts.Where(r => r.ID == order.TRealAccountsID).FirstOrDefault();
OLog.BeforeValue += ObjectToJson.ModelToJson(realAccount);
realAccount.AccountMoney = realAccount.AccountMoney + yingkui + fee;
}
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(order) + ObjectToJson.ModelToJson(realAccount);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
}
else if (type == 3)
{
db.TOrders.DeleteOnSubmit(order);
db.SubmitChanges();
OLog.PageName = "删除交易";
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
}
return Json(new { code = 1, msg = "操作成功！" });
}
catch (System.Exception ex)
{
return Json(new { code = 0, msg = "服务器内部错误！" });
}
}
public ActionResult MoneySetEdit()
{
string ID = AdminProduct.Utils.Converter.ToString(Request.Form["Id"], "");
string OsName = AdminProduct.Utils.Converter.ToString(Request.Form["OsName"], "", null);
string IsHaveSigned = AdminProduct.Utils.Converter.ToString(Request.Form["IsHaveSigned"], "", null);
string MoneyInTime1_start = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInTime1_start"], "", null);
string MoneyInTime1_end = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInTime1_end"], "", null);
string MoneyInTime2_start = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInTime2_start"], "", null);
string MoneyInTime2_end = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInTime2_end"], "", null);
string MoneyInMin = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInMin"], "", null);
string MoneyInMax = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyInMax"], "", null);
string MoneyOutTime_start = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutTime_start"], "", null);
string MoneyOutTime_end = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutTime_end"], "", null);
string MoneyOutDayMax = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutDayMax"], "", null);
string MoneyOutMin = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutMin"], "", null);
string MoneyOutMax = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutMax"], "", null);
string MoneyOutCounterFee = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutCounterFee"], "", null);
string IsMoneyOutSure = AdminProduct.Utils.Converter.ToString(Request.Form["IsMoneyOutSure"], "", null);
string MoneyOutDayOfCount = AdminProduct.Utils.Converter.ToString(Request.Form["MoneyOutDayOfCount"], "", null);
TOperationLog OLog = new TOperationLog();
try
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
var sys = (from c in db.TSysPreference select c).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(sys);
if (sys != null)
{
sys.OsName = OsName;
sys.IsHaveSigned = IsHaveSigned == "TRUE";
sys.MoneyInTime1_start = TimeSpan.Parse(MoneyInTime1_start);
sys.MoneyInTime1_end = TimeSpan.Parse(MoneyInTime1_end);
sys.MoneyInTime2_start = TimeSpan.Parse(MoneyInTime2_start);
sys.MoneyInTime2_end = TimeSpan.Parse(MoneyInTime2_end);
sys.MoneyInMin = double.Parse(MoneyInMin);
sys.MoneyInMax = double.Parse(MoneyInMax);
sys.MoneyOutTime_start = TimeSpan.Parse(MoneyOutTime_start);
sys.MoneyOutTime_end = TimeSpan.Parse(MoneyOutTime_end);
sys.MoneyOutDayMax = double.Parse(MoneyOutDayMax);
sys.MoneyOutMin = double.Parse(MoneyOutMin);
sys.MoneyOutMax = double.Parse(MoneyOutMax);
sys.MoneyOutCounterFee = double.Parse(MoneyOutCounterFee);
sys.IsMoneyOutSure = IsMoneyOutSure == "TRUE";
sys.MoneyOutDayOfCount = int.Parse(MoneyOutDayOfCount);
OLog.PageName = "设置资金后台";
OLog.UpdateValue = ObjectToJson.ModelToJson(sys);
}
else
{
TSysPreference tsys = new TSysPreference();
tsys.OsName = OsName;
tsys.IsHaveSigned = IsHaveSigned == "TRUE";
tsys.MoneyInTime1_start = TimeSpan.Parse(MoneyInTime1_start);
tsys.MoneyInTime1_end = TimeSpan.Parse(MoneyInTime1_end);
tsys.MoneyInTime2_start = TimeSpan.Parse(MoneyInTime2_start);
tsys.MoneyInTime2_end = TimeSpan.Parse(MoneyInTime2_end);
tsys.MoneyInMin = double.Parse(MoneyInMin);
tsys.MoneyInMax = double.Parse(MoneyInMax);
tsys.MoneyOutTime_start = TimeSpan.Parse(MoneyOutTime_start);
tsys.MoneyOutTime_end = TimeSpan.Parse(MoneyOutTime_end);
tsys.MoneyOutDayMax = double.Parse(MoneyOutDayMax);
tsys.MoneyOutMin = double.Parse(MoneyOutMin);
tsys.MoneyOutMax = double.Parse(MoneyOutMax);
tsys.MoneyOutCounterFee = double.Parse(MoneyOutCounterFee);
tsys.IsMoneyOutSure = IsMoneyOutSure == "TRUE";
tsys.MoneyOutDayOfCount = int.Parse(MoneyOutDayOfCount);
db.TSysPreference.InsertOnSubmit(tsys);
OLog.PageName = "设置资金后台";
OLog.UpdateValue = ObjectToJson.ModelToJson(tsys);
// }
}
db.SubmitChanges();
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
return Content(ID.ToString());
}
}
catch
{
return Content("fail");
}
}
/// <summary>
/// 调整资金
/// </summary>
/// <param name="type">0表示客户，1表示会员</param>
/// <param name="createMoney">调整金额</param>
/// <param name="id">客户或会员的ID</param>
/// <param name="typeid">存款或取款</param>
/// <returns></returns>
public ActionResult MoneyChange(int type, double createMoney, int id, int typeid)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
try
{
TRealAccounts realAccount = new TRealAccounts();
TAgents agent = new TAgents();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
TAccountMoney accountMoney = new TAccountMoney() { CreateMoney = createMoney, TypeId = typeid, CreateTime = DateTime.Now, Status = 2, BankState=1,PlatformState=1,Examine=1 };
if (type == 0)
{
realAccount = db.TRealAccounts.Where(t => t.ID == id).FirstOrDefault();
accountMoney.OriginalMoney = realAccount.AccountMoney;
accountMoney.NowMoney = realAccount.AccountMoney + (typeid == 1 ? createMoney : (-1) * createMoney);
accountMoney.RealAccountId = id;
realAccount.AccountMoney = accountMoney.NowMoney;
if (typeid == 3 && realAccount.AccountMoney < 0)
{
return Json("余额不足！");
}
}
else
{
agent = db.TAgents.Where(t => t.ID == id).FirstOrDefault();
accountMoney.OriginalMoney = agent.AccountMoney;
accountMoney.NowMoney = agent.AccountMoney + (typeid == 1 ? createMoney : (-1) * createMoney);
accountMoney.AgentId = id;
agent.AccountMoney = (double)accountMoney.NowMoney;
if (typeid == 3 && agent.AccountMoney < 0)
{
return Json("余额不足！");
}
}
db.TAccountMoney.InsertOnSubmit(accountMoney);
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(accountMoney);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "调整金额";
Converter.InsertOperationLog(OLog);
return Json(1);
}
catch
{
return Json("服务器内部错误！");
}
}
}
public ActionResult PostProduct()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'非法请求'}");
int id = Converter.ToInt(Request.Form["id"], 0);
string pname = Converter.ToString(Request.Form["ProductName"]).Trim();
string tn = Converter.ToString(Request.Form["TableName"]).Trim();
string cn = Converter.ToString(Request.Form["ContractNumber"]).Trim();
string fix = Converter.ToString(Request.Form["Fixedly"]).Trim();
string scale = Converter.ToString(Request.Form["Scale"]).Trim();
string prof = Converter.ToString(Request.Form["ProfitSize"]).Trim();
string losize = Converter.ToString(Request.Form["LossSize"]).Trim();
string ensize = Converter.ToString(Request.Form["EntrustSize"]).Trim();
int isbuy = Converter.ToInt(Request.Form["IsBuy"], 0);
int issell = Converter.ToInt(Request.Form["IsSell"], 0);
int type1 = Converter.ToInt(Request.Form["OccupyFundsType"], 0);
int type2 = Converter.ToInt(Request.Form["OpenDeposit"], 0);
int type3 = Converter.ToInt(Request.Form["InterestType"], 0);
int sortNum = 0;
string sortNumStr = Request.Form["SortNum"];
int Base_TCurrencyId = Converter.ToInt(Request.Form["Base_TCurrencyId"], 0);
int Quote_TCurrencyId = Converter.ToInt(Request.Form["Quote_TCurrencyId"], 0);
string errMsg = "";
if (pname == "")
errMsg += "、产品名称不能为空；";
if (tn == "")
errMsg += "、数据来源不能为空；";
int cn1 = 0;
if (!int.TryParse(sortNumStr, out sortNum) || sortNum < 0)
errMsg += "、排列顺序必须为数字且为正整数；";
if (!int.TryParse(cn, out cn1) || cn1 < 0)
errMsg += "、合约数必须为大于或等于0的正数；";
double fix1 = 0;
if (!double.TryParse(fix, out fix1) || fix1 < 0)
errMsg += "、交易点差必须为大于或等于0的数；";
int scale1 = 0;
if (!int.TryParse(scale, out scale1) || scale1 < 0)
errMsg += "、小数点必须为大于或等于0的正数；";
double prof1 = 0;
if (!double.TryParse(prof, out prof1) || prof1 < 0)
errMsg += "、止盈距离必须为大于或等于0的数；";
double losize1 = 0;
if (!double.TryParse(losize, out losize1) || losize1 < 0)
errMsg += "、止盈距离必须为大于或等于0的数；";
double ensize1 = 0;
if (!double.TryParse(ensize, out ensize1) || ensize1 < 0)
errMsg += "、挂单距离必须为大于或等于0的数";
#region 保证金
double funds = 0;
if (type1 == 1)
{
string funds1 = Converter.ToString(Request.Form["Funds1"]).Trim();
if (!double.TryParse(funds1, out funds) || funds < 0)
errMsg += "、固定保证金数额不能为空；";
}
else if (type1 == 2)
{
string funds1 = Converter.ToString(Request.Form["Funds2"]).Trim();
if (!double.TryParse(funds1, out funds) || funds < 0)
errMsg += "、浮动保证金比率不能为空；";
}
else
errMsg += "、请选择固定保证金模式；";
#endregion
#region 加工费
double open = 0;
double close = 0;
if (type2 == 1)
{
string open1 = Converter.ToString(Request.Form["Open1"]).Trim();
string close1 = Converter.ToString(Request.Form["Close1"]).Trim();
if (!double.TryParse(open1, out open) || open < 0)
errMsg += "、开仓金额不能为空；";
if (!double.TryParse(close1, out close) || close < 0)
errMsg += "、平仓金额不能为空";
}
else if (type2 == 2)
{
string open2 = Converter.ToString(Request.Form["Open2"]).Trim();
string close2 = Converter.ToString(Request.Form["Close2"]).Trim();
if (!double.TryParse(open2, out open) || open < 0)
errMsg += "、开仓金额不能为空；";
if (!double.TryParse(close2, out close) || close < 0)
errMsg += "、平仓金额不能为空";
}
else
errMsg += "、请选择固定保证金模式；";
#endregion
#region 仓息
double buy = 0;
double sell = 0;
if (type3 == 1)
{
string buy1 = Converter.ToString(Request.Form["Buy1"]).Trim();
string sell1 = Converter.ToString(Request.Form["Sell1"]).Trim();
if (!double.TryParse(buy1, out buy) || buy < 0)
errMsg += "、买单金额不能为空；";
if (!double.TryParse(sell1, out sell) || sell < 0)
errMsg += "、卖单金额不能为空";
}
else if (type3 == 2)
{
string buy2 = Converter.ToString(Request.Form["Buy2"]).Trim();
string sell2 = Converter.ToString(Request.Form["Sell2"]).Trim();
if (!double.TryParse(buy2, out buy) || buy < 0)
errMsg += "、买单比率不能为空；";
if (!double.TryParse(sell2, out sell) || sell < 0)
errMsg += "、卖单比率不能为空";
}
else
errMsg += "、请选择仓息模式；";
#endregion
if (errMsg.Length > 0)
return Content("{result:'fail',msg:'" + errMsg + "'}");
try
{
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
//id>0表名是修改
if (id > 0)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
var entify = (from p in db.TProducts where p.ID != id && p.ProductName.ToLower() == pname.ToLower() select p).FirstOrDefault();
int count = (from p in db.TProducts where p.ID != id && p.ProductName.ToLower() == pname.ToLower() select p).Count();
if (count > 0)
return Content("{result:'fail',msg:'产品名称已存在，不能重复！'}");
var entity = db.TProducts.Where(p => p.ID == id).FirstOrDefault();
if (entity == null)
return Content("{result:'fail',msg:'修改失败，产品不存在！'}");
else
{
OLog.BeforeValue = ObjectToJson.ModelToJson(entity);
//var ProductName = (from c in db.TProductName where c.ProductCode == entity.ProductCode select c).FirstOrDefault();
//if (ProductName != null)
//{
// ProductName.Quote_TCurrencyId = Quote_TCurrencyId;
// ProductName.Base_TCurrencyId = Base_TCurrencyId;
//}
entity.ProductName = pname;
entity.ProductCode = entity.ProductTable = tn;
entity.ContractNumber = cn1;
entity.Fixedly = fix1;
entity.Scale = scale1;
entity.ProfitSize = prof1;
entity.LossSize = losize1;
entity.EntrustSize = ensize1;
entity.IsBuy = isbuy == 0 ? false : true;
entity.IsSell = issell == 0 ? false : true;
entity.OccupyFundsType = type1;
entity.OccupyFunds = funds;
entity.DepositType = type2;
entity.OpenDeposit = open;
entity.CloseDeposit = close;
entity.InterestType = type3;
entity.BuyInterest = buy;
entity.IsLook = true;
entity.SellInterest = sell;
entity.SortNum = sortNum;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(entity);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改交易商品";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'success',msg:'修改产品信息成功！'}");
}
}
}
else
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
int count = (from p in db.TProducts where p.ProductName.ToLower() == pname.ToLower() select p).Count();
if (count > 0)
return Content("{result:'fail',msg:'产品名称已存在，不能重复！'}");
TProducts entity = new TProducts();
//var ProductName = (from c in db.TProductName where c.ProductCode == entity.ProductCode select c).FirstOrDefault();
//if (ProductName != null)
//{
// //ProductName.Quote_TCurrencyId = Quote_TCurrencyId;
// //ProductName.Base_TCurrencyId = Base_TCurrencyId;
//}
entity.ProductName = pname;
entity.ProductCode = entity.ProductTable = tn;
entity.ContractNumber = cn1;
entity.Fixedly = fix1;
entity.Scale = scale1;
entity.ProfitSize = prof1;
entity.LossSize = losize1;
entity.EntrustSize = ensize1;
entity.IsBuy = isbuy == 0 ? false : true;
entity.IsSell = issell == 0 ? false : true;
entity.OccupyFundsType = type1;
entity.OccupyFunds = funds;
entity.DepositType = type2;
entity.OpenDeposit = open;
entity.CloseDeposit = close;
entity.InterestType = type3;
entity.BuyInterest = buy;
entity.SellInterest = sell;
entity.IsLook = true;
entity.SortNum = sortNum;
db.TProducts.InsertOnSubmit(entity);
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(entity);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "新增交易商品";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "产品增加成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'success',msg:'产品增加成功！'}");
}
}
}
catch
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "产品编辑失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'出现位置错误，操作失败！'}");
}
}
public ActionResult DelUserGroup()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
if (!Request.IsAjaxRequest())
return Content("fail");
int id = Converter.ToInt(Request["id"], 0);
try
{
if (id > 0)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
int defaultGroupID = Convert.ToInt32(db.TSysPreference.FirstOrDefault().DefaultDisplay);
if (defaultGroupID==id)
{
return Json(new {content="fail",msg="默认分组不能删除！" });//默认分组不能删除
}
var usergroup = (from c in db.TUserGroup where c.ID == id select c).FirstOrDefault();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = ObjectToJson.ModelToJson(usergroup);
if (usergroup != null)
{
db.TUserGroup.DeleteOnSubmit(usergroup);
//该分组下的用户都归到默认分组下
List<TRealAccounts> listAccount = db.TRealAccounts.Where(t => t.GroupID == usergroup.ID).ToList();
foreach (TRealAccounts a in listAccount)
{
a.GroupID = defaultGroupID;
}
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除分组管理";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "用户分组删除成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
db.SubmitChanges();
return Json(new { result = "success", msg = "删除成功！！" });
}
else
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "用户分组删除失败";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Json(new { result = "fail", msg = "删除失败！" });
}
}
}
else
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "用户分组删除失败";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Json(new { result = "fail", msg = "删除失败！" });
}
}
catch
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "用户分组修改失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("fail");
}
}
public ActionResult PostHoliday()
{
int id = 0; //Id
string Name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'非法请求'}");
string name = Converter.ToString(Request.Form["HolidayName"]).Trim();
string begin = Converter.ToString(Request.Form["BeginDate"]).Trim();
string end = Converter.ToString(Request.Form["EndDate"]).Trim();
string errMsg = "";
DateTime dt1 = DateTime.Now;
DateTime dt2 = DateTime.Now;
if (name == "")
errMsg += "名称不能为空；";
if (begin == "")
errMsg += "起始时间不能为空；";
else
{
if (!DateTime.TryParse(begin, out dt1))
errMsg += "起始时间无效；";
}
if (end == "")
errMsg += "起始时间不能为空；";
else
{
if (!DateTime.TryParse(end, out dt2))
errMsg += "结束时间无效；";
}
if (errMsg != "")
return Content("{result:'fail',msg:'" + errMsg + "'}");
try
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
int count = db.THoliday.Where(p => p.HolidayName.ToLower() == name.ToLower()).Count();
if (count > 0)
return Content("{result:'fail',msg:'假期休市已存在，不能重复！'}");
THoliday entity = new THoliday();
entity.CreateDate = DateTime.Now;
entity.HolidayName = name;
entity.BeginDate = dt1;
entity.EndDate = dt2;
db.THoliday.InsertOnSubmit(entity);
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(entity);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "添加假期休市";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "添加假期休市成功";
fruit = true;
Converter.InsertLog(id, Name, Type, msg, fruit);
return Content("{result:'success',msg:'添加成功！'}");
}
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "添加假期休市失败";
fruit = false;
Converter.InsertLog(id, Name, Type, msg, fruit);
return Content("{result:'fail',msg:'添加失败，未知错误！'}");
}
}
public ActionResult AddAgentInfos()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
var AgentName = Converter.ToString(Request["AgentName"], "");
var Account = Converter.ToString(Request["Account"], "");
var TelePhone = Converter.ToString(Request["TelePhone"], "");
var Email = Converter.ToString(Request["Email"], "");
var Status = Converter.ToInt(Request["Status"], -1);
var CityCode = Converter.ToString(Request["CityCode"], "");
var Address = Converter.ToString(Request["Address"], "");
var DirectAgentID = Converter.ToInt(Request["DirectAgentID"], 0);
var OpenerID = Convert.ToInt32(Session["ID"]); //
DateTime dt = DateTime.Now;
var OpenTime = dt;
var IdCardNo = Converter.ToString(Request["IdCardNo"], "");
var BankID = Converter.ToInt(Request["BankID"], -1);
var SavingsAccount = Converter.ToString(Request["SavingsAccount"], "");
var AllowDevelopCustomers = Converter.ToInt(Request["AllowDevelopCustomers"], -1);
var AllowDevelopAgents = Converter.ToInt(Request["AllowDevelopAgents"], -1);
var GroupID = Converter.ToInt(Request["GroupID"], -1);
//var password = Request["PassWord"];
var Branch = Converter.ToString(Request["Branch"], "");
var savingsName = Converter.ToString(Request["SavingsName"], "");
#region 返佣信息
var hr1= Converter.ToFloat(Request["HeadRate1"]);
var pr1=Converter.ToFloat(Request["ProcessRate1"]);
var ir1 = Converter.ToFloat(Request["InterestRate1"]);
var hr2 = Converter.ToFloat(Request["HeadRate2"]);
var pr2 = Converter.ToFloat(Request["ProcessRate2"]);
var ir2 = Converter.ToFloat(Request["InterestRate2"]);
var hr3 = Converter.ToFloat(Request["HeadRate3"]);
var pr3 = Converter.ToFloat(Request["ProcessRate3"]);
var ir3 = Converter.ToFloat(Request["InterestRate3"]);
var hr4 = Converter.ToFloat(Request["HeadRate4"]);
var pr4 = Converter.ToFloat(Request["ProcessRate4"]);
var ir4 = Converter.ToFloat(Request["InterestRate4"]);
var hr5 = Converter.ToFloat(Request["HeadRate5"]);
var pr5 = Converter.ToFloat(Request["ProcessRate5"]);
var ir5 = Converter.ToFloat(Request["InterestRate5"]);
var depth = Converter.ToInt(Request["Depth"]);
#endregion
#region 数据校验
bool isValid = true;
int i = 0;
if (string.IsNullOrEmpty(AgentName))
{
msg += (++i).ToString() + "、会员名不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(Account))
{
msg += (++i).ToString() + "、会员帐号不能为空！<br />";
isValid = false;
}
else
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
int count = db.TAgents.Count(t => t.Account == Account);
if (count > 0)
{
msg += (++i).ToString() + "、会员帐号已经存在！<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(TelePhone))
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
int count = db.TAgents.Count(t => t.TelePhone == TelePhone);
if (count > 0)
{
msg += (++i).ToString() + "、联系方式已经存在！<br />";
isValid = false;
}
}
}
if (!string.IsNullOrEmpty(Email))
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
int count = db.TAgents.Count(t => t.Email == Email);
if (count > 0)
{
msg += (++i).ToString() + "、联系邮箱已经存在！<br />";
isValid = false;
}
}
}
if (string.IsNullOrEmpty(IdCardNo))
{
msg += (++i).ToString() + "、身份证号不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(SavingsAccount))
{
msg += (++i).ToString() + "、银行卡号不能为空！<br />";
isValid = false;
}
if (BankID == -1)
{
msg += (++i).ToString() + "、开户银行不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(CityCode))
{
msg += (++i).ToString() + "、开户行所在地不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(Branch))
{
msg += (++i).ToString() + "、银行支行名不能为空！<br />";
isValid = false;
}
if (BankID == -1)
{
msg += (++i).ToString() + "、开户银行不能为空！<br />";
isValid = false;
}
#endregion
if (isValid)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
int cityId = (from c in db.TCities where c.CityCode == CityCode select c.ID).FirstOrDefault();
TAgents t = new TAgents();
t.AgentName = AgentName;
t.Account = Account;
t.TelePhone = TelePhone;
t.Email = Email;
t.Status = Status;
t.CityID = cityId;
t.Address = Address;
t.DirectAgentID = DirectAgentID;
t.OpenerID = OpenerID;
t.OpenTime = Convert.ToDateTime(OpenTime);
//t.LastLoginIP = LastLoginIP;
t.IdCardNo = IdCardNo;
t.BankID = BankID;
t.SavingsAccount = SavingsAccount;
t.AllowDevelopCustomers = Convert.ToBoolean(AllowDevelopCustomers);
t.AllowDevelopAgents = Convert.ToBoolean(AllowDevelopAgents);
t.GroupID = GroupID;
t.PassWord = Account;
t.SavingsName = savingsName;
t.Branch = Branch;
t.HeadRate1 = hr1;
t.ProcessRate1 = pr1;
t.InterestRate1 = ir1;
t.HeadRate2 = hr2;
t.ProcessRate2 = pr2;
t.InterestRate2 = ir2;
t.HeadRate3 = hr3;
t.ProcessRate3 = pr3;
t.InterestRate3 = ir3;
t.HeadRate4 = hr4;
t.ProcessRate4 = pr4;
t.InterestRate4 = ir4;
t.HeadRate5 = hr5;
t.ProcessRate5 = pr5;
t.InterestRate5 = ir5;
t.Depth = depth;
db.TAgents.InsertOnSubmit(t);
db.SubmitChanges();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
OLog.UpdateValue = ObjectToJson.ModelToJson(t);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "添加会员会员";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "添加会员成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'添加成功！'}");
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
//msg = "添加会员失败";
fruit = false;
Converter.InsertLog(id, name, Type, "添加会员失败", fruit);
return Content("{result:'fail',msg:'" + msg + "'}");
}
}
public ActionResult PostAgentGroupInfo()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'会员不存在！'}");
int id = Converter.ToInt(Request.Form["id"], 0);
bool isValid = true;
string errMsg = "";
string gname = Converter.ToString(Request.Form["gname"]).Trim();
if (gname == "")
{
errMsg += "分组名不能为空；";
isValid = false;
}
//int cycle = Converter.ToInt(Request.Form["cycle"], 0);
//if (cycle <= 0)
//{
// errMsg += "结算周期不能为空；";
// isValid = false;
//}
//int sway = Converter.ToInt(Request.Form["sway"], 0);
//if (sway <= 0)
//{
// errMsg += "结算方式不能为空；";
// isValid = false;
//}
//float lev = 0f;
//string leverage = Converter.ToString(Request.Form["leverage"]).Trim();
//if (leverage == "")
//{
// errMsg += "保证金杠杆不能为空；";
// isValid = false;
//}
//else if (!float.TryParse(leverage, out lev))
//{
// errMsg += "保证金杠杆必须为数值；";
// isValid = false;
//}
//float ret = 0f;
//string retrate = Converter.ToString(Request.Form["retrate"]).Trim();
//if (retrate == "")
//{
// errMsg += "返还费用税率不能为空；";
// isValid = false;
//}
//else if (!float.TryParse(retrate, out ret))
//{
// errMsg += "返还费用税率必须为数值；";
// isValid = false;
//}
float prat = 0f;
string prate = Converter.ToString(Request.Form["prate"]).Trim();
if (prate == "")
{
errMsg += "加工费分成比率不能为空；";
isValid = false;
}
else if (!float.TryParse(prate, out prat))
{
errMsg += "加工费分成比率必须为数值；";
isValid = false;
}
float br = 0f;
string brate = Converter.ToString(Request.Form["brate"]).Trim();
if (brate == "")
{
errMsg += "头寸分成比率不能为空；";
isValid = false;
}
else if (!float.TryParse(brate, out br))
{
errMsg += "头寸分成比率必须为数值；";
isValid = false;
}
float nr = 0f;
string nrate = Converter.ToString(Request.Form["nrate"]).Trim();
//if (nrate == "")
//{
// errMsg += "下级会员分成占比不能为空；";
// isValid = false;
//}
//else if (!float.TryParse(nrate, out nr))
//{
// errMsg += "下级会员分成占比必须为数值；";
// isValid = false;
//}
float ir = 0f;
string irate = Converter.ToString(Request.Form["irate"]).Trim();
if (irate == "")
{
errMsg += "仓息分成比率不能为空；";
isValid = false;
}
else if (!float.TryParse(irate, out ir))
{
errMsg += "仓息分成比率必须为数值；";
isValid = false;
}
float fe = 0f;
//string fee = Converter.ToString(Request.Form["fee"]).Trim();
//if (fee == "")
//{
// errMsg += "客户赠金不能为空；";
// isValid = false;
//}
//else if (!float.TryParse(fee, out fe))
//{
// errMsg += "客户赠金必须为数值；";
// isValid = false;
//}
//int bway = Converter.ToInt(Request.Form["bway"], 0);
//if (bway <= 0)
//{
// errMsg += "赠金方式不能为空；";
// isValid = false;
//}
int asr = Converter.ToInt(Request.Form["asr"], 0);
int ar = Converter.ToInt(Request.Form["ar"], 0);
TOperationLog OLog = new TOperationLog();
if (isValid == false)
return Content("{result:'fail',msg:'" + errMsg + "'}");
try
{
if (id <= 0)
{
TAgentGroup group = new TAgentGroup();
group.GroupName = gname;
group.CreateTime = DateTime.Now;
//group.SettleWay = sway;
//group.SettleCycle = cycle;
//group.Leverage = Convert.ToDouble(lev.ToString("F4"));
//group.ReturnRate = Convert.ToDouble(ret.ToString("F4"));
group.ProcessRate = Convert.ToDouble(prat.ToString("F4"));
group.HeadRate = Convert.ToDouble(br.ToString("F4"));
group.InterestRate = Convert.ToDouble(ir.ToString("F4"));
group.NextRate = Convert.ToDouble(nr.ToString("F4"));
group.SubAgentFee = Convert.ToDouble(fe.ToString("F4"));
//group.BonusWay = bway;
group.AllowInspectionReport = ar == 0 ? false : true;
group.AllowSubAgentRead = asr == 0 ? false : true;
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
db.TAgentGroup.InsertOnSubmit(group);
db.SubmitChanges();
//记录操作日志
OLog.BeforeValue = "";
OLog.UpdateValue = ObjectToJson.ModelToJson(group);
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "新增会员分组";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组添加成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
}
return Content("{result:'success',msg:'会员分组添加成功！'}");
}
else
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
var group = (from p in db.TAgentGroup where p.ID == id select p).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(group);
if (group == null)
{
return Content("{result:'fail',msg:'修改失败，分组不存在！'}");
}
group.GroupName = gname;
//group.SettleWay = sway;
//group.SettleCycle = cycle;
//group.Leverage = Convert.ToDouble(lev.ToString("F4"));
//group.ReturnRate = Convert.ToDouble(ret.ToString("F4"));
group.ProcessRate = Convert.ToDouble(prat.ToString("F4"));
group.HeadRate = Convert.ToDouble(br.ToString("F4"));
group.InterestRate = Convert.ToDouble(ir.ToString("F4"));
group.NextRate = Convert.ToDouble(nr.ToString("F4"));
group.SubAgentFee = Convert.ToDouble(fe.ToString("F4"));
//group.BonusWay = bway;
group.AllowInspectionReport = ar == 0 ? false : true;
group.AllowSubAgentRead = asr == 0 ? false : true;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(group);
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改会员分组";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组修改成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'success',msg:'修改成功！'}");
}
}
APIDataDataContext db2 = APIDataContextProxy.APIDB;
string sql = "UPDATE TAgentGroup SET NextRate = " + nr.ToString("F4");
db2.ExecuteCommand(sql);
db2.SubmitChanges();
}
catch
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组修改失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'修改失败，出现未知异常！'}");
}
}
//删除员工分组
public ActionResult DelGroup(int id)
{
if (id == 1)
{
return Json("超级管理员不能删除！");
}
APIDataDataContext db = APIDataContextProxy.APIDB;
{
int count = (from g in db.TStaffs where g.GroupID == id select g).Count();
if (count > 0)
{
return Json("该分组下有员工，不能删除");//该分组下有员工，不能删除
}
try
{
var del = (from g in db.TStaffGroup where g.ID == id select g).FirstOrDefault();
db.TStaffGroup.DeleteOnSubmit(del);
db.SubmitChanges();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = ObjectToJson.ModelToJson(del);
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除员工分组";
Converter.InsertOperationLog(OLog);
return Json(1);//删除成功
}
catch (Exception)
{
return Json("服务器出现内部错误，删除失败!");//删除出现意外情况，删除失败
}
}
}
public ActionResult PostTAnalsTs()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
if (!Request.IsAjaxRequest())
return Content("{result:'fail',msg:'非法请求!'}");
int Id = Converter.ToInt(Request.Form["Id"], 0);
string title = Converter.ToString(Request.Form["Title"]).Trim();
string body = Converter.ToString(Request.Form["MsgBody"]).Trim();
string timer = Converter.ToString(Request.Form["timer"]).Trim();
string date = Converter.ToString(Request.Form["sendtime"]).Trim();
string errMsg = "";
DateTime dt = DateTime.Now;
if (title == "")
errMsg += "标题不能为空；";
if (body == "")
errMsg += "正文不能为空；";
if (timer == "1")
{
if (!DateTime.TryParse(date, out dt))
errMsg += "定时分析必须设置时间；";
else if (DateTime.Now > dt)
errMsg += "您设置的时间已过期；";
}
if (errMsg != "")
{
return Content("{result:'fail',msg:'" + errMsg + "'}");
}
if (Id > 0)
{
try
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
var arr = (from b in db.TAnalysis where b.ID == Id select b).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(arr);
arr.Title = title;
arr.MsgBody = body;
arr.SendTime = DateTime.Now;
if (timer=="1")
{
arr.SendTime = dt;
}
db.SubmitChanges();
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改分析成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
OLog.UpdateValue = ObjectToJson.ModelToJson(arr);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改分析";
Converter.InsertOperationLog(OLog);
return Content("{result:'success',msg:'分析修改成功!'}");
}
}
catch (Exception ex)
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "修改分析失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'未知错误，分析修改失败!'}");
}
}
else
{
try
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
TAnalysis entity = new TAnalysis();
entity.Title = title;
entity.MsgBody = body;
entity.SendTime = DateTime.Now;
if (timer == "1")
{
entity.SendTime = dt;
}
entity.SenderID = Convert.ToInt32(Session["ID"]);
db.TAnalysis.InsertOnSubmit(entity);
db.SubmitChanges();
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "发布分析成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
OLog.UpdateValue = ObjectToJson.ModelToJson(entity);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "发布分析";
Converter.InsertOperationLog(OLog);
return Content("{result:'success',msg:'分析发布成功!'}");
}
}
catch (Exception ex)
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "发布分析失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'fail',msg:'未知错误，分析发送失败!'}");
}
}
}
//修改员工分组
public ActionResult UpdateGroup(int id, string groupName, string desc)
{
APIDataDataContext db = APIDataContextProxy.APIDB;
{
try
{
TOperationLog OLog = new TOperationLog();
TStaffGroup group = (from g in db.TStaffGroup where g.ID == id select g).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(group);
if (group == null)
{
return Json(-1);//没有找到对应分组
}
group.GroupName = groupName;
group.Descriptions = desc;
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(group);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "修改员工分组";
Converter.InsertOperationLog(OLog);
return Json(group.ID);//修改成功
}
catch (Exception)
{
return Json(0);//修改出现意外情况，删除失败
}
}
}
/// <summary>
/// 写入操作日志
/// </summary>
/// <param name="model"></param>
public static void InsertOperationLog(TOperationLog model)
{
//记录登录IP
model.IP = IPAddress;
//后台为写死员工操作
APIDataDataContext db = DBFactory.DB;
db.TOperationLog.InsertOnSubmit(model);
db.SubmitChanges();
}
public ActionResult EditPositionPassword()
{
var password = Request["password"];
var orderid = Converter.ToInt(Request["orderid"], 0);
var types = Request["types"];//0保存 1删除 2平仓
var OrderNum = Request["OrderNum"];
var ProductID = Request["ProductID"];
var TRealAccountsID = Converter.ToInt(Request["TRealAccountID"], 0);
var Deal = Request["Deal"];
var OrderCount = Request["OrderCount"];
var OpenPrice = Request["OpenPrice"];
var Loss = Request["Loss"];
var OpenTime = Request["OpenTime"];
var Profit = Request["Profit"];
var NowPrice = Request["NowPrice"];
var Deposit = Request["Deposit"];
var UpdateTime = Request["UpdateTime"];
APIDataDataContext db = APIDataContextProxy.APIDB;
TOperationLog OLog = new TOperationLog();
var user2 = (from c in db.TRealAccounts where c.ID == TRealAccountsID && c.PassWord == password select c).FirstOrDefault();
if (user2 == null)
{
return Json(new { code = "0", msg = "客户密码不正确！" });
}
try
{
if (orderid > 0)
{
var order = (from c in db.TOrders where c.ID == orderid select c).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(order);
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
if (order != null)
{
if (types == "1")
{
#region 删除订单
db.TOrders.DeleteOnSubmit(order);
db.SubmitChanges();
OLog.UpdateValue = "";
//写入操作日志
OLog.PageName = "删除在手订单";
Converter.InsertOperationLog(OLog);
return Json(new { code = "1", msg = "提交成功！" });
#endregion
}
else if (types == "0")
{
#region 修改保存
order.ProductID = Converter.ToInt(ProductID, 0);
order.TRealAccountsID = Converter.ToInt(TRealAccountsID, 0);
order.Deal = Deal == "1" ? true : false;
order.OrderCount = Converter.ToInt(OrderCount, 0);
order.OpenPrice = Converter.ToFloat(OpenPrice, 0);
order.Loss = Converter.ToFloat(Loss, 0);
order.OpenTime = Convert.ToDateTime(OpenTime);
order.Profit = Converter.ToFloat(Profit, 0);
order.NowPrice = Converter.ToFloat(NowPrice, 0);
order.Deposit = Converter.ToFloat(Deposit, 0);
order.UpdateTime = Convert.ToDateTime(UpdateTime);
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(order);
//写入操作日志
OLog.PageName = "修改在手订单";
Converter.InsertOperationLog(OLog);
return Json(new { code = "1", msg = "提交成功！" });
#endregion
}
else
{
#region 平仓
int OrderId = orderid;
var item = (from c in db.TOrders
where c.ID == OrderId
&& c.OrderState == 1
&& c.OrderType == 1
select c).FirstOrDefault();
if (item != null)
{
var product = (from c in db.TProducts
join b in db.TLastClose on c.ProductCode equals b.ProductCode
where c.ID == item.ProductID
orderby c.ID
select new
{
c,
b.LastClose,
b.LastUpdateTime
}).FirstOrDefault();
if (product != null)
{
var Scale = Converter.ToFloat(product.c.Scale, 2);
var nowdate = product.LastUpdateTime;
#region 加工费
double closedeposit = 0.0; //加工费
if (product.c.DepositType == 1)//固定
{
closedeposit = Converter.ToFloat(product.c.CloseDeposit, 0) * Converter.ToFloat(product.c.ContractNumber, 0) * Converter.ToFloat(item.OrderCount, 0);
}
else if (product.c.DepositType == 2)//浮动
{
if (item.Deal == false)
closedeposit = 0.01 * Converter.ToFloat(product.c.CloseDeposit, 0) * (Converter.ToFloat(product.LastClose, 0)) * Converter.ToFloat(product.c.ContractNumber, 0) * Converter.ToFloat(item.OrderCount, 0);
else
closedeposit = 0.01 * Converter.ToFloat(product.c.CloseDeposit, 0) * (Converter.ToFloat(product.LastClose, 0) + Converter.ToFloat(product.c.Fixedly, 0)) * Converter.ToFloat(product.c.ContractNumber, 0) * Converter.ToFloat(item.OrderCount, 0);
}
closedeposit = Converter.ToFloat(closedeposit.ToString("F" + Scale), 0);
#endregion
item.Deposit = Converter.ToFloat((Converter.ToFloat(item.Deposit, 0) + closedeposit).ToString("F" + Scale), 0);
double LastClose = 0.0; //市场价 收盘价
double Spread = 0.0; //点数
//计算盈亏
if (item.Deal == false)//卖出
{
LastClose = Converter.ToFloat(product.LastClose, 0) + Converter.ToFloat(product.c.Fixedly, 0);
Spread = Converter.ToFloat(item.OpenPrice, 0) - LastClose;
}
else if (item.Deal == true)//买入
{
LastClose = Converter.ToFloat(product.LastClose, 0);
Spread = LastClose - Converter.ToFloat(item.OpenPrice, 0);
}
item.Spread = Converter.ToFloat(Spread.ToString("F" + Scale), 0);
item.ProfitAndLoss = Converter.ToFloat((Converter.ToFloat(Spread * item.OrderCount, 0) * Converter.ToFloat(product.c.ContractNumber, 0)).ToString("F" + Scale), 0);
item.NowPrice = Converter.ToFloat(LastClose.ToString("F" + Scale), 0);
item.NetProfit = Converter.ToFloat((Converter.ToFloat(item.ProfitAndLoss, 0) - Converter.ToFloat(item.Deposit, 0) - Converter.ToFloat(item.Interest, 0)).ToString("F" + Scale), 0);
item.UpdateTime = nowdate;
item.OrderState = 2;
item.OrderType = 2;
item.CloseType = "授权平仓";
var user = (from c in db.TRealAccounts where c.ID == item.TRealAccountsID select c).FirstOrDefault();
try
{
var agent = (from c in db.TAgents
join b in db.TAgentGroup on c.GroupID equals b.ID
where c.ID == user.AgendID
select new
{
c.ID,
c.DirectAgentID,
c.Depth,
c.HeadRate1,
c.ProcessRate1,
c.InterestRate1,
c.HeadRate2,
c.ProcessRate2,
c.InterestRate2,
c.HeadRate3,
c.ProcessRate3,
c.InterestRate3,
c.HeadRate4,
c.ProcessRate4,
c.InterestRate4,
c.HeadRate5,
c.ProcessRate5,
c.InterestRate5,
GID = b.ID,
b.GroupName,
b.ProcessRate,
b.HeadRate,
b.InterestRate,
b.NextRate
}).FirstOrDefault();
#region 分成
if (agent != null)
{
//查询客户所属会员的分成
double HeadRate = Convert.ToDouble(Converter.ToFloat(agent.HeadRate, 0).ToString("F4")) * 0.01;
double ProcessRate = Convert.ToDouble(Converter.ToFloat(agent.ProcessRate, 0).ToString("F4")) * 0.01;
double InterestRate = Convert.ToDouble(Converter.ToFloat(agent.InterestRate, 0).ToString("F4")) * 0.01;
//计算分成
double HeadInfo = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
double ProcessInfo = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
double InterestInfo = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tar = new TAgentRate();
tar.HeadRate = HeadInfo.ToString();
tar.ProcessRate = ProcessInfo.ToString();
tar.InterestRate = InterestInfo.ToString();
tar.AllRate = (HeadInfo + ProcessInfo + InterestInfo).ToString();
tar.NextHeadRate = "0";
tar.NextProcessRate = "0";
tar.NextInterestRate = "0";
tar.NextAllRate = "0";
tar.Date = DateTime.Now;
tar.TAgentId = agent.ID;
tar.TOrderId = item.ID;
IList<TAgentRate> tarlist = new List<TAgentRate>();
int depth = agent.Depth;//深度
if (depth > 6)
depth = 6;
var ag = (from c in db.TAgents where c.ID == agent.ID select c).FirstOrDefault();
var age = ag;
for (int i = 1; i < depth; i++)
{
if (i == 1)
{
//会员的分成
HeadRate = Convert.ToDouble(Converter.ToFloat(age.HeadRate1, 0).ToString("F4")) * 0.01;
ProcessRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate1, 0).ToString("F4")) * 0.01;
InterestRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate1, 0).ToString("F4")) * 0.01;
//计算分成
var HeadInfo_ = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
var ProcessInfo_ = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
var InterestInfo_ = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tars = new TAgentRate();
tars.HeadRate = "0";
tars.ProcessRate = "0";
tars.InterestRate = "0";
tars.AllRate = "0";
tars.NextHeadRate = HeadInfo_.ToString();
tars.NextProcessRate = ProcessInfo_.ToString();
tars.NextInterestRate = InterestInfo_.ToString();
tars.NextAllRate = (HeadInfo_ + ProcessInfo_ + InterestInfo_).ToString();
tars.Date = DateTime.Now;
tars.TAgentId = ag.DirectAgentID;
tars.TOrderId = item.ID;
tarlist.Add(tars);
tar.HeadRate = (Convert.ToDouble(tar.HeadRate) - HeadInfo_).ToString("F4");
tar.ProcessRate = (Convert.ToDouble(tar.ProcessRate) - ProcessInfo_).ToString("F4");
tar.InterestRate = (Convert.ToDouble(tar.InterestRate) - InterestInfo_).ToString("F4");
tar.AllRate = (Convert.ToDouble(tar.AllRate) - (HeadInfo_ + ProcessInfo_ + InterestInfo_)).ToString("F4");
}
else if (i == 2)
{
//会员的分成
HeadRate = Convert.ToDouble(Converter.ToFloat(age.HeadRate2, 0).ToString("F4")) * 0.01;
ProcessRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate2, 0).ToString("F4")) * 0.01;
InterestRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate2, 0).ToString("F4")) * 0.01;
//计算分成
var HeadInfo_ = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
var ProcessInfo_ = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
var InterestInfo_ = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tars = new TAgentRate();
tars.HeadRate = "0";
tars.ProcessRate = "0";
tars.InterestRate = "0";
tars.AllRate = "0";
tars.NextHeadRate = HeadInfo_.ToString();
tars.NextProcessRate = ProcessInfo_.ToString();
tars.NextInterestRate = InterestInfo_.ToString();
tars.NextAllRate = (HeadInfo_ + ProcessInfo_ + InterestInfo_).ToString();
tars.Date = DateTime.Now;
tars.TAgentId = ag.DirectAgentID;
tars.TOrderId = item.ID;
tarlist.Add(tars);
tar.HeadRate = (Convert.ToDouble(tar.HeadRate) - HeadInfo_).ToString("F4");
tar.ProcessRate = (Convert.ToDouble(tar.ProcessRate) - ProcessInfo_).ToString("F4");
tar.InterestRate = (Convert.ToDouble(tar.InterestRate) - InterestInfo_).ToString("F4");
tar.AllRate = (Convert.ToDouble(tar.AllRate) - (HeadInfo_ + ProcessInfo_ + InterestInfo_)).ToString("F4");
}
else if (i == 3)
{
//会员的分成
HeadRate = Convert.ToDouble(Converter.ToFloat(age.HeadRate3, 0).ToString("F4")) * 0.01;
ProcessRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate3, 0).ToString("F4")) * 0.01;
InterestRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate3, 0).ToString("F4")) * 0.01;
//计算分成
var HeadInfo_ = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
var ProcessInfo_ = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
var InterestInfo_ = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tars = new TAgentRate();
tars.HeadRate = "0";
tars.ProcessRate = "0";
tars.InterestRate = "0";
tars.AllRate = "0";
tars.NextHeadRate = HeadInfo_.ToString();
tars.NextProcessRate = ProcessInfo_.ToString();
tars.NextInterestRate = InterestInfo_.ToString();
tars.NextAllRate = (HeadInfo_ + ProcessInfo_ + InterestInfo_).ToString();
tars.Date = DateTime.Now;
tars.TAgentId = ag.DirectAgentID;
tars.TOrderId = item.ID;
tarlist.Add(tars);
tar.HeadRate = (Convert.ToDouble(tar.HeadRate) - HeadInfo_).ToString("F4");
tar.ProcessRate = (Convert.ToDouble(tar.ProcessRate) - ProcessInfo_).ToString("F4");
tar.InterestRate = (Convert.ToDouble(tar.InterestRate) - InterestInfo_).ToString("F4");
tar.AllRate = (Convert.ToDouble(tar.AllRate) - (HeadInfo_ + ProcessInfo_ + InterestInfo_)).ToString("F4");
}
else if (i == 4)
{
//会员的分成
HeadRate = Convert.ToDouble(Converter.ToFloat(age.HeadRate4, 0).ToString("F4")) * 0.01;
ProcessRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate4, 0).ToString("F4")) * 0.01;
InterestRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate4, 0).ToString("F4")) * 0.01;
//计算分成
var HeadInfo_ = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
var ProcessInfo_ = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
var InterestInfo_ = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tars = new TAgentRate();
tars.HeadRate = "0";
tars.ProcessRate = "0";
tars.InterestRate = "0";
tars.AllRate = "0";
tars.NextHeadRate = HeadInfo_.ToString();
tars.NextProcessRate = ProcessInfo_.ToString();
tars.NextInterestRate = InterestInfo_.ToString();
tars.NextAllRate = (HeadInfo_ + ProcessInfo_ + InterestInfo_).ToString();
tars.Date = DateTime.Now;
tars.TAgentId = ag.DirectAgentID;
tars.TOrderId = item.ID;
tarlist.Add(tars);
tar.HeadRate = (Convert.ToDouble(tar.HeadRate) - HeadInfo_).ToString("F4");
tar.ProcessRate = (Convert.ToDouble(tar.ProcessRate) - ProcessInfo_).ToString("F4");
tar.InterestRate = (Convert.ToDouble(tar.InterestRate) - InterestInfo_).ToString("F4");
tar.AllRate = (Convert.ToDouble(tar.AllRate) - (HeadInfo_ + ProcessInfo_ + InterestInfo_)).ToString("F4");
}
else if (i == 5)
{
//会员的分成
HeadRate = Convert.ToDouble(Converter.ToFloat(age.HeadRate5, 0).ToString("F4")) * 0.01;
ProcessRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate5, 0).ToString("F4")) * 0.01;
InterestRate = Convert.ToDouble(Converter.ToFloat(age.ProcessRate5, 0).ToString("F4")) * 0.01;
//计算分成
var HeadInfo_ = Convert.ToDouble((Converter.ToFloat(item.ProfitAndLoss, 0) * HeadRate * -1).ToString("F4"));
var ProcessInfo_ = Convert.ToDouble((Converter.ToFloat(item.Deposit, 0) * ProcessRate).ToString("F4"));
var InterestInfo_ = Convert.ToDouble((Converter.ToFloat(item.Interest, 0) * InterestRate).ToString("F4"));
TAgentRate tars = new TAgentRate();
tars.HeadRate = "0";
tars.ProcessRate = "0";
tars.InterestRate = "0";
tars.AllRate = "0";
tars.NextHeadRate = HeadInfo_.ToString();
tars.NextProcessRate = ProcessInfo_.ToString();
tars.NextInterestRate = InterestInfo_.ToString();
tars.NextAllRate = (HeadInfo_ + ProcessInfo_ + InterestInfo_).ToString();
tars.Date = DateTime.Now;
tars.TAgentId = ag.DirectAgentID;
tars.TOrderId = item.ID;
tarlist.Add(tars);
tar.HeadRate = (Convert.ToDouble(tar.HeadRate) - HeadInfo_).ToString("F4");
tar.ProcessRate = (Convert.ToDouble(tar.ProcessRate) - ProcessInfo_).ToString("F4");
tar.InterestRate = (Convert.ToDouble(tar.InterestRate) - InterestInfo_).ToString("F4");
tar.AllRate = (Convert.ToDouble(tar.AllRate) - (HeadInfo_ + ProcessInfo_ + InterestInfo_)).ToString("F4");
}
ag = (from c in db.TAgents where c.ID == ag.DirectAgentID select c).FirstOrDefault();
}
tarlist.Add(tar);
db.TAgentRate.InsertAllOnSubmit(tarlist);
db.SubmitChanges();
//AgentRate ar = new AgentRate();
//ar.Id = agent.ID;
//ar.DirectAgentID = Converter.ToInt(agent.DirectAgentID, 0);
//ar.Groupid = agent.GID;
//ar.Num = 0;
//ar.HeadInfo = HeadInfo;
//ar.ProcessInfo = ProcessInfo;
//ar.InterestInfo = InterestInfo;
//ar.NextheadInfo = HeadInfo;
//ar.NextprocessInfo = ProcessInfo;
//ar.NextinterestInfo = InterestInfo;
//if (ar.DirectAgentID > 0)
//{
// Converter.GetAgent(ar, ar, item.ID);
//}
//ar.HeadInfo = ar.NextheadInfo;
//ar.ProcessInfo = ar.NextprocessInfo;
//ar.InterestInfo = ar.NextinterestInfo;
//ar.NextheadInfo = 0;
//ar.NextprocessInfo = 0;
//ar.NextinterestInfo = 0;
//APIDataDataContext db2 = ConnectionHelper.Db;
//{
// TAgentRate tar = new TAgentRate();
// tar.HeadRate = ar.HeadInfo.ToString();
// tar.ProcessRate = ar.ProcessInfo.ToString();
// tar.InterestRate = ar.InterestInfo.ToString();
// tar.AllRate = (ar.HeadInfo + ar.ProcessInfo + ar.InterestInfo).ToString();
// tar.NextHeadRate = ar.NextheadInfo.ToString();
// tar.NextProcessRate = ar.NextprocessInfo.ToString();
// tar.NextInterestRate = ar.NextinterestInfo.ToString();
// tar.NextAllRate = (ar.NextheadInfo + ar.NextprocessInfo + ar.NextinterestInfo).ToString();
// tar.Date = DateTime.Now;
// tar.TAgentId = agent.ID;
// tar.TOrderId = item.ID;
// db2.TAgentRate.InsertOnSubmit(tar);
// db2.SubmitChanges();
//}
}
#endregion
}
catch
{
}
#region 资金记录
TAccountMoney tam = new TAccountMoney();
tam.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tam.RealAccountId = Converter.ToInt(item.TRealAccountsID, 0);
tam.TypeId = 4;
tam.OriginalMoney = user.AccountMoney;
tam.CreateMoney = item.ProfitAndLoss;
tam.NowMoney = user.AccountMoney + item.ProfitAndLoss;
if (tam.NowMoney < 0)
{
tam.NowMoney = 0;
}
tam.CreateTime = nowdate;
tam.UpDateTime = nowdate;
tam.Status = 2;
tam.TOrderId = item.ID;
db.TAccountMoney.InsertOnSubmit(tam);
TAccountMoney tams = new TAccountMoney();
tams.MoneyOrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
tams.RealAccountId = Converter.ToInt(item.TRealAccountsID, 0);
tams.TypeId = 5;
tams.OriginalMoney = tam.NowMoney;
tams.CreateMoney = item.Deposit;
tams.NowMoney = tam.NowMoney - item.Deposit;
if (tams.NowMoney < 0)
{
tams.NowMoney = 0;
}
tams.CreateTime = nowdate;
tams.UpDateTime = nowdate;
tams.Status = 2;
tams.TOrderId = item.ID;
db.TAccountMoney.InsertOnSubmit(tams);
#endregion
user.AccountMoney = user.AccountMoney + item.ProfitAndLoss - item.Deposit;
if (user.AccountMoney < 0)
{
user.AccountMoney = 0;
}
db.SubmitChanges();
OLog.UpdateValue = ObjectToJson.ModelToJson(order);
//写入操作日志
OLog.PageName = "平仓";
Converter.InsertOperationLog(OLog);
return Json(new { code = "1", msg = "提交成功！" });
}
else
{
return Json(new { code = "0", msg = "订单id不正确！" });
}
}
else
{
return Json(new { code = "0", msg = "订单id不正确！" });
}
#endregion
}
}
else
{
return Json(new { code = "0", msg = "提交失败请稍后在试！" });
}
}
else
{
//添加
#region 添加
TOrders to = new TOrders();
to.OrderNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
to.ProductID = Converter.ToInt(ProductID, 0);
to.TRealAccountsID = TRealAccountsID;
to.Deal = Deal == "1" ? true : false;
to.OrderCount = Converter.ToInt(OrderCount, 0);
to.OpenPrice = Converter.ToFloat(OpenPrice, 0);
to.Profit = Converter.ToFloat(Profit, 0);
to.Loss = Converter.ToFloat(Loss, 0);
to.NowPrice = Converter.ToFloat(NowPrice, 0);
to.Deposit = Converter.ToFloat(Deposit, 0);
to.Interest = 0;
double nowbaozhengjin = 0;
var product = (from c in db.TProducts where c.ID == Converter.ToInt(ProductID, 0) select c).FirstOrDefault();
int OccupyFundsType = product.OccupyFundsType.Value; //保证金方式(每单必须有的保证金) 1固定(每笔统一价) 2浮动(按照交易金额的百分比来算)
double OccupyFunds = Converter.ToFloat(product.OccupyFunds, 0); //保证金 固定（固定值*手数） 浮动（开仓价*固定值*手数）
if (OccupyFundsType == 1)
nowbaozhengjin = OccupyFunds * product.ContractNumber.Value * Converter.ToInt(OrderCount, 0);
else
nowbaozhengjin = 0.01 * OccupyFunds * product.ContractNumber.Value * Converter.ToFloat(NowPrice, 0) * Converter.ToInt(OrderCount, 0);
to.OccupyFunds = nowbaozhengjin;
to.OpenTime = Convert.ToDateTime(OpenTime);
to.UpdateTime = DateTime.Now;
try
{
to.OperatorIP = GetUserIp;
}
catch
{
return Json(new { code = "0", msg = "服务器内部错误！" });
}
to.OrderState = 1;
to.OrderType = 1;
to.EntrustType = 0;
db.TOrders.InsertOnSubmit(to);
db.SubmitChanges();
return Json(new { code = "1", msg = "提交成功！" });
#endregion
}
}
catch
{
return Json(new { code = "0", msg = "服务器内部错误！" });
}
}
/// <summary>
/// 删除员工
/// </summary>
/// <returns></returns>
public ActionResult DeleteStaff()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
APIDataDataContext db = APIDataContextProxy.APIDB;
int Id = Converter.ToInt(Request["Id"], 0);
var arr = (from b in db.TStaffs where b.ID == Id select b).FirstOrDefault();
if (arr != null)
{
try
{
db.TStaffs.DeleteOnSubmit(arr);
db.SubmitChanges();
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除用户成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
OLog.BeforeValue = ObjectToJson.ModelToJson(arr);
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除模拟账户";
Converter.InsertOperationLog(OLog);
return Content("true");
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除用户失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("删除失败");
}
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除用户失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("传入的参数不正确");
}
}
/// <summary>
/// 处理提款申请结果
/// </summary>
/// <returns></returns>
public ActionResult ApplyforResult(int orderId, int bankStatus, int? platformStatus, int? examine)
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
var res = "1";
try
{
//调用出金接口
Tranx tranx = new Tranx();
TAccountMoney ta = db.TAccountMoney.Where(s => s.Id == orderId).FirstOrDefault();
TOperationLog OLog = new TOperationLog();
bool isTrue = false;
OLog.BeforeValue = ObjectToJson.ModelToJson(ta);
if (bankStatus == -1 || bankStatus == -2)
{
OLog.PageName = bankStatus == -1 ? "确认出金成功" : "确认出金失败";
}
if (ta.AgentId == null)
{
#region 用户出金
switch (bankStatus)
{
case -1://确认出金成功
TRealAccounts tr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
var linq = db.TOrders.Where(o => o.TRealAccountsID == ta.RealAccountId && o.OrderType == 1 && o.OrderState == 1);
double NetProfit = 0.0;
if (linq.Count() > 0)
{
NetProfit = db.TOrders.Where(o => o.TRealAccountsID == ta.RealAccountId && o.OrderType == 1 && o.OrderState == 1).Sum(p => p.NetProfit.Value);
}
if ((NetProfit + tr.AccountMoney) < ta.CreateMoney)
{
res = "余额不足!";//余额不足
}
else if (ta.Status > 1)
{
res = "订单状态错误！";
}
else
{
//调用出金接口
TRealAccounts account = db.TRealAccounts.Where(a => a.ID == ta.RealAccountId.Value).FirstOrDefault();
if (account != null)
{
RequestResult result = tranx.tranxTestMethod(account.Name, account.SavingsAccount, "PERSONAL", (ta.CreateMoney * 100).ToString(), db.TBanks.Where(b => b.Id == account.BankID).FirstOrDefault().BankName + account.Branch, "");
if (!result.IsSuccess)
{
return Json(0);
}
}
else
{
return Json(0);//用户不存在
}
ta.BankState = 1;
ta.PlatformState = 1;
ta.Examine = 1;
ta.Status = 2;
tr.AccountMoney = tr.AccountMoney - ta.CreateMoney;
}
break;
case -2://确认出金失败
ta.BankState = 2;
ta.PlatformState = 2;
ta.Examine = 2;
ta.Status = 3;
break;
default://提交处理其他
ta.BankState = bankStatus;
ta.PlatformState = platformStatus;
ta.Examine = examine;
if (examine == 0)
{
TRealAccounts trr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
TBanks tb = db.TBanks.Where(b => b.Id == trr.BankID).FirstOrDefault();
res = Converter.SetMoneyOrder(orderId.ToString(), trr.Name, ta.AccountNo, Converter.ToInt(ta.CreateMoney), ta.BankName, tb.Code);
}
break;
}
#endregion
}
else
{
#region 会员出金
switch (bankStatus)
{
case -1://确认出金成功
//TRealAccounts tr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
TAgents tg = db.TAgents.Where(t => t.ID == ta.AgentId).FirstOrDefault();
var linq = db.TOrders.Where(o => o.TRealAccountsID == ta.RealAccountId && o.OrderType == 1 && o.OrderState == 1);
double NetProfit = 0.0;
if (linq.Count() > 0)
{
NetProfit = db.TOrders.Where(o => o.TRealAccountsID == ta.RealAccountId && o.OrderType == 1 && o.OrderState == 1).Sum(p => p.NetProfit.Value);
}
if ((NetProfit + tg.AccountMoney) < ta.CreateMoney)
{
res = "余额不足!";//余额不足
}
else if (ta.Status > 1)
{
res = "订单状态错误！";
}
else
{
//调用出金接口
TAgents agent = db.TAgents.Where(a => a.ID == ta.AgentId.Value).FirstOrDefault();
if (agent != null)
{
RequestResult result = tranx.tranxTestMethod(agent.SavingsName, agent.SavingsAccount, "PERSONAL", (ta.CreateMoney * 100).ToString(), db.TBanks.Where(b => b.Id == agent.BankID).FirstOrDefault().BankName + agent.Branch, "");
if (!result.IsSuccess)
{
return Json(0);
}
}
else
{
return Json(0);//会员不存在
}
isTrue = true;
ta.BankState = 1;
ta.PlatformState = 1;
ta.Examine = 1;
ta.Status = 2;
tg.AccountMoney = ((double)tg.AccountMoney - (double)ta.CreateMoney);
}
break;
case -2://确认出金失败
ta.BankState = 2;
ta.PlatformState = 2;
ta.Examine = 2;
ta.Status = 3;
break;
default://提交处理其他
ta.BankState = bankStatus;
ta.PlatformState = platformStatus;
ta.Examine = examine;
if (examine == 0)
{
TRealAccounts trr = db.TRealAccounts.Where(t => t.ID == ta.RealAccountId).FirstOrDefault();
TBanks tb = db.TBanks.Where(b => b.Id == trr.BankID).FirstOrDefault();
res = Converter.SetMoneyOrder(orderId.ToString(), trr.Name, ta.AccountNo, Converter.ToInt(ta.CreateMoney), ta.BankName, tb.Code);
}
break;
}
#endregion
}
db.SubmitChanges();
if (isTrue)
{
OLog.UpdateValue = ObjectToJson.ModelToJson(ta);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
Converter.InsertOperationLog(OLog);
}
}
catch
{
res = "0";
}
return Json(res);
}
}
public ActionResult AddStaffs()
{
int id = 0; //Id
string Name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
var name = Converter.ToString(Request["StaffName"], "");
var Account = Converter.ToString(Request["Account"], "");
var GroupID = Converter.ToInt(Request["GroupID"], -1);
var TelePhone = Converter.ToString(Request["TelePhone"], "");
var Email = Converter.ToString(Request["Email"], "");
var Status = Converter.ToInt(Request["Status"], -1);
var DepartmentID = Converter.ToInt(Request["DepartmentID"], -1);
//var password = Converter.ToString(Request["Password"]);
var OpenerID = 1;
var LastUpdateTime = DateTime.Now;
var LastLoginIP = "192.168.1.2";
string returnMsg = string.Empty;
APIDataDataContext db = APIDataContextProxy.APIDB;
#region 参数校验
bool isStop = false;
int i = 0;
if (string.IsNullOrEmpty(name))
{
returnMsg += (++i).ToString() + "、员工名称不能为空。<br />";
isStop = true;
}
if (string.IsNullOrEmpty(Account))
{
returnMsg += (++i).ToString() + "、员工帐号不能为空。<br />";
isStop = true;
}
else
{
int count = db.TStaffs.Count(t => t.Account == Account);
if (count > 0)
{
returnMsg += (++i).ToString() + "、员工帐号已经存在。<br />";
isStop = true;
}
}
//if (string.IsNullOrEmpty(password))
//{
// returnMsg += (++i).ToString()+"、密码不能为空。<br />";
// isStop = true;
//}
if (!string.IsNullOrEmpty(TelePhone))
{
int countPh = db.TRealAccounts.Count(t => t.Phone == TelePhone);
if (countPh > 0)
{
returnMsg += (++i).ToString() + "、此联系电话已经存在。<br />";
isStop = true;
}
}
if (!string.IsNullOrEmpty(Email))
{
int countPh = db.TRealAccounts.Count(t => t.Phone == TelePhone);
if (countPh > 0)
{
returnMsg += (++i).ToString() + "、此联系邮箱已经存在。<br />";
isStop = true;
}
}
if (isStop)
{
return Json(new { code = 0, msg = returnMsg });
}
#endregion
TStaffs s = new TStaffs();
s.GroupID = GroupID;
s.StaffName = name;
s.Account = Account;
s.TelePhone = TelePhone;
s.Email = Email;
s.Status = Status;
s.DepartmentID = DepartmentID;
s.OpenerID = OpenerID;
s.LastUpdateTime = LastUpdateTime;
s.LastLoginIP = LastLoginIP;
s.Password = Account;
db.TStaffs.InsertOnSubmit(s);
db.SubmitChanges();
OLog.BeforeValue = "";
OLog.UpdateValue = ObjectToJson.ModelToJson(s);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "新增员工账户";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "添加员工成功";
fruit = true;
Converter.InsertLog(id, Name, Type, msg, fruit);
return Json(new { code = 1, msg = "添加成功！" });
}
public ActionResult DelAgentGroup()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
if (!Request.IsAjaxRequest())
return Content("fail");
int id = Converter.ToInt(Request["id"], 0);
try
{
if (id > 0)
{
using (APIDataDataContext db = APIDataContextProxy.APIDB)
{
var agentgroup = (from c in db.TAgentGroup where c.ID == id select c).FirstOrDefault();
if (agentgroup != null)
{
db.TAgentGroup.DeleteOnSubmit(agentgroup);
TOperationLog OLog = new TOperationLog();
//记录操作日志
OLog.BeforeValue = ObjectToJson.ModelToJson(agentgroup);
OLog.UpdateValue = "";
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除会员分组";
Converter.InsertOperationLog(OLog);
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组删除成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
db.SubmitChanges();
return Content("success");
}
else
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组删除失败";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("fail");
}
}
}
else
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组删除失败";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("fail");
}
}
catch
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "会员分组修改失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("fail");
}
}
public ActionResult Delete()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
int Id = Converter.ToInt(Request["Accountsid"], 0);
APIDataDataContext db = APIDataContextProxy.APIDB;
//查询此条实盘记录的orderyType orderyState 账号余额
var arr = (from b in db.TRealAccounts
where b.ID == Id
select new
{
//判断是否有在手、持仓单子
orderCount = (from o in db.TOrders where o.TRealAccountsID == b.ID && o.OrderState==1 && o.OrderType==1 select o.ID).Count(),
b.AccountMoney
}).FirstOrDefault();
//要是orderype==1 orderyState=1 账号余额大于0.01
if (arr.orderCount > 0 || arr.AccountMoney >= 0.01)
{
return Content("false");
}
else
{
try
{
var ra = (from b in db.TRealAccounts where b.ID == Id select b).FirstOrDefault();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = ObjectToJson.ModelToJson(ra);
if (ra != null)
{
db.TRealAccounts.DeleteOnSubmit(ra);
db.SubmitChanges();
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除客户";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除用户成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("true");
}
}
catch
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除用户失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("false");
}
}
return View();
}
/// <summary>
/// 删除会员
/// </summary>
/// <returns></returns>
public ActionResult DeletetTagent(int Id)
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false;
APIDataDataContext db = APIDataContextProxy.APIDB;
var arr = (from b in db.TAgents where b.ID == Id select b.AccountMoney).FirstOrDefault();
if (Id != 0)
{
if (arr <= 0)
{
TOperationLog OLog=new TOperationLog();
var Tagent = (from a in db.TAgents where a.ID == Id select a).FirstOrDefault();
OLog.BeforeValue = ObjectToJson.ModelToJson(Tagent);
string update = "update dbo.[TRealAccounts] set [AgendID]=0 where [AgendID]=" + Id;
db.ExecuteQuery<int>(update);
db.TAgents.DeleteOnSubmit(Tagent);
db.SubmitChanges();
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除会员会员";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除会员成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("true");
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除会员失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("删除会员失败");
}
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除会员失败";
fruit = false;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("删除会员失败");
}
}
public ActionResult AddInfors()
{
int id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
APIDataDataContext db = APIDataContextProxy.APIDB;
var Name = Converter.ToString(Request["Name"], ""); //姓名
var Account = Converter.ToString(Request["Account"], ""); //账号
var AccountType = Converter.ToInt(Request["AccountType"], -1); //账号类型 0为"模拟" 1为"实盘";
var Phone = Converter.ToString(Request["Phone"], ""); //联系方式
var Email = Converter.ToString(Request["Email"], ""); //email
var Status = Converter.ToInt(Request["Status"], -1); //状态
var CityCode = Request["CityCode"]; //地区
var Address = Converter.ToString(Request["Address"], ""); //地址
var agentid = Converter.ToInt(Request["agentid"], -1); //所属会员id
var OpenerID = Converter.ToInt(Request["staffs"], 0); //开户专员
DateTime dt = DateTime.Now;
var OpenTime = dt; //开户时间
var LastLoginTime = dt; //最后登陆时间
var LastLoginIP = ""; //登陆的ip
var IDCardNo = Converter.ToString(Request["IDCardNo"], ""); //身份证号
var Bankid = Converter.ToInt(Request["Bankid"], 0); //开户银行
var SavingsAccount = Converter.ToString(Request["SavingsAccount"], ""); //储蓄账号
var AllowTrade = Converter.ToInt(Request["AllowTrade"], -1); //交易操作
var AllowFinance = Converter.ToInt(Request["AllowFinance"], -1); //资金操作
var GroupID = Converter.ToInt(Request["GroupID"], -1); //用户分组
var AccountMoney = Converter.ToFloat(Request["AccountMoney"], 0); //账户余额
//var Password = Converter.ToString(Request["password"], ""); //密码
var Branch = Converter.ToString(Request["Branch"], "");//开户行支行
#region 数据校验
bool isValid = true;
int i = 0;
if (string.IsNullOrEmpty(Name))
{
msg += (++i).ToString() + "、客户名称不能为空！<br />";
isValid = false;
}
if (string.IsNullOrEmpty(Account))
{
msg += (++i).ToString() + "、账号不能为空！<br />";
isValid = false;
}
int count = db.TRealAccounts.Count(t => t.Account == Account);
if (count > 0)
{
msg += (++i).ToString() + "、该帐号已经存在！<br />";
isValid = false;
}
if (!string.IsNullOrEmpty(Phone))
{
count = db.TRealAccounts.Count(t => t.Phone == Phone);
if (count > 0)
{
msg += (++i).ToString() + "、该联系方式已经存在！<br />";
isValid = false;
}
}
if (!string.IsNullOrEmpty(Email))
{
count = db.TRealAccounts.Count(t => t.Email == Email);
if (count > 0)
{
msg += (++i).ToString() + "、该联系邮箱已经存在！<br />";
isValid = false;
}
}
//if (string.IsNullOrEmpty(Password))
//{
// msg += (++i).ToString()+"、密码不能为空！<br />";
// isValid = false;
//}
if (string.IsNullOrEmpty(IDCardNo))
{
msg += (++i).ToString() + "、身份证号不能为空！<br />";
isValid = false;
}
if (Bankid <= 0)
{
msg += (++i).ToString() + "、开户银行不能为空！<br />";
}
if (string.IsNullOrEmpty(SavingsAccount))
{
msg += (++i).ToString() + "、银行卡号不能为空！<br />";
isValid = false;
}
//if (string.IsNullOrEmpty(CityCode))
//{
// msg += (++i).ToString() + "、开户行所在地不能为空！<br />";
// isValid = false;
//}
//if (string.IsNullOrEmpty(Branch))
//{
// msg += (++i).ToString() + "、开户行支行不能为空！<br />";
// isValid = false;
//}
#endregion
if (isValid)
{
TRealAccounts trs = new TRealAccounts();
trs.Name = Name;
trs.Account = Account;
trs.AccountType = AccountType;
trs.Phone = Phone;
trs.Email = Email;
trs.PassWord = Account;
trs.Status = Status;
trs.CityID = (from c in db.TCities where c.CityCode == CityCode select c.ID).FirstOrDefault();
trs.Address = Address;
if (agentid > 0)
trs.AgendID = agentid;
else
trs.AgendID = (from c in db.TAgents select c.ID).FirstOrDefault();
trs.OpenerID = OpenerID;
trs.OpenTime = Convert.ToDateTime(OpenTime);
trs.LastLoginTime = Convert.ToDateTime(LastLoginTime);
trs.LastLoginIP = LastLoginIP;
trs.IDCardNo = IDCardNo;
trs.BankID = Bankid;
trs.SavingsAccount = SavingsAccount;
trs.AllowTrade = Convert.ToBoolean(AllowTrade);
trs.AllowFinance = Convert.ToBoolean(AllowFinance);
trs.GroupID = GroupID;
trs.AccountMoney = AccountMoney;
trs.Branch = Branch;
db.TRealAccounts.InsertOnSubmit(trs);
db.SubmitChanges();
TOperationLog OLog = new TOperationLog();
OLog.BeforeValue = "";
OLog.UpdateValue = ObjectToJson.ModelToJson(trs);
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "新增用户";
Converter.InsertOperationLog(OLog);
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "添加用户成功";
fruit = true;
Converter.InsertLog(id, name, Type, msg, fruit);
return Content("{result:'success',msg:'添加成功！'}");
}
else
{
//存入日志
id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
//msg = "添加用户失败";
fruit = false;
Converter.InsertLog(id, name, Type, "添加用户失败", fruit);
return Content("{result:'fail',msg:'" + msg + "'}");
}
}
public ActionResult KLineHistoryDel()
{
int Id = 0; //Id
string name = ""; //登陆名
string Type = ""; //type
string msg = ""; //提示信息
bool fruit = false; //结果
int ids = Converter.ToInt(Request["ids"], 1);
int id = Converter.ToInt(Request["id"], 1);
string type = Converter.ToString(Request["type"], "_01MINUTE");
APIDataDataContext db = APIDataContextProxy.APIDB;
TOperationLog OLog = new TOperationLog();
try
{
var productname = (from c in db.TProductName where c.ID == ids select c.TableName).FirstOrDefault();
string sql = "DELETE FROM [" + productname + type + "] WHERE id = " + id;
int i = db.ExecuteCommand(sql);
if (i > 0)
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除时段里的数据数据成功";
fruit = true;
Converter.InsertLog(Id, name, Type, msg, fruit);
OLog.BeforeValue = "{\"TableName\"：\"" + productname + type + "\",\"id\"：\"" + id + "\"}";
OLog.UpdateValue = "";
//写入操作日志
OLog.UserID = Convert.ToInt32(Session["ID"]);
OLog.UserType = 2;//0 用户 1 会员 2 员工
OLog.CreateDate = DateTime.Now;
OLog.PageName = "删除时段里的数据";
Converter.InsertOperationLog(OLog);
return Content("true");
}
else
{
//存入日志
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除时段里的数据数据失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("false");
}
}
catch
{
Id = Convert.ToInt32(Session["ID"]); //id
Type = Session["Type"].ToString(); //类型
msg = "删除时段里的数据数据失败";
fruit = false;
Converter.InsertLog(Id, name, Type, msg, fruit);
return Content("false");
}
}
