/// <summary> /// 编辑终端信息 /// </summary> public void Edit(Model.Terminal terminal, Model.Source source1) { terminal.Update(); //循环更新附件 string[] picName = source1.SourceUrl.Replace("|$|", "&").Split(new char[] { '&' }); for (int i = 0; i < picName.Length - 1; i++) { string[] picUrl = picName[i].Replace("|#|", "|").Split(new char[] { '|' }); source1.SourceUrl = picUrl[1]; source1.SourceType = picUrl[0]; Hashtable ht = new Hashtable(); ht.Add("TerGuid", source1.TerGuid); ht.Add("SourceType", source1.SourceType); if (source1.IsExist(ht)) { source1.Update( "SourceUrl='" + source1.SourceUrl + "'", " and TerGuid='" + source1.TerGuid + "' and SourceType='" + source1.SourceType + "'"); } else { source1.CreateTime = DateTime.Now; source1.Insert(); } } }
public ActionResult Create(Memo m) { //Insert the object myModel.Insert(m); //Come back to the main page return(RedirectToAction("Index")); }
private void ModelSaveButtonInsert_Click(object sender, RoutedEventArgs e) { Model _Model = new Model(); _Model.str_Description = ModelBezeichnungUpdateInsert.Text; foreach (Hersteller item in DataController.ReturnHersteller()) { if (ModelHerstellerUpdateInsert.Text == item.str_Name) { _Model.int_Manufacturer = item.int_ID; } } _Model.Insert(); DataController.CreateDataLayer(); HerstellerGrid = _Controller.FillHerstellerGrid(HerstellerGrid, DataController.ReturnHersteller()); ModelGrid = _Controller.FillModelGrid(ModelGrid, DataController.ReturnModels()); ArticleGrid = _Controller.FillArticleGrid(ArticleGrid, DataController.ReturnLiveArtikel()); // Clear formular _Controller.ClearGrid(ModelInsertGrid, true); ModelNothingSelectedInsert.Content = "Datensatz erfolgreich erstellt!"; ModelNothingSelectedInsert.Foreground = Brushes.Green; ModelNothingSelectedInsert.Visibility = Visibility.Visible; ModelSaveButtonInsert.IsEnabled = false; }
/* ----------------------------------------------------------------- */ /// /// SetCommands /// /// <summary> /// Sets commands of the MainWindow. /// </summary> /// /* ----------------------------------------------------------------- */ private void SetCommands() { Open = IsDrop(); InsertOrMove = IsDragMove(); Recent.Open = IsLink(); Ribbon.Open.Command = Any(() => PostOpen(e => Model.Open(e))); Ribbon.Close.Command = Close(); Ribbon.Save.Command = IsOpen(() => Post(() => Model.Overwrite())); Ribbon.SaveAs.Command = IsOpen(() => PostSave(e => Model.Save(e))); Ribbon.Preview.Command = IsItem(() => PostPreview()); Ribbon.Select.Command = IsOpen(() => Send(() => Model.Select())); Ribbon.SelectAll.Command = IsOpen(() => Send(() => Model.Select(true))); Ribbon.SelectFlip.Command = IsOpen(() => Send(() => Model.Flip())); Ribbon.SelectClear.Command = IsOpen(() => Send(() => Model.Select(false))); Ribbon.Insert.Command = IsItem(() => PostInsert(e => Model.Insert(e))); Ribbon.InsertFront.Command = IsOpen(() => PostInsert(e => Model.Insert(0, e))); Ribbon.InsertBack.Command = IsOpen(() => PostInsert(e => Model.Insert(int.MaxValue, e))); Ribbon.InsertOthers.Command = IsOpen(() => PostInsert()); Ribbon.Extract.Command = IsItem(() => PostSave(e => Model.Extract(e))); Ribbon.Remove.Command = IsItem(() => Send(() => Model.Remove())); Ribbon.RemoveOthers.Command = IsOpen(() => PostRemove()); Ribbon.MovePrevious.Command = IsItem(() => Send(() => Model.Move(-1))); Ribbon.MoveNext.Command = IsItem(() => Send(() => Model.Move(1))); Ribbon.RotateLeft.Command = IsItem(() => Send(() => Model.Rotate(-90))); Ribbon.RotateRight.Command = IsItem(() => Send(() => Model.Rotate(90))); Ribbon.Metadata.Command = IsOpen(() => PostMetadata()); Ribbon.Encryption.Command = IsOpen(() => PostEncryption()); Ribbon.Refresh.Command = IsOpen(() => Send(() => Model.Refresh())); Ribbon.Undo.Command = IsUndo(); Ribbon.Redo.Command = IsRedo(); Ribbon.ZoomIn.Command = Any(() => Send(() => Model.Zoom(1))); Ribbon.ZoomOut.Command = Any(() => Send(() => Model.Zoom(-1))); Ribbon.Settings.Command = Any(() => PostSettings()); Ribbon.Exit.Command = Any(() => Send <CloseMessage>()); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { bool result = db.Insert("insert into Blog(Category,Title,Details1,Details,Author,[Year])values('" + txtCategory.SelectedValue.ToString() + "','" + tbTitle.Text + "','" + txtSummary.Text + "','" + tbDetails.Text + "','" + tbAuthor.Text + "','" + System.DateTime.Now.ToString("dd-MMM-yyyy") + "')"); if (result == true) { gridDataBind(); txtCategory.SelectedValue = "0"; tbTitle.Text = ""; txtSummary.Text = ""; tbDetails.Text = ""; lblalert.Text = "Blog Added Successfully"; alertdenger.Visible = false; alert.Visible = true; } else { lblalert.Text = "Some Error occured in Data Try Again."; alertdenger.Visible = true; alert.Visible = false; } } catch (Exception ex) { lblalertdenger.Text = ex.Message; alertdenger.Visible = true; alert.Visible = false; } }
protected void lnkSend_Click(object sender, EventArgs e) { Model m = new Model(); m.BrandId = int.Parse(drpMarka.SelectedValue); m.ModelText = txtModel.Text; m.Insert(); Response.Redirect("../../index.aspx"); // TODO: Listeye çevir }
public void InsertPoint(CVPoint point, int segmentIndex) { Vector3 startPos = points[segmentIndex].Position; Vector3 endPos = points[segmentIndex + 1].Position; Model.Insert(segmentIndex + 1, point.Model); points.Insert(segmentIndex + 1, point); segments[segmentIndex].SetPositions(startPos, point.Position); // modify segment like part 1 CreateSegment(point.Position, endPos, segmentIndex + 1); // create segment like part 2 }
private void Vlozit_Click(object sender, RoutedEventArgs e) { Model.IdUlice = IdUlice; var result = Model.Insert(); FormularGenerator.GenerujSpravu(result, Model.ErrorMessage); if (result) { DataContext = null; DataContext = new SStlp(); } }
private void Vlozit_Click(object sender, RoutedEventArgs e) { Model.Cislo = CisloStlpu; var result = Model.Insert(); FormularGenerator.GenerujSpravu(result, Model.ErrorMessage); if (result) { DataContext = null; DataContext = new SInfo(); Obrazok.Source = null; } }
public override T Insert(T item) { var expando = SetDataForDocument(item); expando = Model.Insert(expando); if (Model.PrimaryKeyMapping.IsAutoIncementing) { var newId = Model.GetPrimaryKey(expando); this.SetPrimaryKey(item, newId); // update document body of autoinc Pk value (insert and update should go within transaction, wait for Biggy transactions) Update(item); } return(item); }
void ScenarioViewModel_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e) { switch (e.Action) { case System.Collections.Specialized.NotifyCollectionChangedAction.Add: for (int i = e.NewStartingIndex; i < e.NewStartingIndex + e.NewItems.Count; i++) { this[i].OwnerScenario = this; Model.Insert(i, this[i].Model); } break; case System.Collections.Specialized.NotifyCollectionChangedAction.Replace: for (int i = e.NewStartingIndex; i < e.NewStartingIndex + e.NewItems.Count; i++) { this[i].OwnerScenario = this; Model[i] = this[i].Model; } break; case System.Collections.Specialized.NotifyCollectionChangedAction.Remove: foreach (AtomViewModel atom in e.OldItems) { atom.OwnerScenario = null; Model.RemoveAt(e.OldStartingIndex); if (OwnerDocument != null) { OwnerDocument.ClearLinks(atom); } } IsComplex = Items.Any(atom => atom.Model.Type == AtomTypes.Marker); break; case System.Collections.Specialized.NotifyCollectionChangedAction.Reset: Model.Clear(); foreach (AtomViewModel atom in this) { atom.OwnerScenario = this; Model.Add(atom.Model); } IsComplex = Items.Any(atom => atom.Model.Type == AtomTypes.Marker); break; } UpdateCommands(); }
public void Edit(Model.AcceptForm acceptform, Model.AD ad, Model.Client client, Model.Publish publish) { //客户信息插入或更新 Hashtable hs = new Hashtable(); hs.Add("ClientName", client.ClientName); if (client.IsExist(hs)) { client.Update( "ClientName='" + client.ClientName + "',Tel='" + client.Tel + "',Mobile='" + client.Mobile + "',Operator='" + client.Operator + "',AgencyCompany='" + client.AgencyCompany + "'", " and ClientName ='" + client.ClientName + "'"); HD.Model.Client newClient = HD.Model.Client.Instance.GetModelById(hs); acceptform.ClientGuid = newClient.ClientPGuid; } else { client.ClientPostTime = DateTime.Now; client.ClientPGuid = Public.GetGuID; client.Insert(); acceptform.ClientGuid = client.ClientPGuid; } //广告插入 ad.Update(); //先删除原来的发布形式,再循环插入发布形式 //string strSql = " and ADGuid='" + publish.ADGuid + "'"; hs.Clear(); hs.Add("ADGuid", ad.ADPGuid); publish.Delete(hs); //string StrSql = "Select * From " + DbConfig.Prefix + "Admin Where AdminName=@AdminName And AdminPass=@AdminPass And IsLock=1"; //IDataParameter[] Param = new IDataParameter[] { // DbHelper.MakeParam("@AdminName",AdminName), // DbHelper.MakeParam("@AdminPass",AdminPass) //}; string[] pubTypeName = publish.PublishType.Split(','); string[] pubTypeNu = publish.PublishQuantity.Split(','); for (int i = 0; i < pubTypeName.Length; i++) { publish.ADGuid = ad.ADPGuid; publish.PublishType = pubTypeName[i]; publish.PublishQuantity = pubTypeNu[i]; publish.Insert(); } //更新受理单信息 acceptform.Update(acceptform); }
public void Add(Model.Terminal terminal, Model.Source source) { terminal.Insert(); //循环插入附件 string[] picName = source.SourceUrl.Replace("|$|", "&").Split(new char[] { '&' }); for (int i = 0; i < picName.Length - 1; i++) { string[] picUrl = picName[i].Replace("|#|", "|").Split(new char[] { '|' }); source.SourceUrl = picUrl[1]; source.SourceType = picUrl[0]; source.Insert(); } }
public ActionResult Insert() { var allQuestions = Database.Get("SELECT * FROM [question]", 1); var allAnswers = Database.Get("SELECT * FROM [answer]", 1); List <string> allNouns = Database.Get("SELECT * FROM [noun]", 1); List <string> allVerbs = Database.Get("SELECT * FROM [verb]", 1); var answer = Request.Form["answer"]; var question = Request.Form["question"]; Model.Insert(allAnswers, answer, "answer", "answer"); Model.InsertQuestion(answer, allQuestions, allNouns, allVerbs, question, "question", "question"); return(RedirectToAction("About")); }
public override T Insert(T item) { var expando = SetDataForDocument(item); expando = Model.Insert(expando); var pkMap = Model.TableMapping.PrimaryKeyMapping.Single(); //TODO: compound Pk not supported if (pkMap.IsAutoIncementing) { var newId = Model.GetPropertyValue(expando, pkMap.PropertyName); this.Model.SetPropertyValue(item, pkMap.PropertyName, newId); // update document body of autoinc Pk value (insert and update should go within transaction, wait for Biggy transactions) Update(item); } return(item); }
public void Add(Model.Repair repair, Model.Reply reply) { string guid = repair.Guid; repair.Update(); Hashtable hs = new Hashtable(); hs.Add("RepairGuid", guid); if (reply.IsExist(hs)) { reply.Update( "ReplyContent='" + reply.ReplyContent + "',ReplyName='" + reply.ReplyName + "',ReplyRepairTime='" + reply.ReplyRepairTime + "'", " and RepairGuid='" + guid + "'"); } else { reply.Insert(); } }
//Butonul de insert apeleaza functia din obiect ce implementeaza Insertul, comunicand parametrii introdusi private void buttonInsert_Click(object sender, EventArgs e) { M.IDModel = textBoxIDModel.Text; M.NumeModel = textBoxNumeModel.Text; SqlConnection conn = new SqlConnection(myconnstring); DataSet idmarca = new DataSet(); try { //Descifram la ce marca se refera comboBox-ul string sql = "SELECT IDMarca FROM Marca WHERE Nume=@NumeMarca"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@NumeMarca", comboBoxMarca.Text); SqlDataAdapter adapter = new SqlDataAdapter(cmd); conn.Open(); adapter.Fill(idmarca); } catch { } finally { conn.Close(); } M.Marca = idmarca.Tables[0].Rows[0]["IDMarca"].ToString(); bool succes = M.Insert(M); if (succes) { MessageBox.Show("Model Inserat cu Succes!"); DataTable dt = M.Select(); dataGridViewModel.DataSource = dt; } else { MessageBox.Show("Operatiunea a esuat!"); } }
public void Add(Model.Application appli,Model.SCW scw, Model.Source source, Model.BulkFreight bulk) { appli.Insert(); if (appli.IO==1) { scw.Insert(); } //循环插入附件 string[] picName = source.SourceUrl.Replace("|$|", "&").Split(new char[] {'&'}); for (int i = 0; i < picName.Length - 1; i++) { string[] picUrl = picName[i].Replace("|#|", "|").Split(new char[] { '|' }); source.SourceUrl = picUrl[1]; source.SourceType = picUrl[0]; source.Insert(); } //循环插入散装货物列表 string[] BfGoodsName = bulk.BfGoodsName.Split(','); string[] BfGoodsGroup = bulk.BfGoodsGroup.Split(','); string[] Class = bulk.Class.Split(','); string[] DangerousNo = bulk.DangerousNo.Split(','); string[] BfTotalWeight = bulk.BfTotalWeight.Split(','); string[] DischargingPort = bulk.DischargingPort.Split(','); string[] Position = bulk.Position.Split(','); string[] Remark = bulk.Remark.Split(','); for (int i = 0; i < BfGoodsName.Length; i++) { bulk.BfGoodsName = BfGoodsName[i]; bulk.BfGoodsGroup = BfGoodsGroup[i]; bulk.Class = Class[i]; bulk.DangerousNo = DangerousNo[i]; bulk.BfTotalWeight = BfTotalWeight[i]; bulk.DischargingPort = DischargingPort[i]; bulk.Position = Position[i]; bulk.Remark = Remark[i]; bulk.Insert(); } }
public void Add(Model.AcceptForm acceptform, Model.AD ad, Model.Publish publish) { //广告插入 ad.Insert(); //循环插入发布形式 string[] pubTypeName = publish.PublishType.Split(','); string[] pubTypeNu = publish.PublishQuantity.Split(','); for (int i = 0; i < pubTypeName.Length; i++) { publish.ADGuid = ad.ADPGuid; publish.PublishType = pubTypeName[i]; publish.PublishQuantity = pubTypeNu[i]; publish.Insert(); } //插入受理单信息 acceptform.Insert(); }
public void Insert(int index, MenuItemBase item) { Model.Insert(index, item); }
public void Process() { string primary_key = "ID"; foreach (PropertyInfo prop in Dataset.GetProperties()) { if (prop.GetCustomAttribute <PrimaryKey>() != null) { primary_key = prop.Name; break; } } if (this._POST.ContainsKey("_METHOD")) { this.HTTPMethod = _POST["_METHOD"]; _POST.Remove("_METHOD"); } if (this._POST.ContainsKey("_REDIRECT")) { this.Location = _POST["_REDIRECT"]; _POST.Remove("_REDIRECT"); } Table table; int UID = 0; int colID = 0; if (this._POST != null) { if (this.HTTPMethod != Constants.METHOD_PUT && this.HTTPMethod != Constants.METHOD_PATCH && HTTPMethod != Constants.METHOD_DELETE) { UID = Sessions.sessions.Where(x => x.Value.Item2 == Headers.Session) .Select(x => x.Key) .Cast <int>() .First(); if (UID <= 0) { colID = 0; //fix this shit try { if (this.HTTPMethod == Constants.METHOD_GET && this._GET["1"] != "all" && this._GET["1"] != "info") { colID = Convert.ToInt16(this._GET["1"]); } else if (this.HTTPMethod != Constants.METHOD_GET) { colID = Convert.ToInt16(this._POST["ID"]); } } catch (Exception e) { } } else { colID = UID; } } Model model = DB.GetModel(this.Dataset.Name); if (this.HTTPMethod == Constants.METHOD_PATCH) { table = model.Select("*").AddFieldToFilter(primary_key, Tuple.Create <string, Expression>("eq", new Expression(_POST["ROW_ID"]))).Load(); if (((DataSet[])typeof(Table).GetMethod("ToDataSet").MakeGenericMethod(this.Dataset).Invoke(table, Type.EmptyTypes)).Length > 0) { model = model.Update(); foreach (KeyValuePair <string, string> kv in this._POST) { if (kv.Key == "ROW_ID") { continue; } KeyValuePair <string, string> kv2 = new KeyValuePair <string, string>(kv.Key, kv.Value.Replace("+", " ")); model = model.AddKeyValueToUpdate(kv2); } model.AddFieldToFilter(primary_key, Tuple.Create <string, Expression>("eq", new Expression(_POST["ROW_ID"]))).Load(); this.ContentType = Constants.CONTENT_JSON; this.response = Constants.STATUS_TRUE; } } else if (this.HTTPMethod == Constants.METHOD_PUT) { Model insertModel = model.Insert(); foreach (KeyValuePair <string, string> kv in this._POST) { KeyValuePair <string, string> kv2 = new KeyValuePair <string, string>(kv.Key, kv.Value.Replace("+", " ")); insertModel.AddDataToInsert(kv2); } insertModel.Load(); table = model.Select("*").AddFieldToFilter(primary_key, Tuple.Create <string, Expression>("eq", new Expression("LAST_INSERT_ID()", false))).Load(); dynamic[] result = ((dynamic[])typeof(Table).GetMethod("ToDataSet").MakeGenericMethod(this.Dataset).Invoke(table, Type.EmptyTypes)); this.ContentType = Constants.CONTENT_JSON; this.response = result.First().ToJSON(); } else if (this.HTTPMethod == Constants.METHOD_DELETE) { model.Delete().AddFieldToFilter(primary_key, Tuple.Create <string, Expression>("eq", new Expression(_POST["ROW_ID"]))).Load(); this.ContentType = Constants.CONTENT_JSON; this.response = Constants.STATUS_TRUE; } else if (this.HTTPMethod == Constants.METHOD_GET) { model = DB.GetModel(this.Dataset.Name); if (this._GET["1"] == "all") { int[] limit = this._GET.Count >= 3 ? new int[] { Convert.ToInt16(this._GET["2"]), Convert.ToInt16(this._GET["3"]) } : null; model = model.Select("*"); if (limit != null) { model = model.SetLimit(limit[0], limit[1]); } table = model.Load(); dynamic[] result = ((dynamic[])typeof(Table).GetMethod("ToDataSet").MakeGenericMethod(this.Dataset).Invoke(table, Type.EmptyTypes)); this.ContentType = Constants.CONTENT_JSON; this.response = "["; result.ToList <dynamic>().ForEach(x => this.response += x.ToJSON() + ","); this.response = this.response.Remove(this.response.Length - 1); this.response += "]"; if (result.Length <= 0) { this.response = Constants.STATUS_FALSE; } } else if (int.TryParse(this._GET["1"], out colID)) { //colID = Convert.ToInt16(this._GET["1"]); table = model.Select("*").AddFieldToFilter(primary_key, Tuple.Create <string, Expression>("eq", new Expression(colID.ToString()))).Load(); dynamic[] result = ((dynamic[])typeof(Table).GetMethod("ToDataSet").MakeGenericMethod(this.Dataset).Invoke(table, Type.EmptyTypes)); this.ContentType = Constants.CONTENT_JSON; if (result.Length > 0) { this.response = result.First().ToJSON(); } else { this.response = Constants.STATUS_FALSE; } } else if (this._GET["1"].Contains("info")) { table = model.Select("COUNT(*) as `records`").Load(); Dictionary <string, string> result = table.ToDict(); if (result.Count > 0) { this.response = result.ToJSON(); } } } } }
/* ----------------------------------------------------------------- */ /// /// PostInsert /// /// <summary> /// Posts the message to show a dialog of the InsertWindow /// class. /// </summary> /// /* ----------------------------------------------------------------- */ private void PostInsert() => Post(new InsertViewModel( (i, v) => Post(() => Model.Insert(i + 1, v.Select(e => e.FullName))), Data.Images.Selection.First, Data.Count.Value, Data.IO, Context ));
public void Edit(Model.Application appli,Model.SCW scw, Model.Source source1, Model.BulkFreight bulk, string bulkId) { appli.Update(); if (appli.IO == 1) { scw.Update(); } //循环更新附件 string[] picName = source1.SourceUrl.Replace("|$|", "&").Split(new char[] { '&' }); for (int i = 0; i < picName.Length - 1; i++) { string[] picUrl = picName[i].Replace("|#|", "|").Split(new char[] { '|' }); source1.SourceUrl = picUrl[1]; source1.SourceType = picUrl[0]; Hashtable ht = new Hashtable(); ht.Add("AppGuid", source1.AppGuid); ht.Add("SourceType", source1.SourceType); if (source1.IsExist(ht)) { source1.Update( "SourceUrl='" + source1.SourceUrl + "'", " and AppGuid='" + source1.AppGuid + "' and SourceType='" + source1.SourceType + "'"); } else { source1.CreateTime = DateTime.Now; source1.Insert(); } } //循环插入散装货物列表 string[] BulkId = bulkId.Split(','); string[] BfGoodsName = bulk.BfGoodsName.Split(','); string[] BfGoodsGroup = bulk.BfGoodsGroup.Split(','); string[] Class = bulk.Class.Split(','); string[] DangerousNo = bulk.DangerousNo.Split(','); string[] BfTotalWeight = bulk.BfTotalWeight.Split(','); string[] DischargingPort = bulk.DischargingPort.Split(','); string[] Position = bulk.Position.Split(','); string[] Remark = bulk.Remark.Split(','); for (int i = 0; i < BfGoodsName.Length; i++) { bulk.BfGoodsName = BfGoodsName[i]; bulk.BfGoodsGroup = BfGoodsGroup[i]; bulk.Class = Class[i]; bulk.DangerousNo = DangerousNo[i]; bulk.BfTotalWeight = BfTotalWeight[i]; bulk.DischargingPort = DischargingPort[i]; bulk.Position = Position[i]; bulk.Remark = Remark[i]; bulk.Id = Convert.ToInt32(BulkId[i]); bulk.Update(); } }