/// <summary> /// Положить на булочку /// </summary> /// <param name="food"> Продукт </param> public void PutOnBread(Food food) { Pan p = food.gameObject.transform.root.GetChild(0).GetComponent <Pan>(); foreach (var plate in p.plates) { if (!plate.IsEmpty && plate.food.dish == Dish.Bread) { GameObject newObj; Destroy(plate.spawnPoint.gameObject.transform.GetChild(0).gameObject); if (plate.gameObject.tag == "BurgerBread") { newObj = Instantiate(burgerPrefab, plate.spawnPoint); } else { newObj = Instantiate(hotDogPrefab, plate.spawnPoint); } plate.food = newObj.GetComponentInChildren <Food>(); p.IsEmpty = true; Destroy(food.transform.parent.gameObject); break; } } }
internal LookAround(Pan action) { this.IsChildAction = true; this.Type = KeyActionType.LookAround; this.mPan = action; this.ParentAction = (IMAction)action; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Affiliate model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Affiliate("); strSql.Append("enterprise,enterprise_type,person,person_post,mobile_num,time)"); strSql.Append(" values ("); strSql.Append("@enterprise,@enterprise_type,@person,@person_post,@mobile_num,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@enterprise", SqlDbType.VarChar,50), new SqlParameter("@enterprise_type", SqlDbType.VarChar,20), new SqlParameter("@person", SqlDbType.VarChar,16), new SqlParameter("@person_post", SqlDbType.VarChar,20), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@time", SqlDbType.Char,20)}; parameters[0].Value = model.enterprise; parameters[1].Value = model.enterprise_type; parameters[2].Value = model.person; parameters[3].Value = model.person_post; parameters[4].Value = model.mobile_num; parameters[5].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
bool ConsumeTouch(TouchInfo touch) { if (touch.now.phase == TouchPhase.Began && !touch.canvas && Picker.instance.GetPickerTile(touch.now.position, PickMask.Floor, out Vector3Int pickerPosition)) { pans.Add(new Pan { fingerId = touch.now.fingerId, startingTile = pickerPosition, startingPixelCoordinate = touch.now.position }); return(false); } if (touch.now.phase == TouchPhase.Moved) { for (int i = 0, len = pans.Count; i < len; ++i) { Pan pan = pans[i]; if (!pan.panningBegan && Picker.instance.GetPickerTile(touch.now.position, PickMask.Floor, out pickerPosition) && pickerPosition != pan.startingTile) { pan.panningBegan = true; pans[i] = pan; return(true); } } } return(false); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Credit model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Credit("); strSql.Append("name,sex,mobile_num,i_num,collateral,limit_date,time)"); strSql.Append(" values ("); strSql.Append("@name,@sex,@mobile_num,@i_num,@collateral,@limit_date,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,16), new SqlParameter("@sex", SqlDbType.Char,2), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@i_num", SqlDbType.Int,4), new SqlParameter("@collateral", SqlDbType.Char,10), new SqlParameter("@limit_date", SqlDbType.Char,12), new SqlParameter("@time", SqlDbType.Char,20)}; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.mobile_num; parameters[3].Value = model.i_num; parameters[4].Value = model.collateral; parameters[5].Value = model.limit_date; parameters[6].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public override void RevertChanges() { Filter.RevertChanges(); Phaser.RevertChanges(); Flanger.RevertChanges(); Synth.RevertChanges(); LoFi.RevertChanges(); RingModulator.RevertChanges(); GuitarToBass.RevertChanges(); SlowGear.RevertChanges(); Transpose.RevertChanges(); PitchBend.RevertChanges(); Robot.RevertChanges(); VocalDist.RevertChanges(); Dynamics.RevertChanges(); Eq.RevertChanges(); Isolator.RevertChanges(); Octave.RevertChanges(); Pan.RevertChanges(); Tremolo.RevertChanges(); Slicer.RevertChanges(); Delay.RevertChanges(); PanningDelay.RevertChanges(); TapeEcho.RevertChanges(); GranularDelay.RevertChanges(); Roll.RevertChanges(); Chorus.RevertChanges(); Reverb.RevertChanges(); }
public void ZoomToFit(double margin = 10) { var selectedNodes = SelectedModels.Where(s => s is NodeModel).Select(s => (NodeModel)s).ToList(); if (selectedNodes.Count == 0 && _nodes.Count == 0) { return; } (var minX, var maxX, var minY, var maxY) = GetNodesRect(selectedNodes); var width = maxX - minX + 2 * margin; var height = maxY - minY + 2 * margin; minX -= margin; minY -= margin; var xf = Container.Width / width; var yf = Container.Height / height; Zoom = Math.Min(xf, yf); var nx = Container.Left + Pan.X + minX * Zoom; var ny = Container.Top + Pan.Y + minY * Zoom; Pan = Pan.Add(Container.Left - nx, Container.Top - ny); Refresh(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Feedback model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Feedback("); strSql.Append("name,sex,mobile_num,content,time)"); strSql.Append(" values ("); strSql.Append("@name,@sex,@mobile_num,@content,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,16), new SqlParameter("@sex", SqlDbType.Char,4), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@content", SqlDbType.VarChar,255), new SqlParameter("@time", SqlDbType.Char,20)}; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.mobile_num; parameters[3].Value = model.content; parameters[4].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public void Test_Pan() { var sut = new Pan(); Assert.True(sut.Name.Equals("Pan")); Assert.True(sut.Price.Equals(5.00m)); }
//确定 private void okBtn_Click(object sender, EventArgs e) { string _amount = amount.Text.Trim(); string _paner = paner.Text; string _note = note.Text.Trim(); if (_amount == "") { BathClass.printErrorMsg("需要填入实际库存!"); return; } if (_paner == "") { BathClass.printErrorMsg("需要选择盘点员工!"); return; } var p = new Pan(); p.name = name.Text; p.amount = Convert.ToDouble(_amount) - amount_p; p.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id; p.date = DateTime.Now; p.paner = _paner; p.note = _note; db.Pan.InsertOnSubmit(p); db.SubmitChanges(); this.Close(); }
public VirtualSchemaContainer() { // InitializeComponent(); scroller = new ScrollViewer(); scroller.HorizontalScrollBarVisibility = ScrollBarVisibility.Visible; scroller.VerticalScrollBarVisibility = ScrollBarVisibility.Visible; scroller.CanContentScroll = true; Child = scroller; grid = new VirtualCanvas(); scroller.Content = grid; grid.SmallScrollIncrement = new Size(_tileWidth + _tileMargin, _tileHeight + _tileMargin); //Scroller.Content = grid; object v = scroller.GetValue(ScrollViewer.CanContentScrollProperty); Canvas target = grid.ContentCanvas; zoom = new MapZoom(target); pan = new Pan(target, zoom); rectZoom = new RectangleSelectionGesture(target, zoom, System.Windows.Input.ModifierKeys.Control); rectZoom.ZoomSelection = true; autoScroll = new AutoScroll(target, zoom); zoom.ZoomChanged += new EventHandler(OnZoomChanged); grid.VisualsChanged += new EventHandler <VisualChangeEventArgs>(OnVisualsChanged); //ZoomSlider.ValueChanged += new RoutedPropertyChangedEventHandler<double>(OnZoomSliderValueChanged); grid.Scale.Changed += new EventHandler(OnScaleChanged); grid.Translate.Changed += new EventHandler(OnScaleChanged); grid.Background = new SolidColorBrush(Color.FromRgb(0xd0, 0xd0, 0xd0)); grid.ContentCanvas.Background = Brushes.White; }
internal PanShoot(Pan action) { this.IsChildAction = true; this.Type = KeyActionType.PanShoot; this.mPan = action; this.ParentAction = (IMAction)action; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.FriendLink model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into FriendLink("); strSql.Append("name,link,[order])"); strSql.Append(" values ("); strSql.Append("@name,@link,@order)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,40), new SqlParameter("@link", SqlDbType.VarChar,40), new SqlParameter("@order", SqlDbType.Int,4)}; parameters[0].Value = model.name; parameters[1].Value = model.link; parameters[2].Value = model.order; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public void Status() { Console.WriteLine("*************************************"); Console.WriteLine("Mode Pan: " + Pan.ToString()); Console.WriteLine("Mode Select: " + Select.ToString()); Console.WriteLine("Mode Zoom: " + Zoom.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.PageSet model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PageSet("); strSql.Append("href,column,title,keywords,description)"); strSql.Append(" values ("); strSql.Append("@href,@column,@title,@keywords,@description)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@href", SqlDbType.VarChar,40), new SqlParameter("@column", SqlDbType.VarChar,40), new SqlParameter("@title", SqlDbType.VarChar,225), new SqlParameter("@keywords", SqlDbType.VarChar,225), new SqlParameter("@description", SqlDbType.VarChar,225)}; parameters[0].Value = model.href; parameters[1].Value = model.column; parameters[2].Value = model.title; parameters[3].Value = model.keywords; parameters[4].Value = model.description; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
private void Init() { if (Document.DocumentMode == DocumentMode.Auto) { List <Node> nodes = NodeFactory.CreateNodes(30); ContentControl.PopulateNodes(nodes); LinkFactory.Nodes = nodes; ContentControl.PopulateLinks(LinkFactory.CreateLinks(60)); } Canvas target = ContentControl.ContentCanvas; zoom = new MapZoom(target); pan = new Pan(target, zoom); rectZoom = new RectangleSelectionGesture(target, zoom, ModifierKeys.Control); rectZoom.ZoomSelection = true; autoScroll = new AutoScroll(target, zoom); zoom.ZoomChanged += new EventHandler(OnZoomChanged); ContentControl.VisualsChanged += new EventHandler <VisualChangeEventArgs>(OnVisualsChanged); //ZoomSlider.ValueChanged += new RoutedPropertyChangedEventHandler<double>(OnZoomSliderValueChanged); ContentControl.Scale.Changed += new EventHandler(OnScaleChanged); ContentControl.Translate.Changed += new EventHandler(OnScaleChanged); //ContentControl.Background = new SolidColorBrush(Color.FromRgb(0xd0, 0xd0, 0xd0)); ContentControl.Background = new SolidColorBrush(Colors.White); ContentControl.ContentCanvas.Background = Brushes.White; Document.Nodes = ContentControl.Nodes; Document.Links = ContentControl.Links; }
public static void getOne_Postfix(ref Pan __instance, ref Item __result) { if (__result is Pan panResult) { panResult.UpgradeLevel = __instance.UpgradeLevel; } }
public override XmlElement VToXML() { var componentDoc = new XmlDocument(); var componentData = componentDoc.CreateElement(GetComponentName <Cv_SoundEmitterComponent>()); var sound = componentDoc.CreateElement("SoundEffect"); var volume = componentDoc.CreateElement("Volume"); var pan = componentDoc.CreateElement("Pan"); var pitch = componentDoc.CreateElement("Pitch"); var looping = componentDoc.CreateElement("Looping"); var positional = componentDoc.CreateElement("IsPositional"); var autoPlay = componentDoc.CreateElement("AutoPlay"); sound.SetAttribute("resource", SoundResource); volume.SetAttribute("value", Volume.ToString(CultureInfo.InvariantCulture)); pan.SetAttribute("value", Pan.ToString(CultureInfo.InvariantCulture)); pitch.SetAttribute("value", Pitch.ToString(CultureInfo.InvariantCulture)); looping.SetAttribute("status", Looping.ToString(CultureInfo.InvariantCulture)); positional.SetAttribute("status", IsPositional.ToString(CultureInfo.InvariantCulture)); autoPlay.SetAttribute("status", AutoPlay.ToString(CultureInfo.InvariantCulture)); componentData.AppendChild(sound); componentData.AppendChild(volume); componentData.AppendChild(pan); componentData.AppendChild(pitch); componentData.AppendChild(looping); componentData.AppendChild(positional); componentData.AppendChild(autoPlay); return(componentData); }
private void SetUpNextEnviroment(GameEnviroment ge) { float newX = 0; //Randomise the position of the next gbb if (targetRange.x < targetRange.y) { newX = UnityEngine.Random.Range(targetRange.x, targetRange.y); } if (targetRange.y < targetRange.x) { newX = UnityEngine.Random.Range(targetRange.y, targetRange.x); } ge.gbb.transform.position = new Vector3(newX, ge.gbb.transform.position.y, 0); // Calculate game target size based on score and difficulty float xDiff = 1; float yDiff = 1; if (difficulty) { Vector2 diff = difficulty.GetGoalSize(score); xDiff = diff.x; yDiff = diff.y; } // Determine size of target Vector2 newSize = new Vector2((ge.gbb.transform.localScale.x + targetIncrease.x) * xDiff, (ge.gbb.transform.transform.localScale.y + targetIncrease.y) * yDiff); // Increase size of game target ge.gbb.transform.localScale = newSize; // Add spin/flair float randZ = UnityEngine.Random.Range(flairStrength.x, flairStrength.y); Vector3 newRot = new Vector3(0, 0, randZ); ge.gbb.transform.DORotate(newRot, flairDuration, RotateMode.FastBeyond360); // Add Pan if (score >= difficulty.addPanAt) { Pan newPan = ge.gbb.gameObject.AddComponent <Pan>(); newPan.target = new Vector2(-ge.gbb.transform.position.x, ge.gbb.transform.localPosition.y); newPan.duration = difficulty.GetPanDuration(score); } // Calculate players gbb size based on score and difficulty if (difficulty) { Vector2 diff = difficulty.GetGbbSize(score); xDiff = diff.x; yDiff = diff.y; } // Determine size of the players gbb newSize = new Vector2((player.GetComponent <ThingController>().bounds.transform.lossyScale.x + boundsIncrease.x) * xDiff, (player.GetComponent <ThingController>().bounds.transform.lossyScale.y + boundsIncrease.y) * yDiff); //Increase size of players gbb player.GetComponent <ThingController>().bounds.transform.DOScale(newSize, animationDuration); if (player.GetComponent <ThingController>().bounds.GetComponent <Pan>()) { Destroy(player.GetComponent <ThingController>().bounds.GetComponent <Pan>()); } }
public override Utensil CreateUtensil(List <string> values) { Pan pan = new Pan(); SetProperties(pan, values); return(pan); }
public byte[] CameraPanTilt(uint deviceAddress, Pan panAction, uint panSpeed, Tilt tiltAction, uint tiltSpeed) { byte[] mTiltMessage = CameraTilt(deviceAddress, tiltAction, tiltSpeed); byte[] mPanMessage = CameraPan(deviceAddress, panAction, panSpeed); byte[] mBytes = Message.GetMessage(deviceAddress, 0x00, (byte)(mTiltMessage[3] + mPanMessage[3]), mPanMessage[4], mTiltMessage[5]); return(mBytes); }
public static API.Rpc.Pan ToModel(this Pan entity) { return(new API.Rpc.Pan { Left = entity.Left, Right = entity.Right }); }
//private ProductPictrueShowWin _showPictrueWin; public SubordinateRetailAggregation() { this.DataContext = new SubordinateRetailAggregationVM(); InitializeComponent(); var pan = new Pan(); pan.Invest(bdPictrueShow, bdPictrueShow); }
public BoardTemplate SetupBoard(SynthData data) { var board = new BoardTemplate(); board.AddBoard(data.SubBoards["glideSubBoard"]); board.AddBoard(data.SubBoards["pitchWheelSubBoard"]); board.AddBoard(data.SubBoards["volumeControlSubBoard"]); var env1 = new Envelope(30, 240, 0.6f, 40, 3); var o1 = new OscillatorModule(new SawOscillator(), 1); var o2 = new OscillatorModule(new SawOscillator(), 1, 0.08f); var o3 = new OscillatorModule(new SawOscillator(), 1, 11.92f); var d1 = new Distributer(new float[] { 1, 0.7f, 0.0f }, new float[] { 1 }); //var sf1 = new EffectModule(new SimpleFilter(5)); var sf1 = new EffectModule(new Filter(Filter.GenerateSincKernel((float)FilterCutoff.Value, 64, data.SampleRate))); var g1 = new EffectModule(new Boost(0.2f)); var lfo2 = new ConstantOscillatorModule(new SineOscillator(), 1, 0.5f); var p1 = new Pan(); var endLeft = new EndModule(false); var endRight = new EndModule(true); board.Add(endLeft, endRight, sf1, d1, o3, o2, o1, env1, g1, lfo2, p1); //board.AddConnections(glideIn, glideTranslate, glideOut); //board.AddConnection(pitchWheel, pitchShift); //board.AddConnections(volumeControl, volumeTranslate, boardGain); board.AddConnection(env1, o1, destIndex: 0); board.AddConnection(env1, o2, destIndex: 0); board.AddConnection(env1, o3, destIndex: 0); board.AddConnection(o1, d1); board.AddConnection(o2, d1); board.AddConnection(o3, d1); board.AddConnections(d1, g1, sf1, p1); board.AddConnection(p1, endLeft); board.AddConnection(p1, endRight); return(board); }
private void axMapControl1_OnMouseUp(object sender, IMapControlEvents2_OnMouseUpEvent e) { //漫游(BaseTool方法) if (pan != null) { pan.OnMouseUp(e.button, e.shift, e.x, e.y); //调用前面定义的pan.cs的函数 pan = null; } }
private List <float> beatWithClips = new List <float>(); // Whenever the AudioElement is played, this keep tracks of what beat the // clip is played at so that other clips don't get triggered at the // same time void Awake() { sources.Init(this, randomVolume); Category c = AudioElementManager.instance.AddElement(GetComponent <AudioElement>()); volume = new Volume(settings.volume, c.volume.GetVolume(), sources); pan = new Pan(settings.pan, sources); beatWithClips.Add(0f); }
public static byte[] CameraPan(uint deviceAddress, Pan action, uint speed) { if (speed < PanSpeedMax) { speed = PanSpeedMax; } return(Message.GetMessage(deviceAddress, 0x00, (byte)action, (byte)speed, 0x00)); }
/// <summary> /// Resets the unput, is called on LateUpdate /// </summary> public void Reset() { foreach (Key k in Keys.Values) { k.Update(); } Swipe.Update(); Pan.Update(); }
/// <summary> /// 点击菜单响应 /// </summary> private void menuPan_Click(object sender, EventArgs e) { //声明并初始化 pan = new Pan(); //关联MapControl pan.OnCreate(this.axMapControl1.Object); //设置鼠标形状 this.axMapControl1.CurrentTool = pan; this.axMapControl1.MousePointer = esriControlsMousePointer.esriPointerPan; }
private void MoveTouch(TouchState touch) { var index = IndexOfTouch(touch); if (index < 0) { return; } if (_activeTouches.Count == 1) { var dist = touch.ScreenPosition - _activeTouches[index].ScreenPosition; var contact = _environment.Raycast(touch.ScreenPosition); if (_potentialClick) { if (dist.LengthSquared < ClickThresholdSquared) { return; } _potentialClick = false; ClickCanceled?.Invoke(this, new SimpleInteractionEventArgs(contact)); } Pan?.Invoke(this, new PanInteractionEventArgs(Move(contact, _activeTouches[index].ScreenPosition), contact)); } else if (_activeTouches.Count >= 2) { var center = _multitouchCenter; var dist = _panningDistance; var angle = _panningAngle; CalculatePanning(out center, out dist, ref angle); if (center != _multitouchCenter) { var oldContact = _environment.Raycast(_multitouchCenter); var newContact = _environment.Raycast(center); Pan?.Invoke(this, new PanInteractionEventArgs(oldContact, newContact)); _multitouchCenter = center; } if (angle != _panningAngle) { var oldContact = _environment.Raycast(_multitouchCenter); Rotate?.Invoke(this, new RotateInteractionEventArgs(oldContact, angle - _panningAngle)); _panningAngle = angle; } if (dist != _panningDistance) { var oldContact = _environment.Raycast(_multitouchCenter); Zoom?.Invoke(this, new ZoomInteractionEventArgs(oldContact, dist - _panningDistance)); _panningDistance = dist; } } _activeTouches[index].Update(touch); }
public void Pan_MaskedValue_provides_the_PAN_with_first_twelve_digits_masked() { var input1 = "1111222233334444"; var input2 = "5555666677778888"; var pan1 = new Pan(input1); var pan2 = new Pan(input2); Assert.Equal("************4444", pan1.MaskedValue); Assert.Equal("************8888", pan2.MaskedValue); }
public static bool PerformSpecialItemGrabReplacement_Prefix(Item heldItem, ref Item __result) { if (heldItem != null && heldItem is PanHat panHat) { Pan pan = new Pan(); pan.UpgradeLevel = panHat.UpgradeLevel; __result = pan; return(false); } return(true); }
public void Can_serialize_valid_PAN() { var jsonSerializerOptions = new JsonSerializerOptions(); jsonSerializerOptions.Converters.Add(new CardPanJsonConverter()); var panInput = "1111222233334444"; var pan = new Pan(panInput); var panJson = JsonSerializer.Serialize(pan, jsonSerializerOptions); Assert.Equal(@$ "" "{panInput}" "", panJson); }
public static void OnPan(Point p) { var dragX = p.X - _previousPosX; var dragY = p.Y - _previousPosY; _previousPosX = p.X; _previousPosY = p.Y; Pan?.Invoke(new Point(p.X, p.Y)); OnSwipe(new Point(dragX, dragY)); }
protected override void RenderContent(UnityEngine.Object undoRecordObject) { MoveForward.RenderEditorGUI(undoRecordObject); MoveBack.RenderEditorGUI(undoRecordObject); StrafeLeft.RenderEditorGUI(undoRecordObject); StrafeRight.RenderEditorGUI(undoRecordObject); MoveUp.RenderEditorGUI(undoRecordObject); MoveDown.RenderEditorGUI(undoRecordObject); Pan.RenderEditorGUI(undoRecordObject); LookAround.RenderEditorGUI(undoRecordObject); Orbit.RenderEditorGUI(undoRecordObject); }
public int Add(Pan.Model.FooterSEO model) { string sql = "insert into FooterSEO(keys,val) values(@keys,@val);select @@IDENTITY"; SqlParameter[] parameters = { new SqlParameter("@keys", SqlDbType.NVarChar,50), new SqlParameter("@val", SqlDbType.NVarChar,50) }; parameters[0].Value = model.Keys; parameters[1].Value = model.Val; object obj = DbHelperSQL.GetSingle(sql, parameters); if (obj != null) { return (int)obj; } return 0; }
public ActionResult AccountEdit(Pan.Model.account model) { System.Security.Cryptography.MD5CryptoServiceProvider md5 = new System.Security.Cryptography.MD5CryptoServiceProvider(); model.pwd = BitConverter.ToString(md5.ComputeHash(UTF8Encoding.Default.GetBytes(model.pwd))).Replace("-", ""); if (string.IsNullOrEmpty(model.id.ToString()) || model.id == 0) { account.Add(model); } else { account.Update(model); } return RedirectToAction("Accounts"); }
public int Update(Pan.Model.FooterSEO model) { string sql = "update FooterSEO set keys=@keys, val=@val where id=@id "; SqlParameter[] parameters = { new SqlParameter("",SqlDbType.NVarChar,50), new SqlParameter("",SqlDbType.NVarChar,50), new SqlParameter("",SqlDbType.Int) }; parameters[0].Value = model.Keys; parameters[1].Value = model.Val; parameters[2].Value = model.Id; object obj = DbHelperSQL.GetSingle(sql, parameters); if (obj != null) { return (int)obj; } return 0; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into News("); strSql.Append("title,summary,isTop,isReco,type,content,author,source,views,keywords,description,time)"); strSql.Append(" values ("); strSql.Append("@title,@summary,@isTop,@isReco,@type,@content,@author,@source,@views,@keywords,@description,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar,80), new SqlParameter("@summary", SqlDbType.VarChar,225), new SqlParameter("@isTop", SqlDbType.Char,2), new SqlParameter("@isReco", SqlDbType.Char,2), new SqlParameter("@type", SqlDbType.VarChar,20), new SqlParameter("@content", SqlDbType.VarChar,-1), new SqlParameter("@author", SqlDbType.VarChar,20), new SqlParameter("@source", SqlDbType.VarChar,40), new SqlParameter("@views", SqlDbType.Char,10), new SqlParameter("@keywords", SqlDbType.VarChar,225), new SqlParameter("@description", SqlDbType.VarChar,225), new SqlParameter("@time", SqlDbType.Char,20)}; parameters[0].Value = model.title; parameters[1].Value = model.summary; parameters[2].Value = model.isTop; parameters[3].Value = model.isReco; parameters[4].Value = model.type; parameters[5].Value = model.content; parameters[6].Value = model.author; parameters[7].Value = model.source; parameters[8].Value = model.views; parameters[9].Value = model.keywords; parameters[10].Value = model.description; parameters[11].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.account model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into account("); strSql.Append("uid,pwd)"); strSql.Append(" values ("); strSql.Append("@uid,@pwd)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@uid", SqlDbType.VarChar,20), new SqlParameter("@pwd", SqlDbType.Char,32)}; parameters[0].Value = model.uid; parameters[1].Value = model.pwd; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Questions model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Questions("); strSql.Append("title,content)"); strSql.Append(" values ("); strSql.Append("@title,@content)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar,128), new SqlParameter("@content", SqlDbType.VarChar,-1)}; parameters[0].Value = model.title; parameters[1].Value = model.content; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
public ActionResult Editq(Pan.Model.Questions model) { if (string.IsNullOrEmpty(model.id.ToString()) || model.id.ToString() == "0") { q.Add(model); } else { q.Update(model); } return RedirectToAction("ql"); }
public ActionResult EditNews(Pan.Model.News model) { if (!ModelState.IsValid) { return Content(JavaScriptHandler.AlertAndBack("数据验证错误,请检查!")); } if (model.isTop == null) { model.isTop = "否"; } if (model.isReco == null) { model.isReco = "否"; } if (string.IsNullOrEmpty(model.id.ToString()) || model.id.ToString() == "0") { news.Add(model); } else { news.Update(model); } return RedirectToAction("News"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.FriendLink model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update FriendLink set "); strSql.Append("name=@name,"); strSql.Append("link=@link,"); strSql.Append("[order]=@order"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,40), new SqlParameter("@link", SqlDbType.VarChar,40), new SqlParameter("@order", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.name; parameters[1].Value = model.link; parameters[2].Value = model.order; parameters[3].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
public byte[] CameraPanTilt(uint deviceAddress,Pan panAction, uint panSpeed, Tilt tiltAction, uint tiltSpeed) { byte[] mTiltMessage = CameraTilt(deviceAddress,tiltAction,tiltSpeed); byte[] mPanMessage = CameraPan(deviceAddress,panAction,panSpeed); byte[] mBytes = Message.GetMessage(deviceAddress,0x00,(byte)(mTiltMessage[3]+mPanMessage[3]), mPanMessage[4],mTiltMessage[5]); return mBytes; }
public byte[] CameraPan(uint deviceAddress,Pan action, uint speed) { if(speed<PanSpeedMin) speed = PanSpeedMin; if(speed<PanSpeedMax) speed = PanSpeedMax; return Message.GetMessage(deviceAddress,0x00,(byte)action,(byte)speed,0x00); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Questions model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Questions set "); strSql.Append("title=@title,"); strSql.Append("content=@content"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar,128), new SqlParameter("@content", SqlDbType.VarChar,-1), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.title; parameters[1].Value = model.content; parameters[2].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Affiliate model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Affiliate set "); strSql.Append("enterprise=@enterprise,"); strSql.Append("enterprise_type=@enterprise_type,"); strSql.Append("person=@person,"); strSql.Append("person_post=@person_post,"); strSql.Append("mobile_num=@mobile_num,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@enterprise", SqlDbType.VarChar,50), new SqlParameter("@enterprise_type", SqlDbType.VarChar,20), new SqlParameter("@person", SqlDbType.VarChar,16), new SqlParameter("@person_post", SqlDbType.VarChar,20), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@time", SqlDbType.Char,20), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.enterprise; parameters[1].Value = model.enterprise_type; parameters[2].Value = model.person; parameters[3].Value = model.person_post; parameters[4].Value = model.mobile_num; parameters[5].Value = model.time; parameters[6].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Investment model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.FriendLink model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Feedback model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Feedback set "); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("mobile_num=@mobile_num,"); strSql.Append("content=@content,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,16), new SqlParameter("@sex", SqlDbType.Char,4), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@content", SqlDbType.VarChar,255), new SqlParameter("@time", SqlDbType.Char,20), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.mobile_num; parameters[3].Value = model.content; parameters[4].Value = model.time; parameters[5].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Credit model) { return dal.Update(model); }
public ActionResult FriendLinkEdit(Pan.Model.FriendLink model) { if (string.IsNullOrEmpty(model.id.ToString()) || model.id == 0) { fl.Add(model); } else { fl.Update(model); } return RedirectToAction("FriendLink"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Investment model) { return dal.Add(model); }
public ActionResult PageSetEdit(Pan.Model.PageSet model) { Pan.BLL.PageSet ps = new PageSet(); ps.Update(model); return RedirectToAction("pageset"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.Credit model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Credit set "); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("mobile_num=@mobile_num,"); strSql.Append("i_num=@i_num,"); strSql.Append("collateral=@collateral,"); strSql.Append("limit_date=@limit_date,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar,16), new SqlParameter("@sex", SqlDbType.Char,2), new SqlParameter("@mobile_num", SqlDbType.Char,11), new SqlParameter("@i_num", SqlDbType.Int,4), new SqlParameter("@collateral", SqlDbType.Char,10), new SqlParameter("@limit_date", SqlDbType.Char,12), new SqlParameter("@time", SqlDbType.Char,20), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.mobile_num; parameters[3].Value = model.i_num; parameters[4].Value = model.collateral; parameters[5].Value = model.limit_date; parameters[6].Value = model.time; parameters[7].Value = model.id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.FriendLink model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.Credit model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Pan.Model.News model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Pan.Model.News model) { return dal.Update(model); }