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