/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Extractionconfig_k model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into extractionconfig_k("); strSql.Append("KId,KUrl,KTitle,KPublishDateTime,KContent,KAddressBusinessType,KKeyword,KPercent)"); strSql.Append(" values ("); strSql.Append("@KId,@KUrl,@KTitle,@KPublishDateTime,@KContent,@KAddressBusinessType,@KKeyword,@KPercent)"); MySqlParameter[] parameters = { new MySqlParameter("@KId", MySqlDbType.Int32,11), new MySqlParameter("@KUrl", MySqlDbType.Text), new MySqlParameter("@KTitle", MySqlDbType.Text), new MySqlParameter("@KPublishDateTime", MySqlDbType.DateTime), new MySqlParameter("@KContent", MySqlDbType.Text), new MySqlParameter("@KAddressBusinessType", MySqlDbType.Text), new MySqlParameter("@KKeyword", MySqlDbType.Text), new MySqlParameter("@KPercent", MySqlDbType.Float)}; parameters[0].Value = model.KId; parameters[1].Value = model.KUrl; parameters[2].Value = model.KTitle; parameters[3].Value = model.KPublishDateTime; parameters[4].Value = model.KContent; parameters[5].Value = model.KAddressBusinessType; parameters[6].Value = model.KKeyword; parameters[7].Value = model.KPercent; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <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; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Deletedrecord_k model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into deletedrecord_k("); strSql.Append("kId,kCapturedataId,kDeleteDatetime,kNotes)"); strSql.Append(" values ("); strSql.Append("@kId,@kCapturedataId,@kDeleteDatetime,@kNotes)"); MySqlParameter[] parameters = { new MySqlParameter("@kId", MySqlDbType.Int32,11), new MySqlParameter("@kCapturedataId", MySqlDbType.Int32,11), new MySqlParameter("@kDeleteDatetime", MySqlDbType.DateTime), new MySqlParameter("@kNotes", MySqlDbType.Text)}; parameters[0].Value = model.kId; parameters[1].Value = model.kCapturedataId; parameters[2].Value = model.kDeleteDatetime; parameters[3].Value = model.kNotes; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Deletedrecord_k model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update deletedrecord_k set "); strSql.Append("kCapturedataId=@kCapturedataId,"); strSql.Append("kDeleteDatetime=@kDeleteDatetime,"); strSql.Append("kNotes=@kNotes"); strSql.Append(" where kId=@kId "); MySqlParameter[] parameters = { new MySqlParameter("@kCapturedataId", MySqlDbType.Int32,11), new MySqlParameter("@kDeleteDatetime", MySqlDbType.DateTime), new MySqlParameter("@kNotes", MySqlDbType.Text), new MySqlParameter("@kId", MySqlDbType.Int32,11)}; parameters[0].Value = model.kCapturedataId; parameters[1].Value = model.kDeleteDatetime; parameters[2].Value = model.kNotes; parameters[3].Value = model.kId; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Urlconfigs_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into urlconfigs_k("); strSql.Append("kUrl,kPageTotal,kCaptureType,kDetailPattern,kDetailPatternType,kNextPagePattern,kNextPagePatternType,kComplateDegree,kAddressBusinessType,kKeyWords,kNotes)"); strSql.Append(" values ("); strSql.Append("@kUrl,@kPageTotal,@kCaptureType,@kDetailPattern,@kDetailPatternType,@kNextPagePattern,@kNextPagePatternType,@kComplateDegree,@kAddressBusinessType,@kKeyWords,@kNotes)"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPageTotal", MySqlDbType.Int32,11), new MySqlParameter("@kCaptureType", MySqlDbType.Text), new MySqlParameter("@kDetailPattern", MySqlDbType.Text), new MySqlParameter("@kDetailPatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kNextPagePattern", MySqlDbType.Text), new MySqlParameter("@kNextPagePatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kComplateDegree", MySqlDbType.Float), new MySqlParameter("@kAddressBusinessType", MySqlDbType.Text), new MySqlParameter("@kKeyWords", MySqlDbType.Text), new MySqlParameter("@kNotes", MySqlDbType.VarChar, 255)}; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPageTotal; parameters[2].Value = model.kCaptureType; parameters[3].Value = model.kDetailPattern; parameters[4].Value = model.kDetailPatternType; parameters[5].Value = model.kNextPagePattern; parameters[6].Value = model.kNextPagePatternType; parameters[7].Value = model.kComplateDegree; parameters[8].Value = model.kAddressBusinessType; parameters[9].Value = model.kKeyWords; parameters[10].Value = model.kNotes; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <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 bool Update(KiwiCrawler.Model.Extractdata_k model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Extractdata_k model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Deletedrecord_k model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Deletedrecord_k model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Urlconfigs_k model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KiwiCrawler.Model.Urlconfigs_k model) { return dal.Add(model); }
/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod /// <summary> /// 添加一条信息,返回添加数据的主键 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddBringId(KiwiCrawler.Model.Urlconfigs_k model) { return dal.AddBringId(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KiwiCrawler.Model.Urlconfigs_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update urlconfigs_k set "); strSql.Append("kUrl=@kUrl,"); strSql.Append("kPageTotal=@kPageTotal,"); strSql.Append("kCaptureType=@kCaptureType,"); strSql.Append("kDetailPattern=@kDetailPattern,"); strSql.Append("kDetailPatternType=@kDetailPatternType,"); strSql.Append("kNextPagePattern=@kNextPagePattern,"); strSql.Append("kNextPagePatternType=@kNextPagePatternType,"); strSql.Append("kComplateDegree=@kComplateDegree,"); strSql.Append("kAddressBusinessType=@kAddressBusinessType,"); strSql.Append("kKeyWords=@kKeyWords,"); strSql.Append("kNotes=@kNotes"); strSql.Append(" where kId=@kId"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPageTotal", MySqlDbType.Int32,11), new MySqlParameter("@kCaptureType", MySqlDbType.Text), new MySqlParameter("@kDetailPattern", MySqlDbType.Text), new MySqlParameter("@kDetailPatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kNextPagePattern", MySqlDbType.Text), new MySqlParameter("@kNextPagePatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kComplateDegree", MySqlDbType.Float), new MySqlParameter("@kAddressBusinessType", MySqlDbType.Text), new MySqlParameter("@kKeyWords", MySqlDbType.Text), new MySqlParameter("@kNotes", MySqlDbType.VarChar, 255), new MySqlParameter("@kId", MySqlDbType.Int32,11)}; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPageTotal; parameters[2].Value = model.kCaptureType; parameters[3].Value = model.kDetailPattern; parameters[4].Value = model.kDetailPatternType; parameters[5].Value = model.kNextPagePattern; parameters[6].Value = model.kNextPagePatternType; parameters[7].Value = model.kComplateDegree; parameters[8].Value = model.kAddressBusinessType; parameters[9].Value = model.kKeyWords; 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; } }
/* /// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetList(int PageSize,int PageIndex,string strWhere) { MySqlParameter[] parameters = { new MySqlParameter("@tblName", MySqlDbType.VarChar, 255), new MySqlParameter("@fldName", MySqlDbType.VarChar, 255), new MySqlParameter("@PageSize", MySqlDbType.Int32), new MySqlParameter("@PageIndex", MySqlDbType.Int32), new MySqlParameter("@IsReCount", MySqlDbType.Bit), new MySqlParameter("@OrderType", MySqlDbType.Bit), new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000), }; parameters[0].Value = "urlconfigs_k"; parameters[1].Value = "kId"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperMySQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }*/ #endregion BasicMethod #region ExtensionMethod public int AddBringId(KiwiCrawler.Model.Urlconfigs_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into urlconfigs_k("); strSql.Append("kUrl,kPageTotal,kCaptureType,kDetailPattern,kDetailPatternType,kNextPagePattern,kNextPagePatternType,kComplateDegree,kAddressBusinessType,kKeyWords,kNotes)"); strSql.Append(" output inserted.kId"); strSql.Append(" values ("); strSql.Append("@kUrl,@kPageTotal,@kCaptureType,@kDetailPattern,@kDetailPatternType,@kNextPagePattern,@kNextPagePatternType,@kComplateDegree,@kAddressBusinessType,@kKeyWords,@kNotes)"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPageTotal", MySqlDbType.Int32,11), new MySqlParameter("@kCaptureType", MySqlDbType.Text), new MySqlParameter("@kDetailPattern", MySqlDbType.Text), new MySqlParameter("@kDetailPatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kNextPagePattern", MySqlDbType.Text), new MySqlParameter("@kNextPagePatternType", MySqlDbType.VarChar,255), new MySqlParameter("@kComplateDegree", MySqlDbType.Float), new MySqlParameter("@kAddressBusinessType", MySqlDbType.Text), new MySqlParameter("@kKeyWords", MySqlDbType.Text), new MySqlParameter("@kNotes", MySqlDbType.VarChar, 255)}; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPageTotal; parameters[2].Value = model.kCaptureType; parameters[3].Value = model.kDetailPattern; parameters[4].Value = model.kDetailPatternType; parameters[5].Value = model.kNextPagePattern; parameters[6].Value = model.kNextPagePatternType; parameters[7].Value = model.kComplateDegree; parameters[8].Value = model.kAddressBusinessType; parameters[9].Value = model.kKeyWords; parameters[10].Value = model.kNotes; int id =Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return id; }
public frmEdit(KiwiCrawler.Model.Urlconfigs_k model) : this() { editFrmModel = new KiwiCrawler.Model.Urlconfigs_k(); editFrmModel = model; }