/// <summary>
/// 根据用户登陆名,获取用户资料
/// </summary>
/// <param name="u_LoginName">用户名</param>
/// <returns>用户实体类</returns>
public static sys_UserTable Get_sys_UserTable(string u_LoginName)
{
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where U_LoginName='{0}' ",u_LoginName);
int rInt = 0;
return BusinessFacade.sys_UserList(qp,out rInt)[0] as sys_UserTable;
}
private void OnStart()
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = Common.ApplicationID != 0 ? string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", Common.ApplicationID) : "Where M_Close=0 and M_ParentID=0 ";
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
int i = 1;
foreach (sys_ModuleTable var in lst)
{
ArrayList lst2 = BusinessFacade.GetPermissionModuleSub(var.ModuleID);//5*1*a*s*p*x
if (lst2.Count > 0)
{
if (i == 1)
sb_FramesetRows.Append("21,*");
else
sb_FramesetRows.Append(",21,0");
sb_HTMLSrc.AppendFormat("<frame name={0}menubarbutton_{1}{0} target={0}pagemain{0} scrolling={0}no{0} noresize src={0}Menu1_Button.aspx?APCatalogueID={1}&OrderNo={2}&APCatCName={3}{0}>{4}<frame name={0}menubar_{1}{0} target={0}pagemain{0} scrolling={0}auto{0} noresize src={0}Menu1_Disp.aspx?ModuleID={5}&OrderNo={2}{0} STYLE={0}border-width:1; border-bottom-style:solid{0}>{4}", "\"", var.ModuleID, i, var.M_CName, "\n",var.ModuleID);
i++;
}
}
}
public string GetSubCount(string F_Key)
{
QueryParam qp = new QueryParam();
qp.Where = string.Format("Where V_F_Key='{0}'", Common.inSQL(F_Key));
int RecordCount = 0;
BusinessFacade.sys_FieldValueList(qp, out RecordCount);
return RecordCount.ToString();
}
public int GetCatCount(int ApplicationID)
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_OrderLevel ";
qp.OrderType = 0;
qp.Where = string.Format("Where M_ApplicationID ={0} and M_ParentID=0 ", ApplicationID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
return RecordCount;
}
/// <summary>
/// 返回sys_ApplicationsTable实体类的ArrayList对象
/// </summary>
/// <param name="qp">查询类</param>
/// <param name="RecordCount">返回记录总数</param>
/// <returns>sys_ApplicationsTable实体类的ArrayList对象</returns>
public static ArrayList sys_ApplicationsList(QueryParam qp, out int RecordCount)
{
qp.TableName = "sys_Applications";
qp.ReturnFields = "*";
if (qp.Orderfld == null)
{
qp.Orderfld = "ApplicationID";
}
return DataProvider.Instance().sys_ApplicationsList(qp, out RecordCount);
}
/// <summary>
/// 绑定数据
/// </summary>
private void OnDisp()
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", ApplicationID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
Module_Main.DataSource = lst;
Module_Main.DataBind();
}
/// <summary>
/// 绑定主菜单
/// </summary>
private void BindMenu()
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = Common.ApplicationID != 0 ? string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", Common.ApplicationID) : "Where M_Close=0 and M_ParentID=0 ";
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
LeftMenu.DataSource = lst;
LeftMenu.DataBind();
}
private void BindE_ApplicationID()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ApplicationsList(qp, out RecordCount);
E_ApplicationID.DataTextField = "A_AppName";
E_ApplicationID.DataValueField = "ApplicationID";
E_ApplicationID.DataSource = lst;
E_ApplicationID.DataBind();
E_ApplicationID.Items.Insert(0, new ListItem("²»ÏÞ", ""));
}
private void ListBind()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
qp.PageIndex = Pager.CurrentPageIndex;
qp.PageSize = Pager.PageSize;
int RecordCount = 0;
ArrayList lst = BusinessFacade.PM_ProjectsList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.Pager.RecordCount = RecordCount;
}
private void ListBind()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
private void OutJs()
{
int TotalRecord = 0;
string strLink = "";
int intCount = 0;
QueryParam qp = new QueryParam();
qp.Where = "Where G_Delete=0";
qp.Orderfld = "G_Level,G_ShowOrder";
qp.OrderType = 0;
ArrayList lst = BusinessFacade.sys_GroupList(qp, out TotalRecord);
StringBuilder strSB = new StringBuilder();
strSB.Append("<script language='JavaScript'>\n");
strSB.Append("Fold_id='';\n");
strSB.Append("treeRoot = gFld(\"mainbody\", \"╡©цеап╠М\", \"0\",\"0\")\n");
foreach (sys_GroupTable x in lst)
{
intCount = intCount + 1;
//strLink = "GroupList.aspx?GroupID=" + x.GroupID.ToString();
strLink = x.GroupID.ToString();
if (x.G_Level == 1)
{
if (x.G_ChildCount == 0)
{
strSB.AppendFormat("insDoc(treeRoot,gLnk(\"mainbody\",\"{0}\",\"\",{1}))\n", Common.ReplaceJs(x.G_CName), strLink);
}
else
{
strSB.AppendFormat("N{0}=insFld(treeRoot,gFld(\"mainbody\",\"{1}\",\"\",{2}))\n", x.GroupID, Common.ReplaceJs(x.G_CName), strLink);
}
}
else
{
if (x.G_ChildCount == 0)
{
strSB.AppendFormat("insDoc(N{0},gLnk(\"mainbody\",\"{1}\",\"\",{2}))\n", x.G_ParentID, Common.ReplaceJs(x.G_CName), strLink);
}
else
{
strSB.AppendFormat("N{0}=insFld(N{1},gFld(\"mainbody\",\"{2}\",\"\",{3}))\n", x.GroupID, x.G_ParentID, Common.ReplaceJs(x.G_CName), strLink);
}
}
}
strSB.Append(" initializeDocument();\n");
strSB.Append("</script>\n");
ShowScript.Text = strSB.ToString();
}
private void BindData()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_UserList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
private void OnStart()
{
if (CMD != "Look")
{
TabOptionItem2.Visible = false;
TabOptionItem3.Visible = false;
TabOptionItem4.Visible = false;
tr_username.Visible = false;
}
else {
if (!FrameWorkPermission.CheckButtonPermission(PopedomType.New))
TabOptionItem3.Visible = false;
//绑定应用列表
int Recordcount=0;
QueryParam qp = new QueryParam();
qp.Where = string.Format("Where A_RoleID = {0}",RoleID);
qp.OrderType = 0;
ArrayList lst = BusinessFacade.sys_RoleApplicationList(qp, out Recordcount);
Repeater1.DataSource = lst;
Repeater1.DataBind();
QueryParam qp1 = new QueryParam();
qp1.OrderType = 0;
ArrayList lst1 = BusinessFacade.sys_ApplicationsList(qp1, out Recordcount);
NewAppID.DataSource = lst1;
NewAppID.DataTextField = "A_AppName";
NewAppID.DataValueField = "ApplicationID";
NewAppID.DataBind();
foreach (sys_RoleApplicationTable var in lst)
{
ListItem ditem1 = this.NewAppID.Items.FindByValue(var.A_ApplicationID.ToString());
if (ditem1 != null)
NewAppID.Items.Remove(ditem1);
}
ListItem item3 = new ListItem();
item3.Text = "请选择应用";
item3.Value = "";
NewAppID.Items.Insert(0, item3);
BindUserList();
}
InputData();
//Button1.Attributes.Add("Onclick", "javascript:return checkForm(aspnetForm);");
//Button2.Attributes.Add("Onclick", "javascript:return checkForm(aspnetForm);");
}
/// <summary>
/// 根据ID返回 sys_ApplicationsTable实体类 单笔资料
/// </summary>
/// <param name="ApplicationID">自动ID 1:为系统管理应用</param>
/// <returns>返回sys_ApplicationsTable实体类 ApplicationID为0则无记录</returns>
public static sys_ApplicationsTable sys_ApplicationsDisp(int ApplicationID)
{
sys_ApplicationsTable fam = new sys_ApplicationsTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = " Where sys_Applications.ApplicationID = " + ApplicationID;
int RecordCount = 0;
ArrayList lst = sys_ApplicationsList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = (sys_ApplicationsTable)lst[0];
}
return fam;
}
protected void BindDataList()
{
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where E_U_LoginName='{0}' and E_Type=2",UserData.GetUserDate.U_LoginName);
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_EventList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
/// <summary>
/// 构造函数
/// </summary>
static FrameSystemInfo()
{
if (GetSystemInfoTable == null)
{
sys_SystemInfoTable si = new sys_SystemInfoTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.OrderType = 0;
int Recount = 0;
ArrayList lst = BusinessFacade.sys_SystemInfoList(qp, out Recount);
if (Recount == 0)
{
si.DB_Option_Action_ = "Insert";
si.SystemID = BusinessFacade.sys_SystemInfoInsertUpdate(si);
}
else
{
si = lst[0] as sys_SystemInfoTable;
//更新新加配置
sys_ConfigDataTable sys_ConfigDB = si.S_SystemConfigData;
sys_ConfigDataTable sys_Config = new sys_ConfigDataTable();
//foreach (PropertyInfo pi in new sys_ConfigDataTable().GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
foreach (PropertyInfo pi in sys_ConfigDB.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
{
if (pi.GetValue(sys_ConfigDB, null) == null)
{
pi.SetValue(sys_ConfigDB, pi.GetValue(sys_Config, null), null);
}
}
//从Dll中更新版本
//sys_FrameWorkInfoTable sys_Db = si.S_FrameWorkInfo;
//sys_FrameWorkInfoTable sys_Dll = new sys_FrameWorkInfoTable();
//foreach (PropertyInfo pi in sys_Db.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
//{
// if (pi.Name != "S_Licensed")
// {
// pi.SetValue(sys_Db, pi.GetValue(sys_Dll, null), null);
// }
//}
}
GetSystemInfoTable = si;
}
FrameWorkPermission.InitStat = true;
}
private void OnStart()
{
sys_GroupTable gt = BusinessFacade.sys_GroupDisp(GroupID);
this.G_CName.Text = gt.G_CName;
if (gt.G_ParentID == 0)
G_ParentID_Txt.Text = "部门列表";
else
G_ParentID_Txt.Text = BusinessFacade.sys_GroupDisp(gt.G_ParentID).G_CName;
CatListTitle.Text = string.Format("<a href='GroupList.aspx'>部门列表</a>{0}", BusinessFacade.GetGroupTitle(GroupID));
//判断是否删除
if (CMD == "Delete")
{
FrameWorkPermission.CheckPermissionVoid(PopedomType.Delete);
//删除子分类
DeleteCat(GroupID);
//删除当前分类
BusinessFacade.Update_Table_Fileds("sys_Group", "G_Delete=1", string.Format("GroupID={0}", GroupID));
if (gt.G_ParentID!=0)
{
//更新父类子类数
BusinessFacade.Update_Table_Fileds("sys_Group", "G_ChildCount=G_ChildCount-1", string.Format("GroupID={0}", gt.G_ParentID));
//更新父类子类排序
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Where = string.Format("Where G_ParentID={0} and G_Delete=0",gt.G_ParentID);
qp.Orderfld = "G_Level,G_ShowOrder";
qp.OrderType = 0;
ArrayList lst = BusinessFacade.sys_GroupList(qp,out RecordCount);
RecordCount = 1;
foreach (sys_GroupTable var in lst)
{
BusinessFacade.Update_Table_Fileds("sys_Group", string.Format("G_ShowOrder={0}", RecordCount), string.Format("GroupID={0}", var.GroupID));
RecordCount++;
}
}
EventMessage.MessageBox(1, "操作成功", string.Format("删除部门({0})成功!",gt.G_CName), Icon_Type.OK, Common.GetHomeBaseUrl("GroupList.aspx"),Common.BuildJs);
}
}
private void OnStart()
{
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Orderfld = "G_Level,G_ShowOrder";
qp.OrderType = 0;
qp.Where = string.Format("Where G_ParentID={0} and G_Delete= 0",GroupID);
ArrayList lst = BusinessFacade.sys_GroupList(qp, out RecordCount);
OrderByListItems.DataSource = lst;
OrderByListItems.DataTextField = "G_CName";
OrderByListItems.DataValueField = "GroupID";
OrderByListItems.DataBind();
if (lst.Count > 0)
OrderByListItems.Rows = lst.Count;
CatListTitle.Text = string.Format("<a href='GroupList.aspx'>部门列表</a>{0}", BusinessFacade.GetGroupTitle(GroupID));
}
private void BindUserList()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_UserList(qp, out RecordCount);
string stringDel = "";
foreach (sys_UserTable var in lst)
{
stringDel = "";
if (var.U_Status == 2)
{
stringDel = "¼ºÉ¾³ý";
}
E_UserID.Items.Add(new ListItem(var.U_LoginName + "(" + var.U_CName + ")" + stringDel, var.UserID.ToString()));
}
E_UserID.Items.Insert(0,new ListItem("²»ÏÞ", ""));
}
private void OnStart()
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = Common.ApplicationID != 0 ? string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", Common.ApplicationID) : "Where M_Close=0 and M_ParentID=0 ";
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
int i = 1;
int j ;
foreach (sys_ModuleTable var in lst)
{
ArrayList lst2 = BusinessFacade.GetPermissionModuleSub(var.ModuleID);
if (lst2.Count > 0)
{
sb_TopHTMLSrc.AppendFormat("<td width='90' align='center' valign='bottom' OnMouseOver={1}javascript:ImageOverOROut('menu_{0}','v'){1} OnMouseOut={1}javascript:ImageOverOROut('menu_{0}','o'){1} class='topmenuoff' id='menu_{0}' OnClick={1}javascript:NowShow('menu_',{0}){1}>{2}</td><td valign='bottom' align='center'><img border='0' src='images/index/top-2-2.gif' width='3' height='20'></td>",i,"\"",var.M_CName);
sb_TopHTMLSrc2.AppendFormat("<td height='7' align='center'><img border='0' src='images/index/top-b-1.gif' id='menu_{0}i'></td><td height='7'></td>",i);
sb_DownHTMLSrc.AppendFormat("<table border='0' cellpadding='0' cellspacing='0' style={0}display:'none';position: absolute;left: 117px{0} align='left' id='menu_{1}_table'><tr><td align='right'><img border='0' src='images/index/top-b4-1.gif' width='5'></td>","\"",i);
j = 1;
foreach (sys_ModuleTable var2 in lst2)
{
sb_DownHTMLSrc.AppendFormat("<td background={0}images/index/top-b4-b.gif{0} align={0}center{0} width={0}92{0} class={0}topmenuoff2{0} id={0}menu_{1}_{2}{0} OnMouseOver={0}javascript:xImageOverOROut('menu_{1}_{2}','v'){0} OnMouseOut={0}javascript:xImageOverOROut('menu_{1}_{2}','o'){0} OnClick={0}javascript:xNowShow('menu_{1}_{2}','{3}'){0}> {4} </td>","\"",i,j,var2.M_Directory.Replace("\\","\\\\"),var2.M_CName);
sb_DownHTMLSrc.Append("\n");
if (j != lst2.Count)
sb_DownHTMLSrc.AppendFormat("<td background={0}images/index/top-b4-b.gif{0}><img border={0}0{0} src={0}images/index/top-b4-c.gif{0} width={0}1{0} height={0}19{0}></td>","\"");
j++;
}
if (j < i)
{
sb_DownHTMLSrc.AppendFormat("<td background={0}images/index/top-b4-b.gif{0}><img border={0}0{0} src={0}images/index/top-b4-c.gif{0} width={0}1{0} height={0}19{0}></td>", "\"");
for (int x = -1; x < i-j; x++)
{
sb_DownHTMLSrc.AppendFormat("<td background={0}images/index/top-b4-b.gif{0} width={0}1{0}></td><td background={0}images/index/top-b4-b.gif{0} align={0}center{0} width={0}92{0} class={0}topmenuoff2{0}> </td>","\"");
}
}
sb_DownHTMLSrc.Append("<td><img border='0' src='images/index/top-b4-2.gif' width='5'></td><td></td></tr></table>");
i++;
TopMenuCount++;
}
}
}
/// <summary>
/// 绑定主菜单
/// </summary>
private void BindMenu()
{
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = string.Format("Where M_ParentID=0 and M_ApplicationID ={0}", S_ID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
//绑定排序
OrderByListItems.DataSource = lst;
OrderByListItems.DataTextField = "M_CName";
OrderByListItems.DataValueField = "ModuleID";
OrderByListItems.DataBind();
if (lst.Count>0)
OrderByListItems.Rows = lst.Count;
}
private void OnStart()
{
Button2.Attributes.Add("onclick","return doConfirm(this.form);");
if (CMD == "OrderBy")
{
Table_OrderBy_FieldValue.Visible = true;
string F_Key = (string)Common.sink("F_Key", MethodType.Get, 50, 1, DataType.CharAndNum);
QueryParam qp = new QueryParam();
qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(F_Key));
qp.Orderfld = " V_ShowOrder ";
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount);
OrderByListItems.DataTextField = "V_Text";
OrderByListItems.DataValueField = "ValueID";
OrderByListItems.DataSource = lst;
OrderByListItems.DataBind();
Button3.OnClientClick = string.Format("selectAll({0})", OrderByListItems.UniqueID);
}
else
{
int FieldID = (int)Common.sink("FieldID", MethodType.Get, 255, 1, DataType.Int);
sys_FieldTable ft = BusinessFacade.sys_FieldDisp(FieldID);
F_Key.Text = ft.F_Key;
F_CName.Text = ft.F_CName;
Table_Manager_FieldValue.Visible = true;
if (CMD == "Edit")
{
int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 1, DataType.Int);
V_Text_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Text;
V_Code_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Code;
}
else
Button2.Visible = false;
}
}
private void OnStart()
{
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Orderfld = "G_Level,G_ShowOrder";
qp.OrderType = 0;
qp.Where = string.Format("Where G_ParentID ={0} and G_Delete=0 ",GroupID);
ArrayList lst = BusinessFacade.sys_GroupList(qp, out RecordCount);
CatCountTxt.Text = RecordCount.ToString();
if (GroupID == 0)
CatNameTxt.Text = "部门列表";
else {
CatNameTxt.Text = BusinessFacade.sys_GroupDisp(GroupID).G_CName;
}
SubGroup.DataSource = lst;
SubGroup.DataBind();
CatListTitle.Text = string.Format("<a href='GroupList.aspx'>部门列表</a>{0}", BusinessFacade.GetGroupTitle(GroupID));
}
/// <summary>
/// 绑定子菜单事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LeftMenu_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
sys_ModuleTable s_Mt= (sys_ModuleTable)e.Item.DataItem;
QueryParam qp = new QueryParam();
qp.Orderfld = " M_OrderLevel ";
qp.OrderType = 0;
qp.Where = string.Format("Where M_Close=0 and M_ParentID ={0}",s_Mt.ModuleID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
BusinessFacade.Remove_MenuNoPermission(lst);
if (lst.Count > 0)
{
Repeater LeftSubID = (Repeater)e.Item.FindControl("LeftMenu_Sub");
LeftSubID.DataSource = lst;
LeftSubID.DataBind();
}
else {
e.Item.Visible = false;
}
}
private void OnStart()
{
sys_FieldTable Ft = BusinessFacade.sys_FieldDisp(FieldID);
F_Key_Txt.Text = Ft.F_Key;
F_CName_Txt.Text = Ft.F_CName;
F_Remark_Txt.Text = Ft.F_Remark;
QueryParam qp = new QueryParam();
qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(Ft.F_Key));
qp.Orderfld = " V_ShowOrder ";
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount);
Main_Value.DataSource = lst;
Main_Value.DataBind();
if (CMD == "List")
{
HeadMenuButtonItem bi1 = new HeadMenuButtonItem();
bi1.ButtonPopedom = PopedomType.Edit;
bi1.ButtonName = "应用字段";
bi1.ButtonUrl = string.Format("?CMD=Edit&FieldID={0}", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi1);
HeadMenuButtonItem bi3 = new HeadMenuButtonItem();
bi3.ButtonPopedom = PopedomType.New;
bi3.ButtonName = "应用字段值";
bi3.ButtonUrl = string.Format("showPopWin('应用字段值增加','FieldValueBox.aspx?FieldID={0}&CMD=New&{1}', 300, 160, AlertMessageBox,true);", FieldID, Common.RndNum(7));
bi3.ButtonUrlType = UrlType.JavaScript;
HeadMenuWebControls1.ButtonList.Add(bi3);
HeadMenuButtonItem bi4 = new HeadMenuButtonItem();
bi4.ButtonPopedom = PopedomType.Edit;
bi4.ButtonName = "排序应用字段值";
bi4.ButtonIcon = "Orderby.gif";
bi4.ButtonUrl = string.Format("showPopWin('应用字段值排序','FieldValueBox.aspx?F_Key={0}&CMD=OrderBy&{1}', 180, 210, AlertMessageBox,true);", Ft.F_Key, Common.RndNum(7));
bi4.ButtonUrlType = UrlType.JavaScript;
HeadMenuWebControls1.ButtonList.Add(bi4);
Disp_Input.Visible = false;
F_Key_Txt.Visible = true;
F_CName_Txt.Visible = true;
F_Remark_Txt.Visible = true;
F_Key.Visible = false;
F_CName.Visible = false;
F_Remark.Visible = false;
}
else if (CMD == "Edit")
{
F_Key.Text = Ft.F_Key;
F_CName.Text = Ft.F_CName;
F_Remark.Text = Ft.F_Remark;
F_Key.Visible = false;
F_Key_Txt.Visible = true;
HeadMenuButtonItem bi5 = new HeadMenuButtonItem();
bi5.ButtonIcon = "back.gif";
bi5.ButtonPopedom = PopedomType.List;
bi5.ButtonName = "返回";
bi5.ButtonUrl = string.Format("?CMD=List&FieldID={0}", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi5);
HeadMenuButtonItem bi2 = new HeadMenuButtonItem();
bi2.ButtonPopedom = PopedomType.Delete;
bi2.ButtonName = "应用字段";
bi2.ButtonUrlType = UrlType.JavaScript;
bi2.ButtonUrl = string.Format("DelData('?CMD=Delete&FieldID={0}')", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi2);
Disp_Sub.Visible = false;
}
else if (CMD == "New")
{
Disp_Sub.Visible = false;
}
else if (CMD == "Delete")
{
Ft.DB_Option_Action_ = "Delete";
BusinessFacade.sys_FieldInsertUpdate(Ft);
foreach (sys_FieldValueTable var in lst)
{
var.DB_Option_Action_ = "Delete";
BusinessFacade.sys_FieldValueInsertUpdate(var);
}
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", FieldID, "删除应用字段"), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
}
/// <summary>
/// 返回sys_OnlineTable实体类的ArrayList对象
/// </summary>
/// <param name="qp">查询类</param>
/// <param name="RecordCount">返回记录总数</param>
/// <returns>sys_OnlineTable实体类的ArrayList对象</returns>
public override ArrayList sys_OnlineList(QueryParam qp, out int RecordCount)
{
PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_Online);
return this.GetObjectList(mypd, qp, out RecordCount);
}
/// <summary>
/// 返回sys_ModuleExtPermissionTable实体类的ArrayList对象
/// </summary>
/// <param name="qp">查询类</param>
/// <param name="RecordCount">返回记录总数</param>
/// <returns>sys_ModuleExtPermissionTable实体类的ArrayList对象</returns>
public override ArrayList sys_ModuleExtPermissionList(QueryParam qp, out int RecordCount)
{
PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_ModuleExtPermission);
return this.GetObjectList(mypd, qp, out RecordCount);
}
/// <summary>
/// 公共查询数据函数Sql存储过程版
/// </summary>
/// <param name="pd">委托对象</param>
/// <param name="pp">查询字符串</param>
/// <param name="RecordCount">返回记录总数</param>
/// <returns>返回记录集ArrayList</returns>
private ArrayList GetObjectList(PopulateDelegate pd, QueryParam pp, out int RecordCount)
{
ArrayList lst = new ArrayList();
RecordCount = 0;
using (SqlConnection conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("SupesoftPage", conn);
cmd.CommandType = CommandType.StoredProcedure;
// 设置参数
cmd.Parameters.Add("@TableName", SqlDbType.NVarChar, 500).Value = pp.TableName;
cmd.Parameters.Add("@ReturnFields", SqlDbType.NVarChar, 500).Value = pp.ReturnFields;
cmd.Parameters.Add("@Where", SqlDbType.NVarChar, 500).Value = pp.Where;
cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pp.PageIndex;
cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pp.PageSize;
cmd.Parameters.Add("@Orderfld", SqlDbType.NVarChar, 200).Value = pp.Orderfld;
cmd.Parameters.Add("@OrderType", SqlDbType.Int).Value = pp.OrderType;
// 执行
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
lst.Add(pd(dr));
}
// 取记录总数 及页数
if (dr.NextResult())
{
if (dr.Read())
{
RecordCount = Convert.ToInt32(dr["RecordCount"]);
}
}
dr.Close();
cmd.Dispose();
conn.Close();
}
return lst;
}
private void DeleteCat(int GroupID)
{
//删除子分类和删除当前分类
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Where = string.Format("Where G_ParentID={0} and G_Delete = 0 ", GroupID);
ArrayList lst = BusinessFacade.sys_GroupList(qp, out RecordCount);
foreach (sys_GroupTable var in lst)
{
BusinessFacade.Update_Table_Fileds("sys_Group", "G_Delete=1", string.Format("GroupID={0}", var.GroupID));
DeleteCat(var.GroupID);
}
}
/// <summary>
/// 返回PM_ProjectsTable实体类的ArrayList对象
/// </summary>
/// <param name="qp">查询类</param>
/// <param name="RecordCount">返回记录总数</param>
/// <returns>PM_ProjectsTable实体类的ArrayList对象</returns>
public override ArrayList PM_ProjectsList(QueryParam qp, out int RecordCount)
{
PopulateDelegate mypd = new PopulateDelegate(base.PopulatePM_ProjectsTable);
return this.GetObjectList(mypd, qp, out RecordCount);
}
