Exemplo n.º 1
0
 private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex < dgvCompany.Rows.Count && e.RowIndex > -1)
     {
         if (dgvCompany.Rows[e.RowIndex].Cells[5].Value == null)
         {
             item = new CompanyVO
             {
                 Company_ID         = Convert.ToInt32(dgvCompany.Rows[e.RowIndex].Cells[0].Value),
                 Company_Name       = dgvCompany.Rows[e.RowIndex].Cells[1].Value.ToString(),
                 Company_AddrNumber = dgvCompany.Rows[e.RowIndex].Cells[2].Value.ToString(),
                 Company_Address    = dgvCompany.Rows[e.RowIndex].Cells[3].Value.ToString(),
                 Company_Number     = dgvCompany.Rows[e.RowIndex].Cells[4].Value.ToString(),
                 CodeTable_CodeID   = dgvCompany.Rows[e.RowIndex].Cells[6].Value.ToString(),
                 Company_Owner      = dgvCompany.Rows[e.RowIndex].Cells[8].Value.ToString()
             };
         }
         else
         {
             item = new CompanyVO
             {
                 Company_ID         = Convert.ToInt32(dgvCompany.Rows[e.RowIndex].Cells[0].Value),
                 Company_Name       = dgvCompany.Rows[e.RowIndex].Cells[1].Value.ToString(),
                 Company_AddrNumber = dgvCompany.Rows[e.RowIndex].Cells[2].Value.ToString(),
                 Company_Address    = dgvCompany.Rows[e.RowIndex].Cells[3].Value.ToString(),
                 Company_Number     = dgvCompany.Rows[e.RowIndex].Cells[4].Value.ToString(),
                 Company_Fax        = dgvCompany.Rows[e.RowIndex].Cells[5].Value.ToString(),
                 CodeTable_CodeID   = dgvCompany.Rows[e.RowIndex].Cells[6].Value.ToString(),
                 Company_Owner      = dgvCompany.Rows[e.RowIndex].Cells[8].Value.ToString()
             };
         }
     }
 }
Exemplo n.º 2
0
        public bool InsertCompany(CompanyVO vo)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                string sql = "InsertCompany";

                cmd.Connection  = new SqlConnection(this.ConnectionString);
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection.Open();

                //         cmd.Parameters.AddWithValue("@company_id", vo.company_id);
                cmd.Parameters.AddWithValue("@company_code", vo.company_code);
                cmd.Parameters.AddWithValue("@company_name", vo.company_name);
                cmd.Parameters.AddWithValue("@company_type", vo.company_type);
                cmd.Parameters.AddWithValue("@company_ceo", vo.company_ceo);
                cmd.Parameters.AddWithValue("@company_cnum", vo.company_cnum);
                cmd.Parameters.AddWithValue("@company_btype", vo.company_btype);
                cmd.Parameters.AddWithValue("@company_gtype", vo.company_gtype);
                cmd.Parameters.AddWithValue("@user_id", vo.user_id);
                cmd.Parameters.AddWithValue("@company_email", vo.company_email);
                cmd.Parameters.AddWithValue("@company_phone", vo.company_phone);
                cmd.Parameters.AddWithValue("@company_fax", vo.company_fax);
                cmd.Parameters.AddWithValue("@company_yn", vo.company_yn);
                cmd.Parameters.AddWithValue("@company_uadmin", vo.company_uadmin);
                cmd.Parameters.AddWithValue("@company_udate", vo.company_udate);
                cmd.Parameters.AddWithValue("@company_comment", vo.company_comment);
                //  cmd.Parameters.AddWithValue("@company_order_code", vo.company_order_code);

                var successRow = cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                return(successRow > 0);
            }
        }
Exemplo n.º 3
0
 /// <summary>
 /// Constructor
 /// </summary>
 public Company(CompanyVO companyVO)
 {
     ID         = companyVO.CompanyID;
     Name       = companyVO.Name;
     NameWithID = companyVO.Name + " - " + ID;
     IsSelected = companyVO.IsSelected;
 }
