首页 > 解决方案 > 缺少指令或程序集引用

问题描述

我需要检查用户是否选择了消息更改,因为我需要通过传递 id 来获取成员的状态和日期。我缺少程序集参考或指令。我收到错误,因为 SmsStatusResult 不包含状态定义。

模型:

public class SmsStatus
{
   public string Status { get; set; }
   public DateTime OptInDate { get; set; }
} 


public class SmsStatusResult : OperationResult
{
    public SmsStatus SmsStatus { get; set; }
}

方法 :

public static SmsStatusResult GetSmsStatus(string memberNumber)
{
   // string Status = string.Empty, OptInDate = string.Empty;
    var Status = "";
    var OptInDate = "";


    var smsStatusResult = new SmsStatusResult();

    if (!string.IsNullOrEmpty(memberNumber))
    {
        using (
            var connection =
                new OracleConnection(
                    ConfigurationManager.ConnectionStrings["OracleMemberConnectionString"].ConnectionString))
        {
            connection.Open();

            using (
                var command =
                    new OracleCommand(
                        "SELECT sms_status,sms_opt_in_date FROM member WHERE member_nbr = :memberNumber", connection))
            {
                command.Parameters.Add(
                    new OracleParameter(
                        "memberNumber",
                        OracleDbType.Varchar2,
                        memberNumber,
                        ParameterDirection.Input));


                SmsStatusResult data;
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        data = new SmsStatusResult(); 
                        data.Status = reader["sms_status"].ToString(); //SmsStatusResult does not contain definition for status. missing a using directive or assembly reference
                        data.OptInDate = reader["sms_opt_in_date"].ToString(); SmsStatusResult does not contain definition for OptInDate . missing a using directive or assembly reference

                        break;
                    }
                     return data;
                }

            }
        }
    }

标签: asp.netasp.net-mvcweb-serviceswcf

解决方案


推荐阅读