コード例 #1
0
ファイル: Company.cs プロジェクト: Oman/Maleos
        private void setNewValue(Company company)
        {
            if (!string.IsNullOrEmpty(company.CompanyName))
                this.CompanyName = company.CompanyName;

            if (!string.IsNullOrEmpty(company.CompanyAddress))
                this.CompanyAddress = company.CompanyAddress;

            if (!string.IsNullOrEmpty(company.CompanyPost))
                this.CompanyPost = company.CompanyPost;

            if (!string.IsNullOrEmpty(company.JuridicalPerson))
                this.JuridicalPerson = company.JuridicalPerson;

            if (!string.IsNullOrEmpty(company.JuridicalPersonSex))
                this.JuridicalPersonSex = company.JuridicalPersonSex;

            if (!string.IsNullOrEmpty(company.JuridicalPersonAge))
                this.JuridicalPersonAge = company.JuridicalPersonAge;

            if (!string.IsNullOrEmpty(company.JuridicalPersonJob))
                this.JuridicalPersonJob = company.JuridicalPersonJob;

            if (!string.IsNullOrEmpty(company.Mobile))
                this.Mobile = company.Mobile;

            if (!string.IsNullOrEmpty(company.Tel))
                this.Tel = company.Tel;
        }
コード例 #2
0
ファイル: Company.cs プロジェクト: Oman/Maleos
        /// <summary>
        /// 根据名称更新企业信息
        /// </summary>
        /// <param name="company">企业对象</param>
        internal void UpdateCompanyByName(Company company)
        {
            if (company.CompanyName == "")
                return;

            Company databaseCompany = null;
            using (IDataReader reader = DB.Select(DataBases.Company).Where(DataBases.Company.CompanyName == company.CompanyName).ToDataReader())
            {
                if (reader.Read())
                {
                    databaseCompany = ReadRow(reader);
                }
            }

            if (databaseCompany != null)
            {
                databaseCompany.setNewValue(company);
                databaseCompany.SystemService = this.SystemService;
                databaseCompany.SQLtransaction = this.SQLtransaction;
                databaseCompany.Update();
            }
            else
            {
                company.SystemService = this.SystemService;
                company.SQLtransaction = this.SQLtransaction;
                company.Update();
            }
        }
コード例 #3
0
ファイル: CompanyDangerChemicals.cs プロジェクト: Oman/Maleos
        /// <summary>
        /// 危险化学品经营许可表
        /// </summary>
        /// <param name="CompanyID">基本信息表编号</param>
        /// <returns>实体</returns>
        internal CompanyDangerChemicals CompanyDangerChemicalsGetOne(int CompanyID)
        {
            CompanyDangerChemicals Company = new CompanyDangerChemicals();
            SelectSqlSection section = DB.Select(DataBases.CompanyDangerChemicals, DataBases.CompanyDangerChemicals.ID.Count());
            if (CompanyID >=0)
            {
                section.Where(DataBases.CompanyDangerChemicals.CompanyID == CompanyID);
            }

            int count = Convert.ToInt32(section.ToScalar());
            if (count > 0)
            {
                section = DB.Select(DataBases.CompanyDangerChemicals);
                if (CompanyID >= 0)
                {
                    section.Where(DataBases.CompanyDangerChemicals.CompanyID == CompanyID);
                }

                //section.SetSelectRange(pageSize, (pageSize * (page - 1)), DataBases.CompanyDangerChemicals.ID);

                using (IDataReader reader = section.ToDataReader())
                {
                    while (reader.Read())
                    {
                        Company = ReadRow(reader);
                        break;
                    }
                }
                if (Company.CompanyID >= 0)
                {

                    SelectSqlSection sectionCompany = DB.Select(DataBases.Company).Where(DataBases.Company.CompanyID == CompanyID);
                    using (IDataReader readerCompany = sectionCompany.ToDataReader())
                    {
                        while (readerCompany.Read())
                        {
                            Company.Company.CompanyAddress = readerCompany["CompanyAddress"].ToString();
                            Company.Company.CompanyID = Convert.ToInt32(readerCompany["CompanyID"].ToString());
                            Company.Company.CompanyName = readerCompany["CompanyName"].ToString();
                            Company.Company.CompanyPost = readerCompany["CompanyPost"].ToString();
                            Company.Company.JuridicalPerson = readerCompany["JuridicalPerson"].ToString();
                            Company.Company.JuridicalPersonAge = readerCompany["JuridicalPersonAge"].ToString();
                            Company.Company.JuridicalPersonJob = readerCompany["JuridicalPersonJob"].ToString();
                            Company.Company.JuridicalPersonSex = readerCompany["JuridicalPersonSex"].ToString();
                            Company.Company.Mobile = readerCompany["Mobile"].ToString();
                            Company.Company.Tel = readerCompany["Tel"].ToString();
                            Company.Company.IsCity = Convert.ToInt32(readerCompany["IsCity"].ToString());
                            Company.Company.CompanyAreaID = Convert.ToInt32(readerCompany["CompanyAreaID"].ToString());
                        }
                    }
                }
            }

            return Company;
        }
