public GetProperty GetProperty(string obj_code) { GetProperty getExportData = new GetProperty(); using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); // IDbTransaction transaction = dbConnection.BeginTransaction(); try { string sql = @"select * from V_FLC_OBJECTPROPERTY where obj_code = :obj_code and lan = 'zn_CN' "; var para = new DynamicParameters(); para.Add(":obj_code", obj_code); getExportData.objects = AppDataBase.Query <V_FLC_OBJECTPROPERTY>(sql, para, null, dbConnection); string sql2 = @"select *from flc_objects objs left join flc_lang lan on lan.key=objs.obj_code||'.'||objs.obj_table where obj_code=:obj_code and lan='zn_CN' and is_main=0 "; getExportData.tables = AppDataBase.Query <ObjectsUnionLang>(sql2, para, null, dbConnection); } catch (Exception e) { throw e; } } return(getExportData); }
/// <summary> /// 获取全部菜单权限 /// </summary> /// <param name="role"></param> /// <param name="lan"></param> public GetAllAuthByRole GetAllAuthByRole(string role, string lan) { //尽管role没有用到,考虑客户端调用的时候 传值了,为了减少更改 //所有还是留着了 lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; GetAllAuthByRole getAllAuthByRole = new GetAllAuthByRole(); using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = @"select * from v_FLC_MENU where lan = :lan order by disp_order "; var parm = new DynamicParameters(); parm.Add(":lan", lan); getAllAuthByRole.dtNodes = AppDataBase.Query <V_FLC_MENU>(sql, parm, null, dbConnection); sql = @"select t.*,t1.value from FLC_OBJ_OPERATION t left join FLC_LANG t1 on t.operation_id = t1.key order by obj_code,page,btn_index"; getAllAuthByRole.dtOperation = AppDataBase.Query <FLC_OBJ_OPERATION>(sql, null, null, dbConnection); } catch (Exception e) { throw e; } } return(getAllAuthByRole); }
public IEnumerable <V_FLC_MENU> GetObjectList(string lan) { IEnumerable <V_FLC_MENU> v_FLC_MENUs = null; lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = @"select t1.* from v_FLC_MENU t1 where lan = :lan and is_sys <> 1 and is_enable = 1 and is_show = 1 and is_from_model <> 0 order by disp_order"; var parm = new DynamicParameters(); parm.Add(":lan", lan); v_FLC_MENUs = AppDataBase.Query <V_FLC_MENU>(sql, parm, null, dbConnection); } catch (Exception e) { throw e; } } return(v_FLC_MENUs); }
public GetExportData GetExportData(string objectCode) { GetExportData getExportData = new GetExportData(); using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); // IDbTransaction transaction = dbConnection.BeginTransaction(); try { string sql = @"select * from V_FLC_OBJECTPROPERTY where obj_code = '" + objectCode + @"' and lan = 'zn_CN' order by obj_table ,obj_pro_using desc,obj_pro_null desc "; getExportData.v_FLC_s = AppDataBase.Query <V_FLC_OBJECTPROPERTY>(sql, null, null, dbConnection); string sql2 = @"select *from flc_objects objs left join flc_lang lan on lan.key=objs.obj_code||'.'||objs.obj_table where obj_code='" + objectCode + "' and lan='zn_CN' and is_main=0 "; getExportData.objectsUnions = AppDataBase.Query <ObjectsUnionLang>(sql2, null, null, dbConnection); } catch (Exception e) { throw e; } } return(getExportData); }
public IEnumerable <dynamic> GetProdclineDA(string opseq, string cinvcode) { IEnumerable <dynamic> GetProdclineDA = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = @"select *from Data_PRODCLLIN_Item0 item0 inner join data_PRODCLLIN duc on item0.mid=duc.id inner join data_INVENTORY inv on inv.cinvccode=duc.ccinvcode where item0.opseq='" + opseq + "' and inv.cinvcode='" + cinvcode + @"' and versioncode=(select max(versioncode) from (select *from Data_PRODCLLIN_Item0 item0 inner join data_PRODCLLIN duc on item0.mid=duc.id inner join data_INVENTORY inv on inv.cinvccode=duc.ccinvcode where item0.opseq='" + opseq + "' and inv.cinvcode='" + cinvcode + @"') t )"; GetProdclineDA = AppDataBase.Query <dynamic>(sql, null, null, dbConnection); } catch (Exception e) { throw e; } } return(GetProdclineDA); }
/// <summary> /// 获取权限菜单 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="userCode"></param> /// <returns></returns> public static IEnumerable <MenuRolesModel> GetAuthorizationMenuInfo(string userCode, string roleCode) { string sql = @"Select mr.RoleCode,m.MenuCode,MenuName,MenuIcon,ParentCode,MenuPath,Component,Title,AlwaysShow From Menus m Inner Join MenusRole mr on m.MenuCode = mr.MenuCode Inner Join Users u on u.RoleCode = mr.RoleCode Where mr.RoleCode=@RoleCode And u.UserCode=@UserCode"; var param = new DynamicParameters(); param.Add("@RoleCode", roleCode); param.Add("@UserCode", userCode); IEnumerable <MenuRolesModel> menuRoles = AppDataBase.Query <MenuRolesModel>(sql, param); IEnumerable <MenuRolesModel> menuRolesModels = from x in menuRoles where object.Equals(x.ParentCode, null) select x; foreach (MenuRolesModel item in menuRolesModels) { item.Children = (from x in menuRoles where x.ParentCode == item.MenuCode select x); } return(menuRolesModels); }
public IEnumerable <dynamic> GetObjectDataL() { IEnumerable <dynamic> dynamics = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = @"Select Obj.Id,Obj.Obj_Code,Lng.Key,Lng.Value as Chinese,Flc.Value as English, case Obj.Is_Enable when 1 then '是' when 0 then '否' end Is_Enable, case Obj.Is_System when 1 then '是' when 0 then '否' end Is_System From FLC_OBJECT Obj Left Join FLC_LANG Lng On Lng.Key=Obj.Obj_Code And Lng.lan='zn_CN' Left Join FLC_LANG Flc On Flc.Key=Lng.Key And Flc.lan='en_US' where is_show='1' Order By Obj.Obj_Code Asc"; dynamics = AppDataBase.Query <dynamic>(sql, null, null, dbConnection); } catch (Exception e) { throw e; } } return(dynamics); }
/// <summary> /// 获取权限列表 /// </summary> /// <returns></returns> public static IEnumerable <RoleModel> GetRoles() { string sql = "Select AutoID,RoleCode,RoleName From Roles"; IEnumerable <RoleModel> roleModels = AppDataBase.Query <RoleModel>(sql); return(roleModels); }
public static string CrateObject_Drop(string obj_code) { //删除1.flc_object flc_objects flc_object_property flc_lang对应数据清除 2.对应表清除 string del_obj = "delete from flc_object where obj_code like '" + obj_code + "%'"; string del_objs = "delete from flc_objects where obj_code like '" + obj_code + "%'"; string del_obj_pro = "delete from flc_object_property where obj_code like '" + obj_code + "%'"; string del_lang = "delete from flc_lang where key like '" + obj_code + "%'"; string sql; var param = new DynamicParameters(); using (IDbConnection dbConnection = AppDataBase.DbConection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { sql = "Select * from FLC_OBJECTS where obj_code = :obj_code"; param.Add(":obj_code", obj_code); IEnumerable <Flc_Objects> obj_relations = AppDataBase.Query <Flc_Objects>(sql, param, transaction); foreach (Flc_Objects item in obj_relations) { string[] args = item.Obj_Table.Split('_'); if (!(args[0] == "FLC")) { AppDataBase.Execute(del_obj, null, transaction); AppDataBase.Execute(del_objs, null, transaction); AppDataBase.Execute(del_obj_pro, null, transaction); AppDataBase.Execute(del_lang, null, transaction); string setable = "select count(1) coun from user_tables where table_name=:obj_table"; param = new DynamicParameters(); param.Add(":obj_table", item.Obj_Table); int count = Convert.ToInt32(AppDataBase.ExecuteScalar(setable, dbConnection, param)); if (count > 0) { sql = "drop table " + item.Obj_Table; AppDataBase.Execute(sql, null, transaction); } } } transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } } return("ok"); }
/// <summary> /// 通过用户编码获取菜单 /// </summary> /// <param name="user_code"></param> /// <param name="lan"></param> /// <param name="bAdmin"></param> /// <returns></returns> public IEnumerable <V_FLC_MENU> GetMenuAuthByUser(string user_code, string lan, string bAdmin) { string sql = ""; lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; if (user_code == "admins_group") { bAdmin = "1"; } IEnumerable <V_FLC_MENU> v_FLC_MENUs = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { //查看该用户是否拥有管理员角色 sql = @" select count(1) from DATA_ROLE_USER where user_code='" + user_code + "' and role_code='admins_group'"; string count = AppDataBase.ExecuteScalar(sql, dbConnection, null, transaction).ToString(); if (count != "0") { bAdmin = "1"; } var para = new DynamicParameters(); para.Add(":lan", lan); para.Add(":user_code", user_code); sql = @"select t1.* from FLC_MENU_AUTH t left join v_FLC_MENU t1 on t.menu_id = t1.menucode where lan = :lan and t.role_code in (select role_code from DATA_ROLE_USER where user_code = :user_code) and is_sys = 0 and is_enable = 1 and is_show=1 order by disp_order"; if (bAdmin == "1") { sql = @"select t1.* from v_FLC_MENU t1 where lan = :lan and is_sys = 0 and is_enable = 1 and is_show=1 and is_admin=0 order by disp_order"; } v_FLC_MENUs = AppDataBase.Query <V_FLC_MENU>(sql, para, transaction, dbConnection); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } } return(v_FLC_MENUs); }
public IEnumerable <dynamic> GetAdminRolebyUser(string user_code) { IEnumerable <dynamic> data_role = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = @" select *from DATA_ROLE_USER where user_code='" + user_code + "' and role_code='admins_group'";//查看该用户是否拥有管理员角色 data_role = AppDataBase.Query <dynamic>(sql, null, null, dbConnection); } catch (Exception e) { throw e; } } return(data_role); }
public static Isexist_Obj isexist_Obj(string obj_code, string Language) { try { string is_exit = "select * from flc_object where obj_code='" + obj_code + "'"; object o = AppDataBase.ExecuteScalar(is_exit); if (o == null || o.ToString() == string.Empty) { is_exit = "1"; } else { is_exit = "0"; } string all_object = @"select obj_code,value from flc_object t left join flc_lang e on t.obj_code=e.key and e.lan='" + Language + "'"; List <Allobj> allobjs = AppDataBase.Query <Allobj>(all_object).ToList(); Allobj allobj = new Allobj(); allobj.Obj_Code = obj_code; allobj.Value = "当前对象"; allobjs.Insert(0, allobj); foreach (Allobj item in allobjs) { if (item.Value == "") { item.Value = item.Obj_Code; } } Isexist_Obj isexist_Obj = new Isexist_Obj(); isexist_Obj.is_exit = is_exit; isexist_Obj.allobj = allobjs; return(isexist_Obj); } catch (Exception e) { throw e; } }
public IEnumerable <FLC_MENU_AUTH> GetRoleMenuAuthByRole(string role_code) { IEnumerable <FLC_MENU_AUTH> fLC_MENU_s = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = "select * from FLC_MENU_AUTH where role_code = :role_code"; var parm = new DynamicParameters(); parm.Add(":role_code", role_code); fLC_MENU_s = AppDataBase.Query <FLC_MENU_AUTH>(sql, parm, null, dbConnection); } catch (Exception e) { throw e; } } return(fLC_MENU_s); }
/// <summary> /// 通过角色编码获取菜单 /// </summary> /// <param name="role_code"></param> /// <param name="lan"></param> /// <returns></returns> public IEnumerable <V_FLC_MENU> GetMenuAuthByRole(string role_code, string lan) { string bAdmin = "0"; if (role_code == "admins_group") { bAdmin = "1"; } lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; IEnumerable <V_FLC_MENU> v_FLC_MENUs = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { string sql = @"select t1.* from FLC_MENU_AUTH t left join v_FLC_MENU t1 on t.menu_id = t1.menucode where lan = :lan and t.role_code = :role_code and menugrade = 0 order by disp_order"; if (bAdmin == "1") { sql = @"select t.* from v_FLC_MENU t where lan = :lan order by disp_order "; } var parm = new DynamicParameters(); parm.Add(":lan", lan); parm.Add(":role_code", role_code); v_FLC_MENUs = AppDataBase.Query <V_FLC_MENU>(sql, parm, transaction, dbConnection); } catch (Exception e) { throw e; } } return(v_FLC_MENUs); }
/// <summary> /// 返回能够操作的角色列表 /// </summary> /// <param name="user_code"></param> /// <returns></returns> public IEnumerable <dynamic> GetRoleListByUser(string user_code) { IEnumerable <dynamic> data_role = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); try { string sql = " select * from data_role where role_code!='admins_group' "; var parm = new DynamicParameters(); parm.Add(":user_code", user_code); data_role = AppDataBase.Query <dynamic>(sql, parm, null, dbConnection); } catch (Exception e) { throw e; } } return(data_role); }
public static LoadMenuUnionCompany LoadMenu(string UserCode, string Language) { string sql = @"Select * from V_FLC_MENU where lan = :lan and menucode in (select menu_id from FLC_MENU_AUTH where role_code in (select role_code from DATA_ROLE_USER where user_code = :user_code)) and is_show=1 and is_admin in (0) order by disp_order"; string sqladmins = @"select count(1) from data_role_user where role_code in('admins_group' ,'DATA-MANAGER') and user_code='" + UserCode + "'"; object o = AppDataBase.ExecuteScalar(sqladmins); if (o != null && o.ToString() != "0") { sql = "select * from V_FLC_MENU where lan = :lan and is_show=1 and is_sys <> 1 and is_admin in (0,1) order by disp_order"; } if (System.IO.File.Exists("admin")) { sql = @"select * from V_FLC_MENU where lan = :lan and is_show=1 order by disp_order"; } var param = new DynamicParameters(); param.Add(":user_code", UserCode); param.Add(":lan", Language); IEnumerable <LoadMenu> menuRoles = AppDataBase.Query <LoadMenu>(sql, param); sql = "select id,name from data_company where rownum=1"; Company company = AppDataBase.QuerySingle <Company>(sql); LoadMenuUnionCompany loadMenuUnionCompany = new LoadMenuUnionCompany(); loadMenuUnionCompany.company = company; loadMenuUnionCompany.loadMenu = menuRoles; return(loadMenuUnionCompany); }
/// <summary> /// 按钮列表 /// </summary> /// <param name="user_code"></param> /// <param name="lan"></param> /// <returns></returns> public GetOperationAuthByUser GetOperationAuthByUser(string user_code, string lan) { GetOperationAuthByUser getOperationAuthByUser = new GetOperationAuthByUser(); lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; string bAdmin = "0"; if (user_code == "admin") { bAdmin = "1"; } string sql = string.Empty; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { var parm = new DynamicParameters(); parm.Add(":lan", lan); parm.Add(":user_code", user_code); string sql2 = @" select count(1) from DATA_ROLE_USER where user_code='" + user_code + "' and role_code in('admins_group' ,'DATA-MANAGER')";//查看该用户是否拥有管理员角色 string count = AppDataBase.ExecuteScalar(sql, dbConnection, null, transaction).ToString(); if (count != "0") { bAdmin = "1"; } sql = @"select t.*,t1.value from flc_object t left join FLC_LANG t1 on t.obj_code = t1.key where ((t.is_enable = 1 and t.is_show = 1)or(t.is_model = 0)) and t1.lan = :lan and t.obj_code in (select distinct obj_code from FLC_OPERATION_AUTH df where role_code in ( select ROLE_CODE from DATA_ROLE_USER where USER_CODE= :user_code)) order by t.id "; if (bAdmin == "1") { sql = @"select t1.* from v_FLC_MENU t1 where lan = :lan and is_sys= 0 and is_enable = 1 and is_show = 1 order by disp_order"; } getOperationAuthByUser.objects = AppDataBase.Query <dynamic>(sql, parm, transaction, dbConnection); sql = @"select t.*,t1.value from flc_operation_auth t_m left join FLC_OBJ_OPERATION t on t_m.obj_code = t.obj_code and t_m.page = t.page and t_m.operation_id = t.operation_id left join FLC_LANG t1 on t.operation_id = t1.key where t1.lan = :lan and t_m.role_code in (Select role_code from DATA_ROLE_USER where user_code = :user_code) order by t_m.obj_code,t_m.page,btn_index"; if (bAdmin == "1") { sql = @"select t.*,t1.value from FLC_OBJ_OPERATION t left join FLC_LANG t1 on t.operation_id = t1.key where t1.lan = :lan order by obj_code,page,btn_index"; } getOperationAuthByUser.operation = AppDataBase.Query <FLC_OBJ_OPERATION>(sql, parm, transaction, dbConnection); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } } return(getOperationAuthByUser); }
/// <summary> /// 角色的按钮权限 /// </summary> /// <param name="role_code"></param> /// <param name="lan"></param> /// <returns></returns> public GetOperationAuthByRole GetOperationAuthByRole(string role_code, string lan) { GetOperationAuthByRole getOperationAuthBy = new GetOperationAuthByRole(); lan = string.IsNullOrEmpty(lan) ? "zn_CN" : lan; string bAdmin = "0"; if (role_code == "admins_group") { bAdmin = "1"; } string sql = string.Empty; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { var parm = new DynamicParameters(); parm.Add(":lan", lan); parm.Add(":role_code", role_code); sql = @"select t.*,t1.value from flc_object t left join FLC_LANG t1 on t.obj_code = t1.key where ((t.is_enable = 1 and t.is_show = 1)or(t.is_model = 0)) and t1.lan = :lan and t.obj_code in (select distinct obj_code from FLC_OPERATION_AUTH df where role_code = :role_code) order by t.id "; if (bAdmin == "1") { sql = @"select t.*,t1.value from FLC_OBJECT t left join FLC_LANG t1 on t.obj_code = t1.key where lan = :lan"; } getOperationAuthBy.objects = AppDataBase.Query <FLC_OBJECT>(sql, parm, transaction, dbConnection); sql = @"select t.*,t1.value from flc_operation_auth t_m left join FLC_OBJ_OPERATION t on t_m.obj_code = t.obj_code and t_m.page = t.page and t_m.operation_id = t.operation_id left join FLC_LANG t1 on t.operation_id = t1.key where t1.lan = :lan and t_m.role_code = :role_code order by t_m.obj_code,t_m.page,btn_index"; if (bAdmin == "1") { sql = @"select t.*,t1.value from FLC_OBJ_OPERATION t left join FLC_LANG t1 on t.operation_id = t1.key where t1.lan = :lan order by obj_code,page,btn_index"; } getOperationAuthBy.operation = AppDataBase.Query <FLC_OBJ_OPERATION>(sql, parm, transaction, dbConnection); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } } return(getOperationAuthBy); }
public static GetObj GetObj(string obj_code, string Language) { try { GetObj getObj = new GetObj(); #region 对应UserControl 的编辑对象名 string is_enable = "select is_enable from flc_object where obj_code='{0}'"; string zn_CN1 = "select value from flc_lang where key='{0}' and lan='zn_CN'"; string en_US1 = "select value from flc_lang where key='{0}' and lan='en_US'"; is_enable = AppDataBase.ExecuteScalar(string.Format(is_enable, obj_code)).ToString(); is_enable = (is_enable == "1" ? "是" : "否"); zn_CN1 = AppDataBase.ExecuteScalar(string.Format(zn_CN1, obj_code)).ToString(); en_US1 = AppDataBase.ExecuteScalar(string.Format(en_US1, obj_code)).ToString(); Obj_Name obj_Name = new Obj_Name(); obj_Name.Obj_Code = obj_code; obj_Name.zn_CN = zn_CN1; obj_Name.en_US = en_US1; obj_Name.Is_Enable = is_enable; getObj.obj_name = obj_Name; #endregion #region 对应UserControl 的对象表关系 string getdata_objects = "Select * from FLC_OBJECTS where obj_code = :obj_code"; var param = new DynamicParameters(); param.Add(":obj_code", obj_code); IEnumerable <Flc_Objects> obj_relations = AppDataBase.Query <Flc_Objects>(getdata_objects, param); List <Obj_Relation> obj_Relations = new List <Obj_Relation>(); foreach (Flc_Objects item in obj_relations) { Obj_Relation obj_Relation = new Obj_Relation(); obj_Relation.是否删除 = false; obj_Relation.对象名 = item.Obj_Code; obj_Relation.对象表名 = item.Obj_Table; string code = obj_code + "." + item.Obj_Table; string zn_CN2 = "select value from flc_lang where key='{0}' and lan='zn_CN'"; string en_US2 = "select value from flc_lang where key='{0}' and lan='en_US'"; zn_CN2 = AppDataBase.ExecuteScalar(string.Format(zn_CN2, code)).ToString(); en_US2 = AppDataBase.ExecuteScalar(string.Format(en_US2, code)).ToString(); obj_Relation.中文语言 = zn_CN2; obj_Relation.英文语言 = en_US2; string is_main = item.Is_Main.ToString(); is_main = (is_main == "1" ? "是" : "否"); obj_Relation.是否主表 = is_main; obj_Relations.Add(obj_Relation); } getObj.obj_relation = obj_Relations; #endregion #region 对应UserControl 的对象属性 string getdata_ObjTabProperty = "Select * from FLC_OBJECT_PROPERTY where obj_code = :obj_code"; IEnumerable <Flc_Object_Property> obj_propertys = AppDataBase.Query <Flc_Object_Property>(getdata_ObjTabProperty, param); foreach (Flc_Object_Property item in obj_propertys) { string code = obj_code + "." + item.Obj_Table + "." + item.Obj_Pro_Code.ToString().ToUpper(); string zn_CN2 = "select value from flc_lang where key='{0}' and lan='zn_CN'"; string en_US2 = "select value from flc_lang where key='{0}' and lan='en_US'"; zn_CN2 = AppDataBase.ExecuteScalar(string.Format(zn_CN2, code)).ToString(); en_US2 = AppDataBase.ExecuteScalar(string.Format(en_US2, code)).ToString(); item.Zn_Cn = zn_CN2; item.en_Us = en_US2; item.Is_Del = false; } getObj.obj_property = obj_propertys; #endregion #region 获得所有对象名称 string all_object = @"select obj_code,value from flc_object t left join flc_lang e on t.obj_code=e.key and e.lan='" + Language + "'"; IEnumerable <Allobj> allobjs = AppDataBase.Query <Allobj>(all_object); foreach (Allobj item in allobjs) { if (item.Value == "") { item.Value = item.Obj_Code; } } getObj.allobj = allobjs; #endregion #region 获得所有对象表 string all_objecttab = "select obj_table from flc_objects where obj_code='" + obj_code + "'"; IEnumerable <Allobjtab> allobjtab = AppDataBase.Query <Allobjtab>(all_objecttab); getObj.allobjtab = allobjtab; #endregion return(getObj); } catch (Exception ex) { throw ex; } }
public List <Dictionary <string, IEnumerable <V_FLC_OBJECTPROPERTY> > > GetPropertyByObjCode(string objectCode, string Lan) { if (string.IsNullOrEmpty(Lan)) { Lan = "zn_CN"; } List <Dictionary <string, IEnumerable <V_FLC_OBJECTPROPERTY> > > TableList = null; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); // IDbTransaction transaction = dbConnection.BeginTransaction(); try { //ObjectsUnionLang string sql = @"select t.*,l.value from FLC_Objects t left join FLC_LANG l on Lower(l.key) = Lower(Concat(Concat(t.obj_code,'.'),t.obj_table)) where obj_code = :objectCode and l.lan = :LAN union all select t.*,l.value from FLC_Objects t left join FLC_LANG l on Lower(l.key) = Lower(Concat(Concat(t.obj_code,'.'),t.obj_table)) where obj_code = :objectCode and l.lan is null "; var para = new DynamicParameters(); para.Add(":objectCode", objectCode); para.Add(":LAN", Lan); IEnumerable <ObjectsUnionLang> objectsUnionLangs = AppDataBase.Query <ObjectsUnionLang>(sql, para, null, dbConnection); Dictionary <string, IEnumerable <V_FLC_OBJECTPROPERTY> > keyValues = new Dictionary <string, IEnumerable <V_FLC_OBJECTPROPERTY> >(); foreach (ObjectsUnionLang item in objectsUnionLangs) { IEnumerable <V_FLC_OBJECTPROPERTY> v_FLC_OBJECTPROPERTY = null; sql = @"Select * from v_flc_objectproperty v where lower(v.obj_code)=Lower(:objectCode) and V.LAN=:LAN and lower(v.obj_table) = lower(:objectTable) and v.obj_pro_visible='0' union all Select * from v_flc_objectproperty v where lower(v.obj_code)=Lower(:objectCode) and V.LAN is null and lower(v.obj_table) = lower(:objectTable) and v.obj_pro_visible='0' "; para = new DynamicParameters(); para.Add(":objectCode", objectCode); para.Add(":LAN", Lan); para.Add(":objectTable", item.OBJ_TABLE); v_FLC_OBJECTPROPERTY = AppDataBase.Query <V_FLC_OBJECTPROPERTY>(sql, para, null, dbConnection); if (string.IsNullOrEmpty(item.VALUE)) { item.VALUE = item.OBJ_TABLE; } keyValues.Add(item.VALUE, v_FLC_OBJECTPROPERTY); } TableList.Add(keyValues); } catch (Exception e) { throw e; } } return(TableList); }
public GetDefaultLayout GetDefaultLayout(string objectCode, string Lan) { GetDefaultLayout getDefaultLayout = null; if (string.IsNullOrEmpty(Lan)) { Lan = "zn_CN"; } string sql; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); //IDbTransaction transaction = dbConnection.BeginTransaction(); try { sql = @"select t.*,t1.obj_pro_type,t1.obj_pro_length,t1.obj_pro_digit,t1.obj_pro_enable,t1.obj_pro_using,t1.obj_pro_enum as pro_using ,t.notnull as obj_pro_null ,t1.obj_pro_default,t.OFFER_NUMBER from FLC_OBJ_SHOW_DEFAULT t,FLC_OBJECT_PROPERTY t1 where lower(t.obj_code) = lower(:objectCode) and ((t.obj_pro_object like '%|'|| t1.obj_code and t.obj_pro_table like '%|'||t1.obj_table and t.obj_pro_source like '%.'||t1.obj_pro_code) or (t.obj_pro_object = t1.obj_code and t.obj_pro_table =t1.obj_table and t.obj_pro_source =t1.obj_pro_code) or (t1.obj_pro_type = 6 and t1.obj_code = t.obj_code and t1.obj_table = t.obj_table and t1.obj_pro_code = t.obj_pro_code)) and t.lan = :LAN order by IORDER,layout_y,layout_x"; var para = new DynamicParameters(); para.Add(":objectCode", objectCode); para.Add(":LAN", Lan); IEnumerable <dynamic> LayoutTable = AppDataBase.Query <dynamic>(sql, para, null, dbConnection); getDefaultLayout.LayoutTable = LayoutTable; IEnumerable <dynamic> drs = LayoutTable.Where(x => x.obj_pro_type == 6); if (drs.Count() > 0) { string enumObject = "'-999'"; foreach (DataRow dr in drs) { enumObject += ",'" + dr["pro_using"].ToString().Trim() + "'"; } sql = "Select * from data_enummethon where enum_key in (" + enumObject + ") and lan = :Lan"; para = new DynamicParameters(); para.Add(":Lan", Lan); IEnumerable <dynamic> Enum = AppDataBase.Query <dynamic>(sql, para, null, dbConnection); getDefaultLayout.Enum = Enum; } sql = @" Select rec.obj_code as objectcontrol,rec.iorder, rec.obj_pro_object,rec.obj_pro_name, case when pro.obj_code is null then rec.obj_pro_object else pro.obj_code end as obj_code, case when pro.obj_table is null then rec.obj_pro_table else pro.obj_table end as obj_table, case when pro.obj_pro_code is null then rec.obj_pro_source else pro.obj_pro_code end as obj_pro_code, pro.OBJ_PRO_TYPE,pro.obj_pro_enable,rec.obj_pro_name as obj_name from FLC_LIST_RECORD rec left join v_flc_objectproperty pro on pro.obj_code=rec.obj_pro_object and lan='zn_CN' and pro.obj_pro_code=rec.obj_pro_source where rec.obj_code like :objCode and rec.OBJ_LIST_CODE = :listCode and type='Reference' order by rec.obj_code,rec.iorder "; para = new DynamicParameters(); para.Add(":objCode", objectCode + ".%"); para.Add(":listCode", "test"); IEnumerable <dynamic> dtShow = AppDataBase.Query <dynamic>(sql, para, null, dbConnection); getDefaultLayout.dtShow = dtShow; //transaction.Commit(); } catch (Exception e) { // transaction.Rollback(); throw e; } } return(getDefaultLayout); }
public void GetLayoutByObjectCode(string objectCode, string Lan) { if (string.IsNullOrEmpty(Lan)) { Lan = "zn_CN"; } string sql; var para = new DynamicParameters(); string count = "0"; using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { sql = @"select t.*,t1.obj_pro_type,t1.obj_pro_length,t1.obj_pro_digit,t1.obj_pro_using,t1.obj_pro_enum as pro_using ,t.notnull as obj_pro_null ,t1.obj_pro_default,t.OFFER_NUMBER ,t2.obj_pro_enable,t1.obj_pro_positive from flc_obj_show t,FLC_OBJECT_PROPERTY t1,FLC_OBJECT_PROPERTY t2 where lower(t.obj_code) = lower(:objectCode) and ((t.obj_pro_object like '%|'|| t1.obj_code and t.obj_pro_table like '%|'||t1.obj_table and t.obj_pro_source like '%.'||t1.obj_pro_code) or (t.obj_pro_object = t1.obj_code and t.obj_pro_table =t1.obj_table and t.obj_pro_source =t1.obj_pro_code) or (t1.obj_pro_type = 6 and t1.obj_code = t.obj_code and t1.obj_table = t.obj_table and t1.obj_pro_code = t.obj_pro_code)) and t.lan = :LAN and t.obj_code= t2.obj_code and t.obj_table = t2.obj_table and (t.obj_pro_source like t2.obj_pro_code||'.%' or t.obj_pro_source = t2.obj_pro_code) order by IORDER,layout_y,layout_x"; para.Add(":objectCode", objectCode); para.Add(":LAN", Lan); IEnumerable <dynamic> LayoutTable = AppDataBase.Query <dynamic>(sql, para, transaction, dbConnection); var counst = LayoutTable.Where(x => x.obj_pro_type == 6); if (counst.Count() > 0) { string enumObject = "'-999'"; foreach (var dr in counst) { enumObject += ",'" + dr.pro_using.Trim() + "'"; } sql = "Select * from data_enummethon where enum_key in (" + enumObject + ") and lan = :Lan"; para = new DynamicParameters(); para.Add(":Lan", Lan); IEnumerable <dynamic> Enum = AppDataBase.Query <dynamic>(sql, para, transaction, dbConnection); } sql = @" Select rec.obj_code as objectcontrol,rec.iorder, rec.obj_pro_object,rec.obj_pro_name, case when pro.obj_code is null then rec.obj_pro_object else pro.obj_code end as obj_code, case when pro.obj_table is null then rec.obj_pro_table else pro.obj_table end as obj_table, case when pro.obj_pro_code is null then rec.obj_pro_source else pro.obj_pro_code end as obj_pro_code, pro.OBJ_PRO_TYPE,pro.obj_pro_enable,rec.obj_pro_name as obj_name from FLC_LIST_RECORD rec left join v_flc_objectproperty pro on pro.obj_code=rec.obj_pro_object and lan='zn_CN' and pro.obj_pro_code=rec.obj_pro_source where rec.obj_code like :objCode and rec.OBJ_LIST_CODE = :listCode and type='Reference' order by rec.obj_code,rec.iorder "; para = new DynamicParameters(); para.Add(":objCode", objectCode + ".%"); para.Add(":listCode", "test"); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } } }