public void Update() { MemoryStream ms = new MemoryStream(); DAO db = new DAO(); try { BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(ms, this.ht_content); JpStream jpstream = new JpStream(); byte[] imagebin = jpstream.StreamToBytes(ms); String sql = "UPDATE JpForm SET adate=getdate(),publish=@publish,xmlcontent=@xmlcontent "; sql += " where sno=@sno"; SqlParameter[] prams ={ db.MakeInParam("@xmlcontent",SqlDbType.Image,imagebin), db.MakeInParam("@publish",SqlDbType.Int,publish), db.MakeInParam("@sno",SqlDbType.VarChar,sno), }; db.Execute(sql, prams); } catch { } finally { ms.Close(); db.Close(); } }
public String Insert() { MemoryStream ms = new MemoryStream(); try { BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(ms, this.ht_content); JpStream jpstream = new JpStream(); byte[] imagebin = jpstream.StreamToBytes(ms); String sql = "INSERT INTO JpForm(sno,cid,aid,ip,qdate,publish,xmlcontent)"; sql += " VALUES(@sno,@cid,@aid,@ip,getdate(),@publish,@xmlcontent)"; //GUID = System.Guid.NewGuid().ToString() ; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@sno",SqlDbType.VarChar,sno), db.MakeInParam("@cid",SqlDbType.VarChar,cid), db.MakeInParam("@aid",SqlDbType.Int,aid), db.MakeInParam("@ip",SqlDbType.VarChar,ip), db.MakeInParam("@publish",SqlDbType.Int,publish), db.MakeInParam("@xmlcontent",SqlDbType.Image,imagebin), }; db.Execute(sql, prams); db.Close(); sql = "Select sno from JpForm where sno=@sno"; SqlParameter[] prams1 ={ db.MakeInParam("@sno",SqlDbType.VarChar,sno), }; DataTable dt = db.GetDataTable(sql, prams1); if (dt.Rows.Count > 0) { this.sno = dt.Rows[0]["sno"].ToString(); } return sno; } catch { return ""; } finally { ms.Close(); } }