/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Extractdata_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into extractdata_k("); strSql.Append("kUrl,kPublishDateTime,kContent,kAddress,kType,kCaptureDateTime)"); strSql.Append(" values ("); strSql.Append("@kUrl,@kPublishDateTime,@kContent,@kAddress,@kType,@kCaptureDateTime)"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPublishDateTime", MySqlDbType.DateTime), new MySqlParameter("@kContent", MySqlDbType.Text), new MySqlParameter("@kAddress", MySqlDbType.Text), new MySqlParameter("@kType", MySqlDbType.VarChar,255), new MySqlParameter("@kCaptureDateTime", MySqlDbType.DateTime) }; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPublishDateTime; parameters[2].Value = model.kContent; parameters[3].Value = model.kAddress; parameters[4].Value = model.kType; parameters[5].Value = model.kCaptureDateTime; 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 (!PageValidate.IsDateTime(txtkPublishDateTime.Text)) { strErr += "kPublishDateTime格式错误!\\n"; } if (this.txtkContent.Text.Trim().Length == 0) { strErr += "kContent不能为空!\\n"; } if (this.txtkAddress.Text.Trim().Length == 0) { strErr += "kAddress不能为空!\\n"; } if (this.txtkType.Text.Trim().Length == 0) { strErr += "kType不能为空!\\n"; } if (!PageValidate.IsDateTime(txtkCaptureDateTime.Text)) { strErr += "kCaptureDateTime格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int kId = int.Parse(this.lblkId.Text); string kUrl = this.txtkUrl.Text; DateTime kPublishDateTime = DateTime.Parse(this.txtkPublishDateTime.Text); string kContent = this.txtkContent.Text; string kAddress = this.txtkAddress.Text; string kType = this.txtkType.Text; DateTime kCaptureDateTime = DateTime.Parse(this.txtkCaptureDateTime.Text); KiwiCrawler.Model.Extractdata_k model = new KiwiCrawler.Model.Extractdata_k(); model.kId = kId; model.kUrl = kUrl; model.kPublishDateTime = kPublishDateTime; model.kContent = kContent; model.kAddress = kAddress; model.kType = kType; model.kCaptureDateTime = kCaptureDateTime; KiwiCrawler.BLL.Extractdata_kBll bll = new KiwiCrawler.BLL.Extractdata_kBll(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtkUrl.Text.Trim().Length==0) { strErr+="kUrl不能为空!\\n"; } if(!PageValidate.IsDateTime(txtkPublishDateTime.Text)) { strErr+="kPublishDateTime格式错误!\\n"; } if(this.txtkContent.Text.Trim().Length==0) { strErr+="kContent不能为空!\\n"; } if(this.txtkAddress.Text.Trim().Length==0) { strErr+="kAddress不能为空!\\n"; } if(this.txtkType.Text.Trim().Length==0) { strErr+="kType不能为空!\\n"; } if(!PageValidate.IsDateTime(txtkCaptureDateTime.Text)) { strErr+="kCaptureDateTime格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string kUrl=this.txtkUrl.Text; DateTime kPublishDateTime=DateTime.Parse(this.txtkPublishDateTime.Text); string kContent=this.txtkContent.Text; string kAddress=this.txtkAddress.Text; string kType=this.txtkType.Text; DateTime kCaptureDateTime=DateTime.Parse(this.txtkCaptureDateTime.Text); KiwiCrawler.Model.Extractdata_k model=new KiwiCrawler.Model.Extractdata_k(); model.kUrl=kUrl; model.kPublishDateTime=kPublishDateTime; model.kContent=kContent; model.kAddress=kAddress; model.kType=kType; model.kCaptureDateTime=kCaptureDateTime; KiwiCrawler.BLL.Extractdata_kBll bll=new KiwiCrawler.BLL.Extractdata_kBll(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
private void ShowInfo(int kId) { KiwiCrawler.BLL.Extractdata_kBll bll = new KiwiCrawler.BLL.Extractdata_kBll(); KiwiCrawler.Model.Extractdata_k model = bll.GetModel(kId); this.lblkId.Text = model.kId.ToString(); this.txtkUrl.Text = model.kUrl; this.txtkPublishDateTime.Text = model.kPublishDateTime.ToString(); this.txtkContent.Text = model.kContent; this.txtkAddress.Text = model.kAddress; this.txtkType.Text = model.kType; this.txtkCaptureDateTime.Text = model.kCaptureDateTime.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Extractdata_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update extractdata_k set "); strSql.Append("kUrl=@kUrl,"); strSql.Append("kPublishDateTime=@kPublishDateTime,"); strSql.Append("kContent=@kContent,"); strSql.Append("kAddress=@kAddress,"); strSql.Append("kType=@kType,"); strSql.Append("kCaptureDateTime=@kCaptureDateTime"); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPublishDateTime", MySqlDbType.DateTime), new MySqlParameter("@kContent", MySqlDbType.Text), new MySqlParameter("@kAddress", MySqlDbType.Text), new MySqlParameter("@kType", MySqlDbType.VarChar,255), new MySqlParameter("@kCaptureDateTime", MySqlDbType.DateTime), new MySqlParameter("@kId", MySqlDbType.Int32, 11) }; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPublishDateTime; parameters[2].Value = model.kContent; parameters[3].Value = model.kAddress; parameters[4].Value = model.kType; parameters[5].Value = model.kCaptureDateTime; parameters[6].Value = model.kId; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Extractdata_k DataRowToModel(DataRow row) { KiwiCrawler.Model.Extractdata_k model = new KiwiCrawler.Model.Extractdata_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["kPublishDateTime"] != null && row["kPublishDateTime"].ToString() != "") { model.kPublishDateTime = DateTime.Parse(row["kPublishDateTime"].ToString()); } if (row["kContent"] != null) { model.kContent = row["kContent"].ToString(); } if (row["kAddress"] != null) { model.kAddress = row["kAddress"].ToString(); } if (row["kType"] != null) { model.kType = row["kType"].ToString(); } if (row["kCaptureDateTime"] != null && row["kCaptureDateTime"].ToString() != "") { model.kCaptureDateTime = DateTime.Parse(row["kCaptureDateTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Extractdata_k GetModel(int kId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select kId,kUrl,kPublishDateTime,kContent,kAddress,kType,kCaptureDateTime from extractdata_k "); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kId", MySqlDbType.Int32) }; parameters[0].Value = kId; KiwiCrawler.Model.Extractdata_k model = new KiwiCrawler.Model.Extractdata_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); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Extractdata_k DataRowToModel(DataRow row) { KiwiCrawler.Model.Extractdata_k model=new KiwiCrawler.Model.Extractdata_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["kPublishDateTime"]!=null && row["kPublishDateTime"].ToString()!="") { model.kPublishDateTime=DateTime.Parse(row["kPublishDateTime"].ToString()); } if(row["kContent"]!=null) { model.kContent=row["kContent"].ToString(); } if(row["kAddress"]!=null) { model.kAddress=row["kAddress"].ToString(); } if(row["kType"]!=null) { model.kType=row["kType"].ToString(); } if(row["kCaptureDateTime"]!=null && row["kCaptureDateTime"].ToString()!="") { model.kCaptureDateTime=DateTime.Parse(row["kCaptureDateTime"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KiwiCrawler.Model.Extractdata_k GetModel(int kId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select kId,kUrl,kPublishDateTime,kContent,kAddress,kType,kCaptureDateTime from extractdata_k "); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kId", MySqlDbType.Int32) }; parameters[0].Value = kId; KiwiCrawler.Model.Extractdata_k model=new KiwiCrawler.Model.Extractdata_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; } }