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(); }