/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Capturedata_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update capturedata_k set "); strSql.Append("kUrl=@kUrl,"); strSql.Append("kContent=@kContent,"); strSql.Append("kType=@kType,"); strSql.Append("kCaptureDateTime=@kCaptureDateTime,"); strSql.Append("kNumber=@kNumber,"); strSql.Append("kExtracted=@kExtracted,"); strSql.Append("kPageMD5=@kPageMD5,"); strSql.Append("kIndexId=@kIndexId,"); strSql.Append("kUpdateTime=@kUpdateTime,"); strSql.Append("kIsUpdated=@kIsUpdated,"); strSql.Append("kNotes=@kNotes"); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kContent", MySqlDbType.LongText), new MySqlParameter("@kType", MySqlDbType.VarChar, 255), new MySqlParameter("@kCaptureDateTime", MySqlDbType.DateTime), new MySqlParameter("@kNumber", MySqlDbType.Int32, 11), new MySqlParameter("@kExtracted", MySqlDbType.Int32, 11), new MySqlParameter("@kPageMD5", MySqlDbType.VarChar, 32), new MySqlParameter("@kIndexId", MySqlDbType.Int32, 11), new MySqlParameter("@kUpdateTime", MySqlDbType.DateTime), new MySqlParameter("@kIsUpdated", MySqlDbType.Int32, 11), new MySqlParameter("@kNotes", MySqlDbType.Text), new MySqlParameter("@kId", MySqlDbType.Int32, 11) }; parameters[0].Value = model.kUrl; parameters[1].Value = model.kContent; parameters[2].Value = model.kType; parameters[3].Value = model.kCaptureDateTime; parameters[4].Value = model.kNumber; parameters[5].Value = model.kExtracted; parameters[6].Value = model.kPageMD5; parameters[7].Value = model.kIndexId; parameters[8].Value = model.kUpdateTime; parameters[9].Value = model.kIsUpdated; parameters[10].Value = model.kNotes; parameters[11].Value = model.kId; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtkUrl.Text.Trim().Length == 0) { strErr += "kUrl不能为空!\\n"; } if (this.txtkContent.Text.Trim().Length == 0) { strErr += "kContent不能为空!\\n"; } if (this.txtkType.Text.Trim().Length == 0) { strErr += "kType不能为空!\\n"; } if (!PageValidate.IsDateTime(txtkCaptureDateTime.Text)) { strErr += "kCaptureDateTime格式错误!\\n"; } if (!PageValidate.IsNumber(txtkNumber.Text)) { strErr += "kNumber格式错误!\\n"; } if (this.txtkNotes.Text.Trim().Length == 0) { strErr += "kNotes不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int kId = int.Parse(this.lblkId.Text); string kUrl = this.txtkUrl.Text; string kContent = this.txtkContent.Text; string kType = this.txtkType.Text; DateTime kCaptureDateTime = DateTime.Parse(this.txtkCaptureDateTime.Text); int kNumber = int.Parse(this.txtkNumber.Text); string kNotes = this.txtkNotes.Text; KiwiCrawler.Model.Capturedata_k model = new KiwiCrawler.Model.Capturedata_k(); model.kId = kId; model.kUrl = kUrl; model.kContent = kContent; model.kType = kType; model.kCaptureDateTime = kCaptureDateTime; model.kNumber = kNumber; model.kNotes = kNotes; KiwiCrawler.BLL.Capturedata_kBll bll = new KiwiCrawler.BLL.Capturedata_kBll(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Capturedata_k DataRowToModel(DataRow row) { KiwiCrawler.Model.Capturedata_k model = new KiwiCrawler.Model.Capturedata_k(); if (row != null) { if (row["kId"] != null && row["kId"].ToString() != "") { model.kId = int.Parse(row["kId"].ToString()); } if (row["kUrl"] != null) { model.kUrl = row["kUrl"].ToString(); } if (row["kContent"] != null) { model.kContent = row["kContent"].ToString(); } if (row["kType"] != null) { model.kType = row["kType"].ToString(); } if (row["kCaptureDateTime"] != null && row["kCaptureDateTime"].ToString() != "") { model.kCaptureDateTime = DateTime.Parse(row["kCaptureDateTime"].ToString()); } if (row["kNumber"] != null && row["kNumber"].ToString() != "") { model.kNumber = int.Parse(row["kNumber"].ToString()); } if (row["kExtracted"] != null && row["kExtracted"].ToString() != "") { model.kExtracted = int.Parse(row["kExtracted"].ToString()); } if (row["kPageMD5"] != null) { model.kPageMD5 = row["kPageMD5"].ToString(); } if (row["kIndexId"] != null && row["kIndexId"].ToString() != "") { model.kIndexId = int.Parse(row["kIndexId"].ToString()); } if (row["kUpdateTime"] != null && row["kUpdateTime"].ToString() != "") { model.kUpdateTime = DateTime.Parse(row["kUpdateTime"].ToString()); } if (row["kIsUpdated"] != null && row["kIsUpdated"].ToString() != "") { model.kIsUpdated = int.Parse(row["kIsUpdated"].ToString()); } if (row["kNotes"] != null) { model.kNotes = row["kNotes"].ToString(); } } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtkUrl.Text.Trim().Length==0) { strErr+="kUrl不能为空!\\n"; } if(this.txtkContent.Text.Trim().Length==0) { strErr+="kContent不能为空!\\n"; } if(this.txtkType.Text.Trim().Length==0) { strErr+="kType不能为空!\\n"; } if(!PageValidate.IsDateTime(txtkCaptureDateTime.Text)) { strErr+="kCaptureDateTime格式错误!\\n"; } if(!PageValidate.IsNumber(txtkNumber.Text)) { strErr+="kNumber格式错误!\\n"; } if(this.txtkNotes.Text.Trim().Length==0) { strErr+="kNotes不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string kUrl=this.txtkUrl.Text; string kContent=this.txtkContent.Text; string kType=this.txtkType.Text; DateTime kCaptureDateTime=DateTime.Parse(this.txtkCaptureDateTime.Text); int kNumber=int.Parse(this.txtkNumber.Text); string kNotes=this.txtkNotes.Text; KiwiCrawler.Model.Capturedata_k model=new KiwiCrawler.Model.Capturedata_k(); model.kUrl=kUrl; model.kContent=kContent; model.kType=kType; model.kCaptureDateTime=kCaptureDateTime; model.kNumber=kNumber; model.kNotes=kNotes; KiwiCrawler.BLL.Capturedata_kBll bll=new KiwiCrawler.BLL.Capturedata_kBll(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
private void ShowInfo(int kId) { KiwiCrawler.BLL.Capturedata_kBll bll = new KiwiCrawler.BLL.Capturedata_kBll(); KiwiCrawler.Model.Capturedata_k model = bll.GetModel(kId); this.lblkId.Text = model.kId.ToString(); this.txtkUrl.Text = model.kUrl; this.txtkContent.Text = model.kContent; this.txtkType.Text = model.kType; this.txtkCaptureDateTime.Text = model.kCaptureDateTime.ToString(); this.txtkNumber.Text = model.kNumber.ToString(); this.txtkNotes.Text = model.kNotes; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Capturedata_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into capturedata_k("); strSql.Append("kUrl,kContent,kType,kCaptureDateTime,kNumber,kExtracted,kPageMD5,kIndexId,kUpdateTime,kIsUpdated,kNotes)"); strSql.Append(" values ("); strSql.Append("@kUrl,@kContent,@kType,@kCaptureDateTime,@kNumber,@kExtracted,@kPageMD5,@kIndexId,@kUpdateTime,@kIsUpdated,@kNotes)"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kContent", MySqlDbType.LongText), new MySqlParameter("@kType", MySqlDbType.VarChar, 255), new MySqlParameter("@kCaptureDateTime", MySqlDbType.DateTime), new MySqlParameter("@kNumber", MySqlDbType.Int32, 11), new MySqlParameter("@kExtracted", MySqlDbType.Int32, 11), new MySqlParameter("@kPageMD5", MySqlDbType.VarChar, 32), new MySqlParameter("@kIndexId", MySqlDbType.Int32, 11), new MySqlParameter("@kUpdateTime", MySqlDbType.DateTime), new MySqlParameter("@kIsUpdated", MySqlDbType.Int32, 11), new MySqlParameter("@kNotes", MySqlDbType.Text) }; parameters[0].Value = model.kUrl; parameters[1].Value = model.kContent; parameters[2].Value = model.kType; parameters[3].Value = model.kCaptureDateTime; parameters[4].Value = model.kNumber; parameters[5].Value = model.kExtracted; parameters[6].Value = model.kPageMD5; parameters[7].Value = model.kIndexId; parameters[8].Value = model.kUpdateTime; parameters[9].Value = model.kIsUpdated; parameters[10].Value = model.kNotes; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Capturedata_k GetModel(int kId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select kId,kUrl,kContent,kType,kCaptureDateTime,kNumber,kExtracted,kPageMD5,kIndexId,kUpdateTime,kIsUpdated,kNotes from capturedata_k "); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kId", MySqlDbType.Int32) }; parameters[0].Value = kId; KiwiCrawler.Model.Capturedata_k model = new KiwiCrawler.Model.Capturedata_k(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }