public static bool InsertWheelAdapterConfigLog(SqlConnection conn, WheelAdapterConfigLog wacl) { string sql = @"INSERT INTO Configuration..WheelAdapterConfigLog(TID,OperateType,CreateDateTime,LastUpdateDateTime,Operator) VALUES(@tid,@operatetype,@createdatetime,@lastupdatedatetime,@operator)"; var sqlParam = new[] { new SqlParameter("@tid", wacl.TID), new SqlParameter("@operatetype", wacl.OperateType), new SqlParameter("@createdatetime", wacl.CreateDateTime), new SqlParameter("@lastupdatedatetime", wacl.LastUpdateDateTime), new SqlParameter("@operator", wacl.Operator), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false); }
public bool InsertWheelAdapterConfigLog(WheelAdapterConfigLog wacl) { try { return(handler.InsertWheelAdapterConfigLog(wacl)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DownloadAppException(1, "InsertWheelAdapterConfigLog", ex); Logger.Log(Level.Error, exception, "InsertWheelAdapterConfigLog"); throw ex; } }
public JsonResult SaveWheelAdapterConfig(WheelAdapterConfigWithTid wac) { bool flag = false; if (wac.PKId == 0) { wac.CreateDateTime = DateTime.Now; wac.LastUpdateDateTime = DateTime.Now; wac.Creator = ThreadIdentity.Operator.Name; flag = WheelAdapterConfigManager.InsertWheelAdapterConfigWithTid(wac); WheelAdapterConfigLog wacl = new WheelAdapterConfigLog() { TID = wac.TID, OperateType = 0, CreateDateTime = wac.CreateDateTime, LastUpdateDateTime = wac.LastUpdateDateTime, Operator = wac.Creator, }; bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl); } else { wac.LastUpdateDateTime = DateTime.Now; flag = WheelAdapterConfigManager.UpdateWheelAdapterConfigWithTid(wac); WheelAdapterConfigLog wacl = new WheelAdapterConfigLog() { TID = wac.TID, OperateType = 1, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now, Operator = ThreadIdentity.Operator.Name, }; bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl); } if (flag) { RefreshCache(new List <string>() { wac.TID }); } return(Json(flag)); }
public bool InsertWheelAdapterConfigLog(WheelAdapterConfigLog wacl) { Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.InsertWheelAdapterConfigLog(connection, wacl); return(dbManager.Execute(action)); }
public static bool InsertWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac, IEnumerable <string> tids) { bool result = true; var props = typeof(WheelAdapterConfigWithTid).GetProperties(); var getresults = SelectWheelAdapterConfigWithTid(conn, tids); if (getresults != null && getresults.Any()) { foreach (var item in getresults) { foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime?) && !string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase) && !string.Equals(x.Name, "tid", StringComparison.OrdinalIgnoreCase) )) { var value = propertyInfo.GetValue(wac); if (value != null) { propertyInfo.SetValue(item, value); } } WheelAdapterConfigLog wacl = new WheelAdapterConfigLog() { TID = item.TID, OperateType = 1, CreateDateTime = wac.CreateDateTime, LastUpdateDateTime = wac.LastUpdateDateTime, Operator = wac.Creator, }; InsertWheelAdapterConfigLog(conn, wacl); item.LastUpdateDateTime = DateTime.Now; item.Creator = wac.Creator; result &= UpdateWheelAdapterConfigWithTid(conn, item); } } var notgetitems = tids.Except(getresults.Select(x => x.TID)).Select(x => { var item = JsonConvert.DeserializeObject <WheelAdapterConfigWithTid>(JsonConvert.SerializeObject(wac)); item.TID = x; return(item); }); foreach (var item in notgetitems) { WheelAdapterConfigLog wacl = new WheelAdapterConfigLog() { TID = item.TID, OperateType = 0, CreateDateTime = wac.CreateDateTime, LastUpdateDateTime = wac.LastUpdateDateTime, Operator = wac.Creator, }; InsertWheelAdapterConfigLog(conn, wacl); result &= InsertWheelAdapterConfigWithTid(conn, item); } return(result); //string sql = ""; //var sqlParam = new List<SqlParameter>(); //var props = typeof(WheelAdapterConfigWithTid).GetProperties(); //List<string> insertsqls = new List<string>(); //foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime) && !string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase))) //{ //} //var records = new List<SqlDataRecord>(tids.Count()); //foreach (var target in tids) //{ // var record = new SqlDataRecord(new SqlMetaData("Pid", SqlDbType.Char, 40)); // var chars = new SqlChars(target.ToString()); // record.SetSqlChars(0, chars); // records.Add(record); //} //using (var cmd = new SqlCommand(sql)) //{ // cmd.CommandType = CommandType.Text; // SqlParameter p = new SqlParameter("@TVP", SqlDbType.Structured); // p.TypeName = "dbo.Pids"; // p.Value = records; // sqlParam.Add(p); // //return await dbhelper.ExecuteNonQueryAsync(cmd); // return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam.ToArray()) > 0; //} }