Exemplo n.º 4
0
        private void InsertCompany()
        {
            CompanyVO item = new CompanyVO
            {
                Company_Name       = txtCompanyName.Text,
                Company_Number     = maskedCompanyNumber.Text,
                Company_Fax        = maskedCompanyFaxNumber.Text,
                CodeTable_CodeID   = cboCompanyDivision.SelectedValue.ToString(),
                Company_Owner      = txtCompanyOwner.Text,
                Company_Address    = addrCompany.Address1 + " " + addrCompany.Address2,
                Company_AddrNumber = addrCompany.Zipcode
            };

            if (item.Company_Fax.Replace("-", "").Trim().Length < 10)
            {
                item.Company_Fax = null;
            }

            try
            {
                StandardService service = new StandardService();
                service.InsertCompany(item);
            }
            catch (Exception err)
            {
                Log.WriteError(err.Message, err);
            }
        }
Exemplo n.º 5
0
        /// <summary>
        /// Transpose Model object to Value Object
        /// </summary>
        /// <param name="userId">user Id</param>
        /// <returns>Value object</returns>
        public CompanyVO Transpose()
        {
            CompanyVO companyVO = new CompanyVO();

            companyVO.Name       = this.Name;
            companyVO.CompanyID  = this.ID;
            companyVO.IsSelected = this.IsSelected;

            return(companyVO);
        }
        public CompanyProductPopupForm(string employeeName, bool IsDataExists, CompanyVO company)
        {
            InitializeComponent();
            this.IsDataExists = IsDataExists;

            this.employeeName = employeeName;
            if (IsDataExists == true)
            {
                this.companyVO = company;
            }
        }
Exemplo n.º 7
0
 private void UpdateInfo(CompanyVO item)
 {
     code = item.Company_ID;
     txtCompanyName.Text         = item.Company_Name;
     maskedCompanyNumber.Text    = item.Company_Number;
     maskedCompanyFaxNumber.Text = item.Company_Fax;
     txtCompanyOwner.Text        = item.Company_Owner;
     addrCompany.Zipcode         = item.Company_AddrNumber;
     string[] str = item.Company_Address.Split(' ');
     addrCompany.Address1 = str[0];
     addrCompany.Address2 = str[1];
     division             = item.CodeTable_CodeID;
 }
