📄 airlineorderh.cs.svn-base
字号:
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace Maticsoft.DAL
{
/// <summary>
/// 数据访问类AirlineOrderH。
/// </summary>
public class AirlineOrderH
{
public AirlineOrderH()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from AirlineOrderH");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,50)};
parameters[0].Value = OrderNo;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Maticsoft.Model.AirlineOrderH model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into AirlineOrderH(");
strSql.Append("OrderNo,Airlines,Flights,VenderID,Trip,StartTime,EndTime,PassengersType,PassengersAmount,Rating,Discount,BaseBuildMoney,FuelMoney,FullPrice,AgioPrice,TotalPrice,ManAmount,LinkMan,Phone1,Phone2,Fax,Email,ConfirmMethods,OutVotesType,SendType,PayMethods,Remark,SendAddress,SendDate,CustomerID)");
strSql.Append(" values (");
strSql.Append("@OrderNo,@Airlines,@Flights,@VenderID,@Trip,@StartTime,@EndTime,@PassengersType,@PassengersAmount,@Rating,@Discount,@BaseBuildMoney,@FuelMoney,@FullPrice,@AgioPrice,@TotalPrice,@ManAmount,@LinkMan,@Phone1,@Phone2,@Fax,@Email,@ConfirmMethods,@OutVotesType,@SendType,@PayMethods,@Remark,@SendAddress,@SendDate,@CustomerID)");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,15),
new SqlParameter("@Airlines", SqlDbType.NVarChar,100),
new SqlParameter("@Flights", SqlDbType.NVarChar,50),
new SqlParameter("@VenderID", SqlDbType.NVarChar,12),
new SqlParameter("@Trip", SqlDbType.NVarChar,20),
new SqlParameter("@StartTime", SqlDbType.NVarChar,20),
new SqlParameter("@EndTime", SqlDbType.NVarChar,20),
new SqlParameter("@PassengersType", SqlDbType.NVarChar,10),
new SqlParameter("@PassengersAmount", SqlDbType.Int,4),
new SqlParameter("@Rating", SqlDbType.NVarChar,10),
new SqlParameter("@Discount", SqlDbType.Decimal,9),
new SqlParameter("@BaseBuildMoney", SqlDbType.Decimal,9),
new SqlParameter("@FuelMoney", SqlDbType.Decimal,9),
new SqlParameter("@FullPrice", SqlDbType.Decimal,9),
new SqlParameter("@AgioPrice", SqlDbType.Decimal,9),
new SqlParameter("@TotalPrice", SqlDbType.Decimal,9),
new SqlParameter("@ManAmount", SqlDbType.Int,4),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,15),
new SqlParameter("@Phone1", SqlDbType.NVarChar,30),
new SqlParameter("@Phone2", SqlDbType.NVarChar,30),
new SqlParameter("@Fax", SqlDbType.NVarChar,20),
new SqlParameter("@Email", SqlDbType.NVarChar,30),
new SqlParameter("@ConfirmMethods", SqlDbType.NVarChar,20),
new SqlParameter("@OutVotesType", SqlDbType.NVarChar,10),
new SqlParameter("@SendType", SqlDbType.NVarChar,10),
new SqlParameter("@PayMethods", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.Text),
new SqlParameter("@SendAddress", SqlDbType.NVarChar,50),
new SqlParameter("@SendDate", SqlDbType.NVarChar,20),
new SqlParameter("@CustomerID", SqlDbType.NVarChar,12)};
parameters[0].Value = model.OrderNo;
parameters[1].Value = model.Airlines;
parameters[2].Value = model.Flights;
parameters[3].Value = model.VenderID;
parameters[4].Value = model.Trip;
parameters[5].Value = model.StartTime;
parameters[6].Value = model.EndTime;
parameters[7].Value = model.PassengersType;
parameters[8].Value = model.PassengersAmount;
parameters[9].Value = model.Rating;
parameters[10].Value = model.Discount;
parameters[11].Value = model.BaseBuildMoney;
parameters[12].Value = model.FuelMoney;
parameters[13].Value = model.FullPrice;
parameters[14].Value = model.AgioPrice;
parameters[15].Value = model.TotalPrice;
parameters[16].Value = model.ManAmount;
parameters[17].Value = model.LinkMan;
parameters[18].Value = model.Phone1;
parameters[19].Value = model.Phone2;
parameters[20].Value = model.Fax;
parameters[21].Value = model.Email;
parameters[22].Value = model.ConfirmMethods;
parameters[23].Value = model.OutVotesType;
parameters[24].Value = model.SendType;
parameters[25].Value = model.PayMethods;
parameters[26].Value = model.Remark;
parameters[27].Value = model.SendAddress;
parameters[28].Value = model.SendDate;
parameters[29].Value = model.CustomerID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.AirlineOrderH model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update AirlineOrderH set ");
strSql.Append("Airlines=@Airlines,");
strSql.Append("Flights=@Flights,");
strSql.Append("VenderID=@VenderID,");
strSql.Append("Trip=@Trip,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("PassengersType=@PassengersType,");
strSql.Append("PassengersAmount=@PassengersAmount,");
strSql.Append("Rating=@Rating,");
strSql.Append("Discount=@Discount,");
strSql.Append("BaseBuildMoney=@BaseBuildMoney,");
strSql.Append("FuelMoney=@FuelMoney,");
strSql.Append("FullPrice=@FullPrice,");
strSql.Append("AgioPrice=@AgioPrice,");
strSql.Append("TotalPrice=@TotalPrice,");
strSql.Append("ManAmount=@ManAmount,");
strSql.Append("LinkMan=@LinkMan,");
strSql.Append("Phone1=@Phone1,");
strSql.Append("Phone2=@Phone2,");
strSql.Append("Fax=@Fax,");
strSql.Append("Email=@Email,");
strSql.Append("ConfirmMethods=@ConfirmMethods,");
strSql.Append("OutVotesType=@OutVotesType,");
strSql.Append("SendType=@SendType,");
strSql.Append("PayMethods=@PayMethods,");
strSql.Append("Remark=@Remark,");
strSql.Append("SendAddress=@SendAddress,");
strSql.Append("SendDate=@SendDate,");
strSql.Append("CustomerID=@CustomerID");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,15),
new SqlParameter("@Airlines", SqlDbType.NVarChar,100),
new SqlParameter("@Flights", SqlDbType.NVarChar,50),
new SqlParameter("@VenderID", SqlDbType.NVarChar,12),
new SqlParameter("@Trip", SqlDbType.NVarChar,20),
new SqlParameter("@StartTime", SqlDbType.NVarChar,20),
new SqlParameter("@EndTime", SqlDbType.NVarChar,20),
new SqlParameter("@PassengersType", SqlDbType.NVarChar,10),
new SqlParameter("@PassengersAmount", SqlDbType.Int,4),
new SqlParameter("@Rating", SqlDbType.NVarChar,10),
new SqlParameter("@Discount", SqlDbType.Decimal,9),
new SqlParameter("@BaseBuildMoney", SqlDbType.Decimal,9),
new SqlParameter("@FuelMoney", SqlDbType.Decimal,9),
new SqlParameter("@FullPrice", SqlDbType.Decimal,9),
new SqlParameter("@AgioPrice", SqlDbType.Decimal,9),
new SqlParameter("@TotalPrice", SqlDbType.Decimal,9),
new SqlParameter("@ManAmount", SqlDbType.Int,4),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,15),
new SqlParameter("@Phone1", SqlDbType.NVarChar,30),
new SqlParameter("@Phone2", SqlDbType.NVarChar,30),
new SqlParameter("@Fax", SqlDbType.NVarChar,20),
new SqlParameter("@Email", SqlDbType.NVarChar,30),
new SqlParameter("@ConfirmMethods", SqlDbType.NVarChar,20),
new SqlParameter("@OutVotesType", SqlDbType.NVarChar,10),
new SqlParameter("@SendType", SqlDbType.NVarChar,10),
new SqlParameter("@PayMethods", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.Text),
new SqlParameter("@SendAddress", SqlDbType.NVarChar,50),
new SqlParameter("@SendDate", SqlDbType.NVarChar,20),
new SqlParameter("@CustomerID", SqlDbType.NVarChar,12)};
parameters[0].Value = model.OrderNo;
parameters[1].Value = model.Airlines;
parameters[2].Value = model.Flights;
parameters[3].Value = model.VenderID;
parameters[4].Value = model.Trip;
parameters[5].Value = model.StartTime;
parameters[6].Value = model.EndTime;
parameters[7].Value = model.PassengersType;
parameters[8].Value = model.PassengersAmount;
parameters[9].Value = model.Rating;
parameters[10].Value = model.Discount;
parameters[11].Value = model.BaseBuildMoney;
parameters[12].Value = model.FuelMoney;
parameters[13].Value = model.FullPrice;
parameters[14].Value = model.AgioPrice;
parameters[15].Value = model.TotalPrice;
parameters[16].Value = model.ManAmount;
parameters[17].Value = model.LinkMan;
parameters[18].Value = model.Phone1;
parameters[19].Value = model.Phone2;
parameters[20].Value = model.Fax;
parameters[21].Value = model.Email;
parameters[22].Value = model.ConfirmMethods;
parameters[23].Value = model.OutVotesType;
parameters[24].Value = model.SendType;
parameters[25].Value = model.PayMethods;
parameters[26].Value = model.Remark;
parameters[27].Value = model.SendAddress;
parameters[28].Value = model.SendDate;
parameters[29].Value = model.CustomerID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete AirlineOrderH ");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,50)};
parameters[0].Value = OrderNo;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.AirlineOrderH GetModel(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select OrderNo,Airlines,Flights,VenderID,Trip,StartTime,EndTime,PassengersType,PassengersAmount,Rating,Discount,BaseBuildMoney,FuelMoney,FullPrice,AgioPrice,TotalPrice,ManAmount,LinkMan,Phone1,Phone2,Fax,Email,ConfirmMethods,OutVotesType,SendType,PayMethods,Remark,SendAddress,SendDate,CustomerID from AirlineOrderH ");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,50)};
parameters[0].Value = OrderNo;
Maticsoft.Model.AirlineOrderH model=new Maticsoft.Model.AirlineOrderH();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
model.OrderNo=ds.Tables[0].Rows[0]["OrderNo"].ToString();
model.Airlines=ds.Tables[0].Rows[0]["Airlines"].ToString();
model.Flights=ds.Tables[0].Rows[0]["Flights"].ToString();
model.VenderID=ds.Tables[0].Rows[0]["VenderID"].ToString();
model.Trip=ds.Tables[0].Rows[0]["Trip"].ToString();
model.StartTime=ds.Tables[0].Rows[0]["StartTime"].ToString();
model.EndTime=ds.Tables[0].Rows[0]["EndTime"].ToString();
model.PassengersType=ds.Tables[0].Rows[0]["PassengersType"].ToString();
if(ds.Tables[0].Rows[0]["PassengersAmount"].ToString()!="")
{
model.PassengersAmount=int.Parse(ds.Tables[0].Rows[0]["PassengersAmount"].ToString());
}
model.Rating=ds.Tables[0].Rows[0]["Rating"].ToString();
if(ds.Tables[0].Rows[0]["Discount"].ToString()!="")
{
model.Discount=decimal.Parse(ds.Tables[0].Rows[0]["Discount"].ToString());
}
if(ds.Tables[0].Rows[0]["BaseBuildMoney"].ToString()!="")
{
model.BaseBuildMoney=decimal.Parse(ds.Tables[0].Rows[0]["BaseBuildMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["FuelMoney"].ToString()!="")
{
model.FuelMoney=decimal.Parse(ds.Tables[0].Rows[0]["FuelMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["FullPrice"].ToString()!="")
{
model.FullPrice=decimal.Parse(ds.Tables[0].Rows[0]["FullPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["AgioPrice"].ToString()!="")
{
model.AgioPrice=decimal.Parse(ds.Tables[0].Rows[0]["AgioPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["TotalPrice"].ToString()!="")
{
model.TotalPrice=decimal.Parse(ds.Tables[0].Rows[0]["TotalPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["ManAmount"].ToString()!="")
{
model.ManAmount=int.Parse(ds.Tables[0].Rows[0]["ManAmount"].ToString());
}
model.LinkMan=ds.Tables[0].Rows[0]["LinkMan"].ToString();
model.Phone1=ds.Tables[0].Rows[0]["Phone1"].ToString();
model.Phone2=ds.Tables[0].Rows[0]["Phone2"].ToString();
model.Fax=ds.Tables[0].Rows[0]["Fax"].ToString();
model.Email=ds.Tables[0].Rows[0]["Email"].ToString();
model.ConfirmMethods=ds.Tables[0].Rows[0]["ConfirmMethods"].ToString();
model.OutVotesType=ds.Tables[0].Rows[0]["OutVotesType"].ToString();
model.SendType=ds.Tables[0].Rows[0]["SendType"].ToString();
model.PayMethods=ds.Tables[0].Rows[0]["PayMethods"].ToString();
model.Remark=ds.Tables[0].Rows[0]["Remark"].ToString();
model.SendAddress=ds.Tables[0].Rows[0]["SendAddress"].ToString();
model.SendDate=ds.Tables[0].Rows[0]["SendDate"].ToString();
model.CustomerID=ds.Tables[0].Rows[0]["CustomerID"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select OrderNo,Airlines,Flights,VenderID,Trip,StartTime,EndTime,PassengersType,PassengersAmount,Rating,Discount,BaseBuildMoney,FuelMoney,FullPrice,AgioPrice,TotalPrice,ManAmount,LinkMan,Phone1,Phone2,Fax,Email,ConfirmMethods,OutVotesType,SendType,PayMethods,Remark,SendAddress,SendDate,CustomerID ");
strSql.Append(" FROM AirlineOrderH ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "AirlineOrderH";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -