public void UpdateSysResource(M_SysResource sysResource) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "update " + sysResource.TableName + " set ParaType = @ParaType,PicName = @PicName,Illustrate = @Illustrate,Content = @Content where ID = @ID"; SQLiteParameter[] param = { new SQLiteParameter("@ID", sysResource.ID), new SQLiteParameter("@ParaType", sysResource.ParaType), new SQLiteParameter("@PicName", sysResource.PicName), new SQLiteParameter("@Illustrate", sysResource.Illustrate), new SQLiteParameter("@Content", sysResource.Content), }; SQLiteHelper.ExecuteNonQuery(sql, param); }
public void AddSysResource(M_SysResource sysResource) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "insert into " + sysResource.TableName + " values(@ID,@ParaType,@PicName,@Illustrate,@Content)"; SQLiteParameter[] param = { new SQLiteParameter("@ID", null), new SQLiteParameter("@ParaType", sysResource.ParaType), new SQLiteParameter("@PicName", sysResource.PicName), new SQLiteParameter("@Illustrate", sysResource.Illustrate), new SQLiteParameter("@Content", sysResource.Content), }; SQLiteHelper.ExecuteNonQuery(sql, param); }
public List <M_SysResource> GetSysResource(string tableName) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "select * from " + tableName; List <M_SysResource> list = new List <M_SysResource>(); using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(sql)) { while (reader.Read()) { M_SysResource sysResource = new M_SysResource(); sysResource.ID = Convert.ToInt32(reader["ID"]); sysResource.ParaType = Convert.ToInt32(reader["ParaType"]); sysResource.PicName = reader["PicName"].ToString(); sysResource.Illustrate = reader["Illustrate"].ToString(); sysResource.Content = (byte[])reader["Content"]; list.Add(sysResource); } } return(list); }
public M_SysResource GetSysResource(int id, string tableName) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "select * from " + tableName + " where ID = @ID"; M_SysResource sysResource = new M_SysResource(); SQLiteParameter[] param = { new SQLiteParameter("@ID", id) }; using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(sql, param)) { if (reader.Read()) { sysResource.ID = Convert.ToInt32(reader["ID"]); sysResource.PicName = reader["PicName"].ToString(); sysResource.Illustrate = reader["Illustrate"].ToString(); sysResource.Content = (byte[])reader["Content"]; } } return(sysResource); }
public void UpdateSysResource(M_SysResource sysConfig) { dal.UpdateSysResource(sysConfig); }
public void AddSysResource(M_SysResource sysConfig) { dal.AddSysResource(sysConfig); }