/// <summary> /// 推广--获取用户具有权限的城市过滤条件对象 /// </summary> /// <param name="userid"></param> /// <returns></returns> public BusinessFilter GetCityFilterByPromotion(int userid) { Wicresoft.DataAccess.SQLServer dal = new Wicresoft.DataAccess.SQLServer(); BusinessFilter filter = new BusinessFilter("Dictionary"); string sql = string.Format("select a.FK_Center,b.parent as CityID,b.name from AssistantDataPermission as a left join [Dictionary] as b on a.fk_center = b.pkid where a.fk_center <> -1 and a.fk_Assistant =" + userid); DataTable dt = dal.ExcuteDataTable(new DataTable(), sql, CommandType.Text); //if (temp != null && temp.Rows.Count != 0) //{ // filter.AddCustomerFilter("Dictionary.PKID IN (" + temp.Rows[0]["CityID"].ToString() + ")", AndOr.AND); //} string strCity = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["CityID"] != null && dt.Rows[i]["CityID"].ToString() != string.Empty) { strCity += "," + dt.Rows[i]["CityID"].ToString(); } } if (strCity != string.Empty) { strCity = strCity.Substring(1, strCity.Length - 1); filter.AddCustomerFilter("Dictionary.PKID IN (" + strCity + ")", AndOr.AND); } return(filter); }
private void BindGrid1() { BusinessFilter filter = this.ucQueryProvider.GetBusinessFilter(); filter.AddFilter(this.BusinessObjectView.InitialFilter, AndOr.AND); this.BusinessObjectView.CurrentFilter = filter; this.ucCustomPaging.TotalRecords = this.BusinessObjectView.LoadData(1, 100000000); DataTable dt = this.BusinessObjectView.tblSchema; if (dt.Rows.Count != 0) { for (int i = 0; i < this.BusinessObjectView.tblSchema.Rows.Count; i++) { strValues += dt.Rows[i]["PKID"].ToString() + ","; strTexts += dt.Rows[i][this.BusinessObjectView.DisplayField.FieldName].ToString() + ","; } if (strValues.IndexOf(",") != -1) { strValues = strValues.Substring(0, strValues.Length - 1); } if (strTexts.IndexOf(",") != -1) { strTexts = strTexts.Substring(0, strTexts.Length - 1); } } }
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; } }
/// <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]); }
/// <summary> /// 推广--获取用户具有权限的中心过滤条件对象 /// </summary> /// <param name="userid"></param> /// <returns></returns> public BusinessFilter GetCenterFilterByPromotion(string userid) { Wicresoft.DataAccess.SQLServer dal = new Wicresoft.DataAccess.SQLServer(); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddCustomerFilter("Dictionary.PKID IN (" + GetCenterFilterByPromotion(int.Parse(userid)) + ")", AndOr.AND); return(filter); }
private bool btnQuery_ButtonClick(object sender, EventArgs e) { string filterDescription; BusinessFilter filter = this.ucQueryProvider.GetBusinessFilter(out filterDescription); SaveQueryResult(filter, filterDescription); GlobalFacade.Utils.CloseWindowAndRefreshParent(); return(false); }
private void LoadData(int pageNumber, int pageSize) { BusinessFilter filter = this.ucQueryProvider.GetBusinessFilter(); filter.AddFilter(this.BusinessObjectView.InitialFilter, AndOr.AND); this.BusinessObjectView.CurrentFilter = filter; this.ucCustomPaging.TotalRecords = this.BusinessObjectView.LoadData(pageNumber, pageSize); this.BindGrid(); }
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/>"; } }
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); } } } }
/// <summary> /// 获取用户具有权限的中心过滤条件对象 /// </summary> /// <param name="userid"></param> /// <returns></returns> public BusinessFilter GetAuthorizedCenterFilter(int userid) { Wicresoft.DataAccess.SQLServer dal = new Wicresoft.DataAccess.SQLServer(); string sql = string.Format(sp_GetUserDataPermissionOnCenter, userid); string centerpkids = dal.ExecuteScalar(sql, CommandType.Text).ToString(); BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddCustomerFilter("Dictionary.PKID IN (" + centerpkids + ")", AndOr.AND); return(filter); }
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; } }
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; } }
// GET: Businesses public IActionResult Index(int skipAmount, BusinessFilter filter) { if (filter == null) { filter = new BusinessFilter(); } var indexVM = new BusinessIndexViewModel { Businesses = _businessManager.GetBusinesses(filter), Filter = filter }; return(View(indexVM)); }
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 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); }
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); } } }
/// <summary> /// 导出独生子女统计列表 /// </summary> /// <param name="pageSize">页大小(一次取出的记录数)</param> /// <param name="pageIndex">页码(1开始)</param> /// <param name="subfilter">筛选条件对象</param> /// <returns>结果集</returns> public DataTable GetCWOneChildListForExport(int pageSize, int pageIndex, BusinessFilter subfilter) { Wicresoft.Session.Session session = new Wicresoft.Session.Session(); BusinessObjectCollection boc = new BusinessObjectCollection("CWOneChild"); boc.SessionInstance = session; BusinessFilter filter = new BusinessFilter("CWOneChild"); filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); if (subfilter != null) { filter.AddFilter(subfilter, AndOr.AND); } boc.AddFilter(filter); return(boc.GetDataTable()); }
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.CWInfo bo = new BusinessMapping.CWInfo(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("CWInfo"); filter.AddFilterItem("PKID", this.PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { int userID = GlobalFacade.SystemContext.GetContext().UserID; bo.VillageName.Value = this.txtVillageName.Text.Trim(); bo.Location.Value = this.txtLocation.Text.Trim(); if (this.ddlDistrict.SelectedValue != "" && this.ddlDistrict.SelectedValue != "0") { bo.District.Value = Convert.ToInt32(this.ddlDistrict.SelectedValue); } else { bo.District.Value = 0; } if (this.txtTotalPeps.Text.Trim() != "") { bo.TotalPeps.Value = Convert.ToInt32(this.txtTotalPeps.Text.Trim()); } if (this.txtIndusValue.Text.Trim() != "") { bo.IndusValue.Value = Convert.ToDecimal(this.txtIndusValue.Text.Trim()); } bo.VillageChief.Value = this.txtVillageChief.Text.Trim(); bo.Memo.Value = this.txtMemo.Text.Trim(); bo.ModifyTime.Value = DateTime.Now; bo.ModifyUser.Value = userID; bo.Update(); } }
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); } } }
public void LoadBaseInfo(int pkid) { BusinessMapping.User bo = new BusinessMapping.User(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("User"); filter.AddFilterItem("PKID", pkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { // 显示基本信息 PresnetUI(bo); } }
public void LoadBaseInfo(int pkid) { BusinessMapping.Role bo = new BusinessMapping.Role(); bo.SessionInstance = new Wicresoft.Session.Session(); BusinessFilter filter = new BusinessFilter("Role"); filter.AddFilterItem("PKID", pkid.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { this.tbxRoleCode.Text = bo.RoleCode.Value; this.tbxRoleName.Text = bo.RoleName.Value; this.tbxMemo.Text = bo.Memo.Value; } }
/// <summary> /// 更新密码 /// </summary> private void Save() { InputPwd = GlobalFacade.EncryptionManager.EncrytPassword(this.tbxNewPassword.Text.Trim().ToString()); bo.SessionInstance = new Wicresoft.Session.Session(); filter = new BusinessFilter("User"); filter.AddFilterItem("PKID", GlobalFacade.SystemContext.GetContext().UserID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); bo.AddFilter(filter); bo.Load(); if (bo.HaveRecord) { bo.Password.Value = InputPwd; // 2006-11-20, Tony bo.LastModifyPasswordTime.Value = DateTime.Now; bo.Update(); } }
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 = "旧密码输入错误"; }
private void LoadData() { BusinessFilter filter = new BusinessFilter("Role"); filter.AddFilterItem("PKID", PKID.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); BusinessMapping.Role role = new BusinessMapping.Role(); role.SessionInstance = new Wicresoft.Session.Session(); role.AddFilter(filter); role.Load(); if (role.HaveRecord) { this.tbxRoleCode.Text = role.RoleCode.Value; this.tbxRoleName.Text = role.RoleName.Value; this.tbxMemo.Text = role.Memo.Value; } }
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")); }
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; }
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")); }