Exemplo n.º 8
0
        /// <summary>
        /// vo에 id, 거래처명, 거래분류, 대표명, 사업자번호, 업종, 업태, 이메일, 번호, 팩스, 우편번호, 주소, 상세주소, 비고를 넣어 DB의 내용을 수정한다.
        /// 작성자: 최현호 / 작성일: 210212
        /// </summary>
        /// <param name="vo"></param>
        /// <returns></returns>
        public bool Update(CompanyVO vo)
        {
            try
            {
                string sql = @"update TBL_COMPANY 
                            set company_name = @company_name, 
	                            company_type = @company_type, 
	                            company_ceo = @company_ceo, 
	                            company_cnum = @company_cnum, 
	                            company_btype = @company_btype, 
	                            company_gtype = @company_gtype, 
	                            company_email = @company_email, 
	                            company_phone = @company_phone, 
	                            company_fax = @company_fax, 
	                            company_ZipCode = @company_ZipCode, 
	                            company_Address = @company_Address, 
	                            company_DetAddress = @company_DetAddress, 
	                            company_uadmin = @company_uadmin, 
	                            company_udate = @company_udate, 
	                            company_comment = @company_comment
                            where company_id = @company_id";
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddWithValue("@company_name", vo.company_name);
                    cmd.Parameters.AddWithValue("@company_type", vo.company_type);
                    cmd.Parameters.AddWithValue("@company_ceo", vo.company_ceo);
                    cmd.Parameters.AddWithValue("@company_cnum", vo.company_cnum);
                    cmd.Parameters.AddWithValue("@company_btype", vo.company_btype);
                    cmd.Parameters.AddWithValue("@company_gtype", vo.company_gtype);
                    cmd.Parameters.AddWithValue("@company_email", vo.company_email);
                    cmd.Parameters.AddWithValue("@company_phone", vo.company_phone);
                    cmd.Parameters.AddWithValue("@company_fax", vo.company_fax);
                    cmd.Parameters.AddWithValue("@company_ZipCode", vo.company_ZipCode);
                    cmd.Parameters.AddWithValue("@company_Address", vo.company_Address);
                    cmd.Parameters.AddWithValue("@company_DetAddress", vo.company_DetAddress);
                    cmd.Parameters.AddWithValue("@company_uadmin", vo.company_uadmin);
                    cmd.Parameters.AddWithValue("@company_udate", vo.company_udate);
                    cmd.Parameters.AddWithValue("@company_comment", vo.company_comment);
                    cmd.Parameters.AddWithValue("@company_id", vo.company_id);

                    int iRowAffect = cmd.ExecuteNonQuery();
                    conn.Close();

                    return(iRowAffect > 0);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 9
0
        /// <summary>
        /// Get list of comapanies associated with user
        /// </summary>
        /// <param name="userId">user id</param>
        /// <returns>list of associated company</returns>
        public List <CompanyVO> GetAssociatedCompanyByUserID(int userId)
        {
            List <CompanyVO>          associatedCompanyList = new List <CompanyVO>();
            List <UserCompanyMapping> userCompanyMapping    = mdbDataContext.UserCompanyMappings.Where(u => u.UserID == userId &&
                                                                                                       u.IsActive == true).ToList();

            foreach (var item in userCompanyMapping)
            {
                CompanyVO company = new CompanyVO();
                company.CompanyID  = item.CompanyID;
                company.IsSelected = true;
                associatedCompanyList.Add(company);
            }

            return(associatedCompanyList);
        }
Exemplo n.º 10
0
    private void BuildBrand()
    {
        StringBuilder html    = new StringBuilder();
        CompanyVO     company = dh.GetCompanyByID(accountInfo.Company_ID);

        if (company != null)
        {
            html.Append("<a class=\"navbar-brand\">" + company.Company_Name + " - ERP系统</a>");
        }
        else
        {
            html.Append("<a class=\"navbar-brand\">ERP系统后台</a>");
        }

        BrandLiteral.Text = html.ToString();
    }
Exemplo n.º 11
0
        public CompanyInsUp(EditMode editMode, CompanyVO item)
        {
            InitializeComponent();

            if (editMode == EditMode.Insert)
            {
                lblName.Text   = "거래처 등록";
                mode           = "Insert";
                pbxTitle.Image = Resources.AddFile_32x32;
            }
            else
            {
                lblName.Text   = "거래처 수정";
                mode           = "Update";
                pbxTitle.Image = Resources.Edit_32x32;

                UpdateInfo(item);
            }
        }
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            try
            {
                CompanyVO vo = new CompanyVO();
                List <ProductSimpleVO> prodListVO = new List <ProductSimpleVO>();

                vo.company_id            = Convert.ToInt32((txtCompany_Id.Text.Length > 0) ? txtCompany_Id.Text:"0");
                vo.company_name          = txtCompany_Name.Text;
                vo.company_seq           = Convert.ToInt32((nudCompany_seq.Text.Length > 0) ? nudCompany_seq.Text : "0");
                vo.company_type          = cboCompany_Type.SelectedValue.ToString();
                vo.first_regist_employee = employeeName;
                vo.final_regist_employee = employeeName;

                if (listBoxProduct.Items.Count > 0)
                {
                    foreach (string prodInfo in listBoxProduct.Items)
                    {
                        prodListVO.Add(new ProductSimpleVO
                        {
                            Product_ID   = Convert.ToInt32(prodInfo.Split('/')[0]),
                            Product_Name = prodInfo.Split('/')[1]
                        }
                                       );
                    }
                }

                if (service.SaveCompany(vo, prodListVO))
                {
                    MessageBox.Show("정상적으로 저장되었습니다.");
                    this.DialogResult = DialogResult.OK;
                    this.Close();
                }
            }
            catch (Exception err)
            {
                throw err;
            }
        }
Exemplo n.º 13
0
        private void Readed(object sender, ReadEventArgs e)
        {
            if (((MainForm)this.MdiParent).ActiveMdiChild == this)
            {
                int comCode = int.Parse(e.ReadMsg.Trim().Replace("\r", "").Replace("\n", ""));

                foreach (DataGridViewRow dgvr in dgvCompanyList.Rows)
                {
                    if (dgvr.Cells["company_id"].Value.ToInt() == comCode)
                    {
                        dgvr.Selected = true;


                        break;
                    }
                }

                if (MessageBox.Show("수정하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    CompanyVO company = new CompanyVO();
                    company.company_id   = Convert.ToInt32(dgvCompanyList.SelectedRows[0].Cells[1].Value);
                    company.company_name = dgvCompanyList.SelectedRows[0].Cells[2].Value.ToString();
                    company.company_type = dgvCompanyList.SelectedRows[0].Cells[3].Value.ToString();
                    company.company_seq  = Convert.ToInt32(dgvCompanyList.SelectedRows[0].Cells[4].Value);

                    CompanyProductPopupForm cpp = new CompanyProductPopupForm(emp.Employee_name, true, company);

                    if (cpp.ShowDialog() == DialogResult.OK)
                    {
                        dgvCompanyList.Columns.Clear();
                        CompanyForm_Load(null, null);
                    }

                    return;
                }

                this.GetMdiParent().ClearStrs();
            }
        }
Exemplo n.º 14
0
        public bool UpdateCompany(CompanyVO item)
        {
            string sql = "Update Company set Company_Name = @Company_Name, Company_Address1 = @Company_Address1, Company_Address2 = @Company_Address2, Company_Number = @Company_Number, Company_Fax = @Company_Fax, CodeTable_CodeID = @CodeTable_CodeID, Company_Owner = @Company_Owner where Company_ID = @Company_ID ";

            string[] str = item.Company_Address.Split(' ');
            try
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddWithValue("@Company_Name", item.Company_Name);
                    cmd.Parameters.AddWithValue("@Company_Address1", str[0]);
                    cmd.Parameters.AddWithValue("@Company_Address2", str[1]);
                    cmd.Parameters.AddWithValue("@Company_Number", item.Company_Number);
                    if (item.Company_Fax == null)
                    {
                        cmd.Parameters.AddWithValue("@Company_Fax", DBNull.Value);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@Company_Fax", item.Company_Fax);
                    }
                    cmd.Parameters.AddWithValue("@CodeTable_CodeID", item.CodeTable_CodeID);
                    cmd.Parameters.AddWithValue("@Company_Owner", item.Company_Owner);
                    cmd.Parameters.AddWithValue("@Company_ID", item.Company_ID);

                    conn.Open();
                    var rowsAffected = cmd.ExecuteNonQuery();
                    return(rowsAffected > 0);
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                conn.Close();
            }
        }
Exemplo n.º 15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            switch (Request.QueryString["type"])
            {
                case "company":
                    CompanyVO auxEmp = new CompanyVO();
                    auxEmp = (CompanyVO)EntityExtractor.create(EntityExtractor.EMP_EXTRACTOR).getDetails(int.Parse(Request.QueryString["id"]));
                    ReportManager.Instance.createReport(auxEmp, this, 1);
                    break;

                case "ods":
                    ODSVO auxOds = new ODSVO();
                    auxOds = (ODSVO)EntityExtractor.create(EntityExtractor.ODS_EXTRACTOR).getDetails(int.Parse(Request.QueryString["id"]));
                    ReportManager.Instance.createReport(auxOds, this, 2);
                    break;

                case "cooperant":
                    CooperantVO auxCoop = new  CooperantVO();
                    auxCoop = (CooperantVO)EntityExtractor.create(EntityExtractor.COOP_EXTRACTOR).getDetails(int.Parse(Request.QueryString["id"]));
                    ReportManager.Instance.createReport(auxCoop, this, 3);
                    break;

            }
        }
