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