public static Object getAdviserMessage(string AU_AD_Code)
{
BL_Advisers Adviser = new BL_Advisers();
MD_Adviser Ad = Adviser.getAdviserMessage(int.Parse(AU_AD_Code));
return(Ad);
}
/// <summary>
/// 获取顾问的联系信息
/// </summary>
/// <param name="AU_Code"></param>
/// <returns></returns>
public MD_Adviser getAdviserMessage(int AU_Code)
{
SqlParameter[] parameters = { new SqlParameter("@AU_Code", SqlDbType.Int) };
parameters[0].Value = AU_Code;
DataSet ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "AD_getAdviserMessage", parameters);
DataTable DT = new DataTable();
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
DT = ds.Tables[0];
MD_Adviser myAdvise = new MD_Adviser();
myAdvise.Mobil = DT.Rows[0]["Mobil"].ToString();
myAdvise.Office = DT.Rows[0]["Office"].ToString();
myAdvise.DealerShip = DT.Rows[0]["DealerShip"].ToString();
myAdvise.Address = DT.Rows[0]["Address"].ToString();
myAdvise.Email = DT.Rows[0]["Email"].ToString();
return(myAdvise);
}