Exemplo n.º 16
0
        private void dgvCompanyList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) //업데이트 할떄 더블클릭
        {
            if (e.RowIndex < 0)
            {
                return;
            }
            else
            {
                CompanyVO company = new CompanyVO();
                company.company_id   = Convert.ToInt32(dgvCompanyList.SelectedRows[0].Cells[1].Value);
                company.company_name = dgvCompanyList.SelectedRows[0].Cells[2].Value.ToString();
                company.company_type = dgvCompanyList.SelectedRows[0].Cells[3].Value.ToString();
                company.company_seq  = Convert.ToInt32(dgvCompanyList.SelectedRows[0].Cells[4].Value);


                CompanyProductPopupForm cpp = new CompanyProductPopupForm(emp.Employee_name, true, company);

                if (cpp.ShowDialog() == DialogResult.OK)
                {
                    dgvCompanyList.Columns.Clear();
                    CompanyForm_Load(null, null);
                }
            }
        }
Exemplo n.º 17
0
    public EntityVO getDetails(int i)
    {
        FVSL_LINQDataContext dbcon = new FVSL_LINQDataContext();

        CompanyVO EMP = new CompanyVO();

        try
        {

            List<EMP_Empresa> resultset = dbcon.MAPA_EMP_DETAILS(i).ToList();

            if (resultset.Count == 1)
            {
                EMP = FEMP(resultset[0]);
            }

            return EMP;
        }
        catch (Exception e)
        {
            Logging.WriteError(e.StackTrace.ToString());
            return null;
        }
    }
