/// <summary> /// ���б����� /// </summary> private void BindData() { string GroupIDs = "", strWhere = ""; int sum = 0, temp = 0; int[] datas; Maticsoft.BLL.sys_Group sys_Group_bll = new Maticsoft.BLL.sys_Group(); int groupID = UserData.GetUserDate.U_GroupID; if (UserData.GetUserDate.U_Type == 0) title = "ȫ����������ͳ��"; else { title = sys_Group_bll.GetModel(groupID).G_CName + "��������ͳ��"; GroupIDs = sys_Group_bll.GetLowerLevelString_withSelf(groupID, false); } Maticsoft.BLL.sys_UserInfo sys_UserInfo_bll = new Maticsoft.BLL.sys_UserInfo(); List<Maticsoft.Model.sys_Group> list = new List<Maticsoft.Model.sys_Group>(); Maticsoft.Model.sys_Group sys_Group_model = new Maticsoft.Model.sys_Group(); if (GroupIDs != "") { list = sys_Group_bll.GetModelList(string.Format("G_Level={0} and GroupID in ({1}) ", 5, GroupIDs)); datas = new int[list.Count]; strWhere = "U_Committee={0}"; for (int i = 0; i < list.Count; i++) { sys_Group_model = (Maticsoft.Model.sys_Group)list[i]; datas[i] = temp = sys_UserInfo_bll.GetRecordCount(string.Format(strWhere, sys_Group_model.GroupID)); sum += temp; } } else { list = sys_Group_bll.GetModelList(string.Format("G_Level={0} ", 5)); datas = new int[list.Count]; strWhere = "U_Committee={0}"; for (int i = 0; i < list.Count; i++) { sys_Group_model = (Maticsoft.Model.sys_Group)list[i]; datas[i] = temp = sys_UserInfo_bll.GetRecordCount(string.Format(strWhere, sys_Group_model.GroupID)); sum += temp; } } for (int i = 0; i < list.Count; i++) { if (i != 0) { data = data + ","; categories = categories + ","; } float per = (float)Math.Round((decimal)datas[i] / sum * 100, 1); data = data + string.Format("{0}", datas[i]); sys_Group_model = (Maticsoft.Model.sys_Group)list[i]; categories = categories + string.Format("'{0}'", sys_Group_model.G_CName); table_data = table_data + string.Format("<tr class='body'><td>{0}</td><td>{1}</td><td>{2}%</td></tr>", sys_Group_model.G_CName, datas[i], per); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Group DataRowToModel(DataRow row) { Maticsoft.Model.sys_Group model=new Maticsoft.Model.sys_Group(); if (row != null) { if(row["GroupID"]!=null && row["GroupID"].ToString()!="") { model.GroupID=int.Parse(row["GroupID"].ToString()); } if(row["G_CName"]!=null) { model.G_CName=row["G_CName"].ToString(); } if(row["G_ParentID"]!=null && row["G_ParentID"].ToString()!="") { model.G_ParentID=int.Parse(row["G_ParentID"].ToString()); } if(row["G_ShowOrder"]!=null && row["G_ShowOrder"].ToString()!="") { model.G_ShowOrder=int.Parse(row["G_ShowOrder"].ToString()); } if(row["G_Level"]!=null && row["G_Level"].ToString()!="") { model.G_Level=int.Parse(row["G_Level"].ToString()); } if(row["G_ChildCount"]!=null && row["G_ChildCount"].ToString()!="") { model.G_ChildCount=int.Parse(row["G_ChildCount"].ToString()); } if(row["G_Delete"]!=null && row["G_Delete"].ToString()!="") { model.G_Delete=int.Parse(row["G_Delete"].ToString()); } if(row["G_Type"]!=null && row["G_Type"].ToString()!="") { model.G_Type=int.Parse(row["G_Type"].ToString()); } if(row["G_Code"]!=null) { model.G_Code=row["G_Code"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Group GetModel(int GroupID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 GroupID,G_CName,G_ParentID,G_ShowOrder,G_Level,G_ChildCount,G_Delete,G_Type,G_Code from sys_Group "); strSql.Append(" where GroupID=@GroupID"); SqlParameter[] parameters = { new SqlParameter("@GroupID", SqlDbType.Int, 4) }; parameters[0].Value = GroupID; Maticsoft.Model.sys_Group model = new Maticsoft.Model.sys_Group(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtG_CName.Text.Trim().Length==0) { strErr+="分类中文说明不能为空!\\n"; } if(!PageValidate.IsNumber(txtG_ParentID.Text)) { strErr+="上级分类ID0:为最高级格式错误!\\n"; } if(!PageValidate.IsNumber(txtG_ShowOrder.Text)) { strErr+="显示顺序格式错误!\\n"; } if(!PageValidate.IsNumber(txtG_Level.Text)) { strErr+="当前分类所在层数格式错误!\\n"; } if(!PageValidate.IsNumber(txtG_ChildCount.Text)) { strErr+="当???分类子分类数格式错误!\\n"; } if(!PageValidate.IsNumber(txtG_Delete.Text)) { strErr+="是否删除1:是0:否格式错误!\\n"; } if(!PageValidate.IsNumber(txtG_Type.Text)) { strErr+="部门类型格式错误!\\n"; } if(this.txtG_Code.Text.Trim().Length==0) { strErr+="行政代码不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int GroupID=int.Parse(this.lblGroupID.Text); string G_CName=this.txtG_CName.Text; int G_ParentID=int.Parse(this.txtG_ParentID.Text); int G_ShowOrder=int.Parse(this.txtG_ShowOrder.Text); int G_Level=int.Parse(this.txtG_Level.Text); int G_ChildCount=int.Parse(this.txtG_ChildCount.Text); int G_Delete=int.Parse(this.txtG_Delete.Text); int G_Type=int.Parse(this.txtG_Type.Text); string G_Code=this.txtG_Code.Text; Maticsoft.Model.sys_Group model=new Maticsoft.Model.sys_Group(); model.GroupID=GroupID; model.G_CName=G_CName; model.G_ParentID=G_ParentID; model.G_ShowOrder=G_ShowOrder; model.G_Level=G_Level; model.G_ChildCount=G_ChildCount; model.G_Delete=G_Delete; model.G_Type=G_Type; model.G_Code=G_Code; Maticsoft.BLL.sys_Group bll=new Maticsoft.BLL.sys_Group(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Group GetModel(int GroupID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 GroupID,G_CName,G_ParentID,G_ShowOrder,G_Level,G_ChildCount,G_Delete,G_Type,G_Code from sys_Group "); strSql.Append(" where GroupID=@GroupID"); SqlParameter[] parameters = { new SqlParameter("@GroupID", SqlDbType.Int,4) }; parameters[0].Value = GroupID; Maticsoft.Model.sys_Group model=new Maticsoft.Model.sys_Group(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// /// </summary> /// <param name="GroupID">部门ID</param> /// <param name="isDriect">是否直接下级机构</param> /// <returns></returns> public List<Maticsoft.Model.sys_Group> GetLowerLevel(int GroupID, Boolean isDriect) { List<Maticsoft.Model.sys_Group> list = new List<Maticsoft.Model.sys_Group>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select * from sys_Group"); strSql.Append(" where G_ParentID=@G_ParentID"); SqlParameter[] parameters = { new SqlParameter("@G_ParentID", SqlDbType.Int,4) }; parameters[0].Value = GroupID; Maticsoft.Model.sys_Group model = new Maticsoft.Model.sys_Group(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { model = (Maticsoft.Model.sys_Group)DataRowToModel(dt.Rows[i]); list.Add(model); if (!isDriect) { list.AddRange(GetLowerLevel(model.GroupID, isDriect)); } } return list; }