Ejemplo n.º 1
0
        private void AddNewDocument(object sender, EventArgs e)
        {
            string         link_code = gd_List.GetSelectString("LINK_CD");
            OpenFileDialog frm       = new OpenFileDialog();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                new FileSender(link_code, frm.FileName);

                ClearSearchData();

                SetSearchData("LINK_CODE", link_code);
                SetSearchData("GRP_NO", gd_schedule.SelectedCells.Count > 0 ? gd_schedule.Rows[gd_schedule.SelectedCells[0].RowIndex].Cells["SCH_DESC"].Value : "사업 접수");
                SetSearchData("CRT_USER_ID", DTOFactory.UserId);
                SetServiceId("InsertBusinessDocument");

                try
                {
                    DTOFactory.Transaction(new ReportDTO());

                    ViewMessage.Info("문서 등록이 완료 되었습니다.");
                    gd_Document.DataSource = DTOFactory.GetDataTable();
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 2
0
        private void Search(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("FROM_DT", dtFrom.Value.ToString("yyyy-MM-dd"));
            SetSearchData("TO_DT", dtTo.Value.ToString("yyyy-MM-dd"));
            SetServiceId("GetAccountHistory");

            try
            {
                DTOFactory.Transaction(new AccountDTO());
                DataSet ds_return = DTOFactory.GetDataSet();

                _dtCard = ds_return.Tables["ds_card"];
                _dtBank = ds_return.Tables["ds_bank"];

                if (bool1)
                {
                    gd_Card.DataSource = _dtCard;
                    gd_Bank.DataSource = _dtBank;

                    gd_Card.SetGridColumn(ds_return.Tables["ds_column1"]);
                    gd_Bank.SetGridColumn(ds_return.Tables["ds_column2"]);

                    bool1 = false;
                }
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 3
0
        private void Search(object sender, EventArgs e)
        {
            if (!"".Equals(cboOrder.ValueList))
            {
                ClearSearchData();
                SetSearchData("DOC_ID", cboOrder.ValueList);
                SetServiceId("GetOrder");

                try
                {
                    DTOFactory.Transaction(new ProductDTO());
                    DS = DTOFactory.GetDataSet();

                    txtDocId.Text     = DS.Tables["ds_master"].Rows[0]["DOC_ID"].ToString();
                    txtCrtDt.Text     = DS.Tables["ds_master"].Rows[0]["CRT_DT"].ToString();
                    txtVendorNm.Text  = DS.Tables["ds_master"].Rows[0]["VENDOR_NM"].ToString();
                    txtOrderDt.Text   = DS.Tables["ds_master"].Rows[0]["ORDER_DT"].ToString();
                    txtVendorTel.Text = DS.Tables["ds_master"].Rows[0]["VENDOR_TEL"].ToString();

                    gd_List.DataSource = DS.Tables["ds_list"];
                    gd_List.SetGridColumn(DS.Tables["ds_column"]);

                    for (int i = 0; i < gd_List.RowCount; i++)
                    {
                        gd_List.Rows[i].Cells["NO"].Value = i + 1;
                    }
                }
                catch (Exception e1)
                {
                    ViewMessage.Error(e1.Message);
                }
            }
        }
Ejemplo n.º 4
0
        private void Search(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("FROM_DT", dtFrom.Value.ToString("yyyy-MM-dd"));
            SetSearchData("TO_DT", dtTo.Value.ToString("yyyy-MM-dd"));
            SetSearchData("COMP_CD", cboComp.ValueList);
            SetSearchData("MODEL_ID", cbockModel.ValueList);
            SetSearchData("STAT_CD", cboStatus.ValueList);
            SetServiceId("GetDeliverList");

            try
            {
                DTOFactory.Transaction(new MachineDTO());

                DataSet ds = DTOFactory.GetDataSet();

                _dtList            = ds.Tables["ds_list"];
                gd_List.DataSource = _dtList;

                if (!gd_List.LabelDisplayed)
                {
                    gd_List.SetGridColumn(ds.Tables["ds_column"]);
                }

                if (gd_List.Rows.Count > 0)
                {
                    gd_List.Rows[0].Selected = true;
                    ViewDetail(gd_List, new DataGridViewCellEventArgs(0, 0));
                }
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 5
0
        private void GridAction(object sender, DataGridViewCellEventArgs e)
        {
            DataGridView view = (DataGridView)sender;

            if (e.RowIndex > -1)
            {
                if ("SAVE".Equals(view.Columns[e.ColumnIndex].Name))
                {
                    DataGridViewRow row = view.Rows[view.SelectedCells[0].RowIndex];

                    ClearSearchData();
                    SetSearchData("MGR_CD", row.Cells["MGR_CD"].Value);
                    SetSearchData("PROC_COMP_CD", row.Cells["PROC_COMP_CD"].Value);
                    SetSearchData("PROC_EQP_ID", row.Cells["PROC_EQP_ID"].Value);
                    SetSearchData("PROD_COMP_CD", row.Cells["PROD_COMP_CD"].Value);
                    SetSearchData("PROD_MODEL_ID", row.Cells["PROD_MODEL_ID"]);
                    SetSearchData("CRT_USER_ID", DTOFactory.UserId);

                    SetServiceId("SetEqpInfo");

                    try
                    {
                        DTOFactory.Transaction(new ManagerDTO());
                    }
                    catch (Exception ex)
                    {
                        ViewMessage.Error(ex.Message);
                    }
                }
                else if ("DEL".Equals(view.Columns[e.ColumnIndex].Name))
                {
                }
            }
        }
Ejemplo n.º 6
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            ClearSearchData();

            SetSearchData("DOC_TYP_CD", DOC_TYP_CD);
            SetSearchData("CRT_USER_ID", DTOFactory.UserId);

            if ("15".Equals(DOC_TYP_CD) || "16".Equals(DOC_TYP_CD))
            {
                SetSearchData("START_TM", dtFrom.Value.ToString("yyyy-MM-dd") + " " + dtFromTime.Value.ToString("HH"));
                SetSearchData("END_TM", dtTo.Value.ToString("yyyy-MM-dd") + " " + dtToTime.Value.ToString("HH"));
            }
            else
            {
                SetSearchData("START_TM", dtFrom.Value.ToString("yyyy-MM-dd"));
                SetSearchData("END_TM", dtTo.Value.ToString("yyyy-MM-dd"));
            }
            SetSearchData("DOC_DESC", txtDocDesc.Text);

            SetServiceId("SetDocList");

            try
            {
                DTOFactory.Transaction(new DocDTO());

                DialogResult = DialogResult.OK;
                ViewMessage.Info("문서 등록이 완료 되었습니다.");
                Close();
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 7
0
        private void Save(object sender, EventArgs e)
        {
            if ("".Equals(ACC_CD))
            {
                FileSender file = new FileSender("", txtBankImage.Text);

                Link = file.GetLinkCode();
                file.Close();
            }

            ClearSearchData();
            SetSearchData("ACC_CD", ACC_CD);
            SetSearchData("ACC_TYPE", cboType.ValueList);
            SetSearchData("OUT_BANK_NM", cboBank.ValueList);
            SetSearchData("OUT_BANK_NO", txtBankCode.Text);
            SetSearchData("USER_ID", cboUser.ValueList);
            SetSearchData("ACCOUNT_DESC", txtBankDesc.Text);
            SetSearchData("LINK_CODE", Link);
            SetSearchData("UPT_USER_ID", DTOFactory.UserId);
            SetServiceId("SetBankAccountList");

            try
            {
                DTOFactory.Transaction(new AccountDTO());

                DialogResult = DialogResult.OK;
                ViewMessage.Info("등록이 완료 되었습니다.");
                Close();
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 8
0
        private void GetModelInfo(int index)
        {
            DataRow row = _dtModel.Rows[index];

            ClearSearchData();
            SetSearchData("PLAN_CD", row["PLAN_CD"]);
            SetSearchData("ESTIMATE_CD", row["ESTIMATE_CD"]);
            SetSearchData("LINK_CODE", row["LINK_CD"]);
            SetServiceId("GetModelInfo");

            try
            {
                DTOFactory.Transaction(new MachineDTO());
                DataSet ds = DTOFactory.GetDataSet();

                _dtPlan                   = ds.Tables["ds_plan"];
                _dtEstimate               = ds.Tables["ds_estimate"];
                _dtDocument               = ds.Tables["ds_document"];
                LstPlan.DataSource        = _dtPlan;
                LstEstimate.DataSource    = _dtEstimate;
                LstDocument.DataSource    = _dtDocument;
                LstPlan.DisplayMember     = "FILE_DESC";
                LstEstimate.DisplayMember = "FILE_DESC";
                LstDocument.DisplayMember = "FILE_DESC";
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 9
0
        private void RemoveCompRow(object sender, EventArgs e)
        {
            if (gd_List.SelectedRows.Count == 1)
            {
                if (!"".Equals(_dtComp.Rows[gd_List.SelectedRows[0].Index]["COMP_CD"].ToString()))
                {
                    if (System.Windows.Forms.MessageBox.Show(
                            _dtComp.Rows[gd_List.SelectedRows[0].Index]["COMP_NM"].ToString() + " 사업장을 삭제 하시겠습니까?", "업체 제거"
                            , MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        ClearSearchData();
                        SetSearchData("COMP_CODE", _dtComp.Rows[gd_List.SelectedRows[0].Index]["COMP_CD"].ToString());
                        SetServiceId("RemoveComp");

                        try
                        {
                            DTOFactory.Transaction(new MemberDTO());
                            _dtComp.Rows.RemoveAt(gd_List.SelectedRows[0].Index);
                        }
                        catch (Exception ex)
                        {
                            ViewMessage.Error(ex.Message);
                        }
                    }
                }
            }
        }
Ejemplo n.º 10
0
        private void ImageAdd(object sender, EventArgs e)
        {
            int            row = gd_VerList.SelectedRows[0].Index;
            OpenFileDialog frm = new OpenFileDialog();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                new FileSender(_dtVersion.Rows[row]["LINK_CD"].ToString(), frm.FileName);

                _dtSearch.Clear();

                DataRow dr = _dtSearch.NewRow();
                dr["FIELD"] = "LINK_CODE";
                dr["DATA"]  = gd_VerList.Rows[row].Cells["LINK_CD"].Value.ToString();
                _dtSearch.Rows.Add(dr);

                SetServiceId("GetLinkList");

                try
                {
                    DTOFactory.Transaction(new ProjectDTO());
                    _dtLink = DTOFactory.GetDataTable();

                    ViewImage(ImageIndex + 1);

                    btnFirst.Enabled  = true;
                    btnLast.Enabled   = true;
                    btnImgAdd.Enabled = true;
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 11
0
        private void SetCompInfo(object sender, DataGridViewCellEventArgs e)
        {
            DataGridView view = (DataGridView)sender;

            if (e.RowIndex > -1)
            {
                if ("DEL".Equals(view.Columns[e.ColumnIndex].Name))
                {
                    if (!"".Equals(_dtComp.Rows[e.RowIndex]["COMP_CD"].ToString()))
                    {
                        if (System.Windows.Forms.MessageBox.Show(
                                _dtComp.Rows[e.RowIndex]["COMP_NM"].ToString() + " 업체 정보를 삭제 하시겠습니까?", "기관 제거"
                                , MessageBoxButtons.YesNo) == DialogResult.Yes)
                        {
                            ClearSearchData();
                            SetSearchData("COMP_CODE", _dtComp.Rows[e.RowIndex]["COMP_CD"].ToString());
                            SetServiceId("RemoveComp");

                            try
                            {
                                DTOFactory.Transaction(new MemberDTO());
                                _dtComp.Rows.RemoveAt(e.RowIndex);

                                ViewMessage.Info("기관 정보가 삭제 되었습니다.");
                            }
                            catch (Exception ex)
                            {
                                ViewMessage.Error(ex.Message);
                            }
                        }
                    }
                }
            }
        }
Ejemplo n.º 12
0
        private void Search(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("FROM_DT", dtFrom.Value.ToString("yyyy/MM/dd"));
            SetSearchData("TO_DT", dtTo.Value.ToString("yyyy/MM/dd"));
            SetSearchData("CST_COMP_CD", cboSearchComp.ValueList);
            SetServiceId("GetEstimateList");

            cboCstUser.SetItemChecked("");
            cboProject.SetItemChecked("");
            cboCashType1.SetItemChecked("");
            cboCashType2.SetItemChecked("");
            cboWarrType.SetItemChecked("");

            txtDocId.Text   = "";
            txtSubject.Text = "";
            txtCost.Text    = "";
            txtVat.Text     = "";

            calWorkDt.Value = DateTime.Now;

            DTOFactory.Action();

            try
            {
                DTOFactory.Transaction(new ReportDTO());
                DataSet ds_return = DTOFactory.GetDataSet();

                dt_Group            = ds_return.Tables["ds_group"];
                gd_Group.DataSource = dt_Group;
                gd_Group.SetGridColumn(ds_return.Tables["ds_column"]);

                cboCstUser.Params.Clear();
                cboCstUser.Params.Add("strCompCode", cboSearchComp.ValueList);
                cboCstUser.BindDataSet();

                cboItmModel.Params.Clear();
                cboItmModel.Params.Add("strCompCode", cboSearchComp.ValueList);
                cboItmModel.BindDataSet();

                //검색 기록이 없을때 rows가 추가되는걸 방지
                if (gd_Group.Rows.Count == 0)
                {
                    gd_Group.Columns["Rows"].Visible = false;
                }

                panel5.Enabled = true;
                panel7.Enabled = true;
                if (dt_Group.Rows.Count != 0)
                {
                    ViewGroup(gd_Group, new DataGridViewCellEventArgs(0, 0));
                }
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }

            DTOFactory.Complete();
        }
Ejemplo n.º 13
0
        private void CompCheck(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("COMP_NAME", txtCompName);
            SetSearchData("COMP_TYPE", "G");

            SetServiceId("GetCompInfo");

            try
            {
                DTOFactory.Transaction(new MemberDTO());
                DataTable dt = DTOFactory.GetDataTable("ds_comp");

                if (dt.Rows.Count > 0)
                {
                    ViewMessage.Info("이미 등록된 기관명 입니다.");
                }
                else
                {
                    ViewMessage.Info("등록이 가능한 기관명 입니다.");
                    btnInsert.Enabled = true;
                }
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 14
0
        private void GetUserProgram(int row)
        {
            ClearSearchData();
            SetSearchData("USER_ID", dtUser.Rows[row]["USER_ID"]);
            SetServiceId("GetProgramList");

            try
            {
                DTOFactory.Transaction(new AdminDTO());
                DataSet ds = DTOFactory.GetDataSet();;

                dtUserProgram = ds.Tables["ds_userprogram"];
                dtProgram     = ds.Tables["ds_program"];

                gd_UserProgram.DataSource = dtUserProgram;
                gd_Program.DataSource     = dtProgram;

                gd_UserProgram.SetGridColumn(ds.Tables["ds_column"]);
                gd_Program.SetGridColumn(ds.Tables["ds_column"]);
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 15
0
        private void GetCheckResult(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("SUBJECT", txtSubject.Text);
            SetServiceId("GetBusiness");
            DTOFactory.SetDTO(_dtSearch);
            DTOFactory.Transaction(new ReportDTO());

            try
            {
                DataTable dt = DTOFactory.GetDataTable();

                string LINK_CODE = dt.Rows[0]["LINK_CODE"].ToString();

                SetSearchData("LINK_CODE", LINK_CODE);

                foreach (DataRow row in _dtFile.Rows)
                {
                    new FileSender(LINK_CODE, row["DIR"].ToString());
                }
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }

            SetServiceId("InsertBusinessDocument");
            DTOFactory.Transaction(new ReportDTO());

            ViewMessage.Info("사업 등록을 완료 하였습니다.");
        }
Ejemplo n.º 16
0
        private void GetBankInfo()
        {
            ClearSearchData();
            SetSearchData("ACC_CD", ACC_CD);
            SetServiceId("GetBankAccountList");

            try
            {
                DTOFactory.Transaction(new AccountDTO());
                DataTable dt = DTOFactory.GetDataTable();

                cboType.SetItemChecked(dt.Rows[0]["ACC_TYP_CD"].ToString());
                cboBank.SetItemChecked(dt.Rows[0]["BNK_COMP_CD"].ToString());
                cboUser.SetItemChecked(dt.Rows[0]["USER_ID"].ToString());

                txtBankCode.Text  = dt.Rows[0]["BNK_NO"].ToString();
                txtBankDesc.Text  = dt.Rows[0]["ACC_DESC"].ToString();
                Link              = dt.Rows[0]["LINK_CD"].ToString();
                txtBankImage.Text = "";

                cboType.Enabled     = false;
                cboBank.Enabled     = false;
                txtBankCode.Enabled = false;
                btnFile.Enabled     = false;
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 17
0
        private void Save(object sender, EventArgs e)
        {
            string MENU_ID = "";

            foreach (DataRow row in dtUserProgram.Rows)
            {
                MENU_ID += "," + row["MENU_ID"].ToString();
            }

            int Row = gd_User.SelectedCells[0].RowIndex;

            ClearSearchData();
            SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID);
            SetSearchData("USER_ID", gd_User.SelectedRows[0].Cells["USER_ID"].Value.ToString());
            SetServiceId("SetPgmList");

            try
            {
                DTOFactory.Transaction(new AdminDTO());
                DataSet ds = DTOFactory.GetDataSet();;

                ViewMessage.Info("메뉴 저장이 완료 되었습니다.");

                GetUserProgram(gd_User.SelectedRows[0].Index);
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 18
0
        private void InitControl()
        {
            SetServiceId("GetItemList");

            try
            {
                DTOFactory.Transaction(new AdminDTO());
                DataSet ds = DTOFactory.GetDataSet();

                menuView.Nodes.Clear();

                dtMenu = ds.Tables["ds_menu"];
                if (dtMenu.PrimaryKey.Length == 0)
                {
                    DataColumn[] col = new DataColumn[1];
                    col[0]            = dtMenu.Columns["MENU_ID"];
                    dtMenu.PrimaryKey = col;
                }

                GetMenuItem(dtMenu);
                dtProgram = ds.Tables["ds_pgm"];
                gd_ProgramList.DataSource = dtProgram;
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 19
0
        private void ItemClick(object sender, DataGridViewCellEventArgs e)
        {
            DataGridView view = (DataGridView)sender;

            if ("관리".Equals(view.Columns[e.ColumnIndex].HeaderText))
            {
                ClearSearchData();
                SetSearchData("ITEM_ID", gd_List.SelectedCells[0].Value);
                SetSearchData("SEQ_NO", _dtItem.Rows[e.RowIndex]["SEQ_NO"].ToString());
                SetSearchData("ITEM_CD", _dtItem.Rows[e.RowIndex]["ITEM_CD"]);
                SetSearchData("ITEM_NM", _dtItem.Rows[e.RowIndex]["ITEM_NM"]);
                SetServiceId("SetItemList");

                try
                {
                    DTOFactory.Transaction(new AdminDTO());

                    ViewMessage.Info("저장이 완료 되었습니다.");
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 20
0
        private void BtnSearch_Click(object sender, EventArgs e)
        {
            ClearSearchData();
            SetSearchData("DOC_ID", cboOrder.ValueList);
            SetSearchData("STAT_CD", "2,3");
            SetServiceId("GetProductSimpleList");

            try
            {
                DTOFactory.Transaction(new MachineDTO());
                DataSet ds_return = DTOFactory.GetDataSet();
                dt_Eqp            = ds_return.Tables["ds_eqp"];
                Gd_Eqp.DataSource = dt_Eqp;

                Gd_Eqp.SetGridColumn(ds_return.Tables["ds_eqp_column"]);
                Gd_Eqp.MultiSelect = true;

                cboUser.Params.Clear();
                cboUser.Params.Add("strCompType", "V");
                cboUser.Params.Add("strCompCode", dt_Eqp.Rows[0]["COMP_CD"].ToString());
                cboUser.BindDataSet();
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 21
0
        public void Confirm(object sender, EventArgs e)
        {
            if (rdbConfirm.Checked || rdbReturn.Checked)
            {
                if (rdbConfirm.Checked)
                {
                    CFM = true;
                }

                string cfm_YN;
                string cfm_YN2;

                if (CFM == true)
                {
                    cfm_YN  = "승인";
                    cfm_YN2 = "Y";
                }
                else
                {
                    cfm_YN  = "반려";
                    cfm_YN2 = "N";
                }

                ClearSearchData();
                SetSearchData("STAT_CD", cfm_YN2);
                SetSearchData("DOC_DESC", txtCfm_DESC.Text);
                SetSearchData("DOC_ID", DOC_ID);
                SetSearchData("DOC_TYP_CD", DOC_TYP_CD);
                SetSearchData("USER_ID", "100000");

                SetServiceId("SetConfirmItem");

                try
                {
                    DTOFactory.Transaction(new DocDTO());

                    Mail.Subject  = "[문서 검토] " + txtDocType.Text + "(" + DOC_ID + ") - " + txtCrtUser.Text;
                    Mail.To       = EMAIL;
                    Mail.IsDirect = true;

                    string strBody = "하기의 사유로 문서가 " + cfm_YN + "되었습니다.<br><hr>";
                    strBody += txtCfm_DESC.Text.Replace("\r\n", "<br>");

                    Mail.Send(strBody);

                    DialogResult = DialogResult.OK;
                    ViewMessage.Info("해당 문서가 검토되었습니다.");
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
            else
            {
                ViewMessage.Warning("승인 여부를 선택해주십시오.");
            }
        }
Ejemplo n.º 22
0
        private void GetUserInfo(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1 && e.ColumnIndex > -1 && "DataGridViewTextBoxCell".Equals(gd_List.Columns[e.ColumnIndex].CellType.Name))
            {
                ClearSearchData();
                SetSearchData("COMP_CODE", _dtComp.Rows[e.RowIndex]["COMP_CD"].ToString());
                SetServiceId("GetUserList");

                try
                {
                    DTOFactory.Transaction(new MemberDTO());
                    DataSet ds = DTOFactory.GetDataSet();

                    _dtUser = ds.Tables["ds_user"];
                    gd_Member.DataSource = _dtUser;

                    if (!gd_Member.LabelDisplayed)
                    {
                        gd_Member.SetGridColumn(ds.Tables["ds_user_column"]);
                        gd_Member.SelectionMode = DataGridViewSelectionMode.CellSelect;
                        gd_Member.ReadOnly      = false;

                        gd_Member.Columns["ADDR_CD"].Visible   = false;
                        gd_Member.Columns["ADDR"].Visible      = false;
                        gd_Member.Columns["JOIN_DT"].Visible   = false;
                        gd_Member.Columns["RETIRE_DT"].Visible = false;
                        gd_Member.Columns["TEL_2"].Visible     = false;
                        gd_Member.Columns["STAT_CD"].Visible   = false;

                        gd_Member.Columns["LINE_ID"].HeaderText = "담당업무";
                        gd_Member.Columns["TEL_1"].HeaderText   = "연락처";

                        DataGridViewButtonColumn bt = new DataGridViewButtonColumn()
                        {
                            Text       = "저장",
                            HeaderText = "관리",
                            Name       = "SAVE",
                            UseColumnTextForButtonValue = true
                        };
                        gd_Member.Columns.AddRange(bt);

                        DataGridViewButtonColumn bt2 = new DataGridViewButtonColumn()
                        {
                            Text       = "삭제",
                            HeaderText = "관리",
                            Name       = "DEL",
                            UseColumnTextForButtonValue = true
                        };
                        gd_Member.Columns.AddRange(bt2);
                    }
                    btnMemberAdd.Enabled = true;
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 23
0
        private void NodeMenu(object sender, MouseEventArgs e)
        {
            TreeView view = (TreeView)sender;

            view.SelectedNode = view.GetNodeAt(e.X, e.Y);

            if (view.SelectedNode != null)
            {
                #region 오른쪽 버튼을 통한 Context Menu View
                if (e.Button == MouseButtons.Right)
                {
                    DataRow row = dtMenu.Rows.Find(view.SelectedNode.Name);

                    ContextMenu menu = new ContextMenu();
                    MenuItem    item = new MenuItem("Add", AddNode);
                    menu.MenuItems.Add(item);

                    if (row != null)
                    {
                        int seq_no = (int)row["SEQ_NO"];
                        int max_no = int.Parse(dtMenu.Compute("MAX(SEQ_NO)", "MENU_PARENT='" + row["MENU_PARENT"] + "'").ToString());

                        if (seq_no > 0)
                        {
                            item = new MenuItem("Up", MoveNodeUp);
                            menu.MenuItems.Add(item);
                        }

                        if (seq_no < max_no)
                        {
                            item = new MenuItem("Down", MoveNodeDown);
                            menu.MenuItems.Add(item);
                        }
                    }

                    menu.Show(view, e.Location);
                }
                #endregion
                else
                {
                    ClearSearchData();
                    SetSearchData("MENU_PARENT", view.SelectedNode.Name);
                    SetServiceId("GetMenuProgramList");

                    try
                    {
                        DTOFactory.Transaction(new AdminDTO());
                        dtMenuProgram         = DTOFactory.GetDataTable();
                        gd_Program.DataSource = dtMenuProgram;
                    }
                    catch (Exception ex)
                    {
                        ViewMessage.Error(ex.Message);
                    }
                }
            }
        }
Ejemplo n.º 24
0
        private void MenuSave(object sender, EventArgs e)
        {
            DataRow[] dr = dtMenu.Select("USE_YN <> 'Y'");

            if (dr.Length > 0)
            {
                string MENU_ID     = "";
                string MENU_NM     = "";
                string MENU_LEVEL  = "";
                string SEQ_NO      = "";
                string MENU_PARENT = "";

                foreach (DataRow row in dr)
                {
                    MENU_ID     += "," + row["MENU_ID"].ToString();
                    MENU_NM     += "," + row["MENU_NM"].ToString();
                    MENU_LEVEL  += "," + row["MENU_LEVEL"].ToString();
                    SEQ_NO      += "," + row["SEQ_NO"].ToString();
                    MENU_PARENT += "," + row["MENU_PARENT"].ToString();
                }

                ClearSearchData();
                SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID);
                SetSearchData("MENU_NM", MENU_NM.Length > 0 ? MENU_NM.Substring(1) : MENU_NM);
                SetSearchData("MENU_LEVEL", MENU_LEVEL.Length > 0 ? MENU_LEVEL.Substring(1) : MENU_LEVEL);
                SetSearchData("SEQ_NO", SEQ_NO.Length > 0 ? SEQ_NO.Substring(1) : SEQ_NO);
                SetSearchData("MENU_PARENT", MENU_PARENT.Length > 0 ? MENU_PARENT.Substring(1) : MENU_PARENT);
                SetServiceId("SetMenuList");

                try
                {
                    DTOFactory.Transaction(new AdminDTO());
                    DataSet ds = DTOFactory.GetDataSet();
                    ViewMessage.Info("메뉴 저장이 완료 되었습니다.");

                    menuView.Nodes.Clear();

                    dtMenu = ds.Tables["ds_menu"];
                    if (dtMenu.PrimaryKey.Length == 0)
                    {
                        DataColumn[] col = new DataColumn[1];
                        col[0]            = dtMenu.Columns["MENU_ID"];
                        dtMenu.PrimaryKey = col;
                    }

                    GetMenuItem(dtMenu);
                    dtProgram = ds.Tables["ds_pgm"];
                    gd_ProgramList.DataSource = dtProgram;
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 25
0
        private void ViewVersion(int index)
        {
            btnVerDel.Enabled  = true;
            btnVerSave.Enabled = true;

            txtVer.Text        = gd_VerList.Rows[index].Cells["VER_NM"].Value.ToString();
            txtVerSubject.Text = gd_VerList.Rows[index].Cells["SUBJECT"].Value.ToString();
            txtVerDesc.Text    = gd_VerList.Rows[index].Cells["CMT_DESC"].Value.ToString();

            if (!"".Equals(gd_VerList.Rows[index].Cells["LINK_CD"].Value.ToString()))
            {
                ImageIndex = -1;
                _dtSearch.Clear();

                DataRow dr = _dtSearch.NewRow();
                dr["FIELD"] = "LINK_CODE";
                dr["DATA"]  = gd_VerList.Rows[index].Cells["LINK_CD"].Value.ToString();
                _dtSearch.Rows.Add(dr);

                SetServiceId("GetLinkList");

                try
                {
                    DTOFactory.Transaction(new ProjectDTO());
                    _dtLink = DTOFactory.GetDataTable();

                    if (_dtLink.Rows.Count > 0)
                    {
                        ViewImage(0);
                    }
                    else
                    {
                        PicVer.Image = null;
                    }

                    btnFirst.Enabled  = true;
                    btnLast.Enabled   = true;
                    btnImgAdd.Enabled = true;
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
            else
            {
                PicVer.Image      = null;
                btnFirst.Enabled  = false;
                btnLeft.Enabled   = false;
                btnRight.Enabled  = false;
                btnLast.Enabled   = false;
                btnImgAdd.Enabled = false;
                btnImgDel.Enabled = false;
            }
        }
Ejemplo n.º 26
0
        private void ProgramSave(object sender, EventArgs e)
        {
            if (dtMenuProgram.Rows.Count > 0)
            {
                string MENU_ID = "";
                string MENU_NM = "";
                string SEQ_NO  = "";
                string USE_YN  = "";

                foreach (DataRow row in dtMenuProgram.Rows)
                {
                    MENU_ID += "," + row["MENU_ID"].ToString();
                    MENU_NM += "," + row["MENU_NM"].ToString();
                    SEQ_NO  += "," + row["SEQ_NO"].ToString();
                    USE_YN  += "," + row["USE_YN"].ToString();
                }

                string  parent = menuView.SelectedNode.Name;
                DataRow menu   = dtMenu.Rows.Find(parent);

                ClearSearchData();
                SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID);
                SetSearchData("MENU_NM", MENU_NM.Length > 0 ? MENU_NM.Substring(1) : MENU_NM);
                SetSearchData("MENU_LEVEL", int.Parse(menu["MENU_LEVEL"].ToString()) + 1);
                SetSearchData("SEQ_NO", SEQ_NO.Length > 0 ? SEQ_NO.Substring(1) : SEQ_NO);
                SetSearchData("MENU_PARENT", parent);
                SetSearchData("USE_YN", USE_YN.Length > 0 ? USE_YN.Substring(1) : USE_YN);
                SetServiceId("SetPgmList");

                try
                {
                    DTOFactory.Transaction(new AdminDTO());
                    DataSet ds = DTOFactory.GetDataSet();
                    ViewMessage.Info("메뉴 저장이 완료 되었습니다.");

                    menuView.Nodes.Clear();

                    dtMenu = ds.Tables["ds_menu"];
                    if (dtMenu.PrimaryKey.Length == 0)
                    {
                        DataColumn[] col = new DataColumn[1];
                        col[0]            = dtMenu.Columns["MENU_ID"];
                        dtMenu.PrimaryKey = col;
                    }

                    GetMenuItem(dtMenu);
                    dtProgram = ds.Tables["ds_pgm"];
                    gd_ProgramList.DataSource = dtProgram;
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
        }
Ejemplo n.º 27
0
        private void ScheduleUpdate(object sender, ToolStripItemClickedEventArgs e)
        {
            switch (e.ClickedItem.Text)
            {
            case "일정 수정":
                string desc = Microsoft.VisualBasic.Interaction.InputBox("변경할 일정 내용을 입력 하시오.", "일정 수정", gd_list.SelectedRows[0].Cells["SCH_DESC"].Value.ToString());

                if (!"".Equals(desc))
                {
                    ClearSearchData();
                    SetSearchData("USER_ID", DTOFactory.UserId);
                    SetSearchData("SCH_TM", gd_list.SelectedRows[0].Cells["SCH_TM"].Value);
                    SetSearchData("WORK_CD", gd_list.SelectedRows[0].Cells["DEL_YN"].Value);
                    SetSearchData("DESC", desc);
                    SetServiceId("UpdateSchedule");

                    try
                    {
                        DTOFactory.Transaction(new MemberDTO());

                        ViewMessage.Info("일정 내용을 수정 하였습니다.");
                        SetCalendar();
                    }
                    catch (Exception ex)
                    {
                        ViewMessage.Error(ex.Message);
                    }
                }
                break;

            case "일정 취소":
                if (System.Windows.Forms.MessageBox.Show(
                        "해당 일정을 취소 하시겠습니까?\r\n(타인의 일정은 취소 할 수 없습니다.)", "일정 취소"
                        , MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    ClearSearchData();
                    SetSearchData("USER_ID", DTOFactory.UserId);
                    SetSearchData("SCH_TM", gd_list.SelectedRows[0].Cells["SCH_TM"].Value);
                    SetServiceId("DisableSchedule");

                    try
                    {
                        DTOFactory.Transaction(new MemberDTO());

                        ViewMessage.Info("일정을 취소 하였습니다.");
                        SetCalendar();
                    }
                    catch (Exception ex)
                    {
                        ViewMessage.Error(ex.Message);
                    }
                }
                break;
            }
        }
Ejemplo n.º 28
0
        private void Save(object sender, EventArgs e)
        {
            if (!"".Equals(txtReceipt.Text))
            {
                FileSender file = new FileSender("", txtReceipt.Text);
                string     Link = file.GetLinkCode();
                file.Close();

                ClearSearchData();
                SetSearchData("ACC_DT", calAccDate.Value.ToString("yyyy-MM-dd"));
                SetSearchData("CASH", txtAccCash.Text.Replace(",", ""));
                SetSearchData("CASH_DESC", txtAccDesc.Text);
                SetSearchData("ACCOUNT_DESC", txtAccInfo.Text);
                SetSearchData("LINK_CODE", Link);
                SetSearchData("UPT_USER_ID", DTOFactory.UserId);
                if (rdoBank.Checked)
                {
                    SetSearchData("ACC_CD", cboBankCode.ValueList);
                    SetSearchData("IN_BANK_NM", txtInBankName.Text);
                    SetSearchData("IN_BANK_NO", txtInBankNo.Text);
                    SetSearchData("IN_NAME", txtInUserName.Text);
                    SetServiceId("SetBankAccountHistory");
                }
                else if (rdoCard.Checked)
                {
                    SetSearchData("ACC_TYPE", cboType.ValueList);
                    SetSearchData("ACC_CD", cboCard.ValueList);
                    SetSearchData("ACC_NO", txtAccNo.Text);
                    SetSearchData("OUT_COMP_NM", txtOutName.Text);
                    SetSearchData("OUT_COMP_REG_ID", txtOutRegId.Text);
                    SetServiceId("SetCardAccountHistory");
                }
                else
                {
                    ViewMessage.Error("잘못된 선택 입니다.");
                }

                try
                {
                    DTOFactory.Transaction(new AccountDTO());

                    DialogResult = DialogResult.OK;
                    ViewMessage.Info("등록이 완료 되었습니다.");
                    Close();
                }
                catch (Exception ex)
                {
                    ViewMessage.Error(ex.Message);
                }
            }
            else
            {
                ViewMessage.Error("첨부 파일이 없습니다.");
            }
        }
Ejemplo n.º 29
0
        private void GetUserInfo(int rowindex, string STAT_CD)
        {
            ClearSearchData();
            SetSearchData("COMP_CODE", _dtComp.Rows[rowindex]["COMP_CD"].ToString());
            SetSearchData("STAT_CD", STAT_CD);
            SetServiceId("GetUserList");

            try
            {
                DTOFactory.Transaction(new MemberDTO());
                DataSet ds = DTOFactory.GetDataSet();

                _dtUser = ds.Tables["ds_user"];
                gd_Member.Columns.Clear();
                gd_Member.DataSource = _dtUser;


                gd_Member.SetGridColumn(ds.Tables["ds_user_column"]);

                gd_Member.SelectionMode = DataGridViewSelectionMode.CellSelect;
                gd_Member.ReadOnly      = false;

                gd_Member.Columns["TEL_1"].HeaderText  = "연락처";
                gd_Member.Columns["TEL_2"].HeaderText  = "내선번호";
                gd_Member.Columns["ADDR_CD"].Visible   = false;
                gd_Member.Columns["ADDR"].Visible      = false;
                gd_Member.Columns["STAT_CD"].Visible   = false;
                gd_Member.Columns["RETIRE_DT"].Visible = false;

                DataGridViewButtonColumn bt = new DataGridViewButtonColumn()
                {
                    Text       = "저장",
                    HeaderText = "",
                    Name       = "SAVE",
                    UseColumnTextForButtonValue = true
                };
                gd_Member.Columns.AddRange(bt);

                //2021-01-26 hsh - 삭제 기능을 제거 후 퇴직 기능 추가
                DataGridViewButtonColumn bt2 = new DataGridViewButtonColumn()
                {
                    Text       = "재직".Equals(STAT_CD) ? "퇴직처리" : "전산등록",
                    HeaderText = "",
                    Name       = "SUBMIT",
                    UseColumnTextForButtonValue = true,
                    ReadOnly = false
                };
                gd_Member.Columns.AddRange(bt2);
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }
Ejemplo n.º 30
0
        private void Save(object sender, EventArgs e)
        {
            DataTable dt_input = new DataTable();

            dt_input.Columns.Add("PGM_ID");
            dt_input.Columns.Add("PGM_NM");
            dt_input.Columns.Add("PGM_DLL");
            dt_input.Columns.Add("PGM_CLASS");
            dt_input.Columns.Add("PGM_SVR_DLL");
            dt_input.Columns.Add("PGM_SVR_CLASS");

            foreach (DataGridViewRow row in gd_Program.Rows)
            {
                if (row.DefaultCellStyle.BackColor == Color.Yellow)
                {
                    DataRow dr = dt_input.NewRow();

                    dr["PGM_ID"]        = row.Cells["PGM_ID"].Value;
                    dr["PGM_NM"]        = row.Cells["PGM_NM"].Value;
                    dr["PGM_DLL"]       = row.Cells["PGM_DLL"].Value;
                    dr["PGM_CLASS"]     = row.Cells["PGM_CLASS"].Value;
                    dr["PGM_SVR_DLL"]   = row.Cells["PGM_SVR_DLL"].Value;
                    dr["PGM_SVR_CLASS"] = row.Cells["PGM_SVR_CLASS"].Value;

                    dt_input.Rows.Add(dr);
                }
            }

            ClearSearchData();
            SetServiceId("SetProgramList");
            DTOFactory.SetDTOTable("ds_list", dt_input);

            try
            {
                DTOFactory.Transaction(new AdminDTO());
                DataSet ds = DTOFactory.GetDataSet();
                dtProgram             = ds.Tables["ds_program"];
                gd_Program.DataSource = dtProgram;
                gd_Program.SetGridColumn(ds.Tables["ds_program_column"]);

                foreach (DataGridViewColumn col in gd_Program.Columns)
                {
                    col.SortMode = DataGridViewColumnSortMode.NotSortable;
                }

                ViewMessage.Info("저장이 완료 되었습니다.");
            }
            catch (Exception ex)
            {
                ViewMessage.Error(ex.Message);
            }
        }