/// <summary>
/// insert
/// </summary>
/// <param name="visitorDataInfo"></param>
/// <returns></returns>
public int insertVisitorData(VisitorDataInfo visitorDataInfo)
{
log.Debug("=================START insertVisitorData=================");
log.Debug("visitorDataInfo = " + visitorDataInfo.ToString());
StringBuilder sql_insert = new StringBuilder();
sql_insert.Append(@"
INSERT INTO VisitorData
([visitDataCode]
,[visitorCode]
,[visitDate]
,[regDate])
VALUES
(" + visitorDataInfo.VisitDataCode + @"
," + visitorDataInfo.VisitorInfo.VisitorCode + @"
,N'" + visitorDataInfo.VisitDate + @"'
,GETDATE())
" );
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert.ToString(), null);
log.Debug(@"=================END insertVisitorData=================");
return(result);
}
/// <summary>
/// 출문 처리
/// </summary>
/// <param name="visitorDataInfo"></param>
/// <returns></returns>
public int updateOutTime(VisitorDataInfo visitorDataInfo)
{
log.Debug("=================START updateInTime=================");
log.Debug("visitorDataInfo = " + visitorDataInfo.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append(@"
UPDATE VisitorData SET
[outTime] = getdate() ,
cardNo = substring(cardNo,1,CHARINDEX('(',cardNo)-1) + '(반납)'
WHERE visitorDataCode=" + visitorDataInfo.VisitorDataCode);
/*
* sql_update.Append(@"
* UPDATE VisitorData SET
* [outTime] = getdate()
* WHERE visitorDataCode=" + visitorDataInfo.VisitorDataCode);
*/
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updateInTime=================");
return(result);
}
/// <summary>
/// delete
/// </summary>
/// <param name="visitorDataInfo"></param>
/// <returns></returns>
public int deleteVisitorData(VisitorDataInfo visitorDataInfo)
{
log.Debug("=================START deleteVisitorData=================");
log.Debug("visitorDataInfo = " + visitorDataInfo.ToString());
StringBuilder sql_delete = new StringBuilder();
sql_delete.Append("DELETE FROM VisitorData WHERE visitorDataCode=" + visitorDataInfo.VisitorDataCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_delete.ToString(), null);
log.Debug(@"=================END deleteVisitorData=================");
return(result);
}
/// <summary>
/// update
/// </summary>
/// <param name="visitorDataInfo"></param>
/// <returns></returns>
public int updateVisitorData(VisitorDataInfo visitorDataInfo)
{
log.Debug("=================START updateVisitorData=================");
log.Debug("visitorDataInfo = " + visitorDataInfo.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append(@"
UPDATE VisitorData SET
,[visitDate] = " + visitorDataInfo.VisitDate + @"
WHERE visitorDataCode=" + visitorDataInfo.VisitorDataCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updateVisitorData=================");
return(result);
}
/// <summary>
/// 입문 처리
/// </summary>
/// <param name="visitorDataInfo"></param>
/// <returns></returns>
//1212
public int updateInTime(VisitorDataInfo visitorDataInfo)
{
log.Debug("=================START updateInTime=================");
log.Debug("visitorDataInfo = " + visitorDataInfo.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append(@"
UPDATE VisitorData SET
[inTime] = getdate() ,
cardNo =N'" + visitorDataInfo.CardNo + @"(지급)'
WHERE visitorDataCode=" + visitorDataInfo.VisitorDataCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updateInTime=================");
return(result);
}
