62,040
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
_caseId = Request["case_id"];
hldCaseId.Value = _caseId;
if (!Page.IsPostBack)
{
if (Request.QueryString["package_id"] != null && Request.QueryString["package_id"].ToString() != "")
{
hfDocTitleId.Value = Request.QueryString["package_id"].ToString();
}
InitOneTime();
}
SearchData();
chkSelectAll.Checked = false;
}
private void InitOneTime()
{
DiscoveryHelper.PageInit(gvActionitem);
DiscoveryHelper.PageInit(GridView);
btnRemove.Attributes["onclick"] = "if (cmdOnclick()==true){if(!confirm('Do you really want to delete the record?')){return false;}else{return true;}}else{return false;}";
}
private void SearchData()
{
string strSQL = "select a.discovery_package_id,a.category,a.title,a.staff_id,a.case_id, a.sequence_no," +
" doc_count=(select count(1) from discovery_info where discovery_package_id=a.discovery_package_id and flag_delete=0)," +
" a.addby,CONVERT(varchar(10),a.addon,101) as createddate,case when len(a.description)>50 then substring(a.description,0,50)+'...' else a.description end as description," +
" b.staff_name from discovery_info_package a left join staff b on a.staff_id=b.staff_id where a.category='PDF' and a.flag_delete=0 and a.status is null" +
" and a.case_id=@1 ";
strSQL += " order by a.sequence_no,a.title ";
DataTable dtPackage = ADORepositoryHelper.GetDataTable(strSQL, _caseId);
if (dtPackage.Rows.Count == 0)
{
tbMain.Visible = false;
tbNoRecord.Visible = true;
return;
}
else
{
tbMain.Visible = true;
tbNoRecord.Visible = false;
}
string strCartCategory = "";
if (hfDocTitleId.Value != null && hfDocTitleId.Value != "" && dtPackage.Select("discovery_package_id='" + hfDocTitleId.Value + "'").Length > 0)
{
_packageId = hfDocTitleId.Value;
DataRow dr = dtPackage.Select("discovery_package_id='" + _packageId + "'")[0];
strCartCategory = dr["category"].ToString();
lblCartCreatedDate.Text = dr["createddate"].ToString();
lblFolder.Text = dr["title"].ToString();
lblDescription.Text = dr["description"].ToString();
}
else
{
DataRow dr = dtPackage.Rows[0];
_packageId = dr["discovery_package_id"].ToString();
lblCartCreatedDate.Text = dr["createddate"].ToString();
lblFolder.Text = dr["title"].ToString();
lblDescription.Text = dr["description"].ToString();
hfDocTitleId.Value = dr["discovery_package_id"].ToString();
}
int intPageIndex = 0;
for (int j = 0; j < dtPackage.Rows.Count; j++)
{
if (dtPackage.Rows[j]["discovery_package_id"].ToString() == hfDocTitleId.Value)
{
intPageIndex = j / gvActionitem.PageSize;
break;
}
}
if (intPageIndex != 0)
{
gvActionitem.PageIndex = intPageIndex;
}
gvActionitem.DataSource = dtPackage.DefaultView;
gvActionitem.DataBind();
strSQL = "select a.discovery_package_id,b.document_id,case when subcategory.description is null then b.folder_name else subcategory.description end as subcategory," +
" CONVERT(varchar(10),b.receive_date,101) as posteddate,staff.staff_name as postedby,fs_name=isnull(redact_path, fs_name),[name],doc_source,doc_author, doc_status=case when rd.document_id is null then 'Pending' else 'Redacted' end " +
" from discovery_package_item a inner join documents b on a.table_id=b.document_id and a.table_name='documents'" +
" left join document_redact_log rd on b.document_id=rd.document_id" +
" left join asp_lookup subcategory on b.folder_name=subcategory.code " +
" and subcategory.lookup_id='doc_folder' and subcategory.display='Y'" +
" left join staff on b.addby=staff.staff_id " +
" where a.flag_delete=0 and a.discovery_package_id=@1" +
" order by subcategory.description,b.name ";
DataTable dtCartContent = ADORepositoryHelper.GetDataTable(strSQL, _packageId);
dtCartContent.Columns.Add("document_name", typeof(string));
DataTable dtTemp = dtCartContent.Clone();
DataRow[] drsTemp = dtCartContent.Select();
for (int k = 0; k < drsTemp.Length; k++)
{
dtTemp.Rows.Add(drsTemp[k].ItemArray);
dtTemp.Rows[dtTemp.Rows.Count - 1]["document_name"] = DiscoveryHelper.FormatFileName(dtTemp.Rows[dtTemp.Rows.Count - 1]["fs_name"].ToString().Trim(),
dtTemp.Rows[dtTemp.Rows.Count - 1]["name"].ToString().Trim());
System.Web.UI.WebControls.HiddenField hf = new HiddenField();
hf.ID = drsTemp[k]["document_id"].ToString() + "_path";
hf.Value = drsTemp[k]["fs_name"].ToString().Replace("\\", "/");
phHiddenField.Controls.Add(hf);
}
GridView.CanSort = true;
GridView.DataSource = dtTemp.DefaultView;
}