using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Data.Common;
using
System.Text;
using
DBUtility;
namespace
DAL
{
/// <summary>
/// 数据访问类 TVisit ,此类请勿动,以方便表字段更改时重新生成覆盖
/// </summary>
public
partial
class
TVisitDAL
{
internal
const
string
COMMAND_ADD =
"sp_TVisit_Add"
;
internal
const
string
COMMAND_UPDATE =
"sp_TVisit_Update"
;
internal
const
string
COMMAND_DELETE =
"sp_TVisit_Delete"
;
internal
const
string
COMMAND_EXISTS =
"sp_TVisit_Exists"
;
internal
const
string
COMMAND_GETMODEL =
"sp_TVisit_GetModel"
;
internal
const
string
COMMAND_GETCOUNT =
"sp_TVisit_GetCount"
;
internal
const
string
COMMAND_GETLIST =
"sp_TVisit_GetAllList"
;
internal
const
string
PARM_VISITID =
"@in_VisitId"
;
internal
const
string
PARM_VISITTIME =
"@in_VisitTime"
;
internal
const
string
PARM_VISITCUSTOMER =
"@in_VisitCustomer"
;
internal
const
string
PARM_VISITWAY =
"@in_VisitWay"
;
internal
const
string
PARM_VISITCONTENT =
"@in_VisitContent"
;
internal
const
string
PARM_VISITOR =
"@in_Visitor"
;
internal
const
string
PARM_FREMARK =
"@in_FRemark"
;
internal
const
string
PARM_FSORT =
"@in_FSort"
;
internal
const
string
PARM_FISDELETE =
"@in_FIsDelete"
;
internal
const
string
PARM_FCREATOR =
"@in_FCreator"
;
internal
const
string
PARM_FCREATEDATE =
"@in_FCreateDate"
;
internal
const
string
PARM_FMODIFY =
"@in_FModify"
;
internal
const
string
PARM_FMODIFYDATE =
"@in_FModifyDate"
;
internal
const
string
PARM_FGUID =
"@in_FGUID"
;
internal
const
string
PARM_FISSYNCHRONOUS =
"@in_FIsSynchronous"
;
/// <summary>
/// 为新增一条数据准备参数
/// </summary>
internal
static
IDbDataParameter[] PrepareAddParameters(Model.TVisitModel model)
{
IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_ADD);
if
(parms ==
null
)
{
parms =
new
IDbDataParameter[]{
dbHelper.CreateDbParameter(PARM_VISITTIME, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITCUSTOMER, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITWAY, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITCONTENT, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITOR, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FREMARK, DbType.String, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FSORT, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FISDELETE, DbType.Boolean, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FCREATOR, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FCREATEDATE, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FMODIFY, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FMODIFYDATE, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FGUID, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FISSYNCHRONOUS, DbType.Boolean, ParameterDirection.Input)};
DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_ADD, parms);
}
parms[0].Value = model.VisitTime;
parms[1].Value = model.VisitCustomer;
parms[2].Value = model.VisitWay;
parms[3].Value = model.VisitContent;
parms[4].Value = model.Visitor;
parms[5].Value = model.FRemark;
parms[6].Value = model.FSort;
parms[7].Value = model.FIsDelete;
parms[8].Value = model.FCreator;
parms[9].Value = model.FCreateDate;
parms[10].Value = model.FModify;
parms[11].Value = model.FModifyDate;
parms[12].Value = model.FGUID;
parms[13].Value = model.FIsSynchronous;
return
parms;
}
/// <summary>
/// 为更新一条数据准备参数
/// </summary>
internal
static
IDbDataParameter[] PrepareUpdateParameters(Model.TVisitModel model)
{
IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_UPDATE);
if
(parms ==
null
)
{
parms =
new
IDbDataParameter[]{
dbHelper.CreateDbParameter(PARM_VISITTIME, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITCUSTOMER, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITWAY, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITCONTENT, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITOR, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FREMARK, DbType.String, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FSORT, DbType.Int32, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FISDELETE, DbType.Boolean, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FCREATOR, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FCREATEDATE, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FMODIFY, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FMODIFYDATE, DbType.DateTime, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FGUID, DbType.AnsiString, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_FISSYNCHRONOUS, DbType.Boolean, ParameterDirection.Input),
dbHelper.CreateDbParameter(PARM_VISITID, DbType.Int32, ParameterDirection.Input)};
DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_UPDATE, parms);
}
parms[0].Value = model.VisitTime;
parms[1].Value = model.VisitCustomer;
parms[2].Value = model.VisitWay;
parms[3].Value = model.VisitContent;
parms[4].Value = model.Visitor;
parms[5].Value = model.FRemark;
parms[6].Value = model.FSort;
parms[7].Value = model.FIsDelete;
parms[8].Value = model.FCreator;
parms[9].Value = model.FCreateDate;
parms[10].Value = model.FModify;
parms[11].Value = model.FModifyDate;
parms[12].Value = model.FGUID;
parms[13].Value = model.FIsSynchronous;
parms[14].Value = model.VisitId;
return
parms;
}
/// <summary>
/// 为删除一条数据准备参数
/// </summary>
internal
static
IDbDataParameter[] PrepareDeleteParameters(
int
? VisitId)
{
IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_DELETE);
if
(parms ==
null
)
{
parms =
new
IDbDataParameter[]{
dbHelper.CreateDbParameter(PARM_VISITID, DbType.Int32, ParameterDirection.Input)};
DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_EXISTS, parms);
}
parms[0].Value = VisitId;
return
parms;
}
/// <summary>
/// 为查询是否存在一条数据准备参数
/// </summary>
internal
static
IDbDataParameter[] PrepareExistParameters(
int
? VisitId)
{
IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_EXISTS);
if
(parms ==
null
)
{
parms =
new
IDbDataParameter[]{
dbHelper.CreateDbParameter(PARM_VISITID, DbType.Int32, ParameterDirection.Input)};
DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_EXISTS, parms);
}
parms[0].Value = VisitId;
return
parms;
}
/// <summary>
/// 为获取一条数据准备参数
/// </summary>
internal
static
IDbDataParameter[] PrepareGetModelParameters(
int
? VisitId)
{
IDbDataParameter[] parms = DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, COMMAND_GETMODEL);
if
(parms ==
null
)
{
parms =
new
IDbDataParameter[]{
dbHelper.CreateDbParameter(PARM_VISITID, DbType.Int32, ParameterDirection.Input)};
DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_EXISTS, parms);
}
parms[0].Value = VisitId;
return
parms;
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
internal
static
void
PrepareModel(Model.TVisitModel model, IDataReader dr)
{
model.VisitId = DbValue.GetInt(dr[
"VisitId"
]);
model.VisitTime = DbValue.GetDateTime(dr[
"VisitTime"
]);
model.VisitCustomer = DbValue.GetInt(dr[
"VisitCustomer"
]);
model.VisitWay = DbValue.GetInt(dr[
"VisitWay"
]);
model.VisitContent = DbValue.GetString(dr[
"VisitContent"
]);
model.Visitor = DbValue.GetInt(dr[
"Visitor"
]);
model.FRemark = DbValue.GetString(dr[
"FRemark"
]);
model.FSort = DbValue.GetInt(dr[
"FSort"
]);
model.FIsDelete = DbValue.GetBool(dr[
"FIsDelete"
]);
model.FCreator = DbValue.GetString(dr[
"FCreator"
]);
model.FCreateDate = DbValue.GetDateTime(dr[
"FCreateDate"
]);
model.FModify = DbValue.GetString(dr[
"FModify"
]);
model.FModifyDate = DbValue.GetDateTime(dr[
"FModifyDate"
]);
model.FGUID = DbValue.GetString(dr[
"FGUID"
]);
model.FIsSynchronous = DbValue.GetBool(dr[
"FIsSynchronous"
]);
}
}
}