Exemplo n.º 18
0
        /// <summary>
        /// vo에 거래처명, 거래분류, 대표명, 사업자번호, 업종, 업태, 이메일, 번호, 팩스, 우편번호, 주소, 상세주소, 비고를 넣어 새로 등록한다
        /// 작성자: 최현호 / 작성일: 210212
        /// </summary>
        /// <param name="vo"></param>
        /// <returns></returns>
        public bool Insert(CompanyVO vo)
        {
            try
            {
                string sql = @"insert into 
	                        TBL_COMPANY(company_name, company_type, company_ceo, company_cnum, company_btype, company_gtype, company_email, company_phone, 
                                        company_fax, company_ZipCode, company_Address, company_DetAddress, company_comment)
                            values (@company_name, @company_type, @company_ceo, @company_cnum, @company_btype, @company_gtype, @company_email, 
                                    @company_phone, @company_fax, @company_ZipCode, @company_Address, @company_DetAddress, @company_comment)";
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddWithValue("@company_name", vo.company_name);
                    cmd.Parameters.AddWithValue("@company_type", vo.company_type);
                    cmd.Parameters.AddWithValue("@company_ceo", vo.company_ceo);
                    cmd.Parameters.AddWithValue("@company_cnum", vo.company_cnum);
                    cmd.Parameters.AddWithValue("@company_btype", vo.company_btype);
                    cmd.Parameters.AddWithValue("@company_gtype", vo.company_gtype);
                    cmd.Parameters.AddWithValue("@company_email", vo.company_email);
                    cmd.Parameters.AddWithValue("@company_phone", vo.company_phone);
                    cmd.Parameters.AddWithValue("@company_fax", vo.company_fax);
                    cmd.Parameters.AddWithValue("@company_ZipCode", vo.company_ZipCode);
                    cmd.Parameters.AddWithValue("@company_Address", vo.company_Address);
                    cmd.Parameters.AddWithValue("@company_DetAddress", vo.company_DetAddress);
                    cmd.Parameters.AddWithValue("@company_comment", vo.company_comment);

                    int iRowAffect = cmd.ExecuteNonQuery();
                    conn.Close();

                    return(iRowAffect > 0);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 19
0
 public EMPTemplate(CompanyVO emp)
 {
     this.Id = BaseTemplate.COMPANY_TEMPLATE;
     this._emp = emp;
 }
Exemplo n.º 20
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtCodeCompany.Text == "" || txtNameCompany.Text == "" || cboCompanyType.SelectedIndex == 0)
                {
                    MessageBox.Show("필수항목이 입력되지 않았습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                    this.DialogResult = DialogResult.None;
                    return;
                }
                CompanyVO VO = new CompanyVO();

                VO.company_code    = txtCodeCompany.Text;
                VO.company_name    = txtNameCompany.Text;
                VO.company_type    = cboCompanyType.SelectedValue.ToString();
                VO.company_gtype   = txtGtype.Text;
                VO.user_id         = Convert.ToInt32(cboUser.SelectedValue);
                VO.company_email   = txtEmail.Text;
                VO.company_phone   = txtPhone.Text;
                VO.company_fax     = txtFax.Text;
                VO.company_yn      = cboYN.SelectedValue.ToString();
                VO.company_comment = txtComment.Text;
                VO.company_uadmin  = txtAdmin.Text;
                VO.company_udate   = txtUdate.Text;
                VO.company_cnum    = txtCnum.Text;
                VO.company_ceo     = txtCEO.Text;
                VO.company_btype   = txtbtype.Text;

                bool bResult = false;
                if (mode == EditMode.Input)
                {
                    bResult = R_service.InsertCompany(VO);
                    if (bResult)
                    {
                        //   MessageBox.Show("등록성공");
                        this.DialogResult = DialogResult.OK;
                    }
                    else if (!bResult)
                    {
                        //     MessageBox.Show("등록실패");
                        this.DialogResult = DialogResult.None;
                        return;
                    }
                }
                if (mode == EditMode.Update)
                {
                    VO.company_order_code = txtOrder_code.Text;
                    VO.company_id         = Convert.ToInt32(lblID.Text);
                    bResult = R_service.UpdateCompany(VO);
                    if (bResult)
                    {
                        //    MessageBox.Show("수정성공");
                        this.DialogResult = DialogResult.OK;
                    }
                    else if (!bResult)
                    {
                        //    MessageBox.Show("수정실패");
                        this.DialogResult = DialogResult.None;
                        return;
                    }
                }
            }
            catch (NullReferenceException err)
            {
                MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.DialogResult = DialogResult.None;
                return;
            }
            catch (Exception err)
            {
                string str = err.Message;
            }
        }
