/// <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 BusinessObjectCollection GetAuthorizedCenters(int userid)
{
BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary");
boc.SessionInstance = new Wicresoft.Session.Session();
boc.AddFilter(GetAuthorizedCenterFilter(userid));
boc.Query();
return(boc);
}
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 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);
}
/// <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());
}
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 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 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 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;
}
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);
}
}
/// <summary>
/// 获取独生子女统计列表
/// </summary>
/// <param name="totalCount">记录总数</param>
/// <param name="pageSize">页大小（一次取出的记录数）</param>
/// <param name="pageIndex">页码（1开始）</param>
/// <param name="obType">排续类型</param>
/// <param name="subfilter">筛选条件对象</param>
/// <returns>结果集</returns>
public DataTable GetCWOneChildList(out int totalCount, int pageSize, int pageIndex,
Common.OrderByType obType, 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);
DataSet ds = boc.GetPagedRecords(pageIndex, pageSize, "PKID", (obType == Common.OrderByType.DESC)?true:false);
totalCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ds.Tables[1]);
}
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]);
}
//Qick 获取城市列表 2009-02-06
public DataTable GetCityListNew(out int totalCount, int pageSize, int pageIndex, Common.OrderByType obType, BusinessFilter filter)
{
Common commonRule = new Common();
BusinessFilter flt = new BusinessFilter("DictionaryAD");
flt.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
flt.AddCustomerFilter("(DictionaryAD.Level =1 OR DictionaryAD.Level =0)", AndOr.AND);
flt.AddFilter(filter, AndOr.AND);
BusinessObjectCollection boc = new BusinessObjectCollection("DictionaryAD");
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]);
}
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();
}
}
/// <summary>
/// 获取行政区列表
/// </summary>
/// <param name="totalCount">记录总数</param>
/// <param name="pageSize">页大小（一次取出的记录数）</param>
/// <param name="pageIndex">页码（1开始）</param>
/// <param name="obType">排续类型</param>
/// <param name="subfilter">筛选条件对象</param>
/// <returns>结果集</returns>
public DataTable GetDistrictList(out int totalCount, int pageSize, int pageIndex,
Common.OrderByType obType, BusinessFilter subfilter)
{
BusinessRule.BaseData.Region rule = new Region();
Wicresoft.Session.Session session = new Wicresoft.Session.Session();
BusinessObjectCollection boc = new BusinessObjectCollection("District");
boc.SessionInstance = session;
BusinessFilter filter = new BusinessFilter("District");
filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
filter.AddCustomerFilter("District.FK_Dictionary IN (" + rule.GetAuthorizedCitiesPKID(GlobalFacade.SystemContext.GetContext().UserID) + ")", AndOr.AND);
if (subfilter != null)
{
filter.AddFilter(subfilter, AndOr.AND);
}
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]);
}
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);
}
public void GenerateTree(Microsoft.Web.UI.WebControls.TreeView tr_region)
{
BusinessObjectCollection ParentCollection = new BusinessObjectCollection("Dictionary");
ParentCollection.SessionInstance = session;
BusinessFilter filter = new BusinessFilter("Dictionary");
filter.AddFilterItem("Parent", Level.Top, Operation.Equal, FilterType.NumberType, AndOr.AND);
filter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND);
// filter.AddFilterItem("Parent","0",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);
ParentCollection.AddFilter(filter);
DataTable parenttable = ParentCollection.GetDataTable();
for (int i = 0; i < parenttable.Rows.Count; i++)
{
Microsoft.Web.UI.WebControls.TreeNode node = new TreeNode();
node.NodeData = parenttable.Rows[i]["PKID"].ToString();
node.Text = parenttable.Rows[i]["Name"].ToString();
node.ID = parenttable.Rows[i]["path"].ToString();
tr_region.Nodes.Add(node);
BusinessObjectCollection childCollection = new BusinessObjectCollection("Dictionary");
childCollection.SessionInstance = session;
BusinessFilter subfilter = new BusinessFilter("Dictionary");
subfilter.AddFilterItem("Parent", parenttable.Rows[i]["PKID"].ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND);
subfilter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND);
// if (type == DictionaryType.Region)
// {
// subfilter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else if (type == DictionaryType.Product)
// {
// subfilter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else
// {
// subfilter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
subfilter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
childCollection.AddFilter(subfilter);
DataTable childtable = childCollection.GetDataTable();
GenerateElement(node, childtable);
}
}
//Qick新加方法
public DataTable GetCityListAD(out int totalCount, int pageSize, int pageIndex, Common.OrderByType obType, BusinessFilter filter)
{
//获取没有中心的城市
string sql = "select pkid from dictionaryAd where pkid in (select pkid from dictionaryAd where [name] not in (select [name] from dictionary where isvalid =1 and ([level]=1 or [level]=0)) and isvalid = 1 and ([level]=1 or [level]=0)) and ([level]=1 or [level]=0)";
Wicresoft.Session.Session session = new Wicresoft.Session.Session();
DataTable dt = session.SqlHelper.ExcuteDataTable(null, sql, CommandType.Text);
string NOPKIDs = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
NOPKIDs += "," + dt.Rows[i][0];
}
//获取登陆用户拥有权限的城市
/* Andy Modify 2009-12-17 用DictionaryAD表的PKID和FK_Dictionary过滤不同值 */
BusinessRule.BaseData.Region regionRule = new BusinessRule.BaseData.Region();
string cityPKIDs = regionRule.GetAuthorizedCitiesPKID(GlobalFacade.SystemContext.GetContext().UserID).ToString();
if (cityPKIDs.IndexOf("2,") != -1)
{
cityPKIDs += ",1";
}
if (NOPKIDs != string.Empty)
{
NOPKIDs = NOPKIDs.Substring(1, NOPKIDs.Length - 1);
}
// string cityPKIDs = ","+regionRule.GetAuthorizedCitiesPKID(GlobalFacade.SystemContext.GetContext().UserID).ToString()+",";
// if(cityPKIDs.IndexOf(",2,")!=-1)
// {
// cityPKIDs=cityPKIDs.Substring(1,cityPKIDs.Length-2);
// cityPKIDs+=",1";
// if(NOPKIDs!=null&&NOPKIDs!=""&&NOPKIDs!=string.Empty)
// {
// cityPKIDs+=NOPKIDs;
// }
// }
// else
// {
// cityPKIDs=cityPKIDs.Substring(1,cityPKIDs.Length-2);
// }
Common commonRule = new Common();
BusinessFilter flt = new BusinessFilter("DictionaryAD");
flt.AddCustomerFilter("(DictionaryAD.PKID IN(" + NOPKIDs + ") OR DictionaryAD.FK_Dictionary IN (" + cityPKIDs + "))", AndOr.AND);
// flt.AddCustomerFilter("(DictionaryAD.PKID IN(" + cityPKIDs + ") OR DictionaryAD.PKID IN (" + cityPKIDs + "))", AndOr.AND);
flt.AddFilterItem("IsValid", "1", 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("DictionaryAD");
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]);
}
public DataTable GetDictionaryList(out int totalCount, int pageSize, int pageIndex,
Common.OrderByType obType, BusinessFilter subfilter)
{
// //找出没有中心的城市PKID
// string sql="select pkid from dictionaryAd where pkid in (select pkid from dictionaryAd where [name] not in (select [name] from dictionary where isvalid =1 and ([level]=1 or [level]=0)) and isvalid = 1 and ([level]=1 or [level]=0)) and ([level]=1 or [level]=0)";
// Wicresoft.Session.Session session = new Wicresoft.Session.Session();
// DataTable dt = session.SqlHelper.ExcuteDataTable(null,sql,CommandType.Text);
// string NOPKIDs="";
// for(int i=0;i<dt.Rows.Count;i++)
// {
// NOPKIDs+=","+dt.Rows[i][0];
// }
//
// //找出当前用户所拥有权限的城市PKID
// BusinessRule.BaseData.Region regionRule = new BusinessRule.BaseData.Region();
//
// string cityPKIDs = ","+regionRule.GetAuthorizedCitiesPKID(GlobalFacade.SystemContext.GetContext().UserID).ToString()+",";
//
// BusinessObjectCollection boc = new BusinessObjectCollection("ADClient");
// boc.SessionInstance = session;
// BusinessFilter filter = new BusinessFilter("ADClient");
//
// //找出是总部发布的PKID
// string sqlADInfomation="select PKID from ADInfomation where FK_Center =1 and isvalid=1";
// Wicresoft.Session.Session sessionADInfomation = new Wicresoft.Session.Session();
// DataTable dtADInfomation=sessionADInfomation.SqlHelper.ExcuteDataTable(null,sqlADInfomation,CommandType.Text);
// string ADInfomationPKID = string.Empty;
// if(dtADInfomation.Rows.Count>0)
// {
// for(int j=0;j<dtADInfomation.Rows.Count;j++)
// {
// ADInfomationPKID+=dtADInfomation.Rows[j][0]+",";
// }
// ADInfomationPKID=ADInfomationPKID.Substring(0,ADInfomationPKID.Length-1);
// }
// //防止ADInfomationPKID为空
// if(ADInfomationPKID == string.Empty)
// {
// ADInfomationPKID = "0";
// }
// //有总部权限的
// if(cityPKIDs.IndexOf(",2,")!=-1)
// {
// cityPKIDs=cityPKIDs.Substring(1,cityPKIDs.Length-2);
// cityPKIDs+=",1";
// if(NOPKIDs!=null&&NOPKIDs!=""&&NOPKIDs!=string.Empty)
// {
// cityPKIDs+=NOPKIDs;
// }
// //如果该用户是总部的 就能看到
// /* Andy Modify 2009-03-08 */
// filter.AddCustomerFilter("(ADClient.FK_City IN(" + cityPKIDs + ") OR ADClient.FK_ADInfomation IN (" + ADInfomationPKID + ")) AND ADClient.FK_ADInfomation IN (" + regionRule.GetAuthorizedADInfomationPKID(GlobalFacade.SystemContext.GetContext().UserID) + ")", AndOr.AND);
// }
// else
// {
// cityPKIDs=cityPKIDs.Substring(1,cityPKIDs.Length-2);
// //如果该用户不是总部的 无法看到
// /* Andy Modify 2009-03-08 */
// filter.AddCustomerFilter("(ADClient.FK_City IN(" + cityPKIDs + ") AND ADClient.FK_ADInfomation not IN (" + ADInfomationPKID + ")) AND ADClient.FK_ADInfomation IN (" + regionRule.GetAuthorizedADInfomationPKID(GlobalFacade.SystemContext.GetContext().UserID) + ")", AndOr.AND);
// }
// //过滤城市
// //filter.AddCustomerFilter("(ADClient.FK_City IN(" + cityPKIDs + ") OR ADClient.FK_City IN (" + cityPKIDs + "))", AndOr.AND);
// filter.AddFilterItem("IsValid","1",Operation.Equal,FilterType.NumberType,AndOr.AND);
//
// if (subfilter != null)
// filter.AddFilter(subfilter,AndOr.AND);
// 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];
Wicresoft.Session.Session session = new Wicresoft.Session.Session();
BusinessObjectCollection boc = new BusinessObjectCollection("Dictionary");
boc.SessionInstance = session;
BusinessFilter filter = new BusinessFilter("Dictionary");
filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
filter.AddFilterItem("Level", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
if (subfilter != null)
{
filter.AddFilter(subfilter, AndOr.AND);
}
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]);
}
