public frmDepartment(DB_Talk.Model.m_Departments model, int operate)
{
InitializeComponent();
if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh != 0)
this.txtName.MaxLength = Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;// Global.Params.NameLen;
if (operate == 0)
{
this.FormTitle = "添加";
btnOK.Text = "添加";
}
else
{
_mModel = model;
this.FormTitle = "编辑";
btnOK.Text = "编辑";
ShowModel();
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<DB_Talk.Model.m_Departments> DataTableToList(DataSet ds)
{
List<DB_Talk.Model.m_Departments> modelList = new List<DB_Talk.Model.m_Departments>();
if (ds == null) return modelList;
DataTable dt = ds.Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DB_Talk.Model.m_Departments model;
for (int n = 0; n < rowsCount; n++)
{
model = new DB_Talk.Model.m_Departments();
if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].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_Member DataRowToModel(DataRow row)
{
DB_Talk.Model.m_Member model = new DB_Talk.Model.m_Member();
if (row != null)
{
try
{
model.BoxID = Global.Params.BoxID;
//model.NumberTypeID = 4;// CommControl.PublicEnums.EnumNumberType.SIP.GetHashCode();
//姓名
string strName = row["用户姓名"].ToString().Replace(" ", "");
bool CheckLen = strName.Length <= Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;
if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh == 0)
CheckLen = true;
if (row["用户姓名"] != null && strName != "" &&
CheckLen &&
checkFormat(false, ref strName, false))
{
model.vc_Name = strName;
}
else
{
return model=null;
}
//电话
string strTel = row["电话号码"].ToString().Replace(" ","");
if (row["电话号码"] != null && strTel != "" &&
strTel.Length == Global.Params.NumberLen &&
checkFormat(true, ref strTel, false))
{
string str = strTel.Trim().Substring(0, 1);
if (Global.Params.strNumHead.IndexOf(str) < 0)
{
return model = null;
}
model.i_Number = int.Parse(strTel);
}
else
{
return model = null;
}
if (model.i_Number > Math.Pow(10, Global.Params.NumberLen) - 1) return model = null;
//部门
string strDept = row["部门"].ToString().Replace(" ", "");
if (row["部门"] != null && strDept != "" && strDept.Length <= 10)
{
DB_Talk.Model.m_Departments modelDept = new DB_Talk.BLL.m_Departments().GetModel("i_Flag=0 and vc_Name='" + strDept + "'");
if (modelDept != null)
model.DepartmentID = modelDept.ID;
else //无部门时添加部门
{
modelDept = new DB_Talk.Model.m_Departments();
modelDept.vc_Name = strDept;
model.DepartmentID = new DB_Talk.BLL.m_Departments().Add(modelDept, true);
}
}
//用户权限
if (row["用户权限"] != null && row["用户权限"].ToString() != "")
{
string strAuthority = row["用户权限"].ToString().Replace(" ", "");
switch (strAuthority)
{
case "国际长途":
model.i_Authority = 0;
break;
case "国内长途":
model.i_Authority = 1;
break;
case "市话":
model.i_Authority = 2;
break;
case "内部分机":
model.i_Authority = 3;
break;
case "禁止主叫":
model.i_Authority = 4;
break;
default:
return model = null;
}
}
else
{
return model = null;
}
//号码类型
if (row["电话类型"] != null && row["电话类型"].ToString() != "")
{
string strTellType = row["电话类型"].ToString().Replace(" ", "").ToUpper();
switch (strTellType)
{
case "WIFI手机":
model.i_TellType = PublicEnums.EnumTelType.WiFi手机.GetHashCode();
model.NumberTypeID = PublicEnums.EnumNumberType.手机Wifi.GetHashCode();
model.i_NuPasswordType = PublicEnums.EnumTelPasswordType.增加.GetHashCode();
model.i_NuPassword = (uint)model.i_Number;
break;
case "3G手机":
if (Global.Params.BoxType == MBoxSDK.ConfigSDK.EnumDeviceType.T_HT8000_3G) //目前只有800B支持3G)
{
model.i_TellType = PublicEnums.EnumTelType.G3G手机.GetHashCode();
model.NumberTypeID = PublicEnums.EnumNumberType.手机3G.GetHashCode();
if (row["标示码"] != null && row["标示码"].ToString() != "")
{
string strUmtsImsi = row["标示码"].ToString().Replace(" ", "");
if (strUmtsImsi.Length == Global.Params.UmtsImsiLen)
model.vc_UmtsImsi = strUmtsImsi;
else
return model = null;
}
}
else
{
return model = null;
}
break;
case "固话": //wifi和固话 默认密码为增加模式 与号码相同
model.i_TellType = PublicEnums.EnumTelType.固话.GetHashCode();
model.NumberTypeID = PublicEnums.EnumNumberType.固话.GetHashCode();
model.i_NuPasswordType = PublicEnums.EnumTelPasswordType.增加.GetHashCode();
model.i_NuPassword = (uint)model.i_Number;
break;
case "广播": //wifi和固话 默认密码为增加模式 与号码相同
model.i_TellType = PublicEnums.EnumTelType.广播.GetHashCode();
model.NumberTypeID = PublicEnums.EnumNumberType.固话.GetHashCode(); //固话、wifi手机、广播=4
model.i_NuPasswordType = PublicEnums.EnumTelPasswordType.增加.GetHashCode();
model.i_NuPassword = (uint)model.i_Number;
if (row["广播IP"] != null && row["广播IP"].ToString() != "")
{
string strIP = row["广播IP"].ToString().Replace(" ", "");
if (Global.Methods.checkIP(strIP))
{
model.vc_IP = strIP;
}
else
return model = null;
}
break;
default:
return model = null;
}
}
else
{
return model = null;
}
//if (model.i_Number < Math.Pow(10, Global.Params.NumberLen-1) - 1) return model = null;
}
catch
{
model = null;
}
}
return model;
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public DB_Talk.Model.m_Departments GetModel(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" select top 1 ");
strSql.Append(" ID, vc_Name, vc_Memo, i_Flag ");
strSql.Append(" from m_Departments ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
DB_Talk.Model.m_Departments model=new DB_Talk.Model.m_Departments();
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
model=DataTableToList(ds)[0];
return model;
}
else
{
return null;
}
}
