public void DelRoomPatrol(LCSite.InputRoomPatrol RoomPatrol)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TAB_Site_RoomPatrol ");
strSql.Append(" where strID = @strID ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), new { Strid = RoomPatrol.strID });
}
}
public void AddRoomPatrol(LCSite.InputRoomPatrol RoomPatrol)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Site_RoomPatrol");
strSql.Append("(dtPatrolTime,nSiteID,strSiteName,nLoginType,strNumber,strPhotoID,strTrainmanID,strID,strName)");
strSql.Append("values(@dtPatrolTime,@nSiteID,@strSiteName,@nLoginType,@strNumber,@strPhotoID,@strTrainmanID,@strID,@strName)");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), RoomPatrol);
}
}
public void UpdateRoomPatrol(LCSite.InputRoomPatrol RoomPatrol)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_Site_RoomPatrol set ");
strSql.Append(" dtPatrolTime = @dtPatrolTime, ");
strSql.Append(" nSiteID = @nSiteID, ");
strSql.Append(" strSiteName = @strSiteName, ");
strSql.Append(" nLoginType = @nLoginType, ");
strSql.Append(" strNumber = @strNumber, ");
strSql.Append(" strPhotoID = @strPhotoID, ");
strSql.Append(" strTrainmanID = @strTrainmanID, ");
strSql.Append(" strName = @strName ");
strSql.Append(" where strID = @strID ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), RoomPatrol);
}
}