/// <summary>
/// 得到一个对象实体
/// </summary>
public DB_Talk.Model.SubscriberProfile DataRowToModel(DataRow row)
{
DB_Talk.Model.SubscriberProfile model=new DB_Talk.Model.SubscriberProfile();
if (row != null)
{
if(row["SiteID"]!=null && row["SiteID"].ToString()!="")
{
model.SiteID=int.Parse(row["SiteID"].ToString());
}
if(row["SubscriberID"]!=null && row["SubscriberID"].ToString()!="")
{
model.SubscriberID=int.Parse(row["SubscriberID"].ToString());
}
if(row["EmployeeID"]!=null && row["EmployeeID"].ToString()!="")
{
model.EmployeeID=int.Parse(row["EmployeeID"].ToString());
}
if(row["SPMSubIndex"]!=null && row["SPMSubIndex"].ToString()!="")
{
model.SPMSubIndex=int.Parse(row["SPMSubIndex"].ToString());
}
if(row["SubscriberNumber"]!=null)
{
model.SubscriberNumber=row["SubscriberNumber"].ToString();
}
if(row["SPMPSNumber"]!=null)
{
model.SPMPSNumber=row["SPMPSNumber"].ToString();
}
if(row["SPMAuthKey"]!=null)
{
model.SPMAuthKey=row["SPMAuthKey"].ToString();
}
if(row["SPMSubType"]!=null && row["SPMSubType"].ToString()!="")
{
model.SPMSubType=int.Parse(row["SPMSubType"].ToString());
}
if(row["Record"]!=null && row["Record"].ToString()!="")
{
model.Record=int.Parse(row["Record"].ToString());
}
if(row["SPMPSIdentification"]!=null)
{
model.SPMPSIdentification=row["SPMPSIdentification"].ToString();
}
if(row["SPMDIDNumber"]!=null)
{
model.SPMDIDNumber=row["SPMDIDNumber"].ToString();
}
if(row["SPMSubSuppService"]!=null && row["SPMSubSuppService"].ToString()!="")
{
model.SPMSubSuppService=int.Parse(row["SPMSubSuppService"].ToString());
}
if(row["SPMSubGroup"]!=null)
{
model.SPMSubGroup=row["SPMSubGroup"].ToString();
}
if(row["SPMSubPriority"]!=null && row["SPMSubPriority"].ToString()!="")
{
model.SPMSubPriority=int.Parse(row["SPMSubPriority"].ToString());
}
if(row["SPMFXSPort"]!=null)
{
model.SPMFXSPort=row["SPMFXSPort"].ToString();
}
if(row["SPMSubCfuNumber"]!=null)
{
model.SPMSubCfuNumber=row["SPMSubCfuNumber"].ToString();
}
if(row["SPMSubCfbNumber"]!=null)
{
model.SPMSubCfbNumber=row["SPMSubCfbNumber"].ToString();
}
if(row["SPMSubCfnrNumber"]!=null)
{
model.SPMSubCfnrNumber=row["SPMSubCfnrNumber"].ToString();
}
if(row["SPMSubCfurNumber"]!=null)
{
model.SPMSubCfurNumber=row["SPMSubCfurNumber"].ToString();
}
if(row["SPMAssociationNumber1"]!=null)
{
model.SPMAssociationNumber1=row["SPMAssociationNumber1"].ToString();
}
if(row["SPMAssociationNumber2"]!=null)
{
model.SPMAssociationNumber2=row["SPMAssociationNumber2"].ToString();
}
if(row["SPMSubPassword"]!=null)
{
model.SPMSubPassword=row["SPMSubPassword"].ToString();
}
if(row["SPMSubPasswordLevel"]!=null && row["SPMSubPasswordLevel"].ToString()!="")
{
model.SPMSubPasswordLevel=int.Parse(row["SPMSubPasswordLevel"].ToString());
}
if(row["SPMSubPasswordStatus"]!=null && row["SPMSubPasswordStatus"].ToString()!="")
{
model.SPMSubPasswordStatus=int.Parse(row["SPMSubPasswordStatus"].ToString());
}
if(row["SPMFXOPort"]!=null)
{
model.SPMFXOPort=row["SPMFXOPort"].ToString();
}
if(row["SPMACTimeHour"]!=null && row["SPMACTimeHour"].ToString()!="")
{
model.SPMACTimeHour=int.Parse(row["SPMACTimeHour"].ToString());
}
if(row["SPMACTimeMinute"]!=null && row["SPMACTimeMinute"].ToString()!="")
{
model.SPMACTimeMinute=int.Parse(row["SPMACTimeMinute"].ToString());
}
if(row["SPMSubStatus"]!=null && row["SPMSubStatus"].ToString()!="")
{
model.SPMSubStatus=int.Parse(row["SPMSubStatus"].ToString());
}
if(row["SPMSubBlockStatus"]!=null && row["SPMSubBlockStatus"].ToString()!="")
{
model.SPMSubBlockStatus=int.Parse(row["SPMSubBlockStatus"].ToString());
}
if(row["SPMSubInumberServiceStatus"]!=null && row["SPMSubInumberServiceStatus"].ToString()!="")
{
model.SPMSubInumberServiceStatus=int.Parse(row["SPMSubInumberServiceStatus"].ToString());
}
if(row["DispatchLevel"]!=null && row["DispatchLevel"].ToString()!="")
{
model.DispatchLevel=int.Parse(row["DispatchLevel"].ToString());
}
if(row["ChangeTimestamp"]!=null && row["ChangeTimestamp"].ToString()!="")
{
model.ChangeTimestamp=DateTime.Parse(row["ChangeTimestamp"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DB_Talk.Model.SubscriberProfile GetModel()
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" SiteID,SubscriberID,EmployeeID,SPMSubIndex,SubscriberNumber,SPMPSNumber,SPMAuthKey,SPMSubType,Record,SPMPSIdentification,SPMDIDNumber,SPMSubSuppService,SPMSubGroup,SPMSubPriority,SPMFXSPort,SPMSubCfuNumber,SPMSubCfbNumber,SPMSubCfnrNumber,SPMSubCfurNumber,SPMAssociationNumber1,SPMAssociationNumber2,SPMSubPassword,SPMSubPasswordLevel,SPMSubPasswordStatus,SPMFXOPort,SPMACTimeHour,SPMACTimeMinute,SPMSubStatus,SPMSubBlockStatus,SPMSubInumberServiceStatus,DispatchLevel,ChangeTimestamp ");
strSql.Append(" from SubscriberProfile ");
strSql.Append(" where " );
DB_Talk.Model.SubscriberProfile model=new DB_Talk.Model.SubscriberProfile();
DataSet ds=DB.OleDbHelper.GetDataSet(strSql.ToString());
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}