public frmGroup(DB_Talk.Model.m_Group model, int operate) { InitializeComponent(); _mModel = model; if (_mModel.GroupTypeID == CommControl.PublicEnums.EnumGroupType.Normal.GetHashCode()) GroupType = "调度"; else if((_mModel.GroupTypeID == CommControl.PublicEnums.EnumGroupType.Meeting.GetHashCode())) GroupType = "会议"; if (operate == 0) { this.FormTitle = "添加"; btnOK.Text = "添加"; } else { this.FormTitle = "编辑"; btnOK.Text = "编辑"; ShowModel(); } if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh != 0) this.txtName.MaxLength = Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;// Global.Params.NameLen; }
private void btnAdd_Click(object sender, EventArgs e) { DB_Talk.Model.m_Group m = new DB_Talk.Model.m_Group(); m.BoxID = Global.Params.BoxID.ToString(); m.GroupTypeID = GroupType.GetHashCode(); frmGroup fu = new frmGroup(m, 0); fu.ShowDialog(); if (fu.DialogResult == DialogResult.OK) LoadDataLeft(); }
private void addgroup(DB_Talk.Model.m_Box boxmodel) { Type grouptype = typeof(CommControl.PublicEnums.EnumGroupType); foreach (int i in Enum.GetValues(grouptype)) { if (i == 1) //只有调度才添加常用人员组,2103-5-31修改 { List<DB_Talk.Model.m_Group> lstmodel = new List<DB_Talk.Model.m_Group>(); DB_Talk.BLL.m_Group bll = new DB_Talk.BLL.m_Group(); lstmodel = bll.GetModelList(string.Format(" i_flag=0 and vc_Name='{0}' and BoxID='{1}' and GroupTypeID='{2}'", Global.Params.gruopNormalName, boxmodel.ID, i)); //("i_Flag=0 and vc_Name='" + Global.Params.gruopNormalName + "'"); if (lstmodel.Count == 0) { DB_Talk.Model.m_Group model = new DB_Talk.Model.m_Group(); model.BoxID = boxmodel.ID.ToString(); model.vc_Name = Global.Params.gruopNormalName; model.GroupTypeID = i; bll.Add(model); } } } }
/// <summary> /// 获得数据列表 /// </summary> public List<DB_Talk.Model.m_Group> DataTableToList(DataSet ds) { List<DB_Talk.Model.m_Group> modelList = new List<DB_Talk.Model.m_Group>(); if (ds == null) return modelList; DataTable dt = ds.Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DB_Talk.Model.m_Group model; for (int n = 0; n < rowsCount; n++) { model = new DB_Talk.Model.m_Group(); 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= dt.Rows[n]["BoxID"].ToString(); } if(dt.Rows[n]["GroupTypeID"]!=null && dt.Rows[n]["GroupTypeID"].ToString()!="") { model.GroupTypeID=int.Parse(dt.Rows[n]["GroupTypeID"].ToString()); } if(dt.Rows[n]["vc_Name"]!=null && dt.Rows[n]["vc_Name"].ToString()!="") { model.vc_Name= dt.Rows[n]["vc_Name"].ToString(); } if(dt.Rows[n]["vc_Memo"]!=null && dt.Rows[n]["vc_Memo"].ToString()!="") { model.vc_Memo= dt.Rows[n]["vc_Memo"].ToString(); } if(dt.Rows[n]["i_Flag"]!=null && dt.Rows[n]["i_Flag"].ToString()!="") { model.i_Flag=int.Parse(dt.Rows[n]["i_Flag"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 根据条件得到一个对象实体 /// </summary> public DB_Talk.Model.m_Group GetModel(string strWhere) { StringBuilder strSql=new StringBuilder(); strSql.Append(" select top 1 "); strSql.Append(" ID, BoxID, GroupTypeID, vc_Name, vc_Memo, i_Flag "); strSql.Append(" from m_Group "); if(strWhere.Trim()!="") { strSql.Append(" where "+strWhere); } DB_Talk.Model.m_Group model=new DB_Talk.Model.m_Group(); DataSet ds=GetDataSet(strSql.ToString()); if(ds!=null && ds.Tables[0].Rows.Count>0) { model=DataTableToList(ds)[0]; return model; } else { return null; } }