/// <summary>
/// 获取列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.CustomerCareforInfo> GetList(string CompanyId, int PageSize, int PageIndex, ref int RecordCount)
{
string cmdQuery = string.Format(" Companyid={0}", CompanyId);
string tableName = "tbl_CustomerCarefor";
string primaryKey = "Id";
string field = "*";
IList <EyouSoft.Model.CompanyStructure.CustomerCareforInfo> careForList = new List <EyouSoft.Model.CompanyStructure.CustomerCareforInfo>();
EyouSoft.Model.CompanyStructure.CustomerCareforInfo model = null;
using (IDataReader rd = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, field, cmdQuery, "IssueTime desc"))
{
while (rd.Read())
{
model = new CustomerCareforInfo();
model.Id = rd.GetInt32(rd.GetOrdinal("id"));
model.Content = rd.IsDBNull(rd.GetOrdinal("Content")) ? "" : rd.GetString(rd.GetOrdinal("Content"));
model.IsEnabled = rd.GetString(rd.GetOrdinal("IsEnabled")) == "1" ? true : false;
model.IsMatchCustomerInfo = rd.GetString(rd.GetOrdinal("IsMatchCustomerInfo")) == "1" ? true : false;
model.IsMatchDepartmentInfo = rd.GetString(rd.GetOrdinal("IsMatchDepartmentInfo")) == "1" ? true : false;
model.IsMatchSupplierInfo = rd.GetString(rd.GetOrdinal("IsMatchSupplierInfo")) == "1" ? true : false;
model.IsSeded = rd.GetString(rd.GetOrdinal("IsSeded")) == "1" ? true : false;
model.IssueTime = rd.IsDBNull(rd.GetOrdinal("IssueTime")) ? DateTime.Parse("2000-01-01") : rd.GetDateTime(rd.GetOrdinal("IssueTime"));
model.MobileCode = rd.IsDBNull(rd.GetOrdinal("MobileCode")) ?"": rd.GetString(rd.GetOrdinal("MobileCode"));
model.OperatorId = rd.GetInt32(rd.GetOrdinal("OperatorId"));
model.FixType = rd.IsDBNull(rd.GetOrdinal("FixType")) ? EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime.无: (EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime), rd.GetInt32(rd.GetOrdinal("FixType")).ToString());
model.Time = rd.IsDBNull(rd.GetOrdinal("Time")) ? DateTime.Parse("2000-01-01") : rd.GetDateTime(rd.GetOrdinal("Time"));
careForList.Add(model);
}
}
return(careForList);
}
/// <summary>
/// 返回实体
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.CustomerCareforInfo GetModel(int Id)
{
string sql = "select * from tbl_CustomerCarefor where id=@CareForId ";
DbCommand cmd = this._db.GetSqlStringCommand(sql);
this._db.AddInParameter(cmd, "CareForId", DbType.Int32, Id);
EyouSoft.Model.CompanyStructure.CustomerCareforInfo model = null;
using (IDataReader rd = DbHelper.ExecuteReader(cmd, this._db))
{
if (rd.Read())
{
model = new CustomerCareforInfo();
model.ChannelId = rd.IsDBNull(rd.GetOrdinal("ChannelId")) ? 0 : rd.GetInt32(rd.GetOrdinal("ChannelId"));
model.CompanyId = rd.IsDBNull(rd.GetOrdinal("CompanyId")) ? 0 : rd.GetInt32(rd.GetOrdinal("CompanyId"));
model.Content = rd.IsDBNull(rd.GetOrdinal("Content")) ? "" : rd.GetString(rd.GetOrdinal("Content"));
model.FixType = rd.IsDBNull(rd.GetOrdinal("FixType")) ? EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime.无 : (EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime), rd.GetInt32(rd.GetOrdinal("FixType")).ToString());
model.Id = rd.IsDBNull(rd.GetOrdinal("Id")) ? 0 : rd.GetInt32(rd.GetOrdinal("Id"));
model.IsEnabled = rd.IsDBNull(rd.GetOrdinal("IsEnabled")) ? false : rd.GetString(rd.GetOrdinal("IsEnabled")) == "1" ? true : false;
model.IsMatchCustomerInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchCustomerInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchCustomerInfo")) == "1" ? true : false;
model.IsMatchDepartmentInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchDepartmentInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchDepartmentInfo")) == "1" ? true : false;
model.IsMatchSupplierInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchSupplierInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchSupplierInfo")) == "1" ? true : false;
model.IsSeded = rd.IsDBNull(rd.GetOrdinal("IsSeded")) ? false : rd.GetString(rd.GetOrdinal("IsSeded")) == "1" ? true : false;
model.IssueTime = rd.IsDBNull(rd.GetOrdinal("IssueTime")) ? DateTime.Parse("2011-01-28") : rd.GetDateTime(rd.GetOrdinal("IssueTime"));
model.MobileCode = rd.IsDBNull(rd.GetOrdinal("MobileCode")) ? "" : rd.GetString(rd.GetOrdinal("MobileCode"));
model.OperatorId = rd.IsDBNull(rd.GetOrdinal("OperatorId")) ? 0 : rd.GetInt32(rd.GetOrdinal("OperatorId"));
model.Time = rd.IsDBNull(rd.GetOrdinal("Time")) ? DateTime.Parse("2011-01-28") : rd.GetDateTime(rd.GetOrdinal("Time"));
}
}
return(model);
}
