62,046
社区成员
发帖
与我相关
我的任务
分享
public List<TC_TaxiInfo> GetModelBySql(Guid TaxiID)
{
List<TC_TaxiInfo> list = new List<TC_TaxiInfo>();
StringBuilder sbSql = new StringBuilder();
sbSql.Append(@"SELECT TaxiID,TaxiBrandNumdbo.Rpt_GetDictionaryNameSql(CarModels,'TaxiType') CarModels, CMDS_PrivateDictionaryItem.name as TaxiUnit,CertificateTime,ManufactureDate,YearCarefulTime,CertificatePeriod,SeatingNumber,Attach,Picture,Remark,TC_Taxi.OrganiseUnitID,TC_Taxi.CreatedBy,TC_Taxi.CreatedDate,TC_Taxi.ModifiedBy,TC_Taxi.ModifiedDate
FROM [TC_Taxi]
Left join CMDS_Annex on CMDS_Annex.RunningNo=TC_Taxi.Attach
WHERE TaxiID=@TaxiID ");
int n = 0;
SqlParameter[] parameters = {
new SqlParameter("@TaxiID", SqlDbType.UniqueIdentifier)};
parameters[n++].Value = TaxiID;
//执行查询
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.LocalTrafficConnectionString, CommandType.Text, sbSql.ToString(), parameters))
{
while (rdr.Read())
{
TC_TaxiInfo model = new TC_TaxiInfo();
model.TaxiID = (new Guid(rdr[TC_TaxiInfo.TAXIID_FIELD].ToString()));
model.TaxiBrandNum = rdr[TC_TaxiInfo.TAXIBRANDNUM_FIELD].ToString();
model.TaxiCertificate = rdr[TC_TaxiInfo.TAXICERTIFICATE_FIELD].ToString();
model.Name = rdr[TC_TaxiInfo.NAME_FIELD].ToString();
list.Add(model);
}
}
return list;
}
代码类似上面了……
楼主是学生么?SELECT TaxiID,TaxiBrandNum,CMDS_Annex.name as AttachName,url,TaxiCertificate,TC_Taxi.Name,CertificateTime,ManufactureDate,YearCarefulTime,CertificatePeriod,SeatingNumber,Attach,Picture,Remark,TC_Taxi.OrganiseUnitID,TC_Taxi.CreatedBy,TC_Taxi.CreatedDate,TC_Taxi.ModifiedBy,TC_Taxi.ModifiedDate
FROM [TC_Taxi]
Left join CMDS_Annex on CMDS_Annex.RunningNo=TC_Taxi.Attach
WHERE TaxiID='875a3b50-7380-4c2c-99ac-0a066b96b4bf'
public TC_TaxiInfo GetModelBySql(Guid TaxiID)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append(@"SELECT TaxiID,TaxiBrandNumdbo.Rpt_GetDictionaryNameSql(CarModels,'TaxiType') CarModels, CMDS_PrivateDictionaryItem.name as TaxiUnit,CertificateTime,ManufactureDate,YearCarefulTime,CertificatePeriod,SeatingNumber,Attach,Picture,Remark,TC_Taxi.OrganiseUnitID,TC_Taxi.CreatedBy,TC_Taxi.CreatedDate,TC_Taxi.ModifiedBy,TC_Taxi.ModifiedDate
FROM [TC_Taxi]
Left join CMDS_Annex on CMDS_Annex.RunningNo=TC_Taxi.Attach
WHERE TaxiID=@TaxiID ");
int n = 0;
SqlParameter[] parameters = {
new SqlParameter("@TaxiID", SqlDbType.UniqueIdentifier)};
parameters[n++].Value = TaxiID;
TC_TaxiInfo model = null;
//执行查询
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.LocalTrafficConnectionString, CommandType.Text, sbSql.ToString(), parameters))
{
model = new TC_TaxiInfo();
if (rdr.Read())
{
model.TaxiID = (new Guid(rdr[TC_TaxiInfo.TAXIID_FIELD].ToString()));
model.TaxiBrandNum = rdr[TC_TaxiInfo.TAXIBRANDNUM_FIELD].ToString();
model.TaxiCertificate = rdr[TC_TaxiInfo.TAXICERTIFICATE_FIELD].ToString();
model.Name = rdr[TC_TaxiInfo.NAME_FIELD].ToString();
}
}
return model;
}
请问我这段代码怎么改?我从A表查出所有信息,其中有字段RunningNo,然后我根据RunningNo查询Attachmentde的信息,但是我的方法只能返回一个实体类,就是除了附件的字段为两个,sql语句应该怎么改,实体类怎么改?
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Panel ID="pnlContainer" runat="server">
</asp:Panel>
</form>
</body>
</html>
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
List<Attachment> list = GetList();
if (list != null && list.Count > 0)
{
foreach (Attachment item in list)
{
//加入链接
HyperLink link = new HyperLink();
link.Text = item.Name;
link.NavigateUrl = item.Url;
this.pnlContainer.Controls.Add(link);
//加一个回车, 没有别的用意, 只为分开两者, 更显眼
Literal lt = new Literal();
lt.Text = "<br/>";
this.pnlContainer.Controls.Add(lt);
}
}
}
}
public List<Attachment> GetList()
{
List<Attachment> list = new List<Attachment>()
{
new Attachment(){ Name="百度", Url="http://www.baidu.com" },
new Attachment(){ Name="新浪", Url="http://www.sina.com" }
};
return list;
}
}
public class Attachment
{
public string Name { get; set; }
public string Url { get; set; }
}
}
public TC_TaxiInfo GetModelBySql(Guid TaxiID)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append(@"SELECT TaxiID,TaxiBrandNumdbo.Rpt_GetDictionaryNameSql(CarModels,'TaxiType') CarModels, CMDS_PrivateDictionaryItem.name as TaxiUnit,CertificateTime,ManufactureDate,YearCarefulTime,CertificatePeriod,SeatingNumber,Attach,Picture,Remark,TC_Taxi.OrganiseUnitID,TC_Taxi.CreatedBy,TC_Taxi.CreatedDate,TC_Taxi.ModifiedBy,TC_Taxi.ModifiedDate
FROM [TC_Taxi]
Left join CMDS_Annex on CMDS_Annex.RunningNo=TC_Taxi.Attach
WHERE TaxiID=@TaxiID ");
int n = 0;
SqlParameter[] parameters = {
new SqlParameter("@TaxiID", SqlDbType.UniqueIdentifier)};
parameters[n++].Value = TaxiID;
TC_TaxiInfo model = null;
//执行查询
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.LocalTrafficConnectionString, CommandType.Text, sbSql.ToString(), parameters))
{
model = new TC_TaxiInfo();
if (rdr.Read())
{
model.TaxiID = (new Guid(rdr[TC_TaxiInfo.TAXIID_FIELD].ToString()));
model.TaxiBrandNum = rdr[TC_TaxiInfo.TAXIBRANDNUM_FIELD].ToString();
model.TaxiCertificate = rdr[TC_TaxiInfo.TAXICERTIFICATE_FIELD].ToString();
model.Name = rdr[TC_TaxiInfo.NAME_FIELD].ToString();
}
}
return model;
}