public ActionResult CoServiceList()
{
JMP.BLL.CoServiceFeeRatioGrade bll = new JMP.BLL.CoServiceFeeRatioGrade();
JMP.MDL.CoServiceFeeRatioGrade model = new JMP.MDL.CoServiceFeeRatioGrade();
int pageCount = 0;
int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页
int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 20 : Int32.Parse(Request["PageSize"]); //每页显示数量
int searchDesc = string.IsNullOrEmpty(Request["searchDesc"]) ? 0 : Int32.Parse(Request["searchDesc"]); //排序方式
int type = string.IsNullOrEmpty(Request["type"]) ? 0 : Int32.Parse(Request["type"]); //查询条件选择
string sea_name = string.IsNullOrEmpty(Request["sea_name"]) ? "" : Request["sea_name"]; //查询条件内容
List <JMP.MDL.CoServiceFeeRatioGrade> list = new List <JMP.MDL.CoServiceFeeRatioGrade>();
list = bll.SelectList(sea_name, type, searchDesc, pageIndexs, PageSize, out pageCount);
ViewBag.searchDesc = searchDesc;
ViewBag.type = type;
ViewBag.sea_name = sea_name;
ViewBag.pageIndexs = pageIndexs;
ViewBag.PageSize = PageSize;
ViewBag.pageCount = pageCount;
ViewBag.list = list;
return(View());
}
public ActionResult ServiceFeeRatioGradeList()
{
JMP.BLL.CoServiceFeeRatioGrade bll = new JMP.BLL.CoServiceFeeRatioGrade();
JMP.MDL.CoServiceFeeRatioGrade model = new JMP.MDL.CoServiceFeeRatioGrade();
int pageCount = 0;
int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页
int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 20 : Int32.Parse(Request["PageSize"]); //每页显示数量
int searchDesc = string.IsNullOrEmpty(Request["searchDesc"]) ? 0 : Int32.Parse(Request["searchDesc"]); //排序方式
string status = string.IsNullOrEmpty(Request["status"]) ? "" : Request["status"]; //工单状态
string progress = string.IsNullOrEmpty(Request["progress"]) ? "" : Request["progress"]; //工单进度
int type = string.IsNullOrEmpty(Request["type"]) ? 0 : Int32.Parse(Request["type"]); //查询条件选择
string stime = string.IsNullOrEmpty(Request["r_begin"]) ? DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd") : Request["r_begin"];
string etime = string.IsNullOrEmpty(Request["r_end"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["r_end"];
string sea_name = string.IsNullOrEmpty(Request["sea_name"]) ? "" : Request["sea_name"];//查询条件内容
List <JMP.MDL.CoServiceFeeRatioGrade> list = new List <JMP.MDL.CoServiceFeeRatioGrade>();
list = bll.SelectList(sea_name, type, searchDesc, pageIndexs, PageSize, out pageCount);
ViewBag.searchDesc = searchDesc;
ViewBag.type = type;
ViewBag.sea_name = sea_name;
ViewBag.stime = stime;
ViewBag.etime = etime;
ViewBag.pageIndexs = pageIndexs;
ViewBag.PageSize = PageSize;
ViewBag.pageCount = pageCount;
ViewBag.list = list;
ViewBag.status = status;
ViewBag.progress = progress;
ViewBag.locUrl = GetVoidHtml();
return(View());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.CoServiceFeeRatioGrade GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, CreatedByName, Name, ServiceFeeRatio, CustomerWithoutAgentRatio, BusinessPersonnelAgentRatio, AgentPushMoneyRatio, Description, CreatedOn, CreatedById ");
strSql.Append(" from CoServiceFeeRatioGrade ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
JMP.MDL.CoServiceFeeRatioGrade model = new JMP.MDL.CoServiceFeeRatioGrade();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.CreatedByName = ds.Tables[0].Rows[0]["CreatedByName"].ToString();
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString() != "")
{
model.ServiceFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerWithoutAgentRatio"].ToString() != "")
{
model.CustomerWithoutAgentRatio = decimal.Parse(ds.Tables[0].Rows[0]["CustomerWithoutAgentRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["BusinessPersonnelAgentRatio"].ToString() != "")
{
model.BusinessPersonnelAgentRatio = decimal.Parse(ds.Tables[0].Rows[0]["BusinessPersonnelAgentRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["AgentPushMoneyRatio"].ToString() != "")
{
model.AgentPushMoneyRatio = decimal.Parse(ds.Tables[0].Rows[0]["AgentPushMoneyRatio"].ToString());
}
model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedById"].ToString() != "")
{
model.CreatedById = int.Parse(ds.Tables[0].Rows[0]["CreatedById"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CoServiceFeeRatioGrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CoServiceFeeRatioGrade set ");
strSql.Append(" CreatedByName = @CreatedByName , ");
strSql.Append(" Name = @Name , ");
strSql.Append(" ServiceFeeRatio = @ServiceFeeRatio , ");
strSql.Append(" CustomerWithoutAgentRatio = @CustomerWithoutAgentRatio , ");
strSql.Append(" BusinessPersonnelAgentRatio = @BusinessPersonnelAgentRatio , ");
strSql.Append(" AgentPushMoneyRatio = @AgentPushMoneyRatio , ");
strSql.Append(" Description = @Description , ");
strSql.Append(" CreatedOn = @CreatedOn , ");
strSql.Append(" CreatedById = @CreatedById ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@ServiceFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@CustomerWithoutAgentRatio", SqlDbType.Decimal, 5),
new SqlParameter("@BusinessPersonnelAgentRatio", SqlDbType.Decimal, 5),
new SqlParameter("@AgentPushMoneyRatio", SqlDbType.Decimal, 5),
new SqlParameter("@Description", SqlDbType.NVarChar, -1),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@CreatedById", SqlDbType.Int, 4)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.CreatedByName;
parameters[2].Value = model.Name;
parameters[3].Value = model.ServiceFeeRatio;
parameters[4].Value = model.CustomerWithoutAgentRatio;
parameters[5].Value = model.BusinessPersonnelAgentRatio;
parameters[6].Value = model.AgentPushMoneyRatio;
parameters[7].Value = model.Description;
parameters[8].Value = model.CreatedOn;
parameters[9].Value = model.CreatedById;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public JsonResult AddUser(JMP.MDL.jmp_user jmpuser)
{
JMP.BLL.CoServiceFeeRatioGrade grade_bll = new JMP.BLL.CoServiceFeeRatioGrade();
//查询默认费率
JMP.MDL.CoServiceFeeRatioGrade grade_model = grade_bll.GetModelById();
object obj = new { success = 0, msg = "添加失败！" };
JMP.BLL.jmp_user userBll = new JMP.BLL.jmp_user();
jmpuser.u_password = DESEncrypt.Encrypt(jmpuser.u_password);
jmpuser.u_role_id = int.Parse(ConfigurationManager.AppSettings["JSRoleID"]);
try
{
if (jmpuser.u_category == 0)
{
jmpuser.u_photo = string.IsNullOrEmpty(jmpuser.u_photo) ? "" : jmpuser.u_photo;
}
else
{
jmpuser.u_blicense = string.IsNullOrEmpty(jmpuser.u_blicense) ? "" : jmpuser.u_blicense;
jmpuser.u_photo = string.IsNullOrEmpty(jmpuser.u_photo) ? " " : jmpuser.u_photo;
}
jmpuser.u_qq = string.IsNullOrEmpty(jmpuser.u_qq) ? "" : jmpuser.u_qq;
jmpuser.u_address = string.IsNullOrEmpty(jmpuser.u_address) ? " " : jmpuser.u_address;
jmpuser.ServiceFeeRatioGradeId = string.IsNullOrEmpty(grade_model.Id.ToString()) ? 0 : grade_model.Id;
jmpuser.u_time = DateTime.Now;
bool flag = false;
if (!userBll.ExistsEmail(jmpuser.u_email))
{
flag = userBll.Add(jmpuser) > 0;
}
obj = new { success = flag ? 1 : 0, msg = flag ? "添加成功！" : "添加失败！" };
//写日志
if (flag)
{
Logger.CreateLog("添加开发者", jmpuser);
}
}
catch (Exception ex)
{
obj = new { success = 0, msg = "添加异常！" };
Logger.OperateLog("添加开发者报错", ex.ToString());
}
return(Json(obj));
}
public ActionResult SerViceFeeRationGradeAdd()
{
int id = string.IsNullOrEmpty(Request["id"]) ? 0 : Int32.Parse(Request["id"]);
JMP.BLL.CoServiceFeeRatioGrade bll = new JMP.BLL.CoServiceFeeRatioGrade();
JMP.MDL.CoServiceFeeRatioGrade model = new JMP.MDL.CoServiceFeeRatioGrade();
if (id > 0)
{
model = bll.SelectId(id);
model.AgentPushMoneyRatio = decimal.Parse((model.AgentPushMoneyRatio * 100).ToString("f2"));
model.BusinessPersonnelAgentRatio = decimal.Parse((model.BusinessPersonnelAgentRatio * 100).ToString("f2"));
model.CustomerWithoutAgentRatio = decimal.Parse((model.CustomerWithoutAgentRatio * 100).ToString("f2"));
model.ServiceFeeRatio = decimal.Parse((model.ServiceFeeRatio * 100).ToString("f2"));
}
ViewBag.model = model == null ? new JMP.MDL.CoServiceFeeRatioGrade() : model;
return(View());
}
public JMP.MDL.CoServiceFeeRatioGrade GetModelByName(string Name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append("from CoServiceFeeRatioGrade ");
strSql.Append(" where ");
strSql.Append(" Name = @Name");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Name;
JMP.MDL.CoServiceFeeRatioGrade model = new JMP.MDL.CoServiceFeeRatioGrade();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString() != "")
{
model.ServiceFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerWithoutAgentRatio"].ToString() != "")
{
model.CustomerWithoutAgentRatio = decimal.Parse(ds.Tables[0].Rows[0]["CustomerWithoutAgentRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["BusinessPersonnelAgentRatio"].ToString() != "")
{
model.BusinessPersonnelAgentRatio = decimal.Parse(ds.Tables[0].Rows[0]["BusinessPersonnelAgentRatio"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CoServiceFeeRatioGrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CoServiceFeeRatioGrade(");
strSql.Append("CreatedByName,Name,ServiceFeeRatio,CustomerWithoutAgentRatio,BusinessPersonnelAgentRatio,AgentPushMoneyRatio,Description,CreatedOn,CreatedById");
strSql.Append(") values (");
strSql.Append("@CreatedByName,@Name,@ServiceFeeRatio,@CustomerWithoutAgentRatio,@BusinessPersonnelAgentRatio,@AgentPushMoneyRatio,@Description,@CreatedOn,@CreatedById");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@ServiceFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@CustomerWithoutAgentRatio", SqlDbType.Decimal, 5),
new SqlParameter("@BusinessPersonnelAgentRatio", SqlDbType.Decimal, 5),
new SqlParameter("@AgentPushMoneyRatio", SqlDbType.Decimal, 5),
new SqlParameter("@Description", SqlDbType.NVarChar, -1),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@CreatedById", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreatedByName;
parameters[1].Value = model.Name;
parameters[2].Value = model.ServiceFeeRatio;
parameters[3].Value = model.CustomerWithoutAgentRatio;
parameters[4].Value = model.BusinessPersonnelAgentRatio;
parameters[5].Value = model.AgentPushMoneyRatio;
parameters[6].Value = model.Description;
parameters[7].Value = model.CreatedOn;
parameters[8].Value = model.CreatedById;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加或修改服务费等级信息
/// </summary>
/// <returns></returns>
public JsonResult InsertUpdateSerViceFeeRationGrade(JMP.MDL.CoServiceFeeRatioGrade model)
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.BLL.CoServiceFeeRatioGrade bll = new JMP.BLL.CoServiceFeeRatioGrade();
model.AgentPushMoneyRatio = model.AgentPushMoneyRatio / 100;
model.BusinessPersonnelAgentRatio = model.BusinessPersonnelAgentRatio / 100;
model.CustomerWithoutAgentRatio = model.CustomerWithoutAgentRatio / 100;
model.ServiceFeeRatio = model.ServiceFeeRatio / 100;
var exists = bll.GetModelByName(model.Name);
if (model.Id > 0)
{
// 修改
JMP.MDL.CoServiceFeeRatioGrade oldmodel = new JMP.MDL.CoServiceFeeRatioGrade();
oldmodel = bll.GetModel(model.Id);
var oldmodelConle = oldmodel.Clone();
oldmodel.Name = model.Name;
oldmodel.ServiceFeeRatio = model.ServiceFeeRatio;
oldmodel.BusinessPersonnelAgentRatio = model.BusinessPersonnelAgentRatio;
oldmodel.CustomerWithoutAgentRatio = model.CustomerWithoutAgentRatio;
oldmodel.AgentPushMoneyRatio = model.AgentPushMoneyRatio;
oldmodel.Description = model.Description;
if (exists != null && model.Id != exists.Id)
{
retJson = new { success = 0, msg = "此服务费级别名称已存在" };
return(Json(retJson));
}
if (bll.Update(oldmodel))
{
Logger.ModifyLog("修改服务费等级信息", oldmodelConle, model);
RateLogger.ModifyLog("修改服务费等级信息", oldmodelConle, model);
retJson = new { success = 1, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
}
}
else
{
model.CreatedOn = DateTime.Now;
model.CreatedById = UserInfo.UserId;
model.CreatedByName = UserInfo.UserName;
if (exists != null)
{
retJson = new { success = 0, msg = "此服务费级别名称已存在" };
return(Json(retJson));
}
int cg = bll.Add(model);
if (cg > 0)
{
Logger.CreateLog("添加服务费等级信息", model);
RateLogger.CreateLog("添加服务费等级信息", model);
retJson = new { success = 1, msg = "添加成功" };
}
else
{
retJson = new { success = 1, msg = "添加失败" };
}
}
return(Json(retJson));
}
