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