/// <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"));
}
