/// <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));
}
