private void load_document()
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + (string)Session["path"] + "');", true);
//Label1.Text =Session["path"].ToString();
string _value = Request.QueryString[0].ToString();
Session["_datapath"] = _value.Substring(_value.IndexOf("_P") + 2);
Session["_datapath"] = (string)Session["_datapath"].ToString().Replace(" & ", "<>");
lblprj.Text = _value.Substring(0, _value.IndexOf("_R"));
int _id = Convert.ToInt32(_value.Substring(_value.IndexOf("_R") + 2, _value.IndexOf("_P") - (_value.IndexOf("_R") + 2)));
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + _id.ToString() + "');", true);
bool _enable = true;
publicCls.publicCls _obj = new publicCls.publicCls();
_obj.Load_Documents();
publicCls.publicCls._doctype = "1";
DataTable _dtable1 = new DataTable();
_dtable1.Columns.Add("doc_name");
_dtable1.Columns.Add("uploaded_date");
_dtable1.Columns.Add("file_size");
_dtable1.Columns.Add("version");
_dtable1.Columns.Add("STATUS");
_dtable1.Columns.Add("doc_id");
var Result = from o in publicCls.publicCls._dtdocuments.AsEnumerable()
where o.Field <int>(0) == _id && o.Field <bool>(1) == _enable
select o;
foreach (var row in Result)
{
DataRow _myrow = _dtable1.NewRow();
_myrow[0] = row[4].ToString();
DateTime _date = Convert.ToDateTime(row[6].ToString());
_myrow[1] = string.Format("{0:dd/MM/yyyy}", _date);
_myrow[2] = row[7].ToString();
_myrow[3] = row[9].ToString();
_myrow[4] = row[11].ToString();
_myrow[5] = row[2].ToString();
_dtable1.Rows.Add(_myrow);
}
mydocgridom.DataSource = _dtable1;
mydocgridom.DataBind();
DataTable _dtable3 = new DataTable();
_dtable3.Columns.Add("doc_name");
_dtable3.Columns.Add("version");
_dtable3.Columns.Add("comments");
_dtable3.Columns.Add("uploaded_date");
_dtable3.Columns.Add("STATUS");
_enable = false;
var Result3 = from o in publicCls.publicCls._dtdocuments.AsEnumerable()
where o.Field <int>(0) == _id && o.Field <bool>(1) == _enable
select o;
foreach (var row in Result3)
{
DataRow _myrow = _dtable3.NewRow();
_myrow[0] = row[4].ToString();
_myrow[1] = row[9].ToString();
_myrow[2] = row[10].ToString();
DateTime _date = Convert.ToDateTime(row[6].ToString());
_myrow[3] = string.Format("{0:dd/MM/yyyy}", _date);
_myrow[4] = row[11].ToString();
_dtable3.Rows.Add(_myrow);
}
gridprv.DataSource = _dtable3;
gridprv.DataBind();
}
private void Load_document()
{
myframe.Visible = false;
string _value = Request.QueryString[0].ToString();
_value = _value.Replace("<>", "&");
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + _value + "');", true);
string _path = _value.Substring(_value.IndexOf("_P") + 2, _value.IndexOf("_B") - (_value.IndexOf("_P") + 3));
_path = _path.Replace("@", " > ");
_path = _path.Replace("*", " > ");
Session["parent"] = _value.Substring(_value.Length - 1);
Session["type"] = _value.Substring(_value.Length - 3, 1);
Session["folder"] = _value.Substring(_value.IndexOf("*") + 1, _value.IndexOf("_B") - _value.IndexOf("*") - 2);
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + (string)Session["parent"] + "');", true);
lblprj.Text = _value.Substring(0, _value.IndexOf("_R"));
int _id = Convert.ToInt32(_value.Substring(_value.IndexOf("_R") + 2, _value.IndexOf("_P") - (_value.IndexOf("_R") + 2)));
//int _id = Convert.ToInt32(Request.QueryString[0].ToString());
Label1.Text = _path;
bool _enable = true;
publicCls.publicCls _obj = new publicCls.publicCls();
_obj.Load_Documents();
mydocgrid.Visible = true;
publicCls.publicCls._doctype = "0";
DataTable _dtable2 = new DataTable();
_dtable2.Columns.Add("doc_name");
_dtable2.Columns.Add("doc_title");
_dtable2.Columns.Add("uploaded_date");
_dtable2.Columns.Add("file_size");
_dtable2.Columns.Add("type");
//_dtable1.Columns.Add("STATUS");
var Result1 = from o in publicCls.publicCls._dtdocuments.AsEnumerable()
where o.Field <int>(0) == _id && o.Field <bool>(1) == _enable
select o;
foreach (var row in Result1)
{
DataRow _myrow = _dtable2.NewRow();
_myrow[0] = row[4].ToString();
DateTime _date = Convert.ToDateTime(row[6].ToString());
_myrow[1] = row[3].ToString();
_myrow[2] = string.Format("{0:dd/MM/yyyy}", _date);
_myrow[3] = row[7].ToString();
_myrow[4] = "0";
_dtable2.Rows.Add(_myrow);
}
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_objcls.prj_code = lblprj.Text;
_objcls.srv = _id;
DataTable _dt = _objbll.Load_DMS_TCDOC_SYS(_objcls, _objdb);
_objdb.DBName = "DB_" + lblprj.Text;
foreach (DataRow _drow in _dt.Rows)
{
_objcls.sys = Convert.ToInt32(_drow[0].ToString());
DataTable _dt1 = _objbll.Load_DMS_TCDOC(_objcls, _objdb);
foreach (DataRow _drow1 in _dt1.Rows)
{
DataRow _myrow = _dtable2.NewRow();
_myrow[0] = _drow1[0].ToString();
_myrow[1] = _drow1[2].ToString();
_myrow[2] = _drow1[1].ToString();
_myrow[3] = "";
_myrow[4] = "1";
_dtable2.Rows.Add(_myrow);
}
}
//if ((string)Session["type"] == "3")
//{
// mydocgrid.Visible = false;
// mygriddr.Visible = true;
// mygriddr.DataSource = _dtable2;
// mygriddr.DataBind();
//}
//else
//{
//mygriddr.Visible = false;
mydocgrid.Visible = true;
mydocgrid.DataSource = _dtable2;
mydocgrid.DataBind();
//}
Load_ScheduleList(_id, lblprj.Text);
GetSummary(_id);
}