/// <summary> /// 选出所有城市 /// </summary> /// <param name="totalCount"></param> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="obType"></param> /// <param name="filter"></param> /// <returns></returns> public DataTable GetCityList(out int totalCount, int pageSize, int pageIndex, Common.OrderByType obType, BusinessFilter filter) { Common commonRule = new Common(); BusinessFilter flt = new BusinessFilter("Dictionary"); flt.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); flt.AddFilterItem("Type", ((int)SystemManage.DictionaryType.Region).ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); flt.AddFilterItem("Level", SystemManage.Level.City, Operation.Equal, FilterType.NumberType, AndOr.AND); flt.AddFilter(filter, AndOr.AND); // Add Data Permission // flt.AddFilter(GetAuthorizedCityFilter(GlobalFacade.SystemContext.GetContext().UserID), AndOr.AND); BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary"); boc.SessionInstance = new Session(); boc.AddFilter(flt); DataSet ds = boc.GetPagedRecords(pageIndex, pageSize, "PKID", (obType == Common.OrderByType.ASC) ? true : false); totalCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); return(ds.Tables[1]); }
private void SaveElement(XmlDocument doc, XmlElement Parent, DataTable childtable) { for (int i = 0; i < childtable.Rows.Count; i++) { int childpkid; string ChsName; string URL; childpkid = (int)childtable.Rows[i]["PKID"]; ChsName = (string)childtable.Rows[i]["ChineseName"]; if (childtable.Rows[i]["URL"] != null || childtable.Rows[i]["URL"].ToString() != "") { URL = childtable.Rows[i]["URL"].ToString(); } else { URL = ""; } RoleMenu checkmenu = new RoleMenu(); checkmenu.SessionInstance = session; BusinessFilter checkfilter = new BusinessFilter("RoleMenu"); checkfilter.AddFilterItem("FK_Menu", childpkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); checkfilter.AddFilterItem("FK_Role", this.rolepkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); checkfilter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); checkmenu.AddFilter(checkfilter); checkmenu.Load(); if (checkmenu.HaveRecord) { System.Xml.XmlElement child = GlobalFacade.XDom.CreateDocumentElement(doc, "TREENODE"); GlobalFacade.XDom.SetNodeAttribute(doc, child, "TEXT", ChsName); GlobalFacade.XDom.SetNodeAttribute(doc, child, "NODEDATA", childpkid.ToString()); GlobalFacade.XDom.SetNodeAttribute(doc, child, "EXPANDED", "false"); GlobalFacade.XDom.SetNodeAttribute(doc, child, "TARGET", "main"); GlobalFacade.XDom.SetNodeAttribute(doc, child, "NAVIGATEURL", URL); Parent.AppendChild(child); System.Data.DataTable subchildTable; BusinessObjectCollection subchild = new BusinessObjectCollection("Menu"); subchild.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Menu"); filter.AddFilterItem("Parent", childpkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); subchild.AddFilter(filter); /* Andy Modify 2007-04-26 Add Order By */ subchild.Businessobject.OrderBy = "ORDER BY [DisplayOrder] ASC"; subchildTable = subchild.GetDataTable(); if (subchildTable.Rows.Count > 0) { SaveElement(doc, child, subchildTable); } } } }
public bool IsFieldExclusiveM(string fieldName, string fieldValue, string ObjectName, bool stringField, int objectPKID) { BusinessFilter filter = new BusinessFilter(ObjectName); filter.AddFilterItem("PKID", objectPKID.ToString(), Operation.NotEqual, FilterType.NumberType, AndOr.AND); filter.AddFilterItem(fieldName, fieldValue, Operation.Equal, stringField ? FilterType.StringType : FilterType.NumberType, AndOr.AND); BusinessObjectCollection boc = new BusinessObjectCollection(ObjectName); boc.SessionInstance = new Wicresoft.Session.Session(); boc.AddFilter(filter); boc.Query(); return((boc.Count > 0) ? false : true); }
public string GetRoot() { BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Type", ((int)SystemManage.DictionaryType.Region).ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Parent", SystemManage.Level.Top, Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.Dictionary rootregion = new BusinessMapping.Dictionary(); rootregion.AddFilter(filter); rootregion.SessionInstance = new Session(); rootregion.Load(); return((rootregion.HaveRecord) ? rootregion.PKID.Value.ToString() : SystemManage.Level.Top); }
public bool IsRegionExclusive(string fieldName, string fieldValue, bool stringField, int FK_Dictionary) { BusinessFilter filter = new BusinessFilter("Dictionary_RegionDetail"); filter.AddFilterItem("FK_Dictionary", FK_Dictionary.ToString(), Operation.NotEqual, FilterType.NumberType, AndOr.AND); filter.AddFilterItem(fieldName, fieldValue, Operation.Equal, stringField ? FilterType.StringType : FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary_RegionDetail"); boc.SessionInstance = new Wicresoft.Session.Session(); boc.AddFilter(filter); boc.Query(); return((boc.Count > 0) ? false : true); }
public void Update() { BusinessMapping.Role bo = new BusinessMapping.Role(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("Role"); filter.AddFilterItem("PKID", this.PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { bo.RoleCode.Value = this.tbxRoleCode.Text.Trim(); bo.RoleName.Value = this.tbxRoleName.Text.Trim(); bo.Memo.Value = this.tbxMemo.Text.Trim(); bo.ModifyTime.Value = DateTime.Now; bo.ModifyUser.Value = GlobalFacade.SystemContext.GetContext().UserID; bo.Update(); //BusinessRule.SystemManage.OperationLog rule = new BusinessRule.SystemManage.OperationLog(); //rule.WriteOperationLog("用户组管理", "编辑用户组"); } }
public void LoadBaseInfo(int pkid) { BusinessMapping.CWInfo bo = new BusinessMapping.CWInfo(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("CWInfo"); filter.AddFilterItem("PKID", pkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { txtVillageName.Text = bo.VillageName.Value; txtLocation.Text = bo.Location.Value; if (bo.District.Value > 0) { ddlDistrict.SelectedValue = bo.District.Value.ToString(); } if (bo.TotalPeps.Value > 0) { txtTotalPeps.Text = bo.TotalPeps.Value.ToString(); } if (bo.IndusValue.Value > 0) { txtIndusValue.Text = bo.IndusValue.Value.ToString(); } txtVillageChief.Text = bo.VillageChief.Value; txtMemo.Text = bo.Memo.Value; } }
private void GenerateElement(Microsoft.Web.UI.WebControls.TreeNode Parent, DataTable childtable) { for (int i = 0; i < childtable.Rows.Count; i++) { int childpkid; string Name; string path; childpkid = (int)childtable.Rows[i]["PKID"]; Name = childtable.Rows[i]["Name"].ToString(); path = childtable.Rows[i]["path"].ToString(); Microsoft.Web.UI.WebControls.TreeNode node = new TreeNode(); node.NodeData = childpkid.ToString(); node.Text = Name; node.ID = path; Parent.Nodes.Add(node); System.Data.DataTable subchildTable; BusinessObjectCollection subchild = new BusinessObjectCollection("Dictionary"); subchild.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Parent", childpkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND); // if (type == DictionaryType.Region) // { // filter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else if (type == DictionaryType.Product) // { // filter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else // { // filter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND); // } filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); subchild.AddFilter(filter); subchildTable = subchild.GetDataTable(); if (subchildTable.Rows.Count > 0) { GenerateElement(node, subchildTable); } } }
private void validatorOldPwd_ServerValidate(object source, ServerValidateEventArgs args) { string Alias = GlobalFacade.SystemContext.GetContext().Alias.ToString(); BusinessFilter filter = new BusinessFilter("User"); filter.AddFilterItem("Alias", Alias, Operation.Equal, FilterType.StringType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsActive", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.User bo = new BusinessMapping.User(); bo.SessionInstance = new Wicresoft.Session.Session(); bo.AddFilter(filter); bo.Load(); args.IsValid = GlobalFacade.EncryptionManager.VerifyPassword(this.tbxOldPassword.Text.Trim(), bo.Password.Value); this.validatorOldPwd.ErrorMessage = "旧密码输入错误"; }
public static void DictionaryList(System.Web.UI.WebControls.DropDownList DropOnDictionary, string type) { BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary"); boc.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", type, Operation.Equal, FilterType.NumberType, AndOr.AND); boc.AddFilter(filter); DropOnDictionary.DataSource = boc.GetDataTable(); DropOnDictionary.DataTextField = "Name"; DropOnDictionary.DataValueField = "PKID"; DropOnDictionary.DataBind(); DropOnDictionary.Items.Insert(0, new ListItem(ResourceManager.Instance.GetString("PleaseSelect"), "0")); }
private void BindForeignKeyData() { BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary"); boc.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", GlobalFacade.DictionaryType.Type_1.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); boc.AddFilter(filter); ddlDistrict.DataSource = boc.GetDataTable(); ddlDistrict.DataTextField = "Name"; ddlDistrict.DataValueField = "PKID"; ddlDistrict.DataBind(); ddlDistrict.Items.Insert(0, new ListItem(ResourceManager.Instance.GetString("PleaseSelect"), "0")); }
public void GenerateMenuTreeXML() { XmlElement root; XmlDocument doc = GlobalFacade.XDom.GenXmlDocument("TREENODES", out root); BusinessObjectCollection MenuCollection = new BusinessObjectCollection("Menu"); MenuCollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Menu"); filter.AddFilterItem("Parent", "0", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); MenuCollection.AddFilter(filter); /* Andy Modify 2007-04-26 Add Order By */ MenuCollection.Businessobject.OrderBy = "ORDER BY [DisplayOrder] ASC"; DataTable childtable = MenuCollection.GetDataTable(); GenerateElement(doc, root, childtable); outxml = doc.OuterXml; }
public string GetMenuXML() { XmlElement root; XmlDocument doc = GlobalFacade.XDom.GenXmlDocument("TREENODES", out root); BusinessObjectCollection MenuCollection = new BusinessObjectCollection("Menu"); MenuCollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Menu"); filter.AddFilterItem("Parent", "0", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); MenuCollection.AddFilter(filter); MenuCollection.Businessobject.OrderBy = "ORDER BY [DisplayOrder] ASC"; DataTable childtable = MenuCollection.GetDataTable(); SaveElement(doc, root, childtable); return(doc.OuterXml); }
private void DeleteNode(int Dictionary_PKID, Wicresoft.Session.Session session) { // Delete the entry in Dictionary BusinessMapping.Dictionary owner = new BusinessMapping.Dictionary(); owner.SessionInstance = session; owner.PKID.Value = Dictionary_PKID; owner.IsValid.Value = false; owner.Update(); // Delete the entry in Dictionary_RegionDetail BusinessObjectCollection region = new BusinessObjectCollection("Dictionary_RegionDetail"); region.SessionInstance = session; BusinessFilter regiondeletefilter = new BusinessFilter("Dictionary_RegionDetail"); regiondeletefilter.AddFilterItem("FK_Dictionary", Dictionary_PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); region.AddFilter(regiondeletefilter); ((BusinessMapping.Dictionary_RegionDetail)region.Businessobject).IsValid.Value = false; region.UpdateFilter(); // Delete any child entries BusinessObjectCollection child = new BusinessObjectCollection("Dictionary"); child.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Parent", Dictionary_PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", ((int)SystemManage.DictionaryType.Region).ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); child.AddFilter(filter); DataTable childtable = child.GetDataTable(); for (int i = 0; i < childtable.Rows.Count; i++) { DeleteNode(int.Parse(childtable.Rows[i]["PKID"].ToString()), session); } }
public void GenerateRegionTreeXML() { XmlElement root; XmlDocument doc = GlobalFacade.XDom.GenXmlDocument("TREENODES", out root); BusinessObjectCollection RegionCollection = new BusinessObjectCollection("Dictionary"); RegionCollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Parent", "0", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", Convert.ToString((int)DictionaryType.Region), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); RegionCollection.AddFilter(filter); DataTable childtable = RegionCollection.GetDataTable(); GenerateRegionElement(doc, root, childtable); this.outregionxml = doc.OuterXml; }
private void GenerateRegionElement(XmlDocument doc, XmlElement Parent, DataTable childtable) { for (int i = 0; i < childtable.Rows.Count; i++) { int childpkid; string Name; childpkid = (int)childtable.Rows[i]["PKID"]; Name = (string)childtable.Rows[i]["Name"]; System.Xml.XmlElement child = GlobalFacade.XDom.CreateDocumentElement(doc, "TREENODE"); RoleDataPermission HaveRegion = new RoleDataPermission(); HaveRegion.SessionInstance = session; BusinessFilter checkfilter = new BusinessFilter("RoleDataPermission"); checkfilter.AddFilterItem("Type", Convert.ToString((int)DictionaryType.Region), Operation.Equal, FilterType.NumberType, AndOr.AND); checkfilter.AddFilterItem("FK_Role", this.RolePKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); checkfilter.AddFilterItem("FK_Dictionary", childpkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); HaveRegion.AddFilter(checkfilter); HaveRegion.Load(); if (HaveRegion.HaveRecord) { GlobalFacade.XDom.SetNodeAttribute(doc, child, "checked", "True"); } GlobalFacade.XDom.SetNodeAttribute(doc, child, "checkBox", "True"); GlobalFacade.XDom.SetNodeAttribute(doc, child, "Expanded", "True"); GlobalFacade.XDom.SetNodeAttribute(doc, child, "Text", Name); GlobalFacade.XDom.SetNodeAttribute(doc, child, "NodeData", childpkid.ToString()); Parent.AppendChild(child); System.Data.DataTable subchildTable; BusinessObjectCollection subchild = new BusinessObjectCollection("Dictionary"); subchild.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Parent", childpkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", Convert.ToString((int)DictionaryType.Region), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); subchild.AddFilter(filter); subchildTable = subchild.GetDataTable(); if (subchildTable.Rows.Count > 0) { GenerateRegionElement(doc, child, subchildTable); } } }
public DataTable GetRegionList(out int totalCount, int pageSize, int pageIndex, Common.OrderByType obType, BusinessFilter subfilter, string Parent) { Wicresoft.Session.Session session = new Wicresoft.Session.Session(); BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary"); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", ((int)SystemManage.DictionaryType.Region).ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); if (Parent == SystemManage.Level.Top) { BusinessMapping.Dictionary TopParent = new BusinessMapping.Dictionary(); TopParent.SessionInstance = session; BusinessFilter searchparent = new BusinessFilter("Dictionary"); searchparent.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); searchparent.AddFilterItem("Type", ((int)SystemManage.DictionaryType.Region).ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); searchparent.AddFilterItem("Parent", SystemManage.Level.Top, Operation.Equal, FilterType.NumberType, AndOr.AND); TopParent.AddFilter(searchparent); TopParent.Load(); if (TopParent.HaveRecord) { Parent = TopParent.PKID.Value.ToString(); } } if (!(Parent == null || Parent.Equals(string.Empty))) { filter.AddFilterItem("Parent", Parent.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); } if (subfilter != null) { filter.AddFilter(subfilter, AndOr.AND); } boc.SessionInstance = session; boc.AddFilter(filter); DataSet ds = boc.GetPagedRecords(pageIndex, pageSize, "PKID", (obType == Common.OrderByType.ASC) ? true : false); totalCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); return(ds.Tables[1]); }
/// <summary> /// 获取城市名称 /// </summary> /// <param name="pkid">城市PKID</param> /// <returns></returns> public string GetDictionaryName(string pkid) { string name = string.Empty; BusinessMapping.Dictionary bo = new BusinessMapping.Dictionary(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("PKID", pkid, Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { name = bo.Name.Value; } return(name); }
private void Initialize() { bo.SessionInstance = new Wicresoft.Session.Session(); filter = new BusinessFilter("User"); filter.AddFilterItem("PKID", userid, Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { this.Info.Text = "您正在修改" + bo.ChineseName.Value.ToString() + "[" + bo.Alias.Value.ToString() + "]的个人信息<br/><br/>"; } }
public string GetRoleName(string roleID) { string rolename = string.Empty; Wicresoft.Session.Session session = new Wicresoft.Session.Session(); BusinessMapping.Role bo = new BusinessMapping.Role(); bo.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Role"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("PKID", roleID, Operation.Equal, FilterType.StringType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { rolename = bo.RoleName.Value; } return(rolename); }
/* 根据名称获取用户组ID */ public int GetRoleID(string rolename) { int roleid = -1; Wicresoft.Session.Session session = new Wicresoft.Session.Session(); BusinessMapping.Role bo = new BusinessMapping.Role(); bo.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Role"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("RoleName", rolename, Operation.Equal, FilterType.StringType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { roleid = bo.PKID.Value; } return(roleid); }
public string GetEntryLevelById(string entryId) { BusinessFilter flt = new BusinessFilter("Dictionary"); flt.AddFilterItem("PKID", entryId, Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.Dictionary bo = new BusinessMapping.Dictionary(); bo.SessionInstance = session; bo.AddFilter(flt); bo.Load(); return((bo.HaveRecord)?bo.Level.Value.ToString():string.Empty); }
public void LoadBaseInfo(int pkid) { BusinessMapping.CWBirthInfo bo = new BusinessMapping.CWBirthInfo(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("CWBirthInfo"); filter.AddFilterItem("PKID", pkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { if (bo.FK_CWID.Value > 0) { this.gpCWInfo.SelectedValue = bo.FK_CWID.Value.ToString(); } this.txtChildName.Text = bo.ChildName.Value; if (bo.Sex.Value > 0) { this.ddlSex.SelectedValue = bo.Sex.Value.ToString(); } if (bo.BirthDate.Value != DateTime.MinValue) { this.txtBirthDate.Text = bo.BirthDate.Value.ToString("yyyy-MM-dd"); } this.txtBirthNo.Text = bo.BirthNo.Value; if (bo.IsPlan.Value > 0) { this.ddlIsPlan.SelectedValue = bo.IsPlan.Value.ToString(); } if (bo.ExpectDate.Value != DateTime.MinValue) { this.txtExpectDate.Text = bo.ExpectDate.Value.ToString("yyyy-MM-dd"); } this.txtChildAddress.Text = bo.ChildAddress.Value; this.txtHolderName.Text = bo.HolderName.Value; this.txtHolderIDCardNo.Text = bo.HolderIDCardNo.Value; this.txtFathName.Text = bo.FathName.Value; this.txtFathIDCardNo.Text = bo.FathIDCardNo.Value; this.txtFathAddress.Text = bo.FathAddress.Value; this.txtFathLinkPhone.Text = bo.FathLinkPhone.Value; this.txtMothName.Text = bo.MothName.Value; this.txtMothIDCardNo.Text = bo.MothIDCardNo.Value; this.txtMothAddress.Text = bo.MothAddress.Value; this.txtMothLinkPhone.Text = bo.MothLinkPhone.Value; this.txtMemo.Text = bo.Memo.Value; } }
private void GetCurrentUser() { string id = System.Web.HttpContext.Current.User.Identity.Name; BusinessFilter filter = new BusinessFilter("User"); filter.AddFilterItem("Alias", id, Operation.Equal, FilterType.StringType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.User bo = new BusinessMapping.User(); bo.SessionInstance = new Wicresoft.Session.Session(); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { this.currentUser = bo; } else { throw new Exception("无法取得当前用户信息!"); } }
public void SaveRegionConfig(string[] name, int rolepkid) { Session session = new Session(); try { session.BeginTransaction(); BusinessObjectCollection regioncollection = new BusinessObjectCollection("RoleDataPermission"); regioncollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("RoleDataPermission"); filter.AddFilterItem("FK_Role", rolepkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", Convert.ToString((int)DictionaryType.Region), Operation.Equal, FilterType.NumberType, AndOr.AND); regioncollection.AddFilter(filter); regioncollection.DeleteFilter(); for (int index = 0; index < name.Length; index++) { BusinessMapping.RoleDataPermission regionright = new RoleDataPermission(); regionright.SessionInstance = session; regionright.FK_Role.Value = rolepkid; regionright.Type.Value = 1; regionright.FK_Dictionary.Value = int.Parse(name[index].ToString()); regionright.CreateUser.Value = SystemContext.GetContext().UserID; regionright.ModifyUser.Value = SystemContext.GetContext().UserID; regionright.CreateTime.Value = regionright.ModifyTime.Value = DateTime.Now; regionright.Insert(); } session.Commit(); OperationLog opLog = new OperationLog(); opLog.WriteOperationLog("数据权限管理", "配置数据权限"); } catch { session.Rollback(); } }
public void SaveConfig(string[] name, int rolepkid) { Session session = new Session(); try { session.BeginTransaction(); BusinessObjectCollection rolemenucollection = new BusinessObjectCollection("RoleMenu"); rolemenucollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("RoleMenu"); filter.AddFilterItem("FK_Role", rolepkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); rolemenucollection.AddFilter(filter); rolemenucollection.DeleteFilter(); for (int index = 0; index < name.Length; index++) { RoleMenu rolemenu = new RoleMenu(); rolemenu.SessionInstance = session; rolemenu.FK_Menu.Value = int.Parse(name[index].ToString()); rolemenu.FK_Role.Value = rolepkid; rolemenu.CreateUser.Value = GlobalFacade.SystemContext.GetContext().UserID; rolemenu.ModifyUser.Value = GlobalFacade.SystemContext.GetContext().UserID; rolemenu.CreateTime.Value = DateTime.Now; rolemenu.ModifyTime.Value = DateTime.Now; rolemenu.IsValid.Value = true; rolemenu.Insert(); } session.Commit(); BusinessRule.SystemManage.OperationLog opLog = new BusinessRule.SystemManage.OperationLog(); opLog.WriteOperationLog("界面权限管理", "配置界面权限"); } catch { session.Rollback(); } }
public void LoadBaseInfo(int pkid) { BusinessMapping.CWNewMarrige bo = new BusinessMapping.CWNewMarrige(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("CWNewMarrige"); filter.AddFilterItem("PKID", pkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { if (bo.FK_CWID.Value > 0) { this.gpCWInfo.SelectedValue = bo.FK_CWID.Value.ToString(); } this.txtMaleIDCardNo.Text = bo.MaleIDCardNo.Value; this.txtMaleName.Text = bo.MaleName.Value; this.txtMaleAddress.Text = bo.MaleAddress.Value; this.txtMaleLinkPhone.Text = bo.MaleLinkPhone.Value; this.txtFemaleIDCardNo.Text = bo.FemaleIDCardNo.Value; this.txtFemaleName.Text = bo.FemaleName.Value; this.txtFemaleAddress.Text = bo.FemaleAddress.Value; this.txtFemaleLinkPhone.Text = bo.FemaleLinkPhone.Value; if (bo.MarrigeDate.Value != DateTime.MinValue) { this.txtMarrigeDate.Text = bo.MarrigeDate.Value.ToString("yyyy-MM-dd"); } if (bo.IsPregnant.Value > 0) { this.ddlIsPregnant.SelectedValue = bo.IsPregnant.Value.ToString(); } if (bo.ExpectDate.Value != DateTime.MinValue) { this.txtExpectDate.Text = bo.ExpectDate.Value.ToString("yyyy-MM-dd"); } if (bo.VillageDate.Value != DateTime.MinValue) { this.txtVillageDate.Text = bo.VillageDate.Value.ToString("yyyy-MM-dd"); } this.txtMarrigeNo.Text = bo.MarrigeNo.Value; this.txtMemo.Text = bo.Memo.Value; } }
/// <summary> /// Process User Login Flow /// </summary> /// <param name="userid"></param> /// <param name="password"></param> /// <returns></returns> public bool ProcessLogin(string userid, string password) { BusinessFilter filter = new BusinessFilter("User"); filter.AddFilterItem("Alias", userid, Operation.Equal, FilterType.StringType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsActive", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.User bo = new BusinessMapping.User(); bo.SessionInstance = new Wicresoft.Session.Session(); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord && GlobalFacade.EncryptionManager.VerifyPassword(password, bo.Password.Value)) { GlobalFacade.SystemContext context = GlobalFacade.SystemContext.GetContext(); context.CurrentUser = bo; GlobalFacade.SystemContext.SaveContext(context); if (NeedModifyPassword()) { System.Web.HttpContext.Current.Response.Redirect(System.Web.HttpContext.Current.Request.ApplicationPath + "/SystemManage/UserManage/CheckPassword.aspx"); } else { System.Web.Security.FormsAuthentication.SetAuthCookie(userid, false); System.Web.HttpContext.Current.Response.Redirect(System.Web.HttpContext.Current.Request.ApplicationPath + "/" + Enums.Constants.DefaultUrl); } return(true); } else { return(false); } }
public void SaveMenuTreeXML(string path) { XmlElement root; XmlDocument doc = GlobalFacade.XDom.GenXmlDocument("TREENODES", out root); BusinessObjectCollection MenuCollection = new BusinessObjectCollection("Menu"); MenuCollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Menu"); filter.AddFilterItem("Parent", "0", Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); MenuCollection.AddFilter(filter); /* Andy Modify 2007-04-26 Add Order By */ MenuCollection.Businessobject.OrderBy = "ORDER BY [DisplayOrder] ASC"; DataTable childtable = MenuCollection.GetDataTable(); SaveElement(doc, root, childtable); if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } path = path + "\\" + this.rolepkid.ToString() + ".xml"; doc.Save(path); }
private void btnDel_Click(object sender, ImageClickEventArgs e) { string PKID; int selectedIndex = -1; foreach (DataGridItem item in this.dgUser.Items) { if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { if (((System.Web.UI.WebControls.RadioButton)item.Cells[0].Controls[1]).Checked) { selectedIndex = item.ItemIndex; break; } } } if (selectedIndex != -1) { PKID = this.dgUser.Items[selectedIndex].Cells[1].Text; Wicresoft.Session.Session session = new Wicresoft.Session.Session(); BusinessMapping.User bo = new BusinessMapping.User(); bo.SessionInstance = session; BusinessFilter filter = new BusinessFilter("User"); filter.AddFilterItem("PKID", PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.IsReserved.Value) { GlobalFacade.Utils.ShowMessage(Enums.Constants.RecordReserved); } else { bo.ModifyUser.Value = this.MyContext.UserID; bo.ModifyTime.Value = DateTime.Now; bo.IsValid.Value = false; bo.Update(); //BusinessRule.SystemManage.OperationLog rule = new BusinessRule.SystemManage.OperationLog(); //rule.WriteOperationLog("用户信息管理", "删除用户信息"); // Reload Data ucCustomPaging.LoadData(ucCustomPaging.CurrentPage); } } }