public static string CommentFiles(int R)
{//select * from REQUEST_COMMENT where REQUEST_ID=@r
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from REQUEST_COMMENT_SUPPLIERS where REQUEST_ID=@r and COMMENT_FILE is not null", new SqlParameter[] { new SqlParameter("@r", R) }, CommandType.Text);
List <REQUEST_COMMENT> rcs = new List <REQUEST_COMMENT>();
foreach (DataRow item in dt.Rows)
{
REQUEST_COMMENT rc = new REQUEST_COMMENT();
rc.COMMENT_FILE = item["COMMENT_FILE"].ToString();
rcs.Add(rc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rcs));
}
public static string GetCommentsById(int rid)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from REQUEST_COMMENT_SUPPLIERS where REQUEST_ID=@rid order by COMENT_ID asc", new SqlParameter[] { new SqlParameter("@rid", rid) }, CommandType.Text);
List <REQUEST_COMMENT> rcs = new List <REQUEST_COMMENT>();
foreach (DataRow item in dt.Rows)
{
REQUEST_COMMENT rc = new REQUEST_COMMENT();
rc.COMMENT_FILE = item["COMMENT_FILE"].ToString();
rc.REQUEST_COMMENT_ = item["REQUEST_COMMENT"].ToString();
rc.COMMENT_DATETIME = item["COMMENT_DATETIME"].ToString();
rc.H_COMMNET_FILE = item["H_COMMNET_FILE"].ToString();
rcs.Add(rc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rcs));
}