public static bool InsertLog(VehicleTypeCertificationAuditLogModel model) { var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { using (var cmd = new SqlCommand( @"INSERT Tuhu_log..VehicleTypeCertificationAuditLog(CarId,Author,OldValue,NewValue,Description,CreateTime) VALUES(@carId,@author,@oldValue,@newValue,@description,GETDATE());") ) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@carId", model.CarId); cmd.Parameters.AddWithValue("@author", model.Author); cmd.Parameters.AddWithValue("@oldValue", model.OldValue); cmd.Parameters.AddWithValue("@newValue", model.NewValue); cmd.Parameters.AddWithValue("@description", model.Description); return(dbHelper.ExecuteNonQuery(cmd) > 0); } } }
public static List <VehicleTypeCertificationAuditLogModel> SelectLogs(List <Guid> carIds) { if (!carIds.Any()) { return(new List <VehicleTypeCertificationAuditLogModel>()); } var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { using (var cmd = new SqlCommand( $@"SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY CarId ORDER BY CreateTime DESC) AS N,* FROM Tuhu_log..VehicleTypeCertificationAuditLog WOTH(NOLOCK) WHERE CarId IN({string.Join(",",carIds.Select(_=>$"'{_}'"))})) AS T WHERE T.N=1")) { cmd.CommandType = CommandType.Text; return(dbHelper.ExecuteDataTable(cmd).ConvertTo <VehicleTypeCertificationAuditLogModel>().ToList()); } } }
public static List <RebateConfigLog> SearchRebateConfigLog(string pkid) { const string sql = @" SELECT rcl.PKID , rcl.IdentityId , rcl.Type , rcl.Msg , rcl.Remark , rcl.IPAddress , rcl.HostName , rcl.OperateUser , rcl.CreateDateTime , rcl.UpdateDateTime FROM Tuhu_log..RebateConfigLog AS rcl WITH ( NOLOCK ) WHERE rcl.IdentityId = @IdentityId Order BY rcl.PKID DESC; "; var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { var cmd = new SqlCommand(sql); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdentityId", pkid); return(dbHelper.ExecuteDataTable(cmd).ConvertTo <RebateConfigLog>().ToList()); } }
public static List <FlashSaleRecordsLog> SelectFlashSalRecordsLog(Guid activityId) { var conn = ConfigurationManager.ConnectionStrings["SystemLog_AlwaysOnRead"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { var cmd = new SqlCommand(@"SELECT * FROM SystemLog..tbl_FlashSaleRecords WITH (NOLOCK) WHERE ActivityID=@ActivityID "); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ActivityID", activityId); return(dbHelper.ExecuteDataTable(cmd).ConvertTo <FlashSaleRecordsLog>().ToList()); } }
public static List <CouponActivityLog> SelectOperationLog(string objectId, string type) { var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { var cmd = new SqlCommand(@"SELECT * FROM Tuhu_log..CouponActivityLog WITH (NOLOCK) WHERE ObjectId=@ObjectId AND Type=@Type ORDER BY CreatedTime DESC"); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ObjectId", objectId); cmd.Parameters.AddWithValue("@Type", type.ToString()); return(dbHelper.ExecuteDataTable(cmd).ConvertTo <CouponActivityLog>().ToList()); } }
public static List <OrderCompletionJudgeCriteria> SelectOrderCompJudgeCriteria(string userId) { var conn = ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } const string sql = "SELECT InstallShopId, Status, TBO.DeliveryStatus, TBO.DeliveryDatetime, InstallDatetime, TBOD.DeliveryStatus AS DeliveryStatusInLog, TBOD.DeliveryDatetime AS DeliveryDatetimeInLog FROM Gungnir..tbl_Order AS TBO WITH(NOLOCK) LEFT JOIN Gungnir.dbo.tbl_OrderDeliveryLog AS TBOD ON TBO.PKID = TBOD.OrderID WHERE TBO.UserID=@UserID"; using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { var cmd = new SqlCommand(sql); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@UserID", userId); return(dbHelper.ExecuteDataTable(cmd).ConvertTo <OrderCompletionJudgeCriteria>().ToList()); } }
public static List <VehicleTypeCertificationAuditLogModel> SelectLogsByCarId(Guid carId) { var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { using (var cmd = new SqlCommand( $@"SELECT * FROM Tuhu_log..VehicleTypeCertificationAuditLog WITH(NOLOCK) WHERE CarId=@carId ORDER BY CreateTime DESC")) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@carId", carId); return(dbHelper.ExecuteDataTable(cmd).ConvertTo <VehicleTypeCertificationAuditLogModel>().ToList()); } } }
public static DataTable GetTousuLog(string objectId, string objectType) { var conn = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { string sql = @"SELECT * FROM Tuhu_log..TousuConfigLog WITH(NOLOCK) WHERE ObjectId=@ObjectId AND ObjectType=@ObjectType ORDER BY PKID DESC"; using (var cmd = new SqlCommand(sql)) { cmd.Parameters.AddWithValue("@ObjectId", objectId); cmd.Parameters.AddWithValue("@ObjectType", objectType); return(dbHelper.ExecuteDataTable(cmd)); } } }
private string CheckPIDSamePriceInOtherActivity(ActivityProduct product) { var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(conn)) { var cmd = new SqlCommand(@"SELECT FS.ActivityID,FSP.Price,FSP.PID FROM Activity..tbl_FlashSale AS FS WITH ( NOLOCK ) JOIN Activity..tbl_FlashSaleProducts AS FSP WITH ( NOLOCK ) ON FSP.ActivityID = FS.ActivityID WHERE FS.EndDateTime > GETDATE() AND FSP.PID = @PID AND FSP.Price <> @Price AND FS.ActivityID<>@ActivityID AND ActiveType IN ( 0, 1 )" ); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@PID", product.PID); cmd.Parameters.AddWithValue("@Price", product.Price); cmd.Parameters.AddWithValue("@ActivityID", product.ActivityID); var dt = dbHelper.ExecuteDataTable(cmd); if (dt == null || dt.Rows.Count == 0) { return(null); } var wrongMsg = ""; foreach (DataRow item in dt.Rows) { wrongMsg += "PID:" + item["PID"].ToString() + " 活动ID:" + item["ActivityID"].ToString() + " 价格:" + Convert.ToDouble(item["Price"]).ToString("C") + "<br/>"; } return(wrongMsg); } }
/// <summary> /// 天天秒杀保存按钮使用 /// </summary> /// <param name="qiang"></param> /// <param name="diffs"></param> /// <param name="dbHelper"></param> /// <returns></returns> public static int SpikeSynchroDiffActivity(QiangGouModel qiang, List <QiangGouDiffModel> diffs, Tuhu.Component.Common.SqlDbHelper dbHelper) { var selectedDiffs = diffs.GroupBy(r => new { r.ActivityID, r.ActiveType }).Select(d => new QiangGouModel { ActivityID = d.Key.ActivityID, ActiveType = d.Key.ActiveType, Products = d.Select(product => new QiangGouProductModel { PID = product.PID, ProductName = product.ProductName, Price = product.Price, FalseOriginalPrice = product.FalseOriginalPrice, InstallAndPay = product.InstallAndPay, IsUsePCode = product.IsUsePCode, }) }); List <QiangGouProductModel> list = new List <QiangGouProductModel>(); //List<QiangGouProductModel> selectedlist = new List<QiangGouProductModel>(); foreach (var a in selectedDiffs) { var selecteddiffs = DALQiangGou.SelectSelectedDiffActivityProducts(a.ActivityID, a.ActiveType, a.Products, dbHelper); list.AddRange(selecteddiffs); } var aids = list.Select(_ => _.ActivityID); foreach (var aid in aids) { var model = DALQiangGou.SelectQiangGouForSynchro(aid, dbHelper); var origin = DALQiangGou.SelectQiangGouForSynchro(aid, dbHelper); var needAsyncPids = list.Where(_ => _.ActivityID == aid).Select(_ => _.PID).ToList(); var tempProducts = model.Products.Where(_ => !needAsyncPids.Contains(_.PID)).ToList(); bool flag = true; foreach (var pid in needAsyncPids) { var product = qiang.Products.FirstOrDefault(_ => _.PID == pid); var y_product = model.Products.FirstOrDefault(_ => _.PID == pid); y_product.ProductName = product.ProductName; y_product.Price = product.Price; y_product.FalseOriginalPrice = product.FalseOriginalPrice; y_product.InstallAndPay = product.InstallAndPay; y_product.IsUsePCode = product.IsUsePCode; tempProducts.Add(y_product); if (!string.IsNullOrWhiteSpace(qiang.NeedExamPids) && qiang.NeedExamPids.Split(';').Contains(pid) && flag) { flag = false; } } model.NeedExam = !flag; model.Products = tempProducts; var result = DALQiangGou.CreateOrUpdateQianggou(dbHelper, model); if (result.Item1 < 0) { dbHelper.Rollback(); return(-38);//同步失败 } else { var chandata = LogChangeDataManager.GetLogChangeData(origin, model); var beforeValue = QiangGouManager.GenerateSimpleQiangGouModel(chandata.Item1); var afterValue = QiangGouManager.GenerateSimpleQiangGouModel(chandata.Item2); var oprLog = new FlashSaleProductOprLog { OperateUser = ThreadIdentity.Operator.Name, CreateDateTime = DateTime.Now, BeforeValue = JsonConvert.SerializeObject(beforeValue), AfterValue = JsonConvert.SerializeObject(afterValue), LogType = "FlashSaleLog", LogId = result.Item2.ToString(), Operation = model.NeedExam ? "同步活动到待审核" : "同步活动" }; LoggerManager.InsertLog("FlashSaleOprLog", oprLog); LoggerManager.InsertFlashSaleLog(chandata.Item1, beforeValue.HashKey); LoggerManager.InsertFlashSaleLog(chandata.Item2, afterValue.HashKey); } } foreach (var aid in aids) { var cache = SpikeReflashCache(aid, false); if (cache == false) { return(-3); } } return(1); }