/// <summary> /// 获得数据列表 /// </summary> /// <param name="strWhere">条件</param> /// <returns>OrderDetail集合</returns> public List <ClassLibrary.Model.OrderDetail> GetModelList(string strWhere) { DataTable dt = GetData(strWhere); List <ClassLibrary.Model.OrderDetail> modelList = new List <ClassLibrary.Model.OrderDetail>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ClassLibrary.Model.OrderDetail model; for (int n = 0; n < rowsCount; n++) { model = new ClassLibrary.Model.OrderDetail(); if (dt.Rows[n]["ID"] != DBNull.Value) { model.ID = Convert.ToInt32(dt.Rows[n]["ID"]); } if (dt.Rows[n]["orderNumber"] != DBNull.Value) { model.orderNumber = Convert.ToString(dt.Rows[n]["orderNumber"]); } if (dt.Rows[n]["UserName"] != DBNull.Value) { model.UserName = Convert.ToString(dt.Rows[n]["UserName"]); } if (dt.Rows[n]["routeID"] != DBNull.Value) { model.routeID = Convert.ToInt32(dt.Rows[n]["routeID"]); } if (dt.Rows[n]["Number"] != DBNull.Value) { model.Number = Convert.ToString(dt.Rows[n]["Number"]); } if (dt.Rows[n]["RouteName"] != DBNull.Value) { model.RouteName = Convert.ToString(dt.Rows[n]["RouteName"]); } if (dt.Rows[n]["RoutePrice"] != DBNull.Value) { model.RoutePrice = Convert.ToDecimal(dt.Rows[n]["RoutePrice"]); } if (dt.Rows[n]["RouteTime"] != DBNull.Value) { model.RouteTime = Convert.ToString(dt.Rows[n]["RouteTime"]); } if (dt.Rows[n]["StartTime"] != DBNull.Value) { model.StartTime = Convert.ToString(dt.Rows[n]["StartTime"]); } if (dt.Rows[n]["CreatedTime"] != DBNull.Value) { model.CreatedTime = Convert.ToDateTime(dt.Rows[n]["CreatedTime"]); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model对象</param> public int Add(ClassLibrary.Model.OrderDetail model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model对象</param> /// <returns>影响行数</returns> public int Update(ClassLibrary.Model.OrderDetail model) { return(dal.Update(model)); }