public static bool InsertShareSConfig(SqlConnection conn, ShareSupervisionConfig ssc)
{
string insertShareSConfigText = @"
INSERT INTO Configuration..ShareSupervisionConfig(Location,ShareScene,Status,ShareType,ShareUrl,ThumbPic,Title,Description,BgPic,ParameterRef,CreateDateTime,UpdateDateTime,Creator,SceneSequence,PagePath,MiniGramId,JumpId)
VALUES (@location,@sharescene,@status,@sharetype,@shareurl,@thumbpic,@title,@description,@bgpic,@parameterref,@createdatetime,@updatedatetime,@creator,@scenesequence,@pagepath,@MiniGramId,@JumpId)";
var sqlParam = new[]
{
new SqlParameter("@location", ssc.Location),
new SqlParameter("@sharescene", ssc.ShareScene),
new SqlParameter("@status", ssc.Status),
new SqlParameter("@sharetype", ssc.ShareType),
new SqlParameter("@shareurl", ssc.ShareUrl),
new SqlParameter("@thumbpic", ssc.ThumbPic),
new SqlParameter("@title", ssc.Title),
new SqlParameter("@description", ssc.Description),
new SqlParameter("@bgpic", ssc.BgPic),
new SqlParameter("@parameterref", ssc.ParameterRef),
new SqlParameter("@createdatetime", ssc.CreateDateTime),
new SqlParameter("@updatedatetime", ssc.UpdateDateTime),
new SqlParameter("@creator", ssc.Creator),
new SqlParameter("@scenesequence", ssc.SceneSequence),
new SqlParameter("@pagepath", ssc.PagePath),
new SqlParameter("@MiniGramId", ssc.MiniGramId),
new SqlParameter("@JumpId", ssc.JumpId),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, insertShareSConfigText, sqlParam) > 0 ? true : false);
}
public ActionResult SaveShareSConfig(ShareSupervisionConfig ssc)
{
if (ssc.PKId == 0)
{
ssc.CreateDateTime = DateTime.Now;
ssc.UpdateDateTime = DateTime.Now;
ssc.Creator = ThreadIdentity.Operator.Name;
bool flag = ShareConfigManager.InsertShareSConfig(ssc);
}
else
{
ssc.UpdateDateTime = DateTime.Now;
bool flag = ShareConfigManager.UpdateShareSConfig(ssc);
}
ShareConfigLog scl = new ShareConfigLog()
{
ConfigId = ssc.JumpId,
Operator = ThreadIdentity.Operator.Name,
OperateType = 1,
CreateDateTime = DateTime.Now,
LastUpdateDateTime = DateTime.Now
};
bool flaglog = ShareConfigManager.InsertShareConfigLog(scl);
return(Redirect("TemplateEdit?id=" + ssc.JumpId));
}
public async Task <ActionResult> ShareSConfigEditModule(string location, int jumpid, int id = 0)
{
//ViewBag.MiniGramList = await ShareConfigManager.SelectWxConfigsAsync();
if (id == 0)
{
ViewBag.Title = "创建分享渠道";
ShareSupervisionConfig ssc = new ShareSupervisionConfig()
{
PKId = 0,
Location = location,
ShareScene = 0,
Status = 1,
ShareType = 0,
SceneSequence = 0,
JumpId = jumpid,
};
return(View(ssc));
}
else if (id < 0)
{
ViewBag.Title = "复制分享渠道";
ShareSupervisionConfig ssc = ShareConfigManager.SelectShareSConfigById(-id);
ssc.PKId = 0;
return(View(ssc));
}
else
{
ViewBag.Title = "修改分享渠道";
ShareSupervisionConfig ssc = ShareConfigManager.SelectShareSConfigById(id);
return(View(ssc));
}
}
public bool UpdateShareSConfig(ShareSupervisionConfig ssc)
{
try
{
return(handler.UpdateShareSConfig(ssc));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "UpdateShareSConfig", ex);
Logger.Log(Level.Error, exception, "UpdateShareSConfig");
throw ex;
}
}
public static bool UpdateShareSConfig(SqlConnection conn, ShareSupervisionConfig ssc)
{
string updateShareSConfigText = @"
UPDATE Configuration..ShareSupervisionConfig
SET ShareScene=@sharescene,
Status=@status,
ShareType=@sharetype,
ShareUrl=@shareurl,
ThumbPic=@thumbpic,
Title=@title,
Description=@description,
BgPic=@bgpic,
ParameterRef=@parameterref,
UpdateDateTime=@updatedatetime,
SceneSequence=@scenesequence,
PagePath=@pagepath,
MiniGramId=@MiniGramId
WHERE PKId=@pkid";
var sqlParam = new[]
{
new SqlParameter("@sharescene", ssc.ShareScene),
new SqlParameter("@status", ssc.Status),
new SqlParameter("@sharetype", ssc.ShareType),
new SqlParameter("@shareurl", ssc.ShareUrl),
new SqlParameter("@thumbpic", ssc.ThumbPic),
new SqlParameter("@title", ssc.Title),
new SqlParameter("@description", ssc.Description),
new SqlParameter("@bgpic", ssc.BgPic),
new SqlParameter("@parameterref", ssc.ParameterRef),
new SqlParameter("@updatedatetime", ssc.UpdateDateTime),
new SqlParameter("@scenesequence", ssc.SceneSequence),
new SqlParameter("@pagepath", ssc.PagePath),
new SqlParameter("@pkid", ssc.PKId),
new SqlParameter("@MiniGramId", ssc.MiniGramId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, updateShareSConfigText, sqlParam) > 0 ? true : false);
}
public bool UpdateShareSConfig(ShareSupervisionConfig ssc)
{
Func <SqlConnection, bool> action = (connection) => DalShareConfig.UpdateShareSConfig(connection, ssc);
return(dbManager.Execute(action));
}
