protected string CombSqlTxt()
{
int flag = 0;
int i = 0;
var model = GetAdminInfo_CCOM();
StringBuilder strTemp = new StringBuilder();
BLL.CCOM.Reply_student rs_bll = new BLL.CCOM.Reply_student();
BLL.CCOM.Reply_commission rc_bll = new BLL.CCOM.Reply_commission();
BLL.CCOM.Reply_group rg_bll = new BLL.CCOM.Reply_group();
strTemp.Append("(");
//学生
DataSet ds = rs_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
for (i = 1; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
//组长
ds = rg_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
if (flag == 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
i = 1;
}
else
{
i = 0;
}
for (; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
//组员
ds = rc_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
if (flag == 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
i = 1;
}
else
{
i = 0;
}
for (; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
if (flag == 0)
{
strTemp.Append("-1");
}
strTemp.Append(")");
return(strTemp.ToString());
}