public OrganizationsOR selectARowDate(string m_id) { string sql = string.Format("select * from T_SYS_Organizations where Guid='{0}'", m_id); DataTable dt = null; try { dt = db.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; OrganizationsOR m_Orga = new OrganizationsOR(dr); return m_Orga; }
private OrganizationsOR setValue() { OrganizationsOR m_Orga = new OrganizationsOR(); if (Request.QueryString["opType"].ToString() == "alert") m_Orga.Guid = Request.QueryString["GUID"].ToString(); else m_Orga.Guid = Guid.NewGuid().ToString(); m_Orga.ObjName=m_Orga.DisplayName = txtDisplayName.Text;//显示名称 //m_Orga.ObjName = txtObjName.Text;//对象名称(部门内唯一) m_Orga.CustomsCode = txtCustomsCode.Text;//关区代码 m_Orga.ParentGuid = Request.QueryString["parentGUID"].ToString();//父部门的标志ID(注:树结构中第一个节点没有值) m_Orga.RankCode = dpdRankCode.Text;//机构的行政级别信息数据 m_Orga.AllPathName = txtAllPathName.Text;//用户在系统中的全程文字表述(例如:全国海关\海关总署\信息中心\应用开发二处) m_Orga.OrgClass = int.Parse(dplOrgClass.SelectedValue);//部门的一些特殊属性(1总署、2分署、4特派办、8直属、16院校、32隶属海关、64派驻机构)采用掩码实现 m_Orga.OrgType = int.Parse(dplOrgType.SelectedValue);//部门的一些特殊属性(1虚拟机构、2一般部门、4办公室(厅)、8综合处)采用掩码实现 m_Orga.Status = 1;// int.Parse(txtStatus.Text);//状态(1、正常使用;2、直接逻辑删除;4、机构级联逻辑删除;8、人员级联逻辑删除;)掩码方式实现 m_Orga.Description = txtDescription.Text;//附加说明信息 //m_Orga.CreateTime = DateTime.Now;//创建时间 //m_Orga.ModifyTime = DateTime.Now;//最近修改时间 return m_Orga; }
public void UpdateOrganizations(OrganizationsOR obj, string m_ID) { /* var v = from f in db.T_SYS_Organizations where f.GUID == m_ID select f; if (v.Count() == 0) throw new Exception("�����ڣ�"); T_SYS_Organizations objNew = v.Single(); objNew.DISPLAY_NAME = obj.DISPLAY_NAME; //��ʾ���� objNew.OBJ_NAME = obj.OBJ_NAME; //�������ƣ�������Ψһ�� objNew.RANK_CODE = obj.RANK_CODE; //����������������Ϣ���� objNew.ALL_PATH_NAME = obj.ALL_PATH_NAME; //�û���ϵͳ�е�ȫ�����ֱ��������磺ȫ������\��������\��Ϣ����\Ӧ�ÿ��������� objNew.ORG_CLASS = obj.ORG_CLASS; //���ŵ�һЩ�������ԣ�1����2����4���ɰ졢8ֱ���16ԺУ��32������ء�64��פ��������������ʵ�� objNew.ORG_TYPE = obj.ORG_TYPE; //���ŵ�һЩ�������ԣ�1���������2һ�㲿�š�4�칫�ң�������8�ۺϴ�����������ʵ�� objNew.CUSTOMS_CODE = obj.CUSTOMS_CODE; //�������� objNew.DESCRIPTION = obj.DESCRIPTION; //����˵����Ϣ objNew.MODIFY_TIME = DateTime.Now; //�����ʱ�� db.SubmitChanges(); * */ }
public bool updateOrg(OrganizationsOR T_SY, string m_id) { string sql = string.Format(@" update T_SYS_Organizations set DISPLAY_NAME='{0}',OBJ_NAME='{1}',RANK_CODE='{2}',ALL_PATH_NAME='{3}',ORG_CLASS={4},ORG_TYPE={5},CHILDREN_COUNTER={6},STATUS={7},CUSTOMS_CODE='{8}',DESCRIPTION='{9}',MODIFY_TIME=getDate() where GUID='{10}'" , T_SY.DisplayName, T_SY.ObjName,T_SY.RankCode, T_SY.AllPathName, T_SY.OrgClass, T_SY.OrgType, T_SY.ChildrenCounter, T_SY.Status, T_SY.CustomsCode, T_SY.Description,m_id); try { db.ExecuteNoQuery(sql); } catch (Exception ex) { throw ex; } return true; }
public void InsertOrganizations(OrganizationsOR obj) { OrganizationsOR orgparent = selectSingleOrganization(obj.ParentGuid); DataTable dtOrg = GetOrgByParentID(obj.ParentGuid); int counter = (dtOrg == null ? 0 : dtOrg.Rows.Count); bool sortIsExis = true; while (sortIsExis) { obj.InnerSort = getOrgSort(++counter);//�����ڲ������ sortIsExis = OrgSortIsExis(obj.InnerSort, obj.ParentGuid); } obj.OriginalSort = orgparent.OriginalSort + obj.InnerSort;//��ϵͳ�е�ȫ��ַ����������������־���ڲ��ŵ�·����ϵ�� obj.GlobalSort = obj.OriginalSort;//�û��ڲ����е�ȫ��ַ������ȫ�������� obj.ChildrenCounter = counter++;//��¼�����ڲ�ʹ�õ�����ֵ����¼ֵΪ��һ����ʹ��ֵ����0��ʼ�� insertOrg(obj); }
/// <summary> /// ����T_SYS_Organizations /// </summary> public bool insertOrg(OrganizationsOR T_SY) { string sql = string.Format(@" insert into T_SYS_Organizations (GUID,DISPLAY_NAME,OBJ_NAME,PARENT_GUID,RANK_CODE,INNER_SORT,ORIGINAL_SORT,GLOBAL_SORT,ALL_PATH_NAME,ORG_CLASS,ORG_TYPE,CHILDREN_COUNTER,STATUS,CUSTOMS_CODE,DESCRIPTION,CREATE_TIME,MODIFY_TIME) values(newid(),'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}',((0)),((1)),'{10}','{11}',(getdate()),(getdate()))" , T_SY.DisplayName, T_SY.ObjName, T_SY.ParentGuid, T_SY.RankCode,T_SY.InnerSort,T_SY.OriginalSort, T_SY.GlobalSort,T_SY.AllPathName,T_SY.OrgClass,T_SY.OrgType, T_SY.CustomsCode, T_SY.Description); try { db.ExecuteNoQuery(sql); } catch (Exception ex) { throw ex; } return true; }