public ActionResult Edit(string data)
{
RecommendGetGiftConfig model = JsonConvert.DeserializeObject <RecommendGetGiftConfig>(data);
if (model.Id != 0)
{
model.UpdateName = User.Identity.Name;
if (RecommendGetGiftConfigManager.UpdateRecommendGetGiftConfig(model))
{
AddOprLog(model, "修改");
return(Json(true));
}
else
{
return(Json(false));
}
}
else
{
int newid = 0;
model.CreateName = User.Identity.Name;
if (RecommendGetGiftConfigManager.InsertRecommendGetGiftConfig(model, ref newid))
{
model.Id = newid;
AddOprLog(model, "添加");
return(Json(true));
}
else
{
return(Json(false));
}
}
}
public bool InsertRecommendGetGiftConfig(RecommendGetGiftConfig model, ref int id)
{
try
{
return(DALRecommendGetGiftConfig.InsertRecommendGetGiftConfig(model, ref id));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "InsertRecommendGetGiftConfig");
throw ex;
}
}
public List <RecommendGetGiftConfig> GetRecommendGetGiftConfigList(RecommendGetGiftConfig model, int pageSize, int pageIndex, out int recordCount)
{
try
{
return(DALRecommendGetGiftConfig.GetRecommendGetGiftConfig(model, pageSize, pageIndex, out recordCount));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "GetRecommendGetGiftConfigList");
throw ex;
}
}
public void AddOprLog(RecommendGetGiftConfig model, string opr)
{
OprLog oprModel = new OprLog();
oprModel.Author = User.Identity.Name;
oprModel.ChangeDatetime = DateTime.Now;
oprModel.HostName = Request.UserHostName;
oprModel.ObjectID = model.Id;
oprModel.ObjectType = "SERGG";
oprModel.Operation = opr;
OprLogManager.AddOprLog(oprModel);
}
public ActionResult Share(int id = 0)
{
if (id == 0)
{
return(View(new RecommendGetGiftConfig()));
}
else
{
RecommendGetGiftConfig model = RecommendGetGiftConfigManager.GetRecommendGetGiftConfigById(id);
model.Channel = JsonConvert.DeserializeObject <List <ShareChannel> >(model.ShareChannel);
return(View(model));
}
}
public ActionResult Edit(int id = 0)
{
if (id == 0)
{
return(View(new RecommendGetGiftConfig()));
}
else
{
RecommendGetGiftConfig model = RecommendGetGiftConfigManager.GetRecommendGetGiftConfigById(id);
return(View(model));
}
}
public ActionResult Index(RecommendGetGiftConfig model, int pageIndex = 1, int pageSize = 20)
{
int count = 0;
string strSql = string.Empty;
var lists = RecommendGetGiftConfigManager.GetRecommendGetGiftConfigList(model, pageSize, pageIndex, out count);
var list = new OutData <List <RecommendGetGiftConfig>, int>(lists, count);
var pager = new PagerModel(pageIndex, pageSize)
{
TotalItem = count
};
return(View(new ListModel <RecommendGetGiftConfig>(list.ReturnValue, pager)));
}
public JsonResult Delete(int id)
{
bool result = false;
RecommendGetGiftConfig model = new RecommendGetGiftConfig();
model.Id = id;
if (RecommendGetGiftConfigManager.DeleteRecommendGetGiftConfig(id))
{
AddOprLog(model, "删除");
result = true;
}
return(Json(result));
}
public static bool UpdateRecommendGetGiftConfig(RecommendGetGiftConfig model)
{
const string sql = @"UPDATE Configuration..SE_RecommendGetGiftConfig SET
Name=@Name
,Banner=@Banner
,AwardLimit=@AwardLimit
,AwardType=@AwardType
,AwardValue=@AwardValue
,RegisteredText=@RegisteredText
,AwardedText=@AwardedText
,ShareButtonValue=@ShareButtonValue
,ShareChannel=@ShareChannel
,Rules=@Rules
,TimeLimitCollectRules=@TimeLimitCollectRules
,UpdateName=@UpdateName
,UpdateTime=GETDATE()
,GetRuleGUID=@GetRuleGUID
,TabName=@TabName
,IsSendCode=ISNULL(@IsSendCode,IsSendCode)
,UserGroupId=ISNULL(@UserGroupId,UserGroupId)
,StartTime=ISNULL(@StartTime,StartTime)
,EndTime=ISNULL(@EndTime,EndTime)
WHERE Id=@Id";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@AwardedText", model.AwardedText ?? string.Empty),
new SqlParameter("@AwardLimit", model.AwardLimit),
new SqlParameter("@AwardType", model.AwardType ?? string.Empty),
new SqlParameter("@AwardValue", model.AwardValue),
new SqlParameter("@Banner", model.Banner),
new SqlParameter("@CreateName", model.CreateName ?? string.Empty),
new SqlParameter("@Name", model.Name ?? string.Empty),
new SqlParameter("@RegisteredText", model.RegisteredText ?? string.Empty),
new SqlParameter("@Rules", model.Rules ?? string.Empty),
new SqlParameter("@TimeLimitCollectRules", model.TimeLimitCollectRules ?? string.Empty),
new SqlParameter("@ShareButtonValue", model.ShareButtonValue ?? string.Empty),
new SqlParameter("@ShareChannel", model.ShareChannel ?? string.Empty),
new SqlParameter("@UpdateName", model.UpdateName ?? string.Empty),
new SqlParameter("@Id", model.Id),
new SqlParameter("@GetRuleGUID", model.GetRuleGUID ?? string.Empty),
new SqlParameter("@TabName", model.TabName ?? string.Empty),
new SqlParameter("@IsSendCode", model.IsSendCode),
new SqlParameter("@UserGroupId", model.UserGroupId),
new SqlParameter("@StartTime", model.StartTime),
new SqlParameter("@EndTime", model.EndTime)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
public static List <RecommendGetGiftConfig> GetRecommendGetGiftConfig(RecommendGetGiftConfig model, int pageSize, int pageIndex, out int recordCount)
{
string sql = @"SELECT [Id]
,[Number]
,[Name]
,[Banner]
,[AwardLimit]
,[AwardType]
,[AwardValue]
,[GetRuleGUID]
,[RegisteredText]
,[AwardedText]
,[ShareButtonValue]
,[ShareChannel]
,[Rules]
,[TimeLimitCollectRules]
,[CreateName]
,[CreateTime]
,[UpdateName]
,[UpdateTime]
,TabName
,IsSendCode
,UserGroupId
,StartTime
,EndTime
FROM [Configuration].[dbo].[SE_RecommendGetGiftConfig] AS A WITH (NOLOCK)
ORDER BY A.[UpdateTime] DESC
OFFSET ( @PageIndex - 1 ) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY
";
string sqlCount = @"SELECT Count(0)
FROM [Configuration].[dbo].[SE_RecommendGetGiftConfig] AS A WITH (NOLOCK)";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@PageIndex", pageIndex)
};
recordCount = (int)SqlHelper.ExecuteScalar(connOnRead, CommandType.Text, sqlCount);
return(SqlHelper.ExecuteDataTable(connOnRead, CommandType.Text, sql, sqlParameters).ConvertTo <RecommendGetGiftConfig>().ToList());
}
public bool UpdateRecommendGetGiftConfig(RecommendGetGiftConfig model)
{
try
{
var temp = GetRecommendGetGiftConfigById(model.Id);
if (temp != null)
{
if (temp.StartTime < DateTime.Now || (temp.StartTime == null && temp.EndTime == null))//已经开始了
{
model.IsSendCode = null;
model.UserGroupId = null;
model.StartTime = null;
model.EndTime = temp.EndTime == null ? null : model.EndTime;
}
}
return(DALRecommendGetGiftConfig.UpdateRecommendGetGiftConfig(model));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "UpdateRecommendGetGiftConfig");
throw ex;
}
}
public static bool InsertRecommendGetGiftConfig(RecommendGetGiftConfig model, ref int id)
{
const string sql = @" INSERT INTO Configuration..[SE_RecommendGetGiftConfig]
(
[Number]
,[Name]
,[Banner]
,[AwardLimit]
,[AwardType]
,[AwardValue]
,[GetRuleGUID]
,[RegisteredText]
,[AwardedText]
,[ShareButtonValue]
,[ShareChannel]
,[Rules]
,[TimeLimitCollectRules]
,[CreateName]
,[CreateTime]
,[UpdateName]
,[UpdateTime]
,TabName
,IsSendCode
,UserGroupId
,StartTime
,EndTime
)
VALUES (
NEWID()
,@Name
,@Banner
,@AwardLimit
,@AwardType
,@AwardValue
,@GetRuleGUID
,@RegisteredText
,@AwardedText
,@ShareButtonValue
,@ShareChannel
,@Rules
,@TimeLimitCollectRules
,@CreateName
,GETDATE()
,@UpdateName
,GETDATE()
,@TabName
,@IsSendCode
,@UserGroupId
,@StartTime
,@EndTime
)SELECT @@IDENTITY";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@AwardedText", model.AwardedText ?? string.Empty),
new SqlParameter("@AwardLimit", model.AwardLimit),
new SqlParameter("@AwardType", model.AwardType ?? string.Empty),
new SqlParameter("@AwardValue", model.AwardValue),
new SqlParameter("@Banner", model.Banner),
new SqlParameter("@CreateName", model.CreateName ?? string.Empty),
new SqlParameter("@Name", model.Name ?? string.Empty),
new SqlParameter("@RegisteredText", model.RegisteredText ?? string.Empty),
new SqlParameter("@Rules", model.Rules ?? string.Empty),
new SqlParameter("@TimeLimitCollectRules", model.TimeLimitCollectRules ?? string.Empty),
new SqlParameter("@ShareButtonValue", model.ShareButtonValue ?? string.Empty),
new SqlParameter("@ShareChannel", model.ShareChannel ?? string.Empty),
new SqlParameter("@UpdateName", model.UpdateName ?? string.Empty),
new SqlParameter("@GetRuleGUID", model.GetRuleGUID ?? string.Empty),
new SqlParameter("@TabName", model.TabName ?? string.Empty),
new SqlParameter("@IsSendCode", model.IsSendCode),
new SqlParameter("@UserGroupId", model.UserGroupId),
new SqlParameter("@StartTime", model.StartTime),
new SqlParameter("@EndTime", model.EndTime)
};
id = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParameter));
return(id > 0);
}