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