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