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 AgentGroup() { string sql = "select ID,GroupName from TAgentGroup"; DataTable dtGroups = APIDataContextProxy.GetTable(null, sql, CommandType.Text); ViewData["Groups"] = dtGroups; TAgentGroup model = new TAgentGroup(); int groupid = Converter.ToInt(Request.QueryString["gid"], 0); if (groupid > 0) { using (APIDataDataContext db = APIDataContextProxy.APIDB) { var group = (from p in db.TAgentGroup where p.ID == groupid select p).FirstOrDefault(); if (group != null) model = group; else return Content("<h1>分组不存在!</h1>"); } } ViewData["GroupID"] = groupid; ViewData.Model = model; return View(); }