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