/// <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);
}
}
