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