public static bool EditCoupon(Guid taskId, List <CouponInfoModel> couponList, BaseDbHelper dbHelper)
{
const string sqlStr = @"DELETE Configuration..TaskCouponInfo WHERE TaskId = @taskid;";
const string sqlStr2 = @"INSERT INTO Configuration..TaskCouponInfo(TaskId, CouponId, Count) VALUES (@taskId, @couponId, @count);";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskid", taskId);
dbHelper.ExecuteNonQuery(cmd);
}
var coupons = couponList.Where(g => g.GetRuleId != Guid.Empty && g.Count > 0).ToList();
foreach (var item in coupons)
{
using (var cmd = new SqlCommand(sqlStr2))
{
cmd.Parameters.AddWithValue("@taskId", taskId);
cmd.Parameters.AddWithValue("@couponId", item.GetRuleId);
cmd.Parameters.AddWithValue("@count", item.Count);
var result = dbHelper.ExecuteNonQuery(cmd);
if (result < 1)
{
return(false);
}
}
}
return(true);
}
public static int UpdateCategoryBrand(CategoryBrandRankModel model, BaseDbHelper db)
{
string sql =
@"UPDATE Activity..[tbl_CategoryBrandRank] WITH(ROWLOCK)
SET
[ParentPkid] = @ParentPkid
,[Name] = ISNULL(@Name,[Name])
,[NameIndex] = @NameIndex
,[PageTitle] = ISNULL(@PageTitle,PageTitle)
,[PageShareTitle] = ISNULL(@PageShareTitle,PageShareTitle)
,[PageShareDescription] = ISNULL(@PageShareDescription,PageShareDescription)
,[PageShareContent] = ISNULL(@PageShareContent,PageShareContent)
WHERE PKID=@PKID";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ParentPkid", model.ParentPkid);
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@NameIndex", model.NameIndex);
cmd.Parameters.AddWithValue("@PageTitle", model.PageTitle);
cmd.Parameters.AddWithValue("@PageShareTitle", model.PageShareTitle);
cmd.Parameters.AddWithValue("@PageShareDescription", model.PageShareDescription);
cmd.Parameters.AddWithValue("@PageShareContent", model.PageShareContent);
cmd.Parameters.AddWithValue("@PKID", model.PKID);
return(db.ExecuteNonQuery(cmd));
}
}
public static bool AddCondition(Guid taskId, List <TaskConditionModel> conditionList, BaseDbHelper dbHelper)
{
const string sqlStr = @"INSERT INTO Configuration..TaskConditionInfo
( TaskId ,
ActionName ,
Count ,
SpecialPara ,
Remark
)
VALUES ( @taskId ,
@actionName ,
@count ,
@specialPara ,
@remark
);";
foreach (var item in conditionList)
{
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskId", taskId);
cmd.Parameters.AddWithValue("@actionName", item.ActionName);
cmd.Parameters.AddWithValue("@specialPara", item.SpecialPara);
cmd.Parameters.AddWithValue("@count", item.Count);
cmd.Parameters.AddWithValue("@remark", default(string));
var result = dbHelper.ExecuteNonQuery(cmd);
if (result < 1)
{
return(false);
}
}
}
return(true);
}
public static bool UpdateVehicleAuditStatus(BaseDbHelper db, Guid carId, int status)
{
using (var cmd = new SqlCommand(@"UPDATE Tuhu_profiles..VehicleAuthAppeal WITH(ROWLOCK) SET Status=@Status WHERE CarID=@CarID"))
{
cmd.Parameters.Add(new SqlParameter("@Status", status));
cmd.Parameters.Add(new SqlParameter("@CarID", carId));
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static int JoinWhiteList(BaseDbHelper dbhelper, IEnumerable <string> pids)
{
return(dbhelper.ExecuteNonQuery(@"INSERT INTO Tuhu_bi.dbo.TireStockWhiteList
( PID ,
Type
)
SELECT * ,
1
FROM Tuhu_bi.dbo.Split(@pids, ';')", CommandType.Text, new SqlParameter("@pids", string.Join(";", pids))));
}
public static int DeleteCategoryBrand(long id, BaseDbHelper db)
{
string sql =
@"DELETE FROM Activity..[tbl_CategoryBrandRank] WHERE PKID=@PKID";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@PKID", id);
return(db.ExecuteNonQuery(cmd));
}
}
public static bool UpdateTriggerTask(Guid taskId, List <TriggerTaskModel> triggerList, BaseDbHelper dbHelper)
{
const string sqlStr = @"DELETE Configuration..TaskTriggerInfo WHERE TaskId = @taskid;";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskid", taskId);
var result = dbHelper.ExecuteNonQuery(cmd);
return(AddTriggerTask(taskId, triggerList, dbHelper));
}
}
public static bool UpdateVehicleTypeCertificationInfo(BaseDbHelper db, VehicleAuditInfoModel request)
{
using (var cmd =
new SqlCommand(
@"Update Tuhu_Profiles..VehicleTypeCertificationInfo WITH(ROWLOCK) SET Vehicle_license_img=@Vehicle_license_img,User_IdCard_img=@User_IdCard_img where CarId=@CarId")
)
{
cmd.Parameters.AddWithValue("@Vehicle_license_img", request.ImageUrl);
cmd.Parameters.AddWithValue("@User_IdCard_img", request.IdCardUrl);
cmd.Parameters.AddWithValue("@CarId", request.CarId);
cmd.CommandType = CommandType.Text;
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static bool UpdateCarObject(BaseDbHelper db, VehicleAuditInfoModel request)
{
using (var cmd =
new SqlCommand(
@"Update Tuhu_Profiles..CarObject WITH(ROWLOCK) SET VinCode=@VinCode,ClassNo=@ClassNo,u_carno=@CarNo,Engineno=@EngineNo where CarId=@CarId")
)
{
cmd.Parameters.AddWithValue("@VinCode", request.VinCode);
cmd.Parameters.AddWithValue("@CarNo", request.CarNumber);
cmd.Parameters.AddWithValue("@CarId", request.CarId);
cmd.Parameters.AddWithValue("@ClassNo", request.VinCode);
cmd.Parameters.AddWithValue("@EngineNo", request.EngineNo);
cmd.CommandType = CommandType.Text;
return(db.ExecuteNonQuery(cmd) > 0);
}
}
/// <summary>
/// 设置用户答案结果
/// </summary>
/// <param name="helper"></param>
/// <param name="answerId"></param>
/// <param name="couponCount"></param>
/// <param name="flag"> 1 胜利 2 失败</param>
/// <returns></returns>
public static bool UpdateUserAnswerResult(BaseDbHelper helper, long answerId, int couponCount, int flag)
{
var sql = @"
update Activity.dbo.QuestionnaireAnswerResult
set AnswerResultStatus = @AnswerResultStatus,WinCouponCount = @WinCouponCount,LastUpdateDateTime=getdate()
where PKID = @PKID
";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@AnswerResultStatus", flag);
cmd.Parameters.AddWithValue("@WinCouponCount", couponCount);
cmd.Parameters.AddWithValue("@PKID", answerId);
var result = helper.ExecuteNonQuery(cmd);
return(result > 0);
}
}
public static bool UpdateVehicleTypeCertificationInfoStatus(BaseDbHelper db, Guid carId, int status)
{
//如果是认证成功
string certifiedSql = "";
if (status == 1)
{
certifiedSql = ",certified_time=GETDATE()";
}
using (var cmd =
new SqlCommand(
$@"UPDATE Tuhu_Profiles..VehicleTypeCertificationInfo WITH(ROWLOCK) SET Status=@Status{
certifiedSql
},LastUpdateDateTime=GETDATE() WHERE CarId=@CarId"))
{
cmd.Parameters.AddWithValue("@Status", status);
cmd.Parameters.AddWithValue("@CarId", carId);
cmd.CommandType = CommandType.Text;
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static bool AddCoupon(Guid taskId, List <CouponInfoModel> couponList, BaseDbHelper dbHelper)
{
const string sqlStr = @"INSERT INTO Configuration..TaskCouponInfo
( TaskId, CouponId, Count )
VALUES ( @taskId, @couponId, @count );";
foreach (var item in couponList)
{
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskId", taskId);
cmd.Parameters.AddWithValue("@couponId", item.GetRuleId);
cmd.Parameters.AddWithValue("@count", item.Count);
var result = dbHelper.ExecuteNonQuery(cmd);
if (result < 1)
{
return(false);
}
}
}
return(true);
}
public static bool AddTriggerTask(Guid taskId, List <TriggerTaskModel> triggerList, BaseDbHelper dbHelper)
{
const string sqlStr = @"
INSERT INTO Configuration..TaskTriggerInfo
( TaskId ,
TriggerTaskId ,
TriggerTaskName ,
TriggerType ,
IsTimeout
)
VALUES ( @taskId ,
@triggerTaskId ,
@triggerTaskName ,
@triggerType ,
@isTimeout
);
";
foreach (var item in triggerList)
{
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskId", taskId);
cmd.Parameters.AddWithValue("@triggerTaskId", item.TriggerTaskId);
cmd.Parameters.AddWithValue("@triggerTaskName", item.TriggerTaskName);
cmd.Parameters.AddWithValue("@triggerType", item.TriggerType);
cmd.Parameters.AddWithValue("@isTimeout", item.IsTimeout);
var result = dbHelper.ExecuteNonQuery(cmd);
if (result < 1)
{
return(false);
}
}
}
return(true);
}
public static int DeleteExsit(BaseDbHelper dbhelper, IEnumerable <string> exsitPids)
{
return(dbhelper.ExecuteNonQuery(@"DELETE Tuhu_bi.dbo.TireStockWhiteList
WHERE PID IN ( SELECT *
FROM Tuhu_bi.dbo.Split(@pids, ';') )", CommandType.Text, new SqlParameter("@pids", string.Join(";", exsitPids))));
}
public static bool UpdateTaskConfig(TaskConfigModel request, BaseDbHelper dbHelper)
{
const string sqlStr = @"
update Configuration..TaskConfigInfo with (rowlock)
set TaskName = @taskName,
TaskIcon = @taskicon,
DisplayStatus = @displayStatus,
TaskLink = @taskLink,
TaskText = @taskText,
Duration = @duration,
AwardText = @awardText,
AwardLink = @awardLink,
AwardImg = @awardImg,
Integral = @integral,
TireInsurance = @tireInsurance,
RandomCoupon = @randomCoupon,
TaskRule = @taskrule,
TaskType = @taskType,
LastUpdateDateTime = GETDATE(),
Sequence = @sequence,
PopulationsTag = @populationsTag,
StartVersion = @startVersion,
EndVersion = @endVersion,
RequireActionCount = @requireActionCount,
RecommendImg = @recommendImg,
RecommendLevel = @recommendLevel,
TaskChannel = @taskChannel,
WXAwardAppId = @wxAwardAppId,
WXAwardLink = @wxAwardLink,
WXTaskAppId = @wxTaskAppId,
WXTaskLink = @wxTaskLink
where TaskId = @taskid;";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskName", request.TaskName);
cmd.Parameters.AddWithValue("@taskIcon", request.TaskIcon);
cmd.Parameters.AddWithValue("@displayStatus", request.DisplayStatus);
cmd.Parameters.AddWithValue("@taskLink", request.TaskLink);
cmd.Parameters.AddWithValue("@taskText", request.TaskText);
cmd.Parameters.AddWithValue("@duration", request.Duration);
cmd.Parameters.AddWithValue("@awardText", request.AwardText);
cmd.Parameters.AddWithValue("@awardLink", request.AwardLink);
cmd.Parameters.AddWithValue("@awardImg", request.AwardImg);
cmd.Parameters.AddWithValue("@integral", request.Integral);
cmd.Parameters.AddWithValue("@tireInsurance", request.TireInsurance);
cmd.Parameters.AddWithValue("@randomCoupon", request.RandomCoupon);
cmd.Parameters.AddWithValue("@taskrule", request.TaskRule);
cmd.Parameters.AddWithValue("@taskid", request.TaskId);
cmd.Parameters.AddWithValue("@taskType", request.TaskType);
cmd.Parameters.AddWithValue("@sequence", request.Sequence);
cmd.Parameters.AddWithValue("@populationsTag", request.PopulationsTag);
cmd.Parameters.AddWithValue("@startVersion", request.StartVersion);
cmd.Parameters.AddWithValue("@endVersion", request.EndVersion);
cmd.Parameters.AddWithValue("@requireActionCount", request.RequireActionCount);
cmd.Parameters.AddWithValue("@recommendImg", request.RecommendImg);
cmd.Parameters.AddWithValue("@recommendLevel", request.RecommendLevel);
cmd.Parameters.AddWithValue("@taskChannel", request.TaskChannel);
cmd.Parameters.AddWithValue("@wxAwardAppId", request.WXAwardAppId);
cmd.Parameters.AddWithValue("@wxAwardLink", request.WXAwardLink);
cmd.Parameters.AddWithValue("@wxTaskAppId", request.WXTaskAppId);
cmd.Parameters.AddWithValue("@wxTaskLink", request.WXTaskLink);
return(dbHelper.ExecuteNonQuery(cmd) > 0);
}
}
public static bool AddTaskConfig(TaskConfigModel request, string Operator, BaseDbHelper dbHelper)
{
const string sqlStr = @"
insert into Configuration..TaskConfigInfo
(
TaskId,
TaskName,
TaskType,
TaskIcon,
DisplayStatus,
TaskLink,
TaskText,
TriggerTime,
Duration,
AwardText,
AwardLink,
ButtonText,
AwardImg,
Integral,
TaskRule,
TireInsurance,
RandomCoupon,
Operator,
IsDelete,
Sequence,
PopulationsTag,
StartVersion,
EndVersion,
RequireActionCount,
RecommendImg,
RecommendLevel,
TaskChannel,
WXAwardAppId,
WXAwardLink,
WXTaskAppId,
WXTaskLink
)
values
(@taskid, @taskname, @tasktype, @taskicon, @displaystatus, @tasklink, @tasktext, @triggertime, @duration, @awardtext,
@awardlink, '', @awardimg, @integral, @taskrule, @tireinsurance, @randomcoupon, @operator, 0, @sequence,
@populationsTag, @startVersion, @endVersion, @requireActionCount, @recommendImg, @recommendLevel, @taskChannel,
@wxAwardAppId, @wxAwardLink, @wxTaskAppId, @wxTaskLink);";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@taskid", request.TaskId);
cmd.Parameters.AddWithValue("@taskname", request.TaskName);
cmd.Parameters.AddWithValue("@tasktype", request.TaskType);
cmd.Parameters.AddWithValue("@taskicon", request.TaskIcon);
cmd.Parameters.AddWithValue("@displaystatus", request.DisplayStatus);
cmd.Parameters.AddWithValue("@tasklink", request.TaskLink);
cmd.Parameters.AddWithValue("@tasktext", request.TaskText);
cmd.Parameters.AddWithValue("@triggertime", request.TriggerTime);
cmd.Parameters.AddWithValue("@duration", request.Duration);
cmd.Parameters.AddWithValue("@awardtext", request.AwardText);
cmd.Parameters.AddWithValue("@awardlink", request.AwardLink);
cmd.Parameters.AddWithValue("@awardimg", request.AwardImg);
cmd.Parameters.AddWithValue("@integral", request.Integral);
cmd.Parameters.AddWithValue("@taskrule", request.TaskRule);
cmd.Parameters.AddWithValue("@tireinsurance", request.TireInsurance);
cmd.Parameters.AddWithValue("@randomcoupon", request.RandomCoupon);
cmd.Parameters.AddWithValue("@operator", Operator);
cmd.Parameters.AddWithValue("@sequence", request.Sequence);
cmd.Parameters.AddWithValue("@populationsTag", request.PopulationsTag);
cmd.Parameters.AddWithValue("@startVersion", request.StartVersion);
cmd.Parameters.AddWithValue("@endVersion", request.EndVersion);
cmd.Parameters.AddWithValue("@requireActionCount", request.RequireActionCount);
cmd.Parameters.AddWithValue("@recommendImg", request.RecommendImg);
cmd.Parameters.AddWithValue("@recommendLevel", request.RecommendLevel);
cmd.Parameters.AddWithValue("@taskChannel", request.TaskChannel);
cmd.Parameters.AddWithValue("@wxAwardAppId", request.WXAwardAppId);
cmd.Parameters.AddWithValue("@wxAwardLink", request.WXAwardLink);
cmd.Parameters.AddWithValue("@wxTaskAppId", request.WXTaskAppId);
cmd.Parameters.AddWithValue("@wxTaskLink", request.WXTaskLink);
return(dbHelper.ExecuteNonQuery(cmd) > 0);
}
}