Exemplo n.º 21
0
 public bool InsertCompany(CompanyVO vo)
 {
     return(dac.InsertCompany(vo));
 }
        public bool UpdateCompany(CompanyVO item)
        {
            CompanyDAC dac = new CompanyDAC();

            return(dac.UpdateCompany(item));
        }
        public bool InsertCompany(CompanyVO item)
        {
            CompanyDAC dac = new CompanyDAC();

            return(dac.InsertCompany(item));
        }
Exemplo n.º 24
0
 public bool UpdateCompany(CompanyVO vo)
 {
     return(dac.UpdateCompany(vo));
 }
Exemplo n.º 25
0
        ///<returns></returns>

        /// <summary>
        /// 저장하기
        /// </summary>
        public bool SaveCompany(CompanyVO company, List <ProductSimpleVO> prodListVO)
        {
            return(dac.SaveCompany(company, prodListVO));
        }
Exemplo n.º 26
0
        // GET: Home
        public ActionResult Index()
        {
            HomeVO  homevo = new HomeVO();
            HomeDac hdac   = new HomeDac();


            List <UserVO> userlist = hdac.GetLastestUsers();

            homevo.Userlist = userlist;

            HomeDac hdac1 = new HomeDac();

            homevo.WorkRate = hdac1.GetWorkRate();

            HomeDac hdac2 = new HomeDac();

            homevo.CompanyCount = hdac2.GetCompanyCount();
            List <CompanyVO> clist  = hdac2.GetCompanyCount();
            CompanyVO        result = new CompanyVO();

            result.sum         = clist.Sum(item => item.sum);
            result.month       = clist[1].sum;
            homevo.CompanyData = result;

            HomeDac hdac3 = new HomeDac();

            homevo.SalseRate = hdac3.GetSalesRate();

            homevo.SalesPrice      = string.Format("{0:c}", Convert.ToInt32(homevo.SalseRate[1].price));
            homevo.SalesRateToView = ((homevo.SalseRate[1].price / homevo.SalseRate[0].price) * 100).ToString("#.0") + "%";



            if ((homevo.SalseRate[1].price / homevo.SalseRate[0].price) * 100 > 100)
            {
                homevo.SalesRateBool = true;
            }
            else
            {
                homevo.SalesRateBool   = false;
                homevo.SalesRateToView = (100 - ((homevo.SalseRate[1].price / homevo.SalseRate[0].price) * 100)).ToString() + "%";
            }



            HomeDac hdac4 = new HomeDac();

            homevo.Orderlist = hdac4.GetLastestOrderList();


            //OrderDac oDac = new OrderDAC();
            //List<OrderStatsVO> list = oDac.GetOrderBestProduct();

            //var listStat = from stat in list
            //               orderby stat.MM
            //               group stat by stat.ProductName;

            //List<string> keys = new List<string>();
            //StringBuilder sb = new StringBuilder();
            //string data1 = string.Empty, data2 = string.Empty, data3 = string.Empty;

            //int k = 0;
            //foreach (var group in listStat)
            //{
            //    keys.Add(group.Key);
            //    List<int> qtys = new List<int>();
            //    foreach (var product in group)
            //    {
            //        if (k == 0)
            //        {
            //            sb.Append(product.MM + "월,");
            //        }
            //        qtys.Add(product.Qty);
            //    }
            //    if (k == 0)
            //        data1 = "[" + string.Join(",", qtys.ToArray()) + "]";
            //    else if (k == 1)
            //        data2 = "[" + string.Join(",", qtys.ToArray()) + "]";
            //    else if (k == 2)
            //        data3 = "[" + string.Join(",", qtys.ToArray()) + "]";
            //    k++;
            //    qtys.Clear();
            //}
            //string labels = sb.ToString().TrimEnd(',');
            //string label1 = keys[0];
            //string label2 = keys[1];
            //string label3 = keys[2];


            //ViewBag.Label1 = label1;
            //ViewBag.Data1 = data1;
            //ViewBag.Label2 = label2;
            //ViewBag.Data2 = data2;
            //ViewBag.Label3 = label3;
            //ViewBag.Data3 = data3;
            return(View(homevo));
        }
