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); } }