// Update is called once per frame void Update() { if (isClick) { switch (MsgCenter.insertType) { case "1": if (D_FengGe.value == 0 || D_SceneStyle.value == 0) { break; } xmlStr = InsertData.AddScene(I_Name.text, I_Code.text, I_Sequ.text, MsgCenter.corpID, MsgCenter.FengGe[D_FengGe.captionText.text], MsgCenter.SceneStyle[D_SceneStyle.captionText.text], T_Picture.text, T_Spicture.text, T_Audio.text); break; case "2": if (MsgCenter.nowHouse == null || MsgCenter.nowScenePoint == null) { break; } xmlStr = InsertData.AddRoom(I_Name.text, I_Code.text, MsgCenter.nowHouse.ID.ToString(), MsgCenter.corpID, MsgCenter.nowScenePoint.x.ToString(), MsgCenter.nowScenePoint.y.ToString(), T_Picture.text, T_Spicture.text); break; case "3": if (D_FengGe.value == 0 || D_SceneStyle.value == 0 || MsgCenter.nowScene == null || MsgCenter.nowHouse == null || MsgCenter.StyleTarget == TargetStyle.chuanghu || MsgCenter.StyleTarget == TargetStyle.Null) { break; } xmlStr = InsertData.AddPanorama(I_Name.text, I_Code.text, I_Sequ.text, I_Group.text, MsgCenter.FengGe[D_FengGe.captionText.text], EnumToolV2.GetDescription(MsgCenter.StyleTarget), MsgCenter.nowHouse.ID.ToString(), MsgCenter.nowScene.ID.ToString(), MsgCenter.corpID, T_Picture.text, T_Spicture.text, T_Bpicture.text); break; case "4": break; case "5": break; case "6": break; case "7": break; default: break; } if (xmlStr == "" || xmlStr == null) { this.gameObject.SetActive(false); } else { StartCoroutine(WaitXML()); } isClick = false; } }
private void SaveDetail1() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new DiemThi { MaSV = int.Parse(row.Cells["MaSV"].Text), Diem = double.Parse(row.Cells["DiemThi"].Text), IdNamHoc = _idnamhoc, HocKy = _hocky }; _listThongke.Add(hs); } if (_listThongke.Count > 0 || _listUpdate.Count > 0) { UpdateData.UpdateDiemThi(_listUpdate); InsertData.ThemThongKe(_listThongke); MessageBox.Show(@"Lưu lại thành công"); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void btnUploadToDatabase_Click(object sender, EventArgs e) { try { InsertData insertdata = new InsertData(); string errorInfo = insertdata.InsertDataIntoSQLServerUsingSQLBulkCopy(csv, TableName); if (errorInfo == "") { MessageBox.Show("上传到数据库成功", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show($"上传到数据库失败,{errorInfo}", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("上传到数据库失败,原因:" + ex.Message, "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } frmMain frmmain = (frmMain)this.Owner; string sql = "select LIST,MACADDRESS,DESCRIPTION,VALIDFROM,VALIDTHRU from DhcpFilterStatus where STATUS !='deleting'"; frmmain.dt = SqlHelpers.ExecuteDataTable(CommandType.Text, sql); frmmain.dgvData.DataSource = frmmain.dt; dgvFileData.DataSource = null; }
/// <summary> /// Lưu dữ liệu trên UltraGrid /// </summary> protected override void SaveDetail() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new BaiLam { MaSV = int.Parse(row.Cells["MaSV"].Text), MaDe = row.Cells["MaDe"].Text, KetQua = row.Cells["KetQua"].Text, IdKyThi = _idKythi, MaHoiDong = row.Cells["MaHoiDong"].Text, MaLoCham = row.Cells["MaLoCham"].Text, TenFile = row.Cells["TenFile"].Text, }; _listAdd.Add(hs); } InsertData.ThemBaiLam(_listAdd); Invoke((Action)(() => MessageBox.Show(@"Đã lưu vào CSDL", FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information))); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
static void Main(string[] args) { // ... _vm = InsertData.Insert(); GetData.Read(_vm); // ... }
protected override void SaveDetail() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new DiemThi { MaSV = int.Parse(row.Cells["MaSV"].Text), Diem = double.Parse(row.Cells["TongDiem"].Text), IdNamHoc = _idnamhoc, HocKy = _hocky }; _listThongke.Add(hs); } if (_listThongke.Count > 0) { InsertData.ThemThongKe(_listThongke); MessageBox.Show(@"Thêm thành công"); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public RecyclerViewOnScrollListtener(SwipeRefreshLayout swipeRefreshLayout, LinearLayoutManager linearLayoutManager, RecyclerView.Adapter recyclerViewAdapter, InsertData InsertDataEvent) { _swipeRefreshLayout = swipeRefreshLayout; _linearLayoutManager = linearLayoutManager; _adapter = recyclerViewAdapter; _InsertDataEvent = InsertDataEvent; }
static void Main(string[] args) { var exampleToRun = ExamplesEnumeration.GetChacters; switch (exampleToRun) { case ExamplesEnumeration.GetChacters: GetData.GetCharacters(); break; case ExamplesEnumeration.GetCharactersWithLinq: GetData.GetCharactersWithLinq(); break; case ExamplesEnumeration.UpdateCharacter: UpdateData.UpdateCharacter(); break; case ExamplesEnumeration.InsertCharacter: InsertData.InsertCharacter(); break; } Console.Read(); }
// Use this for initialization void Start() { // set all other buttons to false so the player is forced to input their name and age before they can start the game id = GameObject.FindWithTag("BackAudio"); data = id.GetComponent <Data>(); insertdata = id.GetComponent <InsertData>(); }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtProductName.Text)) { MessageBox.Show("请输入商品名称"); } if (string.IsNullOrEmpty(txtInPrice.Text)) { MessageBox.Show("请输入进货价格"); } if (string.IsNullOrEmpty(txtProductCode.Text)) { MessageBox.Show("请输入商品编号"); } //插入 if (_opearType == "添加") { var sql = InsertSQL.InsertProduct(txtProductName.Text, txtInPrice.Text, txtOutPrice.Text, txtProductCode.Text, txtProductNum.Text, txtRemark.Text, _clientId, _pictureId); MessageBox.Show(InsertData.InsertIntoData(sql) ? "添加商品成功" : "添加商品失败"); } //更新 if (_opearType == "修改") { var updatesql = UpdateSQL.UpdateProduct(txtProductName.Text, txtInPrice.Text, txtOutPrice.Text, txtProductCode.Text, txtProductNum.Text, txtRemark.Text, _clientId, _pictureId, _productId); MessageBox.Show(UpdateData.UpdateInfo(updatesql) ? "更新商品成功" : "更新商品失败"); } Close(); }
/// <summary> /// Lưu dữ liệu trên UltraGrid /// </summary> protected override void SaveDetail() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new DapAn { IdKyThi = _idKythi, MaMon = row.Cells["MaMon"].Text, MaDe = row.Cells["MaDe"].Text, CauHoi = int.Parse(row.Cells["CauHoi"].Text), Dapan = row.Cells["Dapan"].Text, ThangDiem = 0 }; _listAdd.Add(hs); } if (_listAdd.Count <= 0) { return; } InsertData.ThemDapAn(_listAdd); MessageBox.Show(@"Đã lưu vào CSDL", FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message.Contains(FormResource.msgLostConnect) ? FormResource.txtLoiDB : ex.Message); Log2File.LogExceptionToFile(ex); } }
public ServiceResult InsertCallDetailsAsyc([System.Xml.Serialization.XmlElementAttribute(IsNullable = true)] InsertData data) { object[] results = this.Invoke("InsertCallDetailsAsyc", new object[] { data }); return((ServiceResult)(results[0])); }
public static void DeleteOrder(string tgl, string nik, string nama) { string[] tanggalsplit = tgl.Split('/'); string[] tanggalthn = tanggalsplit[2].Split(' '); string tanggalfix = tanggalthn[0] + '-' + tanggalsplit[1] + '-' + tanggalsplit[0]; InsertData.DelOrder(tanggalfix, nik, nama); }
public BaseRecyclerViewAdapter(Context context, List <T> list, int itemLayoutId, InsertData _InsertDataEvent) { this.context = context; this.list = list; this.itemLayoutId = itemLayoutId; this._InsertDataEvent = _InsertDataEvent; inflater = LayoutInflater.From(context); }
/// <remarks/> public void InsertCallDetailsAsycAsync(InsertData data, object userState) { if ((this.InsertCallDetailsAsycOperationCompleted == null)) { this.InsertCallDetailsAsycOperationCompleted = new System.Threading.SendOrPostCallback(this.OnInsertCallDetailsAsycOperationCompleted); } this.InvokeAsync("InsertCallDetailsAsyc", new object[] { data }, this.InsertCallDetailsAsycOperationCompleted, userState); }
public JsonResult InsertRecord(EmployeeRecordModel newRecord) { if (InsertData.InsertRecord(newRecord)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.DenyGet)); } }
public ActionResult InsertEmployee(EmployeeModel newEmployee) { if (InsertData.InsertEmployee(newEmployee)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.DenyGet)); } }
public static string data(string str1, string str2, string str3) { string cardUID = str1; string CardValue = str2; string modifier = str3; string status; status = InsertData.insert(cardUID, CardValue, modifier); return(status); }
//insert data user ke database public static void inserttoDB(string nik, string nama, string[][] array) { int n = array.Length; int i; string[] token = new string[n]; for (i = 0; i < n; i++) { token[i] = Code.CreateCode((i + 1), 6); } InsertData.insertDB(nik, nama, token, array); }
public ActionResult Index(InsertData inD) { HttpClient hc = new HttpClient(); hc.BaseAddress = new Uri("https://localhost:44360/api/InsertData"); var insertRec = hc.PostAsJsonAsync <InsertData>("InsertData", inD); insertRec.Wait(); ViewBag.message = "Values insert successfully"; return(View()); }
//insert data user ke database public static void inserttoDB(string nik, string nama, string[][] array, string modifier) { int n = array.Length; int i; string[] token = new string[n]; Random rnd = new Random(); for (i = 0; i < n; i++) { token[i] = Code.CreateCode((i + 1), 4) + rnd.Next(10, 99); } InsertData.insertDB(nik, nama, token, array, modifier); }
private void btnluu_Click_1(object sender, EventArgs e) { try { if (!Checkghi()) { return; } if (!CheckUpdate) { var hs = new SinhVien { MaSV = int.Parse(txtmasinhvien.Text), HoSV = txthotendem.Text, TenSV = txttensinhvien.Text, NgaySinh = cbongaysinh.Text, IdLop = _idlop, }; InsertData.ThemSinhVien(hs); Themmoisinhvien(sender, hs, cbolop.Text, cbokhoa.Text); MessageBox.Show(@"Đã Thêm mới một sinh viên"); } else { var hs1 = new SinhVien { MaSV = int.Parse(txtmasinhvien.Text), HoSV = txthotendem.Text, TenSV = txttensinhvien.Text, NgaySinh = cbongaysinh.Text, IdLop = _idlop }; if (UpdateData.UpdateSv(hs1)) { MessageBox.Show(@"Chỉnh sửa thành công", @"Thông báo"); CheckUpdate = false; } else { MessageBox.Show(@"Sai thông tin lớp", @"Thông báo"); } Close(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void button2_Click(object sender, EventArgs e) { var amount = numAmount.Value; var shenase = txtُShenase.Text; var receipt = txtReceipt.Text; var bank = comboBox1.Text; //string cmd = string.Format("INSERT INTO Receipt(Shenase,Amount,ReceiptDate)VALUES('{0}','{1}','{2}')", shenase, amount, receipt); string cmd = Helper.PardakhtCommand(1, shenase, amount.ToString(), bank, receipt); string result = InsertData.Payment(cmd); MessageBox.Show(result); }
private static FlatData FlattenInsertsData(InsertData data) { var inner = data.Inserts.Select(x => FlattenInsertsData(x)).ToList(); return(new FlatData() { Debug_Name = data.Insert.Block.Name, Attributes = Combine(data, inner, x => x.Attributes, x => x.Attributes, skipScale: true, skipPos: true), AttributeDefinitions = Combine(data, inner, x => x.AttributeDefinitions, x => x.AttributeDefinitions), Texts = Combine(data, inner, x => x.Texts, x => x.Texts), MTexts = Combine(data, inner, x => x.MTexts, x => x.MTexts), Lines = Combine(data, inner, x => x.Lines, x => x.Lines), Circles = Combine(data, inner, x => x.Circles, x => x.Circles), }); }
protected override void SaveDetail() { try { if (ValidateData()) { MessageBox.Show(@"Vui lòng nhập đầy đủ thông tin", @"Lỗi"); } else { foreach (var row in dgv_DanhSach.Rows.Where(row => string.IsNullOrEmpty(row.Cells["ID"].Text))) { var hs = new Taikhoan { TaiKhoan = row.Cells["TaiKhoan"].Value.ToString(), HoTen = row.Cells["HoTen"].Value.ToString(), Quyen = row.Cells["Quyen"].Value.ToString(), MatKhau = MaHoaMd5.Md5(row.Cells["MatKhau"].Value.ToString()) }; _listAdd.Add(hs); } if (_listAdd.Count <= 0 && _listUpdate.Count <= 0 && _listUpdatepass.Count <= 0) { return; } if (_listUpdate.Count > 0) { UpdateData.UpdateTaiKhoan(_listUpdate); } if (_listUpdatepass.Count > 0) { UpdateData.UpdateMatKhau(_listUpdatepass); } if (_listAdd.Count > 0) { InsertData.ThemTaiKhoan(_listAdd); } MessageBox.Show(FormResource.MsgThongbaothanhcong, FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); LoadFormDetail(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
// Use this for initialization void Start() { CurrentStageLevelInput = SceneManager.GetActiveScene().buildIndex; // get the current scene index // getcomponent need = GetComponent <Needed>(); toolbox = GetComponent <Toolbox>(); scourceAudio = GetComponent <AudioSource>(); // set next question to false nextQuestion.interactable = false; // find background audio // this is used to get the data and insertdata scripts id = GameObject.FindWithTag("BackAudio"); data = id.GetComponent <Data>(); insertData = id.GetComponent <InsertData>(); // set current level, set question answers and send data CurrentStageActive(CurrentStageLevelInput); }
public void CheckDatabaseState() { mDb = Manager.GetContext; if (!System.IO.File.Exists(datafile)) { UpdateDb creator = new CreateDb(); creator.DoUpdate(); UpdateDb inserter = new InsertData(); inserter.DoUpdate(); mDb.Configs.First(c => c.Key == "db_version").Value = CURRENT_VERSION.ToString(); } UpdateDatabase(); mDb.SubmitChanges(); }
protected override void SaveDetail() { try { if (ValidateData()) { MessageBox.Show(@"Vui lòng nhập đầy đủ thông tin", @"Lỗi"); } else { foreach (var row in uG_DanhSach.Rows.Where(row => string.IsNullOrEmpty(row.Cells["ID"].Text))) { var hs = new Kythi { MaKT = row.Cells["MaKT"].Text, TenKT = row.Cells["TenKT"].Text, NgayThi = row.Cells["NgayThi"].Text, TGLamBai = row.Cells["TGLamBai"].Text, TGBatDau = row.Cells["TGBatDau"].Text, TGKetThuc = row.Cells["TGKetThuc"].Text, GhiChu = row.Cells["GhiChu"].Text, }; _listAdd.Add(hs); } if (_listUpdate.Count <= 0 && _listAdd.Count <= 0) { return; } if (_listUpdate.Count > 0) { UpdateData.UpdateKyThi(_listUpdate); } if (_listAdd.Count > 0) { InsertData.ThemKythi(_listAdd); } Updatekythi(null); MessageBox.Show(FormResource.MsgThongbaothanhcong, FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); LoadFormDetail(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
// Use this for initialization void Start() { // data id = GameObject.FindWithTag("BackAudio"); insertdata = id.GetComponent <InsertData>(); data = id.GetComponent <Data>(); // turn ingamemenu of at the start of the scene if (inGameMenu != null) { inGameMenu.SetActive(false); } // set grodijn active at the start of the scene if (gordijn != null) { gordijn.SetActive(true); } }
public IHttpActionResult InsertRecords(InsertData insertData) { Entities db = new Entities(); db.InsertDataResults(insertData.JumperName, insertData.JumperSurname, insertData.JumperCountry, insertData.Meters, insertData.Points, insertData.HillName, insertData.Height, insertData.City, insertData.HillCountry, 0, 0, 0, 0, 0); db.SaveChanges(); return(Ok()); }