/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public DB_Talk.Model.m_GroupMembers GetModel(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" select top 1 ");
strSql.Append(" ID, BoxID, GroupID, MemberID ");
strSql.Append(" from m_GroupMembers ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
DB_Talk.Model.m_GroupMembers model=new DB_Talk.Model.m_GroupMembers();
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
model=DataTableToList(ds)[0];
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<DB_Talk.Model.m_GroupMembers> DataTableToList(DataSet ds)
{
List<DB_Talk.Model.m_GroupMembers> modelList = new List<DB_Talk.Model.m_GroupMembers>();
if (ds == null) return modelList;
DataTable dt = ds.Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DB_Talk.Model.m_GroupMembers model;
for (int n = 0; n < rowsCount; n++)
{
model = new DB_Talk.Model.m_GroupMembers();
if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
}
if(dt.Rows[n]["BoxID"]!=null && dt.Rows[n]["BoxID"].ToString()!="")
{
model.BoxID=int.Parse(dt.Rows[n]["BoxID"].ToString());
}
if(dt.Rows[n]["GroupID"]!=null && dt.Rows[n]["GroupID"].ToString()!="")
{
model.GroupID=int.Parse(dt.Rows[n]["GroupID"].ToString());
}
if(dt.Rows[n]["MemberID"]!=null && dt.Rows[n]["MemberID"].ToString()!="")
{
model.MemberID=int.Parse(dt.Rows[n]["MemberID"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
private void btnSave_Click(object sender, EventArgs e)
{
DB_Talk.BLL.m_GroupMembers bll=new DB_Talk.BLL.m_GroupMembers();
int[] selectRow = gridView1.GetSelectedRows();
if (selectRow.Length == 0)
{
CommControl.MessageBoxEx.MessageBoxEx.Show("请选择要添加的人员！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//if((selectRow.Length + priorCount) < 2)
//{
// CommControl.MessageBoxEx.MessageBoxEx.Show("分组中至少需要两个人！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
// return;
//}
if (GroupType == CommControl.PublicEnums.EnumGroupType.Meeting)
{
if ((selectRow.Length + priorCount) > Global.Params.MaxGroupMemberCount)//Global.Params.ConfigModel.SystemConfig.MaxGroupMemberCount)
{
string mes = "";
if (priorCount > 0)
{
mes = "该组已经有【" + priorCount + "】个人员,";
mes += "最多可再添加【" + (Global.Params.MaxGroupMemberCount - priorCount) + "】个,请重新选择！";
}
else
{
mes = "该组最多只能添加【" + Global.Params.MaxGroupMemberCount + "】个人员,请重新选择！";
}
CommControl.MessageBoxEx.MessageBoxEx.Show(mes, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
}
foreach(int i in selectRow)
{
object obj=gridView1.GetRow(i);
DB_Talk.Model.v_Member vModel=obj as DB_Talk.Model.v_Member;
if(vModel!=null)
{
DB_Talk.Model.m_GroupMembers model=new DB_Talk.Model.m_GroupMembers();
model.BoxID=Global.Params.BoxID;
model.GroupID =groupID;
model.MemberID=vModel.ID;
if (!bll.Exists("BoxID='" + model.BoxID + "' and GroupID='" + model.GroupID + "' and MemberID='"+model.MemberID+"'"))
{
bll.Add(model);
CommControl.SystemLogBLL.WriteLog(Global.Params.UserID, Global.Params.BoxID, CommControl.SystemLogBLL.EnumLogAction.Add, "添加", "会议【" + GroupName + "】中添加了人员：" + vModel.vc_Name, "");
this.DialogResult = DialogResult.OK;
}
}
}
}
