public static bool UpdateWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac) { string sql = @"UPDATE Configuration..WheelAdapterConfigWithTid SET PCD=@pcd, ET=@et, MinET=@minet, MaxET=@maxet, CB=@cb, BoltNutSpec=@boltnutspec, BoltNut=@boltnut, MinWheelSize=@minwheelsize, MaxWheelSize=@maxwheelsize, MinWheelWidth=@minwheelwidth, MaxWheelWidth=@maxwheelwidth, LastUpdateDateTime=@lastupdatedatetime WHERE TID=@tid"; var sqlParam = new[] { new SqlParameter("@tid", wac.TID), new SqlParameter("@pcd", wac.PCD), new SqlParameter("@et", wac.ET), new SqlParameter("@minet", wac.MinET), new SqlParameter("@maxet", wac.MaxET), new SqlParameter("@cb", wac.CB), new SqlParameter("@boltnutspec", wac.BoltNutSpec), new SqlParameter("@boltnut", wac.BoltNut), new SqlParameter("@minwheelsize", wac.MinWheelSize), new SqlParameter("@maxwheelsize", wac.MaxWheelSize), new SqlParameter("@minwheelwidth", wac.MinWheelWidth), new SqlParameter("@maxwheelwidth", wac.MaxWheelWidth), new SqlParameter("@lastupdatedatetime", wac.LastUpdateDateTime), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false); }
public static bool InsertWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac) { string sql = @"INSERT INTO Configuration..WheelAdapterConfigWithTid (TID,PCD,ET,MinET,MaxET,CB,BoltNutSpec,BoltNut,MinWheelSize,MaxWheelSize, MinWheelWidth,MaxWheelWidth,CreateDateTime,LastUpdateDateTime,Creator) VALUES(@tid,@pcd,@et,@minet,@maxet,@cb,@boltnutspec,@boltnut,@minwheelsize,@maxwheelsize, @minwheelwidth,@maxwheelwidth,@createdatetime,@lastupdatedatetime,@creator)"; var sqlParam = new[] { new SqlParameter("@tid", wac.TID), new SqlParameter("@pcd", wac.PCD), new SqlParameter("@et", wac.ET), new SqlParameter("@minet", wac.MinET), new SqlParameter("@maxet", wac.MaxET), new SqlParameter("@cb", wac.CB), new SqlParameter("@boltnutspec", wac.BoltNutSpec), new SqlParameter("@boltnut", wac.BoltNut), new SqlParameter("@minwheelsize", wac.MinWheelSize), new SqlParameter("@maxwheelsize", wac.MaxWheelSize), new SqlParameter("@minwheelwidth", wac.MinWheelWidth), new SqlParameter("@maxwheelwidth", wac.MaxWheelWidth), new SqlParameter("@createdatetime", wac.CreateDateTime), new SqlParameter("@lastupdatedatetime", wac.LastUpdateDateTime), new SqlParameter("@creator", wac.Creator), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false); }
public JsonResult BatchSaveWheelAdapterConfig(WheelAdapterConfigWithTid wac, IEnumerable <string> tids) { var props = typeof(WheelAdapterConfigWithTid).GetProperties(); wac.CreateDateTime = DateTime.Now; wac.LastUpdateDateTime = DateTime.Now; wac.Creator = ThreadIdentity.Operator.Name; var result = WheelAdapterConfigManager.InsertWheelAdapterConfigWithTid(wac, tids); return(Json(result)); }
public ActionResult WheelAdapterEditModule(string tid) { List <WheelAdapterConfigWithTid> waclist = WheelAdapterConfigManager.SelectWheelAdapterConfigWithTid(tid); WheelAdapterConfigWithTid wac = new WheelAdapterConfigWithTid(); if (waclist.Count > 0) { wac = waclist[0]; } else { wac.PKId = 0; wac.TID = tid; } return(View(wac)); }
public bool UpdateWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac) { try { return(handler.UpdateWheelAdapterConfigWithTid(wac)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DownloadAppException(1, "UpdateWheelAdapterConfigWithTid", ex); Logger.Log(Level.Error, exception, "UpdateWheelAdapterConfigWithTid"); throw ex; } }
public bool InsertWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac, IEnumerable <string> tids) { try { return(handler.InsertWheelAdapterConfigWithTid(wac, tids)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DownloadAppException(1, "InsertWheelAdapterConfigWithTid", ex); Logger.Log(Level.Error, exception, "InsertWheelAdapterConfigWithTid"); 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 UpdateWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac) { Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.UpdateWheelAdapterConfigWithTid(connection, wac); return(dbManager.Execute(action)); }
public bool InsertWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac, IEnumerable <string> tids) { Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.InsertWheelAdapterConfigWithTid(connection, wac, tids); 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; //} }