private void AddBlog(BlogGather.DelegatePara dp) { if (this.InvokeRequired) { this.Invoke(new BlogGatherCnblogs.GreetingDelegate(this.AddBlog), dp); return; } try { string strWholeDbName = m_strDBConStringPath + this.toolStripTextBox1.Text + ".db"; DYH_DB.Model.AU_LayerNode modelAU_LayerNode = new DYH_DB.Model.AU_LayerNode(); modelAU_LayerNode.AU_ParentLayerNodeID = -1; modelAU_LayerNode.AU_LayerNodeID = m_bllAU_LayerNode.GetMaxId(strWholeDbName); modelAU_LayerNode.AU_UrlLayer = 0; modelAU_LayerNode.AU_UrlAddress = ""; string strTitle = Regex.Replace(dp.strTitle, @"[|/\;.':*?<>-]", "").ToString(); strTitle = Regex.Replace(strTitle, "[\"]", "").ToString(); strTitle = Regex.Replace(strTitle, @"\s", ""); modelAU_LayerNode.AU_UrlTitle = strTitle; modelAU_LayerNode.AU_UrlContent = dp.strContent;; modelAU_LayerNode.AU_IsVisit = 0; modelAU_LayerNode.AU_RemoveSameOffset1 = 0; modelAU_LayerNode.AU_RemoveSameOffset2 = 0; modelAU_LayerNode.AU_LastUpdateDate = System.DateTime.Now.Date; m_bllAU_LayerNode.Add(strWholeDbName, modelAU_LayerNode); DataSet dsTemps = m_bllAU_LayerNode.GetList(strWholeDbName, ""); this.dataGridView1.DataSource = dsTemps.Tables[0]; this.dataGridView1.Columns[1].Visible = false; this.dataGridView1.Columns[0].Width = this.Width; } catch (Exception ex) { } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(string strConString, DYH_DB.Model.AU_LayerNode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AU_LayerNode("); strSql.Append("AU_LayerNodeID,AU_ParentLayerNodeID,AU_UrlAddress,AU_UrlTitle,AU_UrlContent,AU_UrlLayer,AU_IsVisit,AU_RemoveSameOffset1,AU_RemoveSameOffset2,AU_LastUpdateDate,AU_ReserveInt1,AU_ReserveInt2,AU_ReserveInt3,AU_ReserveInt4,AU_ReserveInt5,AU_ReserveInt6,AU_ReserveInt7,AU_ReserveInt8,AU_ReserveStr1,AU_ReserveStr2,AU_ReserveNStr1,AU_ReserveNStr2,AU_ReserveTEXT1,AU_ReserveTEXT2,AU_ReserveTEXT3,AU_ReserveNTEXT1,AU_ReserveNTEXT2,AU_ReserveNTEXT3,AU_ReserveDateTime1,AU_ReserveDateTime2,AU_ReserveDateTime3,AU_ReserveDateTime4,AU_ReserveDecmial1,AU_ReserveDecmial2)"); strSql.Append(" values ("); strSql.Append("@AU_LayerNodeID,@AU_ParentLayerNodeID,@AU_UrlAddress,@AU_UrlTitle,@AU_UrlContent,@AU_UrlLayer,@AU_IsVisit,@AU_RemoveSameOffset1,@AU_RemoveSameOffset2,@AU_LastUpdateDate,@AU_ReserveInt1,@AU_ReserveInt2,@AU_ReserveInt3,@AU_ReserveInt4,@AU_ReserveInt5,@AU_ReserveInt6,@AU_ReserveInt7,@AU_ReserveInt8,@AU_ReserveStr1,@AU_ReserveStr2,@AU_ReserveNStr1,@AU_ReserveNStr2,@AU_ReserveTEXT1,@AU_ReserveTEXT2,@AU_ReserveTEXT3,@AU_ReserveNTEXT1,@AU_ReserveNTEXT2,@AU_ReserveNTEXT3,@AU_ReserveDateTime1,@AU_ReserveDateTime2,@AU_ReserveDateTime3,@AU_ReserveDateTime4,@AU_ReserveDecmial1,@AU_ReserveDecmial2)"); SQLiteParameter[] parameters = { new SQLiteParameter("@AU_LayerNodeID", DbType.Int32, 4), new SQLiteParameter("@AU_ParentLayerNodeID", DbType.Int32, 4), new SQLiteParameter("@AU_UrlAddress", DbType.String, 1000), new SQLiteParameter("@AU_UrlTitle", DbType.String), new SQLiteParameter("@AU_UrlContent", DbType.String), new SQLiteParameter("@AU_UrlLayer", DbType.Int32, 4), new SQLiteParameter("@AU_IsVisit", DbType.Int32, 4), new SQLiteParameter("@AU_RemoveSameOffset1", DbType.Int32, 4), new SQLiteParameter("@AU_RemoveSameOffset2", DbType.Int32, 4), new SQLiteParameter("@AU_LastUpdateDate", DbType.DateTime), new SQLiteParameter("@AU_ReserveInt1", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt2", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt3", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt4", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt5", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt6", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt7", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt8", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveStr1", DbType.String, 1000), new SQLiteParameter("@AU_ReserveStr2", DbType.String, 1000), new SQLiteParameter("@AU_ReserveNStr1", DbType.String), new SQLiteParameter("@AU_ReserveNStr2", DbType.String), new SQLiteParameter("@AU_ReserveTEXT1", DbType.String), new SQLiteParameter("@AU_ReserveTEXT2", DbType.String), new SQLiteParameter("@AU_ReserveTEXT3", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT1", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT2", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT3", DbType.String), new SQLiteParameter("@AU_ReserveDateTime1", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime2", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime3", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime4", DbType.DateTime), new SQLiteParameter("@AU_ReserveDecmial1", DbType.Decimal, 8), new SQLiteParameter("@AU_ReserveDecmial2", DbType.Decimal, 8) }; parameters[0].Value = model.AU_LayerNodeID; parameters[1].Value = model.AU_ParentLayerNodeID; parameters[2].Value = model.AU_UrlAddress; parameters[3].Value = model.AU_UrlTitle; parameters[4].Value = model.AU_UrlContent; parameters[5].Value = model.AU_UrlLayer; parameters[6].Value = model.AU_IsVisit; parameters[7].Value = model.AU_RemoveSameOffset1; parameters[8].Value = model.AU_RemoveSameOffset2; parameters[9].Value = model.AU_LastUpdateDate; parameters[10].Value = model.AU_ReserveInt1; parameters[11].Value = model.AU_ReserveInt2; parameters[12].Value = model.AU_ReserveInt3; parameters[13].Value = model.AU_ReserveInt4; parameters[14].Value = model.AU_ReserveInt5; parameters[15].Value = model.AU_ReserveInt6; parameters[16].Value = model.AU_ReserveInt7; parameters[17].Value = model.AU_ReserveInt8; parameters[18].Value = model.AU_ReserveStr1; parameters[19].Value = model.AU_ReserveStr2; parameters[20].Value = model.AU_ReserveNStr1; parameters[21].Value = model.AU_ReserveNStr2; parameters[22].Value = model.AU_ReserveTEXT1; parameters[23].Value = model.AU_ReserveTEXT2; parameters[24].Value = model.AU_ReserveTEXT3; parameters[25].Value = model.AU_ReserveNTEXT1; parameters[26].Value = model.AU_ReserveNTEXT2; parameters[27].Value = model.AU_ReserveNTEXT3; parameters[28].Value = model.AU_ReserveDateTime1; parameters[29].Value = model.AU_ReserveDateTime2; parameters[30].Value = model.AU_ReserveDateTime3; parameters[31].Value = model.AU_ReserveDateTime4; parameters[32].Value = model.AU_ReserveDecmial1; parameters[33].Value = model.AU_ReserveDecmial2; DbHelperSQLite.ExecuteSql(strConString, strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public DYH_DB.Model.AU_LayerNode GetModel(string strConString, int AU_LayerNodeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AU_LayerNodeID,AU_ParentLayerNodeID,AU_UrlAddress,AU_UrlTitle,AU_UrlContent,AU_UrlLayer,AU_IsVisit,AU_RemoveSameOffset1,AU_RemoveSameOffset2,AU_LastUpdateDate,AU_ReserveInt1,AU_ReserveInt2,AU_ReserveInt3,AU_ReserveInt4,AU_ReserveInt5,AU_ReserveInt6,AU_ReserveInt7,AU_ReserveInt8,AU_ReserveStr1,AU_ReserveStr2,AU_ReserveNStr1,AU_ReserveNStr2,AU_ReserveTEXT1,AU_ReserveTEXT2,AU_ReserveTEXT3,AU_ReserveNTEXT1,AU_ReserveNTEXT2,AU_ReserveNTEXT3,AU_ReserveDateTime1,AU_ReserveDateTime2,AU_ReserveDateTime3,AU_ReserveDateTime4,AU_ReserveDecmial1,AU_ReserveDecmial2 from AU_LayerNode "); strSql.Append(" where AU_LayerNodeID=@AU_LayerNodeID "); SQLiteParameter[] parameters = { new SQLiteParameter("@AU_LayerNodeID", DbType.Int32, 4) }; parameters[0].Value = AU_LayerNodeID; DYH_DB.Model.AU_LayerNode model = new DYH_DB.Model.AU_LayerNode(); DataSet ds = DbHelperSQLite.Query(strConString, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["AU_LayerNodeID"].ToString() != "") { model.AU_LayerNodeID = int.Parse(ds.Tables[0].Rows[0]["AU_LayerNodeID"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ParentLayerNodeID"].ToString() != "") { model.AU_ParentLayerNodeID = int.Parse(ds.Tables[0].Rows[0]["AU_ParentLayerNodeID"].ToString()); } model.AU_UrlAddress = ds.Tables[0].Rows[0]["AU_UrlAddress"].ToString(); model.AU_UrlTitle = ds.Tables[0].Rows[0]["AU_UrlTitle"].ToString(); model.AU_UrlContent = ds.Tables[0].Rows[0]["AU_UrlContent"].ToString(); if (ds.Tables[0].Rows[0]["AU_UrlLayer"].ToString() != "") { model.AU_UrlLayer = int.Parse(ds.Tables[0].Rows[0]["AU_UrlLayer"].ToString()); } if (ds.Tables[0].Rows[0]["AU_IsVisit"].ToString() != "") { model.AU_IsVisit = int.Parse(ds.Tables[0].Rows[0]["AU_IsVisit"].ToString()); } if (ds.Tables[0].Rows[0]["AU_RemoveSameOffset1"].ToString() != "") { model.AU_RemoveSameOffset1 = int.Parse(ds.Tables[0].Rows[0]["AU_RemoveSameOffset1"].ToString()); } if (ds.Tables[0].Rows[0]["AU_RemoveSameOffset2"].ToString() != "") { model.AU_RemoveSameOffset2 = int.Parse(ds.Tables[0].Rows[0]["AU_RemoveSameOffset2"].ToString()); } if (ds.Tables[0].Rows[0]["AU_LastUpdateDate"].ToString() != "") { model.AU_LastUpdateDate = DateTime.Parse(ds.Tables[0].Rows[0]["AU_LastUpdateDate"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt1"].ToString() != "") { model.AU_ReserveInt1 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt1"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt2"].ToString() != "") { model.AU_ReserveInt2 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt2"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt3"].ToString() != "") { model.AU_ReserveInt3 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt3"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt4"].ToString() != "") { model.AU_ReserveInt4 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt4"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt5"].ToString() != "") { model.AU_ReserveInt5 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt5"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt6"].ToString() != "") { model.AU_ReserveInt6 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt6"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt7"].ToString() != "") { model.AU_ReserveInt7 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt7"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveInt8"].ToString() != "") { model.AU_ReserveInt8 = int.Parse(ds.Tables[0].Rows[0]["AU_ReserveInt8"].ToString()); } model.AU_ReserveStr1 = ds.Tables[0].Rows[0]["AU_ReserveStr1"].ToString(); model.AU_ReserveStr2 = ds.Tables[0].Rows[0]["AU_ReserveStr2"].ToString(); model.AU_ReserveNStr1 = ds.Tables[0].Rows[0]["AU_ReserveNStr1"].ToString(); model.AU_ReserveNStr2 = ds.Tables[0].Rows[0]["AU_ReserveNStr2"].ToString(); model.AU_ReserveTEXT1 = ds.Tables[0].Rows[0]["AU_ReserveTEXT1"].ToString(); model.AU_ReserveTEXT2 = ds.Tables[0].Rows[0]["AU_ReserveTEXT2"].ToString(); model.AU_ReserveTEXT3 = ds.Tables[0].Rows[0]["AU_ReserveTEXT3"].ToString(); model.AU_ReserveNTEXT1 = ds.Tables[0].Rows[0]["AU_ReserveNTEXT1"].ToString(); model.AU_ReserveNTEXT2 = ds.Tables[0].Rows[0]["AU_ReserveNTEXT2"].ToString(); model.AU_ReserveNTEXT3 = ds.Tables[0].Rows[0]["AU_ReserveNTEXT3"].ToString(); if (ds.Tables[0].Rows[0]["AU_ReserveDateTime1"].ToString() != "") { model.AU_ReserveDateTime1 = DateTime.Parse(ds.Tables[0].Rows[0]["AU_ReserveDateTime1"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveDateTime2"].ToString() != "") { model.AU_ReserveDateTime2 = DateTime.Parse(ds.Tables[0].Rows[0]["AU_ReserveDateTime2"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveDateTime3"].ToString() != "") { model.AU_ReserveDateTime3 = DateTime.Parse(ds.Tables[0].Rows[0]["AU_ReserveDateTime3"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveDateTime4"].ToString() != "") { model.AU_ReserveDateTime4 = DateTime.Parse(ds.Tables[0].Rows[0]["AU_ReserveDateTime4"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveDecmial1"].ToString() != "") { model.AU_ReserveDecmial1 = decimal.Parse(ds.Tables[0].Rows[0]["AU_ReserveDecmial1"].ToString()); } if (ds.Tables[0].Rows[0]["AU_ReserveDecmial2"].ToString() != "") { model.AU_ReserveDecmial2 = decimal.Parse(ds.Tables[0].Rows[0]["AU_ReserveDecmial2"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(string strConString, DYH_DB.Model.AU_LayerNode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AU_LayerNode set "); strSql.Append("AU_ParentLayerNodeID=@AU_ParentLayerNodeID,"); strSql.Append("AU_UrlAddress=@AU_UrlAddress,"); strSql.Append("AU_UrlTitle=@AU_UrlTitle,"); strSql.Append("AU_UrlContent=@AU_UrlContent,"); strSql.Append("AU_UrlLayer=@AU_UrlLayer,"); strSql.Append("AU_IsVisit=@AU_IsVisit,"); strSql.Append("AU_RemoveSameOffset1=@AU_RemoveSameOffset1,"); strSql.Append("AU_RemoveSameOffset2=@AU_RemoveSameOffset2,"); strSql.Append("AU_LastUpdateDate=@AU_LastUpdateDate,"); strSql.Append("AU_ReserveInt1=@AU_ReserveInt1,"); strSql.Append("AU_ReserveInt2=@AU_ReserveInt2,"); strSql.Append("AU_ReserveInt3=@AU_ReserveInt3,"); strSql.Append("AU_ReserveInt4=@AU_ReserveInt4,"); strSql.Append("AU_ReserveInt5=@AU_ReserveInt5,"); strSql.Append("AU_ReserveInt6=@AU_ReserveInt6,"); strSql.Append("AU_ReserveInt7=@AU_ReserveInt7,"); strSql.Append("AU_ReserveInt8=@AU_ReserveInt8,"); strSql.Append("AU_ReserveStr1=@AU_ReserveStr1,"); strSql.Append("AU_ReserveStr2=@AU_ReserveStr2,"); strSql.Append("AU_ReserveNStr1=@AU_ReserveNStr1,"); strSql.Append("AU_ReserveNStr2=@AU_ReserveNStr2,"); strSql.Append("AU_ReserveTEXT1=@AU_ReserveTEXT1,"); strSql.Append("AU_ReserveTEXT2=@AU_ReserveTEXT2,"); strSql.Append("AU_ReserveTEXT3=@AU_ReserveTEXT3,"); strSql.Append("AU_ReserveNTEXT1=@AU_ReserveNTEXT1,"); strSql.Append("AU_ReserveNTEXT2=@AU_ReserveNTEXT2,"); strSql.Append("AU_ReserveNTEXT3=@AU_ReserveNTEXT3,"); strSql.Append("AU_ReserveDateTime1=@AU_ReserveDateTime1,"); strSql.Append("AU_ReserveDateTime2=@AU_ReserveDateTime2,"); strSql.Append("AU_ReserveDateTime3=@AU_ReserveDateTime3,"); strSql.Append("AU_ReserveDateTime4=@AU_ReserveDateTime4,"); strSql.Append("AU_ReserveDecmial1=@AU_ReserveDecmial1,"); strSql.Append("AU_ReserveDecmial2=@AU_ReserveDecmial2"); strSql.Append(" where AU_LayerNodeID=@AU_LayerNodeID "); SQLiteParameter[] parameters = { new SQLiteParameter("@AU_ParentLayerNodeID", DbType.Int32, 4), new SQLiteParameter("@AU_UrlAddress", DbType.String, 1000), new SQLiteParameter("@AU_UrlTitle", DbType.String), new SQLiteParameter("@AU_UrlContent", DbType.String), new SQLiteParameter("@AU_UrlLayer", DbType.Int32, 4), new SQLiteParameter("@AU_IsVisit", DbType.Int32, 4), new SQLiteParameter("@AU_RemoveSameOffset1", DbType.Int32, 4), new SQLiteParameter("@AU_RemoveSameOffset2", DbType.Int32, 4), new SQLiteParameter("@AU_LastUpdateDate", DbType.DateTime), new SQLiteParameter("@AU_ReserveInt1", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt2", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt3", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt4", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt5", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt6", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt7", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveInt8", DbType.Int32, 4), new SQLiteParameter("@AU_ReserveStr1", DbType.String, 1000), new SQLiteParameter("@AU_ReserveStr2", DbType.String, 1000), new SQLiteParameter("@AU_ReserveNStr1", DbType.String), new SQLiteParameter("@AU_ReserveNStr2", DbType.String), new SQLiteParameter("@AU_ReserveTEXT1", DbType.String), new SQLiteParameter("@AU_ReserveTEXT2", DbType.String), new SQLiteParameter("@AU_ReserveTEXT3", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT1", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT2", DbType.String), new SQLiteParameter("@AU_ReserveNTEXT3", DbType.String), new SQLiteParameter("@AU_ReserveDateTime1", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime2", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime3", DbType.DateTime), new SQLiteParameter("@AU_ReserveDateTime4", DbType.DateTime), new SQLiteParameter("@AU_ReserveDecmial1", DbType.Decimal, 8), new SQLiteParameter("@AU_ReserveDecmial2", DbType.Decimal, 8), new SQLiteParameter("@AU_LayerNodeID", DbType.Int32, 4) }; parameters[0].Value = model.AU_ParentLayerNodeID; parameters[1].Value = model.AU_UrlAddress; parameters[2].Value = model.AU_UrlTitle; parameters[3].Value = model.AU_UrlContent; parameters[4].Value = model.AU_UrlLayer; parameters[5].Value = model.AU_IsVisit; parameters[6].Value = model.AU_RemoveSameOffset1; parameters[7].Value = model.AU_RemoveSameOffset2; parameters[8].Value = model.AU_LastUpdateDate; parameters[9].Value = model.AU_ReserveInt1; parameters[10].Value = model.AU_ReserveInt2; parameters[11].Value = model.AU_ReserveInt3; parameters[12].Value = model.AU_ReserveInt4; parameters[13].Value = model.AU_ReserveInt5; parameters[14].Value = model.AU_ReserveInt6; parameters[15].Value = model.AU_ReserveInt7; parameters[16].Value = model.AU_ReserveInt8; parameters[17].Value = model.AU_ReserveStr1; parameters[18].Value = model.AU_ReserveStr2; parameters[19].Value = model.AU_ReserveNStr1; parameters[20].Value = model.AU_ReserveNStr2; parameters[21].Value = model.AU_ReserveTEXT1; parameters[22].Value = model.AU_ReserveTEXT2; parameters[23].Value = model.AU_ReserveTEXT3; parameters[24].Value = model.AU_ReserveNTEXT1; parameters[25].Value = model.AU_ReserveNTEXT2; parameters[26].Value = model.AU_ReserveNTEXT3; parameters[27].Value = model.AU_ReserveDateTime1; parameters[28].Value = model.AU_ReserveDateTime2; parameters[29].Value = model.AU_ReserveDateTime3; parameters[30].Value = model.AU_ReserveDateTime4; parameters[31].Value = model.AU_ReserveDecmial1; parameters[32].Value = model.AU_ReserveDecmial2; parameters[33].Value = model.AU_LayerNodeID; int rows = DbHelperSQLite.ExecuteSql(strConString, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }