public void DelTMLeave(LCSite.InputTMLeave TMLeave)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Tab_Site_TMLeave ");
strSql.Append(" where strid = @strid ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), new { strid = TMLeave.strid });
}
}
public void AddTMLeave(LCSite.InputTMLeave TMLeave)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tab_Site_TMLeave");
strSql.Append("(strLeaveRemark,nEndLeaveLoginType,strName,nEndLeaveAdminLoginType,strTrainmanID,nAdminLoginType,strTimeOutReason,strEndAdminPhotoID,nTimeOutMinute,strAdminPhotoID,nIsEndLeave,strUserNumber,strLeavePhotoID,nSiteID,dtLeaveTime,strEndLeaveName,strSiteName,strEndLeavePhotoID,dtEndLeaveTime,strNumber,nLeaveLoginType,strid,strUserID,strUserName,strEndLeaveTestAlcoholID,nIsTimeOut,strEndLeaveNumber,dtLeaveCount,nTestAlcoholResult,strEndLeaveAdminID)");
strSql.Append("values(@strLeaveRemark,@nEndLeaveLoginType,@strName,@nEndLeaveAdminLoginType,@strTrainmanID,@nAdminLoginType,@strTimeOutReason,@strEndAdminPhotoID,@nTimeOutMinute,@strAdminPhotoID,@nIsEndLeave,@strUserNumber,@strLeavePhotoID,@nSiteID,@dtLeaveTime,@strEndLeaveName,@strSiteName,@strEndLeavePhotoID,@dtEndLeaveTime,@strNumber,@nLeaveLoginType,@strid,@strUserID,@strUserName,@strEndLeaveTestAlcoholID,@nIsTimeOut,@strEndLeaveNumber,@dtLeaveCount,@nTestAlcoholResult,@strEndLeaveAdminID)");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), TMLeave);
}
}
public void UpdateTMLeave(LCSite.InputTMLeave TMLeave)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update Tab_Site_TMLeave set ");
strSql.Append(" strLeaveRemark = @strLeaveRemark, ");
strSql.Append(" nEndLeaveLoginType = @nEndLeaveLoginType, ");
strSql.Append(" strName = @strName, ");
strSql.Append(" nEndLeaveAdminLoginType = @nEndLeaveAdminLoginType, ");
strSql.Append(" strTrainmanID = @strTrainmanID, ");
strSql.Append(" nAdminLoginType = @nAdminLoginType, ");
strSql.Append(" strTimeOutReason = @strTimeOutReason, ");
strSql.Append(" strEndAdminPhotoID = @strEndAdminPhotoID, ");
strSql.Append(" nTimeOutMinute = @nTimeOutMinute, ");
strSql.Append(" strAdminPhotoID = @strAdminPhotoID, ");
strSql.Append(" nIsEndLeave = @nIsEndLeave, ");
strSql.Append(" strUserNumber = @strUserNumber, ");
strSql.Append(" strLeavePhotoID = @strLeavePhotoID, ");
strSql.Append(" nSiteID = @nSiteID, ");
strSql.Append(" dtLeaveTime = @dtLeaveTime, ");
strSql.Append(" strEndLeaveName = @strEndLeaveName, ");
strSql.Append(" strSiteName = @strSiteName, ");
strSql.Append(" strEndLeavePhotoID = @strEndLeavePhotoID, ");
strSql.Append(" dtEndLeaveTime = @dtEndLeaveTime, ");
strSql.Append(" strNumber = @strNumber, ");
strSql.Append(" nLeaveLoginType = @nLeaveLoginType, ");
strSql.Append(" strUserID = @strUserID, ");
strSql.Append(" strUserName = @strUserName, ");
strSql.Append(" strEndLeaveTestAlcoholID = @strEndLeaveTestAlcoholID, ");
strSql.Append(" nIsTimeOut = @nIsTimeOut, ");
strSql.Append(" strEndLeaveNumber = @strEndLeaveNumber, ");
strSql.Append(" dtLeaveCount = @dtLeaveCount, ");
strSql.Append(" nTestAlcoholResult = @nTestAlcoholResult, ");
strSql.Append(" strEndLeaveAdminID = @strEndLeaveAdminID ");
strSql.Append(" where strid = @strid ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), TMLeave);
}
}