/// <summary> /// 新增KPI数据 /// </summary> /// <param name="kpiModel"></param> /// <returns></returns> public int SetNewKPI(MonthlyKPI kpiModel) { StringBuilder strSql = new StringBuilder(); strSql.Append(" declare @count int; "); strSql.Append(" select @count=COUNT(*) from Sys_PresetKPI where MDate=@MDate and DelStatus=0; "); strSql.Append(" if(isnull(@count,0)>0) "); strSql.Append(" begin "); strSql.Append(" update Sys_PresetKPI set RegNum = @RegNum, SellCount = @SellCount , "); strSql.Append(" UsrAdd = @UsrAdd ,Sku = @Sku ,Sms = @Sms ,OrderCount = @OrderCount where MDate=@MDate; "); strSql.Append(" select 2; "); strSql.Append(" end "); strSql.Append(" else "); strSql.Append(" begin "); strSql.Append(" insert into Sys_PresetKPI(MDate,RegNum,SellCount,UsrAdd,Sku,Sms,OrderCount) "); strSql.Append(" values (@MDate,@RegNum,@SellCount,@UsrAdd,@Sku,@Sms,@OrderCount) ; "); strSql.Append(" select 1; "); strSql.Append(" end "); object id = DapperHelper.ExecuteScalar(strSql.ToString(), kpiModel); if (id != null) { return(Convert.ToInt32(id)); } else { return(0); } }
public ActionResult AddKpi(MonthlyKPI model) { string msg = PanelShow.AddKpi(model); //return RedirectToAction("KPI_View", new { msg = msg }); //return KPI_View(1, msg); return(RedirectToAction("MonthlyReview", "Home")); }
/// <summary> /// 新增一条KPI预设数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string AddKpi(MonthlyKPI model) { int status = Sys_PresetKPIBLL.AddKpi(model); string tip = string.Empty; switch (status) { case 0: tip = "数据处理出错!"; break; case 1: tip = "添加成功!"; break; case 2: tip = "更新成功!"; break; } return(tip); }
/// <summary> /// 新增一条KPI预设数据 /// </summary> public static int AddKpi(MonthlyKPI model) { Sys_PresetKPIDAL dal = new Sys_PresetKPIDAL(); return(dal.SetNewKPI(model)); }