Compare data between Solr and DB
@*@Styles.Render("~/css")*@
@Scripts.Render("~/bundles/BootStrap")
@Scripts.Render("~/bundles/Scripts")
.pre-Scrollable {
max-height: 700px;
overflow-y: scroll;
}
Compare Data Between Solr and DB
IsMarried:
@Html.DropDownList("ddlMarried", ViewBag.MarriedList as SelectList, null, new { id = "ddlMarried", @class = "form-control" })
BirthDay:
-
Name:
@{Html.RenderPartial("~/Views/Partial/UserInfoPartial.cshtml");}
@{Html.RenderPartial("~/Views/Partial/DiffAndSameWithSolrPartial.cshtml");}
OK，在这我碰到一个问题，就是我的css通过这种方式引用，始终提示Index out of range。如果哪位大牛知道原因的话麻烦留个言，谢谢！
OK，我们接下来看一下控制器代码，页面刚进来，会走Home/Index。
public ActionResult Index()
{
List
首先我们构造了一个SelectList用于下拉列表，Biz层的代码很简单
public dynamic GetMarriedList()
{
IList
用匿名类去构造一个List。接下来就是DataReponse的获取，Biz层的代码如下
public DataResponse GetUserInfoEntityList(UserInfoRequest request = null)
{
if(request==null)
{
request = new UserInfoRequest();
request.PageIndex = ConstValues.CONN_DefaultPageIndex;
request.PageSize = ConstValues.CONN_DefaultPageSize;
}
int totalCount=0;
List userDBEntityList = GRLCDAL.GetInstance().GetUserInfoEntityList(request, out totalCount);
DataResponse dataResponse = new DataResponse();
dataResponse.DataList = userDBEntityList;
dataResponse.TotalCount = totalCount;
return dataResponse;
}
没什么可说的，ConstValues类中是一些静态只读属性
public class ConstValues
{
public static readonly string CON_DBConnection = ConfigurationManager.ConnectionStrings["DB_ConnectionStr"].ToString();
public static readonly string CON_DbScriptXmlFolder = ConfigurationManager.AppSettings["DbScriptXmlFolder"];
public static readonly int CONN_DefaultPageSize = int.Parse(ConfigurationManager.AppSettings["DefaultPageSize"]);
public static readonly int CONN_DefaultPageIndex = 1;
public static readonly int CONN_PagerDisplayCount = int.Parse(ConfigurationManager.AppSettings["PagerDisplayCount"]);
}
看一下DAL层。
public List GetUserInfoEntityList(UserInfoRequest request, out int totalCount)
{
totalCount = 0;
string sqlScript = string.Empty;
try
{
sqlScript = DBScriptManager.GetScript(this.GetType(), "GetUserInfo");
SqlParameter[] sqlParameters =
{
new SqlParameter("@IsMarried",SqlDbType.Char,1),
new SqlParameter("@StartDate",SqlDbType.DateTime),
new SqlParameter("@EndDate",SqlDbType.DateTime),
new SqlParameter("@UserName",SqlDbType.NVarChar,20),
new SqlParameter("@PageIndex",SqlDbType.Int),
new SqlParameter("@PageSize",SqlDbType.Int),
new SqlParameter("@TotalCount",SqlDbType.Int)
};
sqlParameters[0].Value = request.IsMarried;
sqlParameters[1].Value = request.StartDate;
sqlParameters[2].Value = request.EndDate;
sqlParameters[3].Value = request.UserName;
sqlParameters[4].Value = request.PageIndex;
sqlParameters[5].Value = request.PageSize;
sqlParameters[6].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(ConstValues.CON_DBConnection, CommandType.Text, sqlScript, sqlParameters);
if (ds != null && ds.Tables.Count > 0)
{
totalCount = Convert.ToInt32(sqlParameters[6].Value);
return ds.Tables[0].ToEntityList();
}
return new List();
}
catch (Exception ex)
{
LogHelper.WriteExceptionLog(MethodBase.GetCurrentMethod(), ex);
return null;
}
}
public static class DataTableToEntityExtension
{
public static List ToEntityList(this DataTable dt) where T : class,new()
{
List entityList = new List();
Type entityType = typeof(T);
PropertyInfo[] propertys = entityType.GetProperties();
DataMappingAttribute mappingAttribute = null;
foreach (DataRow dr in dt.Rows)
{
T tEntity = new T();
foreach (PropertyInfo pi in propertys)
{
mappingAttribute = pi.GetCustomAttribute(typeof(DataMappingAttribute)) as DataMappingAttribute;
if (mappingAttribute != null && dt.Columns.Contains(mappingAttribute.mappingName))
{
if (!pi.CanWrite) continue;
object value = dr[mappingAttribute.mappingName];
if (value != DBNull.Value)
pi.SetValue(tEntity, value, null);
}
}
entityList.Add(tEntity);
}
return entityList;
}
}
namespace Bruce.GRLC.Model.Entity
{
public class UserDBEntity
{
[DataMapping("UseNo", DbType.AnsiString)]
public string UserID { get; set; }
[DataMapping("Name", DbType.AnsiString)]
public string UserName { get; set; }
[DataMapping("Age", DbType.Int32)]
public int Age { get; set; }
[DataMapping("Married", DbType.String)]
public string Married { get; set; }
}
}
