private void LoadFormToObject(RunnerCrawler runnerCrawler) { runnerCrawler.description = txtDescription.Text; runnerCrawler.number_thread = Convert.ToInt32(spinNumberThread.Value); runnerCrawler.is_find_new = ckFindNewItem.Checked; runnerCrawler.is_reload_item = ckReloadData.Checked; runnerCrawler.max_deep = Convert.ToInt32(spinMaxDeep.Value); runnerCrawler.max_item = Convert.ToInt32(spinMaxItem.Value); runnerCrawler.max_time_run_crawler = Convert.ToInt32(spimMaxTime.Value); runnerCrawler.name = txtName.Text; runnerCrawler.root_link = QT.Entities.Common.GetListXPathFromString(txtRootLink.Text); runnerCrawler.website_id = Convert.ToInt32(cboWebSite.SelectedValue); }
private void ParseRunnerCrawler(DataRow dataRow, RunnerCrawler runnerCrawler) { runnerCrawler.id = Common.Obj2Int(dataRow["id"]); runnerCrawler.name = Common.Obj2String(dataRow["name"]); runnerCrawler.website_id = Common.Obj2Int(dataRow["website_id"]); runnerCrawler.is_find_new = Common.Obj2Bool(dataRow["is_find_new"]); runnerCrawler.is_reload_item = Common.Obj2Bool(dataRow["is_reload_item"]); runnerCrawler.last_end = Common.ObjectToDataTime(dataRow["last_end"]); runnerCrawler.last_push = Common.ObjectToDataTime(dataRow["last_push"]); runnerCrawler.max_deep = Common.Obj2Int(dataRow["max_deep"]); runnerCrawler.max_item = Common.Obj2Int(dataRow["max_item"]); runnerCrawler.max_time_run_crawler = Common.Obj2Int(dataRow["max_time_run_crawler"]); runnerCrawler.number_thread = Common.Obj2Int(dataRow["number_thread"]); runnerCrawler.root_link = QT.Entities.Common.GetListXPathFromString(Common.Obj2String(dataRow["root_link"])); runnerCrawler.second_sleep_recrawler = Common.Obj2Int(dataRow["second_sleep_recrawler"]); }
public Entities.RaoVat.RunnerCrawler GetRunnerCrawler(int idSelected) { DataTable tbl = this.sqlDb.GetTblData("select * from runner_crawler where id = @id", CommandType.Text, new System.Data.SqlClient.SqlParameter[] { SqlDb.CreateParamteterSQL("id", idSelected, SqlDbType.Int) }); if (tbl != null && tbl.Rows.Count > 0) { RunnerCrawler runnerCrawler = new RunnerCrawler(); ParseRunnerCrawler(tbl.Rows[0], runnerCrawler); return(runnerCrawler); } else { return(null); } }
private void SaveData() { try { RunnerCrawler runnerCrawler = new RunnerCrawler(); if (Convert.ToInt32(spinId.Value) != 0) { runnerCrawler = this.adapterProduct.GetRunnerCrawler(Convert.ToInt32(spinId.Value)); } LoadFormToObject(runnerCrawler); if (this.adapterProduct.SaveRunner(runnerCrawler)) { MessageBox.Show("Saved!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public bool SaveRunner(RunnerCrawler runnerCrawler) { SqlParameter[] parameter = new SqlParameter[] { SqlDb.CreateParamteterSQL("id", runnerCrawler.id, SqlDbType.Int), SqlDb.CreateParamteterSQL("name", runnerCrawler.name, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("description", runnerCrawler.description, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("is_find_new", runnerCrawler.is_find_new, SqlDbType.Bit), SqlDb.CreateParamteterSQL("is_reload_item", runnerCrawler.is_reload_item, SqlDbType.Bit), SqlDb.CreateParamteterSQL("max_deep", runnerCrawler.max_deep, SqlDbType.Int), SqlDb.CreateParamteterSQL("max_item", runnerCrawler.max_item, SqlDbType.Int), SqlDb.CreateParamteterSQL("max_time_run_crawler", runnerCrawler.max_time_run_crawler, SqlDbType.Int), SqlDb.CreateParamteterSQL("number_thread", runnerCrawler.number_thread, SqlDbType.Int), SqlDb.CreateParamteterSQL("root_link", Common.ConvertToString(runnerCrawler.root_link), SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("second_sleep_recrawler", runnerCrawler.second_sleep_recrawler, SqlDbType.Int), SqlDb.CreateParamteterSQL("website_id", runnerCrawler.website_id, SqlDbType.Int), SqlDb.CreateParamteterSQL("state", runnerCrawler.state, SqlDbType.Int) }; if (runnerCrawler.id == 0) { this.sqlDb.RunQuery(@"INSERT INTO [dbo].[runner_crawler] ([website_id] ,[root_link] ,[number_thread] ,[second_sleep_recrawler] ,[is_find_new] ,[is_reload_item] ,[max_deep] ,[max_item] ,[description] ,[name] ,[max_time_run_crawler] ,[state]) values (@website_id ,@root_link ,@number_thread ,@second_sleep_recrawler ,@is_find_new ,@is_reload_item ,@max_deep ,@max_item ,@description ,@name ,@max_time_run_crawler ,@state)", CommandType.Text, parameter); } else { this.sqlDb.RunQuery(@" UPDATE [dbo].[runner_crawler] SET [website_id] = @website_id ,[root_link] = @root_link ,[number_thread] = @number_thread ,[second_sleep_recrawler] = @second_sleep_recrawler ,[is_find_new] = @is_find_new ,[is_reload_item] = @is_reload_item ,[max_deep] = @max_deep ,[max_item] = @max_item ,[description] = @description ,[name] = @name ,[max_time_run_crawler] = @max_time_run_crawler ,[state] = @state WHERE id = @id", CommandType.Text, parameter); } return(true); }