protected void makeCauseGrid(string sys_name)
{
SqlDataAdapter data_adapter;
string load_qry = "SELECT OBID, DESCRIPTION, SEQ FROM dbo.TBLSYSTEM_TEMPLATE where PRJ_NAME = '" + fgm_moduler.func_Class.project_Name + "' AND CLASS_NAME = 'Cause' ";
load_qry = load_qry + "AND SYS_NAME ='" + sys_name + "' AND (N1TERMINATIONDATE = '' OR N1TERMINATIONDATE IS NULL) ORDER BY SEQ";
data_adapter = new SqlDataAdapter(load_qry, fgm_moduler.func_Class.connString);
data_adapter.Fill(dt_System);
CauseGrid.DataSource = dt_System;
CauseGrid.DataBind();
}
protected void makeCauseGrid(string sys_obid)
{
SqlDataAdapter data_adapter;
string load_qry = " SELECT A.TAGNO, A.RIGHTREL, A.LEFTREL, B.DESCRIPTION, B.SEQ, B.OBID, B.PARENT_OBID, B.LOC1, B.LOC2 ";
load_qry = load_qry + " FROM TBLSYSTEM_TAGNO A INNER JOIN TBLSYSTEM_TEMPLATE B ON A.LEFTREL = B.OBID WHERE B.CLASS_NAME = 'Cause' ";
load_qry = load_qry + " AND (B.N1TERMINATIONDATE = '' OR B.N1TERMINATIONDATE IS NULL) AND A.RIGHTREL = '" + sys_obid + "' AND B.PRJ_NAME = '" + SessionInfo.ProjectName + "' ORDER BY B.SEQ ";
data_adapter = new SqlDataAdapter(load_qry, fgm_moduler.func_Class.connString);
data_adapter.Fill(dt_System);
CauseGrid.DataSource = dt_System;
CauseGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
fgm_moduler = new FGMModule("FDM", SessionInfo.ProjectName, "TagGroupDetector");
System_Effect.Tables.AddRange(new DataTable[] { dt_System, dt_Effect });
if (!IsPostBack)
{
Setup_Sys();
CauseGrid.DataSource = null;
CauseGrid.DataBind();
}
sys_name = ddl_System.SelectedValue;
makeCauseGrid(sys_name);
makeEffectDataset(sys_name);
Session["Dataset"] = System_Effect;
}