Exemplo n.º 1
0
        public List<BussinessRoleOR> selectAllRole()
        {
            string sql = "select * from t_BussinessRole";

            DataTable dt = null;
            try
            {
                dt = dbMySql.ExecuteQuery(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            if (dt == null)
            {
                return null;
            }
            List<BussinessRoleOR> listBuss = new List<BussinessRoleOR>();
            foreach (DataRow dr in dt.Rows)
            {
                BussinessRoleOR obj = new BussinessRoleOR(dr);
                listBuss.Add(obj);
            }
            return listBuss;
        }
Exemplo n.º 2
0
        public List<BussinessRoleOR> selectBussinessRoleData(string orgbhWhere)
        {
            if (string.IsNullOrEmpty(orgbhWhere))
                return null;

            string sql = @"select bu.* from t_BussinessRole bu
            inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere;
            DataTable dt = null;
            try
            {
                dt = dbMsSql.ExecuteQuery(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            if (dt == null)
                return null;
            List<BussinessRoleOR> listBuss = new List<BussinessRoleOR>();
            foreach (DataRow dr in dt.Rows)
            {
                BussinessRoleOR obj = new BussinessRoleOR(dr);
                listBuss.Add(obj);
            }
            return listBuss;
        }
Exemplo n.º 3
0
        /// <summary>
        /// 获取插入数据
        /// </summary>
        public string GetInsertSql(BussinessRoleOR bussinessRole)
        {
            string sql = @"insert into t_BussinessRole (Id,Name,Description,OrgBH)
            values ('@Id','@Name','@Description','@OrgBH')";
            sql = sql.Replace("@Id", bussinessRole.Id);	//
            sql = sql.Replace("@Name", bussinessRole.Name);	//业务角色名称
            sql = sql.Replace("@Description", bussinessRole.Description);	//描述
            sql = sql.Replace("@OrgBH", bussinessRole.Orgbh);	//

            return sql;
        }