protected void ddl_edit() { DataSet dt = new DataSet(); ComLibrary com = new ComLibrary(); Mgmt mgmt = new Mgmt(g_user_id, g_lang); dt = mgmt.GetMGMTList(); ddl_MGMT_LEVEL.DataValueField = "MANAGEMENT_LEVEL"; ddl_MGMT_LEVEL.DataTextField = "MANAGEMENT_DESCRIPTION"; ddl_MGMT_LEVEL.DataSource = dt; ddl_MGMT_LEVEL.DataBind(); ddl_MGMT_LEVEL.Items.Insert(0, ""); dt = null; Dept dept = new Dept(g_user_id, g_lang); dt = dept.GetDEPTList(); ddl_DEPT_NO.DataValueField = "DEPT_NO"; ddl_DEPT_NO.DataTextField = "DEPT_NAME"; ddl_DEPT_NO.DataSource = dt; ddl_DEPT_NO.DataBind(); ddl_DEPT_NO.Items.Insert(0, ""); dt = null; Process process = new Process(g_user_id, g_lang); dt = process.GetProcessList(); ddl_PROCESS_NO.DataValueField = "PROCESS_NO"; ddl_PROCESS_NO.DataTextField = "PROCESS_NAME"; ddl_PROCESS_NO.DataSource = dt; ddl_PROCESS_NO.DataBind(); ddl_PROCESS_NO.Items.Insert(0, ""); }
protected void Edit_Screen() { ComLibrary com = new ComLibrary(); // ロールマスタを検索 Mgmt mgmt = new Mgmt(g_user_id, g_lang); mgmt.mgmt_cd = txtManagement.Text.ToUpper(); txtManagement.Text = mgmt.mgmt_cd; Clear_Screen(0); // 必須項目のチェック if (txtManagement.Text == "") { Message msg = new Message(g_user_id, g_lang); lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblManagement.Text + ")"; lblMsg.ForeColor = Color.Red; return; } int rtn = mgmt.GetMGMTDetail(); if (hdnUpdMode.Value == "1") { // // 新規のときは、すでに存在すればエラー // if (rtn != ComConst.FAILED) { Message msg = new Message(g_user_id, g_lang); lblMsg.Text = msg.GetMessage("ALREADY_EXIST_ERR"); lblMsg.ForeColor = Color.Red; return; } } else { // // 新規以外のときは、存在しなければエラー // if (rtn == ComConst.FAILED) { Message msg = new Message(g_user_id, g_lang); lblMsg.Text = msg.GetMessage("NOT_EXIST_ERR"); lblMsg.ForeColor = Color.Red; return; } else { // 画面編集 txtManagementDesc1.Text = mgmt.mgmt_desc; //txtManagementDesc1.Text = management.Management_desc1; //txtManagementDesc2.Text = management.Management_desc2; //txtManagementDesc3.Text = management.Management_desc3; //txtManagementDesc4.Text = management.Management_desc4; } } hdnInputMode.Value = "1"; Screen_Control(hdnUpdMode.Value); }
protected void Edit_Grid() { // 品目マスタより一覧を得る string[] strcou; //strcou = flblCount.Text.Split('='); Message msg = new Message(g_user_id, g_lang); Mgmt SrchMgmt = new Mgmt(g_user_id, g_lang); SrchMgmt.mgmt_cd = txtManagement.Text.ToUpper(); DataSet ds = SrchMgmt.GetMGMTList(); if (ds == null || ds.Tables[0].Rows.Count == 0) { dgvSearch.DataSource = null; dgvSearch.DataBind(); //flblCount.Text = strcou[0] + " = 0]"; } if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { dgvSearch.DataSource = ds.Tables[0]; dgvSearch.DataBind(); ViewState["dgvSearch"] = ds.Tables[0]; //flblCount.Text = strcou[0] + " = " + ds.Tables[0].Rows.Count.ToString() + "]"; } }
protected void ddl_edit() { DataSet dt = new DataSet(); ComLibrary com = new ComLibrary(); Role role = new Role(g_user_id, g_lang); dt = role.GetRoleList(); ddl_USER_GROUP.DataValueField = "USER_GROUP_CODE"; ddl_USER_GROUP.DataTextField = "USER_GROUP_NAME"; ddl_USER_GROUP.DataSource = dt; ddl_USER_GROUP.DataBind(); ddl_USER_GROUP.Items.Insert(0, ""); dt = null; Dept dept = new Dept(g_user_id, g_lang); dt = dept.GetDEPTList(); ddl_DEPT_NO.DataValueField = "DEPT_NO"; ddl_DEPT_NO.DataTextField = "DEPT_NAME"; ddl_DEPT_NO.DataSource = dt; ddl_DEPT_NO.DataBind(); ddl_DEPT_NO.Items.Insert(0, ""); dt = null; Mgmt mgmt = new Mgmt(g_user_id, g_lang); dt = mgmt.GetMGMTList(); ddl_MGMT_LEVEL.DataValueField = "MANAGEMENT_LEVEL"; ddl_MGMT_LEVEL.DataTextField = "MANAGEMENT_DESCRIPTION"; ddl_MGMT_LEVEL.DataSource = dt; ddl_MGMT_LEVEL.DataBind(); ddl_MGMT_LEVEL.Items.Insert(0, ""); }
protected void cmdUpdate_Click(object sender, EventArgs e) { Message msg = new Message(g_user_id, g_lang); Mgmt mgmt = new Mgmt(g_user_id, g_lang); mgmt.mgmt_cd = txtManagement.Text.ToUpper(); //if (hdnUpdMode.Value == "3") //{ // DataSet ds = new DataSet(); // ds = management.GetUserListByManagement(); // if (ds.Tables[0].Rows.Count > 0) // { // lblMsg.Text = msg.GetMessage("ROLE_DEL_ERR"); // lblMsg.ForeColor = Color.Red; // return; // } //} //必須項目のチェック if (txtManagementDesc1.Text == "") { lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblManagementDesc1.Text + ")"; lblMsg.ForeColor = Color.Red; return; } ComLibrary com = new ComLibrary(); // ロールマスタを更新 // 画面から項目を編集 mgmt.mgmt_cd = txtManagement.Text; mgmt.mgmt_desc = txtManagementDesc1.Text; mgmt.chg_user_id = g_user_id; //role.chg_pgm = "MstRoleMnt"; int rtn = 0; switch (hdnUpdMode.Value) { case "1": // Insert rtn = mgmt.Insert(); break; case "2": // Update rtn = mgmt.Update(); break; case "3": // Delete rtn = mgmt.Delete(); break; } if (rtn == ComConst.FAILED) { lblMsg.Text = mgmt.strErr; lblMsg.ForeColor = Color.Red; return; } lblMsg.Text = msg.GetMessage("NORMAL_UPDATE"); lblMsg.ForeColor = Color.Blue; if (hdnUpdMode.Value == "3") { Clear_Screen(1); } hdnInputMode.Value = "0"; Screen_Control(hdnUpdMode.Value); }