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;
}
protected void Cause_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
string desc = e.NewValues[0].ToString();
string seq = e.NewValues[1].ToString();
string qry = "INSERT INTO TBLSYSTEM_TEMPLATE(OBID, SYS_NAME, CLASS_NAME, SEQ, PARENT_OBID, DESCRIPTION, PRJ_NAME) ";
qry = qry + "VALUES(NEWID(), '" + sys_name + "', 'Cause', '" + seq + "', '" + sys_name + "', '" + desc + "', '" + fgm_moduler.func_Class.project_Name + "')";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
CauseGrid.CancelEdit();
}
protected void GridGroupDetail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e)
{
DataTable dt = new DataTable();
foreach (var args in e.UpdateValues)
{
string OBID = args.Keys[0].ToString(); // leftrel
string tag_no = args.NewValues[2].ToString();
string right_rel = CauseGrid.GetRowValuesByKeyValue(OBID, "RIGHTREL").ToString();
string qry = " UPDATE TBLSYSTEM_TAGNO SET TAGNO = '" + tag_no + "' ";
qry = qry + " WHERE LEFTREL = '" + OBID + "' AND RIGHTREL = '" + right_rel + "' ";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
}
}
public void Cause_Deleting(object sender, ASPxDataDeletingEventArgs e)
{
SqlCommand cmd;
ASPxGridView detailGridView = (ASPxGridView)sender;
string Selected_OBID = e.Keys[CauseGrid.KeyFieldName].ToString();
string qry = " UPDATE TBLSYSTEM_TEMPLATE SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-'), ";
qry = qry + "N1TERMINATIONID = '" + SessionInfo.UserID + "' ";
qry = qry + "WHERE OBID = '" + Selected_OBID + "' ";
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
string qry2 = " UPDATE TBLSYSTEM_TEMPLATE SET N1TERMINATIONDATE = REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-'), ";
qry2 = qry2 + "N1TERMINATIONID = '" + SessionInfo.UserID + "' ";
qry2 = qry2 + "WHERE PARENT_OBID = '" + Selected_OBID + "' ";
cmd = new SqlCommand(qry2, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
CauseGrid.CancelEdit();
}
