long addCount = 0; //批量添加总数 public frmMember(List<DB_Talk.Model.v_Member> lstvModel, int operate)//DB_Talk.Model.v_Member model, ) { InitializeComponent(); this.cmbNoType.SelectedIndexChanged+=new EventHandler(cmbNoType_SelectedIndexChanged); this.Load += new EventHandler(frmMember_Load); _operate = operate; if (operate == 0) { this.FormTitle = "添加"; btnOK.Text = "添加"; } else if(operate==1) //修改一个 { _vModel = lstvModel[0];// model; _mModel = _BLL.GetModel(_vModel.ID); _mPreModel = (DB_Talk.Model.m_Member)_mModel.Clone(); preNumber =int.Parse(_mModel.i_Number.ToString()); this.FormTitle = "编辑"; btnOK.Text = "编辑"; txtTelEnd.Enabled = false; ShowModel(); } else if (operate == 2) { this.FormTitle = "编辑多个"; btnOK.Text = "编辑多个"; txtName.Enabled = false; txtTel.Enabled = false; txtTelEnd.Enabled = false; cmbNoType.Enabled = false; txtUmtsImsi.Enabled = false; btnG.Enabled = false; _lstvModel = lstvModel; } //if (operate != 2) //{ InitCmb(); if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh != 0) this.txtName.MaxLength = Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;// Global.Params.NameLen; this.txtTel.MaxLength = Global.Params.NumberLen; this.txtTelEnd.MaxLength = Global.Params.NumberLen; //} if (operate == 2) { ShowModelMuti(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DB_Talk.Model.v_Member GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append(" select top 1 "); strSql.Append(" ID, BoxID, i_Number, vc_Name, LevelID, NumberTypeID, i_TellType, i_IsDispatch, DepartmentID, vc_MAC, i_Flag, vc_Memo, i_supplementSerive, i_Authority, i_NuPassword, i_NuPasswordType, i_UnCForwardNu, i_NoAnswerForward, i_PowerOffForward, i_BusyForward, i_DirectNum, i_IsAssociateActive, i_AssociateNum1, i_AssociateNum2, vc_UmtsKi, vc_UmtsImsi, FapID, vc_IP, NumberPasswordType, NumberType, TellAuthority, TellType, IsDispatch, LevelName, deptName, BoxName, boxIP, vc_SN "); strSql.Append(" from v_Member "); strSql.Append(" where ID='"+ID+"'"); DB_Talk.Model.v_Member model=new DB_Talk.Model.v_Member(); 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.v_Member> DataTableToList(DataSet ds) { List<DB_Talk.Model.v_Member> modelList = new List<DB_Talk.Model.v_Member>(); if (ds == null) return modelList; DataTable dt = ds.Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DB_Talk.Model.v_Member model; for (int n = 0; n < rowsCount; n++) { model = new DB_Talk.Model.v_Member(); 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]["i_Number"]!=null && dt.Rows[n]["i_Number"].ToString()!="") { model.i_Number=int.Parse(dt.Rows[n]["i_Number"].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]["LevelID"]!=null && dt.Rows[n]["LevelID"].ToString()!="") { model.LevelID=int.Parse(dt.Rows[n]["LevelID"].ToString()); } if(dt.Rows[n]["NumberTypeID"]!=null && dt.Rows[n]["NumberTypeID"].ToString()!="") { model.NumberTypeID=int.Parse(dt.Rows[n]["NumberTypeID"].ToString()); } if(dt.Rows[n]["i_TellType"]!=null && dt.Rows[n]["i_TellType"].ToString()!="") { model.i_TellType=int.Parse(dt.Rows[n]["i_TellType"].ToString()); } if(dt.Rows[n]["i_IsDispatch"]!=null && dt.Rows[n]["i_IsDispatch"].ToString()!="") { model.i_IsDispatch=int.Parse(dt.Rows[n]["i_IsDispatch"].ToString()); } if(dt.Rows[n]["DepartmentID"]!=null && dt.Rows[n]["DepartmentID"].ToString()!="") { model.DepartmentID=int.Parse(dt.Rows[n]["DepartmentID"].ToString()); } if(dt.Rows[n]["vc_MAC"]!=null && dt.Rows[n]["vc_MAC"].ToString()!="") { model.vc_MAC= dt.Rows[n]["vc_MAC"].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()); } 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_supplementSerive"]!=null && dt.Rows[n]["i_supplementSerive"].ToString()!="") { model.i_supplementSerive=long.Parse(dt.Rows[n]["i_supplementSerive"].ToString()); } if(dt.Rows[n]["i_Authority"]!=null && dt.Rows[n]["i_Authority"].ToString()!="") { model.i_Authority=int.Parse(dt.Rows[n]["i_Authority"].ToString()); } if(dt.Rows[n]["i_NuPassword"]!=null && dt.Rows[n]["i_NuPassword"].ToString()!="") { model.i_NuPassword=int.Parse(dt.Rows[n]["i_NuPassword"].ToString()); } if(dt.Rows[n]["i_NuPasswordType"]!=null && dt.Rows[n]["i_NuPasswordType"].ToString()!="") { model.i_NuPasswordType=int.Parse(dt.Rows[n]["i_NuPasswordType"].ToString()); } if(dt.Rows[n]["i_UnCForwardNu"]!=null && dt.Rows[n]["i_UnCForwardNu"].ToString()!="") { model.i_UnCForwardNu=int.Parse(dt.Rows[n]["i_UnCForwardNu"].ToString()); } if(dt.Rows[n]["i_NoAnswerForward"]!=null && dt.Rows[n]["i_NoAnswerForward"].ToString()!="") { model.i_NoAnswerForward=int.Parse(dt.Rows[n]["i_NoAnswerForward"].ToString()); } if(dt.Rows[n]["i_PowerOffForward"]!=null && dt.Rows[n]["i_PowerOffForward"].ToString()!="") { model.i_PowerOffForward=int.Parse(dt.Rows[n]["i_PowerOffForward"].ToString()); } if(dt.Rows[n]["i_BusyForward"]!=null && dt.Rows[n]["i_BusyForward"].ToString()!="") { model.i_BusyForward=int.Parse(dt.Rows[n]["i_BusyForward"].ToString()); } if(dt.Rows[n]["i_DirectNum"]!=null && dt.Rows[n]["i_DirectNum"].ToString()!="") { model.i_DirectNum=int.Parse(dt.Rows[n]["i_DirectNum"].ToString()); } if(dt.Rows[n]["i_IsAssociateActive"]!=null && dt.Rows[n]["i_IsAssociateActive"].ToString()!="") { model.i_IsAssociateActive=int.Parse(dt.Rows[n]["i_IsAssociateActive"].ToString()); } if(dt.Rows[n]["i_AssociateNum1"]!=null && dt.Rows[n]["i_AssociateNum1"].ToString()!="") { model.i_AssociateNum1=int.Parse(dt.Rows[n]["i_AssociateNum1"].ToString()); } if(dt.Rows[n]["i_AssociateNum2"]!=null && dt.Rows[n]["i_AssociateNum2"].ToString()!="") { model.i_AssociateNum2=int.Parse(dt.Rows[n]["i_AssociateNum2"].ToString()); } if(dt.Rows[n]["vc_UmtsKi"]!=null && dt.Rows[n]["vc_UmtsKi"].ToString()!="") { model.vc_UmtsKi= dt.Rows[n]["vc_UmtsKi"].ToString(); } if(dt.Rows[n]["vc_UmtsImsi"]!=null && dt.Rows[n]["vc_UmtsImsi"].ToString()!="") { model.vc_UmtsImsi= dt.Rows[n]["vc_UmtsImsi"].ToString(); } if(dt.Rows[n]["FapID"]!=null && dt.Rows[n]["FapID"].ToString()!="") { model.FapID=int.Parse(dt.Rows[n]["FapID"].ToString()); } if(dt.Rows[n]["vc_IP"]!=null && dt.Rows[n]["vc_IP"].ToString()!="") { model.vc_IP= dt.Rows[n]["vc_IP"].ToString(); } if(dt.Rows[n]["NumberPasswordType"]!=null && dt.Rows[n]["NumberPasswordType"].ToString()!="") { model.NumberPasswordType= dt.Rows[n]["NumberPasswordType"].ToString(); } if(dt.Rows[n]["NumberType"]!=null && dt.Rows[n]["NumberType"].ToString()!="") { model.NumberType= dt.Rows[n]["NumberType"].ToString(); } if(dt.Rows[n]["TellAuthority"]!=null && dt.Rows[n]["TellAuthority"].ToString()!="") { model.TellAuthority= dt.Rows[n]["TellAuthority"].ToString(); } if(dt.Rows[n]["TellType"]!=null && dt.Rows[n]["TellType"].ToString()!="") { model.TellType= dt.Rows[n]["TellType"].ToString(); } if(dt.Rows[n]["IsDispatch"]!=null && dt.Rows[n]["IsDispatch"].ToString()!="") { model.IsDispatch= dt.Rows[n]["IsDispatch"].ToString(); } if(dt.Rows[n]["LevelName"]!=null && dt.Rows[n]["LevelName"].ToString()!="") { model.LevelName= dt.Rows[n]["LevelName"].ToString(); } if(dt.Rows[n]["deptName"]!=null && dt.Rows[n]["deptName"].ToString()!="") { model.deptName= dt.Rows[n]["deptName"].ToString(); } if(dt.Rows[n]["BoxName"]!=null && dt.Rows[n]["BoxName"].ToString()!="") { model.BoxName= dt.Rows[n]["BoxName"].ToString(); } if(dt.Rows[n]["boxIP"]!=null && dt.Rows[n]["boxIP"].ToString()!="") { model.boxIP= dt.Rows[n]["boxIP"].ToString(); } if(dt.Rows[n]["vc_SN"]!=null && dt.Rows[n]["vc_SN"].ToString()!="") { model.vc_SN= dt.Rows[n]["vc_SN"].ToString(); } modelList.Add(model); } } return modelList; }