Exemplo n.º 27
0
    private CompanyVO FEMP(EMP_Empresa empin)
    {
        CompanyVO aux = new CompanyVO();

        aux.id = empin.Id.ToString();
        aux.name = empin.Nombre;
        aux.latitude = empin.Latitud;
        aux.longitude = empin.Longitud;
        aux.direction = empin.Ciudad + ", " + empin.Urbanizacion + " " + empin.Calle;
        aux.website = empin.PaginaWeb;
        aux.facebook = empin.Facebook;
        aux.twitter = empin.Twitter;
        //aux.objective = empin.o;
        aux.email = empin.Correo;
        aux.type = "empresa";
        aux.beneficiarios = getEMPbeneficiario(empin.Id);
        aux.awards = getEMPaward(empin.Id);
        aux.areas = getEMParea(empin.Id);
        if (empin.Logo != null) aux.imgdata = empin.Logo.ToArray();

        return aux;
    }
Exemplo n.º 28
0
        /// <summary>
        /// CompanyVO 타입으로 선언한 vo에 각 텍스트 내용을 담아서 DAC단의 파라미터로 전달
        /// 수정의 경우 수정자는 현재 로그인계정, 수정일은 현재 날짜 ToShortDateString
        /// 작성자: 최현호 / 작성일: 210210
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnEdit_Click(object sender, EventArgs e)
        {
            #region 등록 및 수정
            try
            {
                if (label1.Text == "업체관리 등록")
                {
                    CompanyVO vo = new CompanyVO
                    {
                        company_name       = txtCName.Text,
                        company_type       = cbCType.Text,
                        company_ceo        = txtCCeo.Text,
                        company_cnum       = txtCNum.Text,
                        company_btype      = txtCBtype.Text,
                        company_gtype      = txtCGtype.Text,
                        company_email      = txtCEmail.Text,
                        company_phone      = txtCPNum.Text,
                        company_fax        = txtCFax.Text,
                        company_ZipCode    = txtZipCode.Text,
                        company_Address    = txtAddress.Text,
                        company_DetAddress = txtDetAddress.Text,
                        company_comment    = txtComment.Text,
                    };
                    bool result = service.Insert(vo);

                    if (result)
                    {
                        MessageBox.Show(Properties.Resources.msgOK);
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show(Properties.Resources.msgError);
                    }
                }
                else if (label1.Text == "업체관리 수정")
                {
                    CompanyVO vo = new CompanyVO
                    {
                        company_id         = int.Parse(lblCompanyID.Text),
                        company_name       = txtCName.Text,
                        company_type       = cbCType.Text,
                        company_ceo        = txtCCeo.Text,
                        company_cnum       = txtCNum.Text,
                        company_btype      = txtCBtype.Text,
                        company_gtype      = txtCGtype.Text,
                        company_email      = txtCEmail.Text,
                        company_phone      = txtCPNum.Text,
                        company_fax        = txtCFax.Text,
                        company_ZipCode    = txtZipCode.Text,
                        company_Address    = txtAddress.Text,
                        company_DetAddress = txtDetAddress.Text,
                        company_comment    = txtComment.Text,
                        company_uadmin     = LoginVO.user.Name,
                        company_udate      = DateTime.Now.ToShortDateString()
                    };
                    bool result = service.Update(vo);

                    if (result)
                    {
                        MessageBox.Show(Properties.Resources.msgOK);
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show(Properties.Resources.msgError);
                    }
                }
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
            #endregion
        }
Exemplo n.º 29
0
        public bool Update(CompanyVO vo)
        {
            CompanyDAC dac = new CompanyDAC();

            return(dac.Update(vo));
        }
Exemplo n.º 30
0
        public bool Insert(CompanyVO vo)
        {
            CompanyDAC dac = new CompanyDAC();

            return(dac.Insert(vo));
        }
Exemplo n.º 31
0
        /// <returns></returns>

        ///<summary>
        /// 저장하기
        /// </summary
        public bool SaveCompany(CompanyVO company, List <ProductSimpleVO> prodListVO)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(this.ConnectionString))
                {
                    conn.Open();

                    string sql = @"SP_SAVE_COMPANY";

                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.AddWithValue("@P_company_id", company.company_id);
                        cmd.Parameters.AddWithValue("@P_company_name", company.company_name);
                        cmd.Parameters.AddWithValue("@P_company_type", company.company_type);
                        cmd.Parameters.AddWithValue("@P_company_seq", company.company_seq);
                        cmd.Parameters.AddWithValue("@P_first_regist_employee", company.first_regist_employee);
                        cmd.Parameters.AddWithValue("@P_final_regist_employee", company.final_regist_employee);

                        SqlParameter param1 = new SqlParameter("@O_company_id", SqlDbType.Int);
                        param1.Direction = ParameterDirection.Output;
                        cmd.Parameters.Add(param1);

                        int result = cmd.ExecuteNonQuery();
                        if (result > 0)
                        {
                            if (company.company_id != 0)
                            {
                                string sqlDelete = @"Delete from TBL_COMPANY_PRODUCT where company_id = @company_id";
                                cmd.CommandText = sqlDelete;
                                cmd.CommandType = CommandType.Text;
                                cmd.Parameters.Clear();
                                cmd.Parameters.AddWithValue("@company_id", company.company_id);
                                cmd.ExecuteNonQuery();

                                foreach (var item in prodListVO)
                                {
                                    string sqlInsert = @"Insert into TBL_COMPANY_PRODUCT(company_id, product_id) values(@company_id, @product_id)";
                                    cmd.CommandText = sqlInsert;
                                    cmd.Parameters.Clear();
                                    cmd.Parameters.AddWithValue("@company_id", company.company_id);
                                    cmd.Parameters.AddWithValue("@product_id", item.Product_ID);
                                    cmd.ExecuteNonQuery();
                                }
                            }

                            else
                            {
                                foreach (var item in prodListVO)
                                {
                                    string sqlInsert = @"Insert into TBL_COMPANY_PRODUCT(company_id, product_id) values(@company_id, @product_id)";
                                    cmd.CommandText = sqlInsert;
                                    cmd.CommandType = CommandType.Text;
                                    cmd.Parameters.Clear();
                                    cmd.Parameters.AddWithValue("@company_id", param1.Value);
                                    cmd.Parameters.AddWithValue("@product_id", item.Product_ID);
                                    cmd.ExecuteNonQuery();
                                }
                            }
                        }
                    }
                }

                return(true);
            }
            catch (Exception err)
            {
                throw err;
                //return false;
            }
        }