📄 tourismproorderh.cs.svn-base
字号:
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace Maticsoft.DAL
{
/// <summary>
/// 数据访问类TourismProOrderH。
/// </summary>
public class TourismProOrderH
{
public TourismProOrderH()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from TourismProOrderH");
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.TourismProOrderH model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TourismProOrderH(");
strSql.Append("OrderNo,LinesProID,CustomerID,ManAmount,Children,Receivable,PayMoney,Balance,OrderType,OrderStates,ConfirmUserID,ConfirmDate,AccountConfirmUserID,AccountConfirmDate,PlanConfirmUserID,PlanConfirmDate,SingleRoomAmount,SumAddPrice,RoomAmount,LinkMan,Phone1,Phone2,Address,Postcode,Remark)");
strSql.Append(" values (");
strSql.Append("@OrderNo,@LinesProID,@CustomerID,@ManAmount,@Children,@Receivable,@PayMoney,@Balance,@OrderType,@OrderStates,@ConfirmUserID,@ConfirmDate,@AccountConfirmUserID,@AccountConfirmDate,@PlanConfirmUserID,@PlanConfirmDate,@SingleRoomAmount,@SumAddPrice,@RoomAmount,@LinkMan,@Phone1,@Phone2,@Address,@Postcode,@Remark)");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,20),
new SqlParameter("@LinesProID", SqlDbType.NVarChar,12),
new SqlParameter("@CustomerID", SqlDbType.NVarChar,12),
new SqlParameter("@ManAmount", SqlDbType.Int,4),
new SqlParameter("@Children", SqlDbType.Int,4),
new SqlParameter("@Receivable", SqlDbType.Decimal,9),
new SqlParameter("@PayMoney", SqlDbType.Decimal,9),
new SqlParameter("@Balance", SqlDbType.Decimal,9),
new SqlParameter("@OrderType", SqlDbType.NVarChar,10),
new SqlParameter("@OrderStates", SqlDbType.Int,4),
new SqlParameter("@ConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@ConfirmDate", SqlDbType.DateTime),
new SqlParameter("@AccountConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@AccountConfirmDate", SqlDbType.DateTime),
new SqlParameter("@PlanConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@PlanConfirmDate", SqlDbType.DateTime),
new SqlParameter("@SingleRoomAmount", SqlDbType.Int,4),
new SqlParameter("@SumAddPrice", SqlDbType.Decimal,9),
new SqlParameter("@RoomAmount", SqlDbType.Int,4),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,15),
new SqlParameter("@Phone1", SqlDbType.NVarChar,30),
new SqlParameter("@Phone2", SqlDbType.NVarChar,30),
new SqlParameter("@Address", SqlDbType.NVarChar,50),
new SqlParameter("@Postcode", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.Text)};
parameters[0].Value = model.OrderNo;
parameters[1].Value = model.LinesProID;
parameters[2].Value = model.CustomerID;
parameters[3].Value = model.ManAmount;
parameters[4].Value = model.Children;
parameters[5].Value = model.Receivable;
parameters[6].Value = model.PayMoney;
parameters[7].Value = model.Balance;
parameters[8].Value = model.OrderType;
parameters[9].Value = model.OrderStates;
parameters[10].Value = model.ConfirmUserID;
parameters[11].Value = model.ConfirmDate;
parameters[12].Value = model.AccountConfirmUserID;
parameters[13].Value = model.AccountConfirmDate;
parameters[14].Value = model.PlanConfirmUserID;
parameters[15].Value = model.PlanConfirmDate;
parameters[16].Value = model.SingleRoomAmount;
parameters[17].Value = model.SumAddPrice;
parameters[18].Value = model.RoomAmount;
parameters[19].Value = model.LinkMan;
parameters[20].Value = model.Phone1;
parameters[21].Value = model.Phone2;
parameters[22].Value = model.Address;
parameters[23].Value = model.Postcode;
parameters[24].Value = model.Remark;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.TourismProOrderH model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update TourismProOrderH set ");
strSql.Append("LinesProID=@LinesProID,");
strSql.Append("CustomerID=@CustomerID,");
strSql.Append("ManAmount=@ManAmount,");
strSql.Append("Children=@Children,");
strSql.Append("Receivable=@Receivable,");
strSql.Append("PayMoney=@PayMoney,");
strSql.Append("Balance=@Balance,");
strSql.Append("OrderType=@OrderType,");
strSql.Append("OrderStates=@OrderStates,");
strSql.Append("ConfirmUserID=@ConfirmUserID,");
strSql.Append("ConfirmDate=@ConfirmDate,");
strSql.Append("AccountConfirmUserID=@AccountConfirmUserID,");
strSql.Append("AccountConfirmDate=@AccountConfirmDate,");
strSql.Append("PlanConfirmUserID=@PlanConfirmUserID,");
strSql.Append("PlanConfirmDate=@PlanConfirmDate,");
strSql.Append("SingleRoomAmount=@SingleRoomAmount,");
strSql.Append("SumAddPrice=@SumAddPrice,");
strSql.Append("RoomAmount=@RoomAmount,");
strSql.Append("LinkMan=@LinkMan,");
strSql.Append("Phone1=@Phone1,");
strSql.Append("Phone2=@Phone2,");
strSql.Append("Address=@Address,");
strSql.Append("Postcode=@Postcode,");
strSql.Append("Remark=@Remark");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,20),
new SqlParameter("@LinesProID", SqlDbType.NVarChar,12),
new SqlParameter("@CustomerID", SqlDbType.NVarChar,12),
new SqlParameter("@ManAmount", SqlDbType.Int,4),
new SqlParameter("@Children", SqlDbType.Int,4),
new SqlParameter("@Receivable", SqlDbType.Decimal,9),
new SqlParameter("@PayMoney", SqlDbType.Decimal,9),
new SqlParameter("@Balance", SqlDbType.Decimal,9),
new SqlParameter("@OrderType", SqlDbType.NVarChar,10),
new SqlParameter("@OrderStates", SqlDbType.Int,4),
new SqlParameter("@ConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@ConfirmDate", SqlDbType.DateTime),
new SqlParameter("@AccountConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@AccountConfirmDate", SqlDbType.DateTime),
new SqlParameter("@PlanConfirmUserID", SqlDbType.NVarChar,12),
new SqlParameter("@PlanConfirmDate", SqlDbType.DateTime),
new SqlParameter("@SingleRoomAmount", SqlDbType.Int,4),
new SqlParameter("@SumAddPrice", SqlDbType.Decimal,9),
new SqlParameter("@RoomAmount", SqlDbType.Int,4),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,15),
new SqlParameter("@Phone1", SqlDbType.NVarChar,30),
new SqlParameter("@Phone2", SqlDbType.NVarChar,30),
new SqlParameter("@Address", SqlDbType.NVarChar,50),
new SqlParameter("@Postcode", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.Text)};
parameters[0].Value = model.OrderNo;
parameters[1].Value = model.LinesProID;
parameters[2].Value = model.CustomerID;
parameters[3].Value = model.ManAmount;
parameters[4].Value = model.Children;
parameters[5].Value = model.Receivable;
parameters[6].Value = model.PayMoney;
parameters[7].Value = model.Balance;
parameters[8].Value = model.OrderType;
parameters[9].Value = model.OrderStates;
parameters[10].Value = model.ConfirmUserID;
parameters[11].Value = model.ConfirmDate;
parameters[12].Value = model.AccountConfirmUserID;
parameters[13].Value = model.AccountConfirmDate;
parameters[14].Value = model.PlanConfirmUserID;
parameters[15].Value = model.PlanConfirmDate;
parameters[16].Value = model.SingleRoomAmount;
parameters[17].Value = model.SumAddPrice;
parameters[18].Value = model.RoomAmount;
parameters[19].Value = model.LinkMan;
parameters[20].Value = model.Phone1;
parameters[21].Value = model.Phone2;
parameters[22].Value = model.Address;
parameters[23].Value = model.Postcode;
parameters[24].Value = model.Remark;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete TourismProOrderH ");
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.TourismProOrderH GetModel(string OrderNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select OrderNo,LinesProID,CustomerID,ManAmount,Children,Receivable,PayMoney,Balance,OrderType,OrderStates,ConfirmUserID,ConfirmDate,AccountConfirmUserID,AccountConfirmDate,PlanConfirmUserID,PlanConfirmDate,SingleRoomAmount,SumAddPrice,RoomAmount,LinkMan,Phone1,Phone2,Address,Postcode,Remark from TourismProOrderH ");
strSql.Append(" where OrderNo=@OrderNo ");
SqlParameter[] parameters = {
new SqlParameter("@OrderNo", SqlDbType.NVarChar,50)};
parameters[0].Value = OrderNo;
Maticsoft.Model.TourismProOrderH model=new Maticsoft.Model.TourismProOrderH();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
model.OrderNo=ds.Tables[0].Rows[0]["OrderNo"].ToString();
model.LinesProID=ds.Tables[0].Rows[0]["LinesProID"].ToString();
model.CustomerID=ds.Tables[0].Rows[0]["CustomerID"].ToString();
if(ds.Tables[0].Rows[0]["ManAmount"].ToString()!="")
{
model.ManAmount=int.Parse(ds.Tables[0].Rows[0]["ManAmount"].ToString());
}
if(ds.Tables[0].Rows[0]["Children"].ToString()!="")
{
model.Children=int.Parse(ds.Tables[0].Rows[0]["Children"].ToString());
}
if(ds.Tables[0].Rows[0]["Receivable"].ToString()!="")
{
model.Receivable=decimal.Parse(ds.Tables[0].Rows[0]["Receivable"].ToString());
}
if(ds.Tables[0].Rows[0]["PayMoney"].ToString()!="")
{
model.PayMoney=decimal.Parse(ds.Tables[0].Rows[0]["PayMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["Balance"].ToString()!="")
{
model.Balance=decimal.Parse(ds.Tables[0].Rows[0]["Balance"].ToString());
}
model.OrderType=ds.Tables[0].Rows[0]["OrderType"].ToString();
if(ds.Tables[0].Rows[0]["OrderStates"].ToString()!="")
{
model.OrderStates=int.Parse(ds.Tables[0].Rows[0]["OrderStates"].ToString());
}
model.ConfirmUserID=ds.Tables[0].Rows[0]["ConfirmUserID"].ToString();
if(ds.Tables[0].Rows[0]["ConfirmDate"].ToString()!="")
{
model.ConfirmDate=DateTime.Parse(ds.Tables[0].Rows[0]["ConfirmDate"].ToString());
}
model.AccountConfirmUserID=ds.Tables[0].Rows[0]["AccountConfirmUserID"].ToString();
if(ds.Tables[0].Rows[0]["AccountConfirmDate"].ToString()!="")
{
model.AccountConfirmDate=DateTime.Parse(ds.Tables[0].Rows[0]["AccountConfirmDate"].ToString());
}
model.PlanConfirmUserID=ds.Tables[0].Rows[0]["PlanConfirmUserID"].ToString();
if(ds.Tables[0].Rows[0]["PlanConfirmDate"].ToString()!="")
{
model.PlanConfirmDate=DateTime.Parse(ds.Tables[0].Rows[0]["PlanConfirmDate"].ToString());
}
if(ds.Tables[0].Rows[0]["SingleRoomAmount"].ToString()!="")
{
model.SingleRoomAmount=int.Parse(ds.Tables[0].Rows[0]["SingleRoomAmount"].ToString());
}
if(ds.Tables[0].Rows[0]["SumAddPrice"].ToString()!="")
{
model.SumAddPrice=decimal.Parse(ds.Tables[0].Rows[0]["SumAddPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["RoomAmount"].ToString()!="")
{
model.RoomAmount=int.Parse(ds.Tables[0].Rows[0]["RoomAmount"].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.Address=ds.Tables[0].Rows[0]["Address"].ToString();
model.Postcode=ds.Tables[0].Rows[0]["Postcode"].ToString();
model.Remark=ds.Tables[0].Rows[0]["Remark"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select OrderNo,LinesProID,CustomerID,ManAmount,Children,Receivable,PayMoney,Balance,OrderType,OrderStates,ConfirmUserID,ConfirmDate,AccountConfirmUserID,AccountConfirmDate,PlanConfirmUserID,PlanConfirmDate,SingleRoomAmount,SumAddPrice,RoomAmount,LinkMan,Phone1,Phone2,Address,Postcode,Remark ");
strSql.Append(" FROM TourismProOrderH ");
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 = "TourismProOrderH";
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 + -