public object GetOrganization(string userid) { IDbTransaction tran = Utility.Database.BeginDbTransaction(); try { string sql = @"select * from B_OA_Organization"; DataSet ds = Utility.Database.ExcuteDataSet(sql, tran); DataTable dataTable = ds.Tables[0]; string jsonData = JsonConvert.SerializeObject(dataTable); List<B_OA_Organization> list_Organization = (List<B_OA_Organization>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_OA_Organization>)); Utility.Database.Commit(tran); B_OA_Organization organization = new B_OA_Organization(); return new { list_Organization = list_Organization, organization = organization }; } catch (Exception ex) { ComBase.Logger(ex); return Utility.JsonResult(false, ex.Message); } }
public object GetOrganization(string userid) { IDbTransaction tran = Utility.Database.BeginDbTransaction(); try { string sql = @" select id,pId,randId,fullName as name,fullName from B_OA_Organization union select '0' as id ,'1' as parentId ,-1 as randId,'全部组织' as name ,'全部组织' as fullName"; DataSet ds = Utility.Database.ExcuteDataSet(sql, tran); DataTable list_Organization = ds.Tables[0]; B_OA_Organization organization = new B_OA_Organization(); Utility.Database.Commit(tran); return new { list_Organization = list_Organization, organization = organization }; } catch (Exception ex) { Utility.Database.Rollback(tran); ComBase.Logger(ex); throw (new Exception("加载数据失败!", ex)); } }
public object GetOrganization(string userid) { IDbTransaction tran = Utility.Database.BeginDbTransaction(); try { string sql = @" select id,pId,randId,fullName as name,fullName from B_OA_Organization union select '0' as id ,'1' as parentId ,-1 as randId,'全部组织' as name ,'全部组织' as fullName"; DataSet ds = Utility.Database.ExcuteDataSet(sql, tran); DataTable list_Organization = ds.Tables[0]; B_OA_Organization organization = new B_OA_Organization(); return new { list_Organization = list_Organization, organization = organization }; } catch (Exception ex) { ComBase.Logger(ex); return Utility.JsonMsg(false, ex.Message); } }
public object DeleteData(string id) { IDbTransaction tran = Utility.Database.BeginDbTransaction(); try { B_OA_Organization org = new B_OA_Organization(); org.Condition.Add("id =" + id); Utility.Database.Delete(org, tran); Utility.Database.Commit(tran); return new { }; } catch (Exception ex) { ComBase.Logger(ex); throw (new Exception("保存数据失败!", ex)); } }