public void DelInOutRoom(LCSite.InputGBInOutRoom gbInOuRoom)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Tab_Site_GanBuInOutRoom ");
strSql.Append(" where strID = @strID ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), new { Strid = gbInOuRoom.strID });
}
}
public void AddInOutRoom(LCSite.InputGBInOutRoom gbInOuRoom)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tab_Site_GanBuInOutRoom");
strSql.Append("(strDuty,nOutRoomLoginType,nIsOutRoom,strTypeName,strInRoomQuDuan,strTrainmanID,strCadresDutyTypeID,strID,strOutRoomQuDuan,strInRoomType,strInRoomPhotoID,strNumber,nSiteID,strJianChaContent,dtOutRoomDateTime,dtInputDateTime,strSiteNumber,dtInRoomDateTime,nInRoomLoginType,dtOutRoomCheCiDateTime,strDepartmentName,strInRoomCheCi,strRemark,strZhengGaiYiJian,strCheJianName,strOutRoomCheCi,strName,strOutRoomPhotoID,strSiteName)");
strSql.Append("values(@strDuty,@nOutRoomLoginType,@nIsOutRoom,@strTypeName,@strInRoomQuDuan,@strTrainmanID,@strCadresDutyTypeID,@strID,@strOutRoomQuDuan,@strInRoomType,@strInRoomPhotoID,@strNumber,@nSiteID,@strJianChaContent,@dtOutRoomDateTime,@dtInputDateTime,@strSiteNumber,@dtInRoomDateTime,@nInRoomLoginType,@dtOutRoomCheCiDateTime,@strDepartmentName,@strInRoomCheCi,@strRemark,@strZhengGaiYiJian,@strCheJianName,@strOutRoomCheCi,@strName,@strOutRoomPhotoID,@strSiteName)");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), gbInOuRoom);
}
}
public void UpdateInOutRoom(LCSite.InputGBInOutRoom gbInOuRoom)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update Tab_Site_GanBuInOutRoom set ");
strSql.Append(" strDuty = @strDuty, ");
strSql.Append(" nOutRoomLoginType = @nOutRoomLoginType, ");
strSql.Append(" nIsOutRoom = @nIsOutRoom, ");
strSql.Append(" strTypeName = @strTypeName, ");
strSql.Append(" strInRoomQuDuan = @strInRoomQuDuan, ");
strSql.Append(" strTrainmanID = @strTrainmanID, ");
strSql.Append(" strCadresDutyTypeID = @strCadresDutyTypeID, ");
strSql.Append(" strOutRoomQuDuan = @strOutRoomQuDuan, ");
strSql.Append(" strInRoomType = @strInRoomType, ");
strSql.Append(" strInRoomPhotoID = @strInRoomPhotoID, ");
strSql.Append(" strNumber = @strNumber, ");
strSql.Append(" nSiteID = @nSiteID, ");
strSql.Append(" strJianChaContent = @strJianChaContent, ");
strSql.Append(" dtOutRoomDateTime = @dtOutRoomDateTime, ");
strSql.Append(" dtInputDateTime = @dtInputDateTime, ");
strSql.Append(" strSiteNumber = @strSiteNumber, ");
strSql.Append(" dtInRoomDateTime = @dtInRoomDateTime, ");
strSql.Append(" nInRoomLoginType = @nInRoomLoginType, ");
strSql.Append(" dtOutRoomCheCiDateTime = @dtOutRoomCheCiDateTime, ");
strSql.Append(" strDepartmentName = @strDepartmentName, ");
strSql.Append(" strInRoomCheCi = @strInRoomCheCi, ");
strSql.Append(" strRemark = @strRemark, ");
strSql.Append(" strZhengGaiYiJian = @strZhengGaiYiJian, ");
strSql.Append(" strCheJianName = @strCheJianName, ");
strSql.Append(" strOutRoomCheCi = @strOutRoomCheCi, ");
strSql.Append(" strName = @strName, ");
strSql.Append(" strOutRoomPhotoID = @strOutRoomPhotoID, ");
strSql.Append(" strSiteName = @strSiteName ");
strSql.Append(" where strID = @strID ");
using (var conn = GetConnection())
{
conn.Execute(strSql.ToString(), gbInOuRoom);
}
}