コード例 #4
0
ファイル: frmCompanyImport.cs プロジェクト: Oman/Maleos
        private void buttonOK_Click(object sender, EventArgs e)
        {
            if (Convert.ToInt32(((ComboBoxItemTextValue)(this.comboBox1.SelectedItem)).selectValue) == -1)
            {
                CommonInvoke.MessageBox("请选择类型!");
                return;
            }
            if (Convert.ToInt32(((ComboBoxItemTextValue)(this.comboBox3.SelectedItem)).selectValue) == -1)
            {
                CommonInvoke.MessageBox("请选择区域!");
                return;
            }

            string path = Application.StartupPath + @"\" + this.txtPath.Text.Trim();
            if (!File.Exists(path))
            {
                CommonInvoke.MessageBox("文件不存在,请重新选择!");
                return;
            }

            DataTable dt = ExcelToTable(path);
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                Company Company = new SOA.ORM.Company();

                Company.CompanyName = dt.Rows[j][0].ToString();
                Company.JuridicalPerson = dt.Rows[j][1].ToString();
                Company.JuridicalPersonSex = dt.Rows[j][2].ToString();
                Company.IDCard = dt.Rows[j][3].ToString();
                Company.JuridicalPersonJob = dt.Rows[j][4].ToString();
                Company.Mobile = dt.Rows[j][5].ToString();
                Company.CompanyAddress = dt.Rows[j][6].ToString();
                Company.CompanyPost = dt.Rows[j][7].ToString();
                Company.BusinessMode = dt.Rows[j][8].ToString();
                Company.WarehousAddress = dt.Rows[j][9].ToString();
                Company.PermitRange = dt.Rows[j][10].ToString();
                Company.PermitValid = dt.Rows[j][11].ToString();
                Company.IsCity = 1;
                Company.CompanyType = Convert.ToInt32(((ComboBoxItemTextValue)(this.comboBox1.SelectedItem)).selectValue);
                    Company.CompanyAreaID = Convert.ToInt32(((ComboBoxItemTextValue)(this.comboBox3.SelectedItem)).selectValue);

                EList<Company> CompanyList = InvokeUtil.SystemService.CompanyGetAllByName(Company.CompanyName);
                if (CompanyList.Items.Count <= 0)
                {
                    InvokeUtil.SystemService.EntityUpdate(Company);
                }
            }
            CommonInvoke.MessageBox("操作成功!");
        }
コード例 #5
0
ファイル: ManageServiceXyr.cs プロジェクト: Oman/Maleos
        /// <summary>
        /// 获取公司信息结合
        /// </summary>
        /// <param name="page">分页</param>
        /// <param name="pageSize"></param>
        /// <param name="name">名称</param>
        /// <param name="CompanyType">类型</param>
        /// <param name="CompanyArea">区域</param>
        /// <param name="IsCity">是否市级</param>
        /// <returns></returns>
        public EList<Company> CompanyNewGetAll(int page, int pageSize, string name, int CompanyType, int CompanyArea, int IsCity)
        {
            try
            {
                Company Obj = new Company();
                Obj.SystemService = this;
                return Obj.CompanyNewGetAll(page, pageSize, name, CompanyType, CompanyArea, IsCity);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #6
0
ファイル: ManageServiceXyr.cs プロジェクト: Oman/Maleos
        /// <summary>
        /// 获取公司信息结合
        /// </summary>
        /// <param name="name">名称</param>
        /// <returns></returns>
        public EList<Company> CompanyGetAllByName(string name)
        {
            try
            {
                Company Obj = new Company();
                Obj.SystemService = this;
                return Obj.CompanyGetAllByName(name);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }